Completed
) Sum Month Sales in PivotTable using PivotTable Grouping Feature
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Frequency Distributions, Visualizations & Skew for Quantitative Data
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Discrete Quantitative Data: Frequency Distribution and Column Chart.
- 3 ) Isaac Restaurant example.
- 4 ) Dick’s Hamburger example.
- 5 ) Date as a Quantitative Variable that can be Discrete, Categorical, or Continuous
- 6 ) Sum Month Sales in PivotTable using PivotTable Grouping Feature
- 7 ) Line Chart for Time Series Data
- 8 ) Quarterly Projected Sales and Actual Sales plotted with a Clustered Column (Side-by-side) Chart
- 9 ) Continuous Quantitative Data: Frequency Distribution and Histogram created with Column Chart
- 10 ) Online Retail Sales Data example
- 11 ) Grouping to create sales counting categories for Continuous sales data
- 12 ) Why we don’t use Built-in Histogram Chart
- 13 ) Histogram Chart created with Column Chart and no gap width
- 14 ) Cumulative & % Cumulative Frequency calculations in Frequency Distribution
- 15 ) Combo Chart for Histogram with Frequency and % Frequency
- 16 ) Accounting Salary example of Normal Distribution.
- 17 ) Customer Service Call Center example of Uniform Distribution.
- 18 ) Order of categories for continuous data
- 19 ) Skew in Histograms
- 20 ) Summary of Videos Topics
- 21 ) Conclusion and Video Links
