Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots

preview_player
Показать описание
Topics in this video:
1. (00:09) Five Number Summary: Min, Quartile 1, Quartile 2, Quartile 3 and Max
2. (02:41) Box Plots: Visual Summary of the Five Number Summary. How to calculate numbers with Excel and draw chart on paper
3. (07:55) +/- 3 Standard Deviation Outliers
4. (08:37) ABS function to find outliers
5. (09:17) +/- 3 Standard Deviation Outliers, COUNTIFS to count TRUE values
6. (10:08) +/- 3 Standard Deviation Outliers, Conditional Formatting to highlight Outliers
  1. excelisfun
  2. Excel 2013
  3. Statistical Analysis
  4. Excel Statistics
  5. Highline College
  6. Business and Economic Statistical Analysis
Рекомендации по теме
Excel 2013 Statistical 0:11:45

Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots

Office 2013 Class 0:25:55

Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples)

Excel Statistical Analysis 0:13:23

Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions

Excel 2013 Statistical 0:31:54

Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical R...

Excel 2013 Statistical 0:09:54

Excel 2013 Statistical Analysis #49: Create Confidence Intervals Sigma Known Z-Score (3 Methods)

Excel 2013 Statistical 0:20:17

Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio

Excel 2013 Statistical 0:29:59

Excel 2013 Statistical Analysis #20: Standard Deviation: How Fairly Does Mean Represent Data Points?

What's New In 1:25:17

What's New In Excel 2013: Flash Fill, Functions, Data Model, PowerPivot, New Charts, Table Slic...

ATS Friendly Resume 0:16:05

ATS Friendly Resume for Data Analyst Fresher | Best CV Format 2024 | CV Format for Job

Excel 2013 Statistical 0:09:41

Excel 2013 Statistical Analysis #32: Expected Value Standard & Deviation Discrete Prob. Distribu...

Excel 2013 Statistical 2:22:43

Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)

Excel 2013 Statistical 0:25:27

Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)

Excel 2013 Statistical 0:19:28

Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information

Basic Excel Business 0:18:21

Basic Excel Business Analytics #23: Variability: Variance, Standard Deviation, Z-score and more

Excel 2013 Statistical 0:33:32

Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variab...

Excel 2013 Statistical 0:20:15

Excel 2013 Statistical Analysis #50: t Distribution Confidence Intervals Sigma NOT Known 3 Examples

Excel 2013 Statistical 0:31:07

Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabili...

Excel 2013 Statistical 0:20:55

Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank

Excel 2013 Statistical 0:32:08

Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD

Excel 2013 Statistical 0:41:36

Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable

Excel 2013 Statistical 0:18:37

Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Para...

Excel 2013 Statistical 0:10:03

Excel 2013 Statistical Analysis #47: Central Limit Theorem To Compare Sample Mean To Normal Curve

Office 2013 Class 0:32:40

Office 2013 Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples)

How to Check 0:00:26

How to Check Stock in Inventory in Excel? #shorts #excel

Комментарии
Автор

Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots
Topics in this video:
1. (00:09) Five Number Summary: Min, Quartile 1, Quartile 2, Quartile 3 and Max
2. (02:41) Box Plots: Visual Summary of the Five Number Summary. How to calculate numbers with Excel and draw chart on paper
3. (07:55) +/- 3 Standard Deviation Outliers
4. (08:37) ABS function to find outliers
5. (09:17) +/- 3 Standard Deviation Outliers, COUNTIFS to count TRUE values
6. (10:08) +/- 3 Standard Deviation Outliers, Conditional Formatting to highlight Outliers

excelisfun
Автор

I'm so happy to see your videos. You're my excel bible! :) and of course I'm waiting for the next one! Thanks for all these beautiful presents!

respiroconfuso
Автор

Regd :(3, 4, 5)
How do you consider +/- 3
I couldn't understand the concept behind it

sankargowda
Автор

I'm starting to think this guy actually made Excel from the ground up.

SniperShotNO
Автор

I just wanted to let you know that you have taken me from feeling like I would never pass my statistics class to actually enjoying learning from your videos. Thanks. Do you teach macro and finance to?

DrifaUlfarsdottirCPC
Автор

Hello Mike, question here. Considering the first method of finding outliers - Max+Multiple*Range - I'm afraid none will fall outside the Max value, did I misunderstand something here?

chriswang