Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable

Topics in this video:
1. (00:09) Overview of Frequency Distributions for Quantitative Variable
2. (02:02) Create Frequency Distribution with PivotTable for Grade Data where NUMBERS ARE DECIMALS (important distinction for grouping feature in a PivotTable)
3. (03:08) Grouping Feature in a PivotTable for creating Classes or Categories for a Decimal Quantitative Variable. Class that are created are 0-10, 10-20, 20-30, etc. Extensive Discussion about how to create classes or categories that are NOT Ambiguous.
4. (05:03) Upper Limit for Class/Category is Not Included when the numbers are Decimals.
5. (05:58) Aggregate Function for Number Values defaults to Count when you have Grouped Numbers in the Row area of the PivotTable.
6. (06:32) Double Click PivotTable to Extract Records that match the criteria from the Row area of the PivotTable
7. (09:16) Use Find and Replace feature to create non-ambiguous labels in a Grouped Decimal Number PivotTable.
8. (10:20) Create Histogram for Quantitative Variable (Grouped Numbers) for Grade Data. This Histogram has Frequencies at the top of each column and the gap width is zero. The colors for each column are different.
9. (13:13) Create Frequency Distribution with PivotTable for Grade Data where numbers are WHOLE NUMBERS (important distinction for grouping feature in a PivotTable)
10. (14:33) Methods for determining Number of Classes and Class Width for a Quantitative Variable
11. (18:19) When grouping Whole Numbers in a PivotTable the classes that are created are not ambiguous. We get classes like: 16-22, 23-29, 30-36. Etc.
12. (20:07) Create Histogram for Quantitative Variable (Grouped Numbers) for Age Data. This Histogram has Frequencies in the vertical axis and the gap width is zero. The colors for each column are the same.
13. (22:00) Discussion about Skew, Histogram shape and Histogram distribution of column heights.
14. (25:37) Relative Frequency and Percent Frequency Distribution built with a PivotTable based on Age Data that is shown as a Whole Number.
15. (27:48) Formulas
16. (27:44) Create Frequency Distribution with Formulas for Grade Data.
17. (30:03) Text Formulas for Category Labels
18. (30:40) COUNTIFS function with Comparative Operators Joined to Lower and Upper Limits from the Cells.
19. (33:17) Relative/Percent Frequency Formula.
20. (34:00) Create Histogram for Grade Data based on Frequency Distribution created with formulas.
21. (35:56) See that we can change the categories be more precise when we use formulas.
22. (38:20) Link Data Labels in Chart to cells in the spreadsheet
23. (39:16) See how formulas allow Frequency Distribution Formulas and Histogram Chart update automatically when raw data change. See different grade distributions with Histogram.
24. (40:45) Summary

[excelisfun]

Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable
Topics in this video:
1. (00:09) Overview of Frequency Distributions for Quantitative Variable
2. (02:02) Create Frequency Distribution with PivotTable for Grade Data where NUMBERS ARE DECIMALS (important distinction for grouping feature in a PivotTable)
3. (03:08) Grouping Feature in a PivotTable for creating Classes or Categories for a Decimal Quantitative Variable. Class that are created are 0-10, 10-20, 20-30, etc. Extensive Discussion about how to create classes or categories that are NOT Ambiguous.
4. (05:03) Upper Limit for Class/Category is Not Included when the numbers are Decimals. 
5. (05:58) Aggregate Function for Number Values defaults to Count when you have Grouped Numbers in the Row area of the PivotTable.
6. (06:32) Double Click PivotTable to Extract Records that match the criteria from the Row area of the PivotTable
7. (09:16) Use Find and Replace feature to create non-ambiguous labels in a Grouped Decimal Number PivotTable.
8. (10:20) Create Histogram for Quantitative Variable (Grouped Numbers) for Grade Data. This Histogram has Frequencies at the top of each column and the gap width is zero. The colors for each column are different.
9. (13:13) Create Frequency Distribution with PivotTable for Grade Data where numbers are WHOLE NUMBERS (important distinction for grouping feature in a PivotTable)
10. (14:33) Methods for determining Number of Classes and Class Width for a Quantitative Variable 
11. (18:19) When grouping Whole Numbers in a PivotTable the classes that are created are not ambiguous. We get classes like: 16-22, 23-29, 30-36. Etc.
12. (20:07) Create Histogram for Quantitative Variable (Grouped Numbers) for Age Data. This Histogram has Frequencies in the vertical axis and the gap width is zero. The colors for each column are the same.
13. (22:00) Discussion about Skew, Histogram shape and Histogram distribution of column heights.
14. (25:37) Relative Frequency and Percent Frequency Distribution built with a PivotTable based on Age Data that is shown as a Whole Number.
15. (27:48) Formulas
16. (27:44) Create Frequency Distribution with Formulas for Grade Data.
17. (30:03) Text Formulas for Category Labels
18. (30:40) COUNTIFS function with Comparative Operators Joined to Lower and Upper Limits from the Cells.
19. (33:17) Relative/Percent Frequency Formula.
20. (34:00) Create Histogram for Grade Data based on Frequency Distribution created with formulas.
21. (35:56) See that we can change the categories be more precise when we use formulas.
22. (38:20) Link Data Labels in Chart to cells in the spreadsheet
23. (39:16) See how formulas allow Frequency Distribution Formulas and Histogram Chart update automatically when raw data change. See different grade distributions with Histogram.
24. (40:45) Summary

[beautyandbeyond]

Hey Mike, day after day I am reaching the point to believe that no one else able to bring this level of teaching, Thank you from the heart!

[ronadomantay]

Wow! Thank you so much. You're my go-to every time I need to know something about excel.

[david_gameplay]

Amazing. One of the best Video of Statistical Analysis I've found in YouTube....Great Job Michael!!!

[coryjhill]

This has been awesome for helping with my statistics class - Thank you for putting this video together! - Aside - has anyone else noticed that he sounds like Ross from Friends?

[kouzoun]

Great job Mike :)
As always, your expertise was really helpful. You have so much talent in tutoring and data. Thank you for sharing your knowledge with us.

[heysachintyagi]

Thank you so much...This is one of the best Statistical analysis tutorial I have ever checked on youtube...you have helped me a lot...Just can't express my gratitude in words!!

[milind]

Excellent, excellent excellent !!!. All I wanted was freq graph. I got much more. Thanks a lot. Please keep up the good work.

[niebs]

Great video... explained clearly but not painfully slow... very good

[moniquei.samuels]

Thank you this saved my life on a Liberal Arts assignment, so detailed!!

[xhz]

Excellent. Especially on working the bins and being consistent about upper limit not included!

[joshuamanampiu]

Amazing Video, Mike you outdid yourself to our benefit.

[madenaarcher]

This was exceptionally simple. Thank you so much!

[holiholi]

gracias tu pronunciacion del ingles es muy clara :) Thank you so much!! saludos de perù

[kebincui]

hi Mike. I am wonder if there is particular reason to use 2^k>n to decide the number of class? Please shed light on this. Thanks 😊

[Chamchijjige]

Clearly understood. Thank you very much again.

[excaliberps]

Thank you, helped me a lot. Lots of love from the UK

[DIGITAL_COOKING]

absolutely a pivot table for statistics: is amazing, I don"t know may this is the third time I watch this video, unfortunately, I can't give a thumb up again
:), but it is a very awesome video about a frequency distribution
👍👍👍👍👍

[mrbhaskarbirajdar]

Incredible 8 excellent job. Appreciation from India

[gplus]

Alas, finally found the information to meet my needs. Very helpful. Thank you for