Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Mathematics #Statistics & Probability #Statistical Analysis #Data Science #Data Visualization #Histograms #Frequency Distribution #Line Charts #Column Charts
0:00 / 0:00
1 of 21

) Introduction