Excel Statistical Analysis - Frequency Distributions, Visualizations & Skew for Quantitative Data
Offered By: ExcelIsFun via YouTube
Course Description
Overview
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.
Taught by
ExcelIsFun
Related Courses
Introduction to Operations ManagementWharton School of the University of Pennsylvania via Coursera Computational Molecular Evolution
Technical University of Denmark (DTU) via Coursera Structural Equation Model and its Applications | 结构方程模型及其应用 (普通话)
The Chinese University of Hong Kong via Coursera Fundamentals of Clinical Trials
Harvard University via edX Curso Práctico de Bioestadística con R
Universidad San Pablo CEU via Miríadax