Главная
Study mode:
on
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
Description:
Dive into a comprehensive 40-minute video tutorial on Excel statistical analysis, focusing on measures of central location and data distribution. Master the use of Mean, Median, Mode, and Moving Average calculations using Excel functions like AVERAGE, MEDIAN, and PERCENTILE.EXC. Explore the concepts of population parameters and sample statistics, and learn how to calculate and interpret skew in data sets. Gain practical skills in using PivotTables, dynamic spilled array formulas, and Power Query for data analysis and visualization. Apply your knowledge to real-world scenarios, including COVID-19 data analysis and company sales forecasting. Download the accompanying Excel file to follow along and reinforce your learning through hands-on practice.

Excel Statistical Analysis - Location, Mean, Median, Mode, Moving Average, Skew & More

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization #Mathematics #Statistics & Probability #Statistical Analysis #Moving Average #Business Intelligence #Power Query
0:00 / 0:00
1 of 25

) Introduction