Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable Download files: people.highline.edu/mgirvin/excelisfun.htm 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
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?
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.
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!!
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 👍👍👍👍👍
Yes, this IS an epic video. All you need to know about Frequency Distributions in a single video. Thanks for your amazing and consistent support, DIGITAL COOKING!!!
can you suggest which video to watch that would instruct me on how to create a graph. I have 6 activities that I am trying to track the weekly progress of. So, I have the activity, dates and then numbers associated with each. tia!!
I have been referring to your videos for years. Your videos and knowledge are an excellent resource. I would love to see a video bible is what i call it of learning formulas.. Nothing but formulas. Or do you have that already? That's where I have issues but I know if I had a video focused on what I need to learn I would use it as a tool box for practicing. Thank you again!
Thank you very much for your fantastic video. How to point in the frequency histogram one value which represent our data (a point, a star...) in other color. Thanks
Good stuff but how would you analyse weight as no point summing total weight unless we would use it for an average. I am tracking weight for a group for fun and noticed not much discussion of weight except singularly. I have been plotting it as a line graph for each not exactly exciting so wondered if you had any vids analysing our weight as in how much we weight. Different using the word weight as it has other connotations especially in statistics.
looks like the file name to download is called Excel2013StatisticsChapter02.xlsx it would have been easier if you had written somewhere that this is the file to use since I dont see chapter 2 anywhere in the title of this video
The download files link in the description is very complicated. I don't know which file to use for this video, I tried to type in every word in the title of the video and nothing comes up, which file is it???
AlexandruP , sorry, but with 2500 video and trying to give it all away for rree, it is a big list. Look for the setion called "Excel 2013 Statistics Class Series (Excel 2010 and 2007 Statistics Series further down)" then get Chapter 02 Excel file.
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!
This video does have all the topics about frequency distributions : ) : ) You are welcome from my heart, huda!!!
Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable
Download files: people.highline.edu/mgirvin/excelisfun.htm
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
I love your videos! Thanks for posting. I'm learning a lot more about excel! Just wanting to express my gratitude!
You are welcome! I am glad that the videos help!
Amazing. One of the best Video of Statistical Analysis I've found in TH-cam....Great Job Michael!!!
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?
Hahaha, thanks for drawing that to our attention!
Wow! Thank you so much. You're my go-to every time I need to know something about excel.
You are welcome for the go-to Excel!
Very Clear - great thanks
Excellent, excellent excellent !!!. All I wanted was freq graph. I got much more. Thanks a lot. Please keep up the good work.
You are welcome!
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.
Thank you this saved my life on a Liberal Arts assignment, so detailed!!
This video is a gift from the gods
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!!
Great video... explained clearly but not painfully slow... very good
Thank you, helped me a lot. Lots of love from the UK
Alas, finally found the information to meet my needs. Very helpful. Thank you for sharing!!!!!!!!
This was exceptionally simple. Thank you so much!
It definitely is a comprehensive video : )
Amazing Video, Mike you outdid yourself to our benefit.
Yes, this is a lot of cool stuff about a report we do all the time : )
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
👍👍👍👍👍
Yes, this IS an epic video. All you need to know about Frequency Distributions in a single video. Thanks for your amazing and consistent support, DIGITAL COOKING!!!
gracias tu pronunciacion del ingles es muy clara :) Thank you so much!! saludos de perù
Excellent. Especially on working the bins and being consistent about upper limit not included!
Glad you like it! EXCELlent, right?
really really helpful
keep making these!
god bless you
Clearly understood. Thank you very much again.
Mike, Statistics is also fun, thanks to you
Incredible 8 excellent job. Appreciation from India
You are welcome! Glad it helps, Bhaskar!!! Thanks for your support with your comment, Thumbs Up and Sub!!
Thanks a lot.That is a great explanation.Please keep up the good work.
can you suggest which video to watch that would instruct me on how to create a graph. I have 6 activities that I am trying to track the weekly progress of. So, I have the activity, dates and then numbers associated with each. tia!!
Great!
Glad you like it!!!!
thanks for this excellent video , it helps me for my problem
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 😊
I have been referring to your videos for years. Your videos and knowledge are an excellent resource. I would love to see a video bible is what i call it of learning formulas.. Nothing but formulas. Or do you have that already? That's where I have issues but I know if I had a video focused on what I need to learn I would use it as a tool box for practicing. Thank you again!
woww <
wonderful ,i am Enjoyed in
this explanation
It's really helpful. Thank you
Glad it helps, Rakesh!!!!!
Thank you very much for your fantastic video. How to point in the frequency histogram one value which represent our data (a point, a star...) in other color. Thanks
what is the exact file name for this particular worksheet. I have search on the link but there seem to be so many worksheets. Any help with that?
great job , you earn love from our side body
You are welcome, MKM!!! Thanks for the love : )
Good stuff but how would you analyse weight as no point summing total weight unless we would use it for an average. I am tracking weight for a group for fun and noticed not much discussion of weight except singularly. I have been plotting it as a line graph for each not exactly exciting so wondered if you had any vids analysing our weight as in how much we weight. Different using the word weight as it has other connotations especially in statistics.
Thanks for that statistical analysis(techniques)
You are welcome, Saqib!!!
superb 👍👍👍👍👍👍
Yes, this is an epic FD video : )
Thanks for sharing your knowledge. By the way, how you can copy so fast?
looks like the file name to download is called Excel2013StatisticsChapter02.xlsx it would have been easier if you had written somewhere that this is the file to use since I dont see chapter 2 anywhere in the title of this video
Thank you very much sir.
I guess that if you don't know which file to use, you could always look at the title of the spreadsheet in the video
The download files link in the description is very complicated. I don't know which file to use for this video, I tried to type in every word in the title of the video and nothing comes up, which file is it???
AlexandruP , sorry, but with 2500 video and trying to give it all away for rree, it is a big list. Look for the setion called "Excel 2013 Statistics Class Series (Excel 2010 and 2007 Statistics Series further down)" then get Chapter 02 Excel file.
ExcelIsFun
No problem. I found it, thanks a lot.
Very Helpful Thanks
Hello Sir just wanted to know if it was fine if I kept 18 as my starting point and went all up to 73 ?
thanks for the amazing video though :)
God bless YOU.
Glad you liked the video, idowu!!!! Thank you for supporting my efforts to provide free education with your comment, thumbs up and Sub : )
where is the work book
Thanks!
Thanks
awesome
Can anyone gudie on how to calculate ABSOLUTE FREQUENCY PLS? Formula is a pain in the ass
is this miles teller lol