find and visualize outliers in excel using Normal Distribution (Statistics and data Science)

Описание: In statistics, an outlier is a data point that differs significantly from other observations. An outlier may be due to a variability in the measurement, an indication of novel data, or it may be the result of experimental error; the latter are sometimes excluded from the data set.

Z test:
1. outliers: data points whose Standard Dev
is too far from the Mean

Box Plot:
1. outliers: a data point fall out of
Quartiles 1st, 2nd, 3rd

steps:

1. identify a problem
2. collect data
3. data exploration
4. data cleaning /transformation
5. model selection & training
6. prediction
7. Optimization

live
https://outliers.streamlit.app/

GitHub
https://github.com/shamiraty/outliers...

Episode 1:
   • Python Web Analytics:  Finding Outliers by...  

STATISTICS FOR INFORMATION ANALYSIS

DATA EXPLORATION & VISUALIZATION TECHNIQUES

FOR OPERATIONAL RESEARCH & BUSINESS INTELLIGENT

1. Business Analytics Web Dashboard
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Complete Business Analytics Web Dashboard ...  

2. Analytics Website Dashboard
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Analytics Website Dashboard  using Python ...  

3. Logistic Multiple Regression Analytics Web
youtube:
   • Logistic Multiple Regression Analytics Web...  
Live demo:
https://open-findings.streamlit.app/

4. Normal Probability Distribution Analytics Web
Live Demo:
https://normal-distribution.streamlit...
Youtube:
   • Normal Probability Distribution Analytics ...  

5. Python: Query Operations
Live Demo:
https://python-query.streamlit.app/
Youtube:
   • Python Query Operations fetch Data from Ex...  

6. Python: Binomial Probability Distributions
Live Demo:
hhttps://binomial-probability.streamli...
Youtube:
   • Python and Streamlit  Statistics Binomial ...  

7. Hypothesis Testing T distribution Curve
Live Demo:
https://hypothesis.streamlit.app/
Youtube:
   • Hypothesis Testing Python and Streamlit un...  

8. Frequency Distribution Table
Live Demo:
https://frequency-distributions.strea...
Youtube:
   • Analytics Website Frequency Distribution T...  

9. Geo Referencing Business Trends
Live demo:
https://open-analytics.streamlit.app/
Youtube:
   • Streamlit Analytics Web Dashboard Using Go...  

10. Multiple Linear Regression Web Project
Live Demo:
https://business-analytical.streamlit...
Youtube:
   • Analytics Web application Multiple Linear ...  


11. Python: Web Dashboard: DashPlotly Framework and Dash
Live Demo:
https://python13.onrender.com/
Youtube:
   • Python Web Dashboard using DashPlotly Fram...  

12. Python: Web Dashboard using DashPlotly Framework
Live Demo:
https://project-fpy1.onrender.com/
Youtube:
   • Python Web Dashboard using DashPlotly Fram...  

13. Python: Multiple Linear Regression
Live Demo:
https://business-force.streamlit.app/
Youtube:
   • Python Machine Learning Web App For Multip...  

14. Logistic Regression Analysis
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Logistic Regression Analysis And Coefficie...  

15. PygWalker Graph Creator
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Streamlit Web Visualization Dashboard usin...  

16. Sales Analytics Web Dashboard
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Web Analytics Dashboard using Python and S...  

17. Analytics Dashboard with MySQL
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Python Analytics Dashboard with MySQL and ...  

18. Business Intelligent Analytics Web Dashboard
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Business Intelligent Analytics Web Dashboa...  

19. Descriptive Analytics Web Dashboard 1
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Business Analytics Dashboard  Website usin...  

20. Descriptive Analytics Web Dashboard 2
Live Demo:
https://shamiraty-numbersummary-perce...
Youtube:
   • Descriptive Analytics Web Dashboard  pytho...  

21. Analytics Dashboard Website with Graphs 3
Live Demo:
https://open-projects.streamlit.app/
Youtube:
   • Analytics Dashboard Website with Graphs Us...  

22. Add new Record to Excel file via Web Interface
Live Demo:
https://shamiraty-add-data-to-excel-s...
Youtube:
   • Add new Record to Excel file via Web Inter...  

23. CrossTabulation Web App
Live Demo:
https://shamiraty-crosstabulation-mai...
Youtube:
   • CrossTabulation Matrix data from Excel to ...  

24. Quantitative Research Data Analysis Techniques
Live demo:
https://open-findings.streamlit.app/
youtube:
   • Quantitative Research Data Analysis Techni...  

25. Quantitative Research Data Collection and Analysis Techniques
Youtube:
   • Quantitative Research Data Collection and ...  

26. Student Results Standardization Excel
youtube:
   • Student Results Standardization, Z test, G...  

27. Alpha Confidence Level & Z table
Live Demo:
https://confidence.streamlit.app/
Youtube:
   • Finding the Confidence Level of a given Al...  

28. Scientific Calculator Table function & Binomial Distribution
Youtube:
   • Scientific Calculator Table function to Co...  

29. Scientific Calculator Variables and Parameters Passing
Youtube:
   • Scientific Calculator How to create Variab...