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

Overview

Explore advanced statistical analysis techniques in Excel, focusing on frequency distributions, visualizations, and skew for quantitative data. Learn to create column charts for discrete data, line and clustered column charts for date data, and histogram column charts for continuous data. Master PivotTable grouping for sum month sales, understand the versatility of date as a quantitative variable, and discover why built-in histogram charts are not preferred. Dive into cumulative frequency calculations, combo charts, and distribution types including normal and uniform. Gain insights on category ordering for continuous data and interpreting skew in histograms. Download the accompanying Excel file to practice these essential data analysis skills hands-on.

Syllabus

) 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.