Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart
16.6 هزار بار بازدید -
2 سال پیش
-
Download Excel File:
Download Excel File: https://excelisfun.net/files/Ch06-ESA... PDF notes file: https://excelisfun.net/files/Ch06-ESA...
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
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
2 سال پیش
در تاریخ 1401/02/09 منتشر شده
است.
16,697
بـار بازدید شده