Excel Statistical Analysis - Location, Mean, Median, Mode, Moving Average, Skew & More
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.