Excel Statistical Analysis - Frequency Distributions, Visualizations & Skew for Quantitative Data

Excel Statistical Analysis - Frequency Distributions, Visualizations & Skew for Quantitative Data

ExcelIsFun via YouTube Direct link

) Cumulative & % Cumulative Frequency calculations in Frequency Distribution

14 of 21

14 of 21

) Cumulative & % Cumulative Frequency calculations in Frequency Distribution

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.