Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about creating frequency distributions and visualizations for quantitative data, including Column Charts for Discrete Data, Line and Clustered Column charts for Date Data and Column Chart Histograms for Continuous Data.
Topics:
1. (00:00) Introduction
2. (00:35) Discrete Quantitative Data: Frequency Distribution and Column Chart.
3. (00:35) Isaac Restaurant example.
4. (06:21) Dick’s Hamburger example.
5. (07:51) Date as a Quantitative Variable that can be Discrete, Categorical, or Continuous
6. (08:33) Sum Month Sales in PivotTable using PivotTable Grouping Feature
7. (11:28) Line Chart for Time Series Data
8. (13:19) Quarterly Projected Sales and Actual Sales plotted with a Clustered Column (Side-by-side) Chart
9. (14:31) Continuous Quantitative Data: Frequency Distribution and Histogram created with Column Chart
10. (14:31) Online Retail Sales Data example
11. (15:46) Grouping to create sales counting categories for Continuous sales data
12. (18:05) Why we don’t use Built-in Histogram Chart
13. (19:00) Histogram Chart created with Column Chart and no gap width
14. (20:23) Cumulative & % Cumulative Frequency calculations in Frequency Distribution
15. (21:37) Combo Chart for Histogram with Frequency and % Frequency
16. (23:58) Accounting Salary example of Normal Distribution.
17. (24:30) Customer Service Call Center example of Uniform Distribution.
18. (25:05) Order of categories for continuous data
19. (25:30) Skew in Histograms
20. (27:59) Summary of Videos Topics
21. ((28:39) Conclusion and Video Links