Channel: ExcelIsFun

Category: Education

Tags: excel bell curve chartbusiness statistical analysisdata analysischart a bell curve in excelhighline collegeexcel statisticsmike girvinarea chartsequence functionmicrosoft 365 excelesa 33busn 210how to plot normnal curve in excelmike excelisfun girvincharting a normal bell probability distributionstatistical analysischapter 6norm.dist functionexcelisfunexcel statistical analysis

Description: Download Excel File: excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: excelisfun.net/files/Ch06-ESA.pdf Learn about how to create a Normal Bell Curve Chart in Excel using Area Chart. Other Charting tricks also. Topics: 1. (00:00) Introduction 2. (00:26) Create Data for Chart 3. (00:45) Create X Values. SEQUENCE function. 4. (01:55) Create Probabilities with NORM.DIST function 5. (02:55) Create Area Chart for Normal Bell Curve 6. (04:37) Create Z Values 7. (05:10) Label for Probability Less Than an X Value. Text Formula and the ROUND function. 8. (06:45) Create Probability Less Than an X Value using the IF Function 9. (07:55) Add Second Column of Probabilities to Area Chart using Select Data Source dialog Box 10. (08:50) Change Second Series of Numbers to Second Axis in the chart 11. (09:09) Add Z Values to Chart in Secondary Axis 12. (09:48) Show Z Values Below X Values 13. (10:08) Change Increment in Z Axis 14. (10:59) Add X and Z label for Horizontal Axis 15. (12:02) Copy Template to create an Area Chart that shows Probability on Upper End (Above X) 16. (14:39) Summary of video 17. (14:50) Closing and Video Links