REPLAY ~ Statistical Analysis with Excel - Beyond Basics - Masterclass

Not your AVERAGE live stream. In this in-depth masterclass, learn how to perform below 10 types of statistical analysis using Excel.

1) Average vs. Median
2) Understanding the spread of data with box plots
3) Histograms and distributions
4) Conditional Averages
5) Conditional Median / max / min
6) Outliers
7) Random Sampling Data
8) Mode and calculating mode for text values
9) Indexing the data
10) Your Questions...
SAMPLE FILE:
============
Download the sample data file from here - https://chandoo.org/wp/wp-content/uploads/2022/02/stats-sample-data.xlsx

A completed file with all examples is here -
https://chandoo.org/wp/wp-content/uploads/2022/02/stats-sample-data-stream.xlsx

Video topics:
===========
00:00 - Hellos & Greetings
08:07 - Agenda for the day & a quick look at the sample data
21:20 - Average vs. Median
26:54 - Box plots & distribution of data
47:30 - Histograms & Frequency Analysis
1:05:00 - Conditional average & medians (with Pivots)
1:13:00 - Conditional average & medians (with Formulas)
1:22:16 - Dealing with Outliers in your data
1:35:00 - Random sampling of data
1:47:00 - Adding normal curve over the histogram
1:53:00 - Mode from your data (numbers & text values)
Additional Resources to Learn:
=========================

Business Data Analysis with Excel - https://youtu.be/v2oNWja7M2E
Learn Advanced Data Analysis in Excel (Course) - https://chandoo.org/wp/resources/50-ways-to-analyze-data/

#Statistics #Excel

Видео REPLAY ~ Statistical Analysis with Excel - Beyond Basics - Masterclass канала Chandoo