Completed
) Skew in Histograms and a Statistical Formula. See the SKEW function. Learn about relationship between Mean, Median and Mode and how they relate to skew.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Location, Mean, Median, Mode, Moving Average, Skew & More
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Files for chapter 3
- 3 ) Reminder of printable notes
- 4 ) Statistical Location of a data point against full data set
- 5 Location: Mean. AVERAGE function.
- 6 ) Location: Median to locate middle of data set. MEDIAN function.
- 7 ) Location: Percentile 75%. PERCENTILE.EXC function.
- 8 ) Population and Sample Mean, X Bar and Mew
- 9 ) Population Parameter and Sample Statistics
- 10 ) Mean Calculation: How and Why
- 11 ) Median Calculation: How and Why
- 12 ) Mode Calculation: How and Why
- 13 ) PivotTable to calculate Mode for Categorical Data.
- 14 ) MODE.MULT and MODE.SNGL functions to calculate Mode for Quantitative Data.
- 15 ) MODE.MULT and COUNTIFS functions to create a Dynamic Spilled Array Report for all quantitative modes.
- 16 ) Use PivotTable to find all quantitative modes.
- 17 ) SORT, UNIQUE and COUNTIFS functions to create a Dynamic Spilled Array Report for categorical data to find the modes. This is really a Frequency Distribution without the total row.
- 18 ) Skew in Histograms and a Statistical Formula. See the SKEW function. Learn about relationship between Mean, Median and Mode and how they relate to skew.
- 19 ) Examples of skew.
- 20 ) Three Bonus Mean Calculations
- 21 ) Bonus #1: Add multiple columns to average function to calcite the text and quiz averages for a class.
- 22 ) Bonus #2: Use Power Query to Import CSV data from a covid government site, calculate 7-day moving average for number of covid 19 cases and plot it on a Line Chart.
- 23 ) Bonus #3: Calculate 6-month moving average for company sales and plot on a Line Chart.
- 24 ) Summary
- 25 ) Conclusion and Video Links
