Completed
) MODE.MULT and COUNTIFS functions to create a Dynamic Spilled Array Report for all quantitative modes.
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
