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

) Introduction.
) Discrete Quantitative Data: Frequency Distribution and Column Chart..
) Isaac Restaurant example..
) Dick’s Hamburger example..
) Date as a Quantitative Variable that can be Discrete, Categorical, or Continuous.
) Sum Month Sales in PivotTable using PivotTable Grouping Feature.
) Line Chart for Time Series Data.
) Quarterly Projected Sales and Actual Sales plotted with a Clustered Column (Side-by-side) Chart.
) Continuous Quantitative Data: Frequency Distribution and Histogram created with Column Chart.
) Online Retail Sales Data example.
) Grouping to create sales counting categories for Continuous sales data.
) Why we don’t use Built-in Histogram Chart.
) Histogram Chart created with Column Chart and no gap width.
) Cumulative & % Cumulative Frequency calculations in Frequency Distribution.
) Combo Chart for Histogram with Frequency and % Frequency.
) Accounting Salary example of Normal Distribution..
) Customer Service Call Center example of Uniform Distribution..
) Order of categories for continuous data.
) Skew in Histograms.
) Summary of Videos Topics.
) Conclusion and Video Links.