Completed
) Use COUNTIFS function to count the number of Outliers. Learn about Comparative Operators in COUNTIFS, SUMIFS and other similar functions.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to Box & Wisker Chart and Power Query to convert an Improper Data Set to a Proper Data Set
- 2 ) Look at csv table of data, 5-Number Summary and Chart button for Box and Wisker Chart
- 3 ) What is a Box and Wisker Chart (Box Plot)? How does it show spread in data?
- 4 ) Power Query to Import csv file
- 5 ) Create 5-Number Summary. Learn a number of different array formula tricks. Learn about COUNTIFS function also.
- 6 ) QUARTILE.INC function to calculate 5 numbers for 5-Number Summary
- 7 ) Calculate Mean for each CPA Test Score Data Set using AVERAGE function
- 8 ) Look at where the numbers from 5-Number Summary are in the Box & Whiskers Chart.
- 9 ) Two methods for calculating Outliers
- 10 ) Calculate Outliers for Box & Whisker Chart. Make calculations with Single Input-Output Formulas.
- 11 ) Use COUNTIFS function to count the number of Outliers. Learn about Comparative Operators in COUNTIFS, SUMIFS and other similar functions.
- 12 ) Using FILTER Array Function to show the number of outliers for a given data set
- 13 ) Learn about the difference between entering a comparative operator into the COUNTIFS and Direct Logical Test formula elements
- 14 ) Convert Outlier Make Single Input-Output Formulas to Spilled Array Formulas
- 15 ) For this example, with the five column data set, we cannot spill the COUNTIFS formula
- 16 ) Create Box & Whisker Chart from table with five columns of CPA Score data
- 17 ) Changing Box and Whiskers Chart from Exclusive Quartile Calculation to Inclusive
- 18 ) Interpreting the CPA Data sets Box Plots
- 19 ) What is an Improper Data Set with a Pivoted Column (Field)? What is a Proper Data Set with only Variable Fields?
- 20 ) Unpivot Power Query feature to convert an Improper Data Set to a Proper Data Set.
- 21 ) Create Box & Whisker Chart from proper data set table with one column for Test Name and one for Test Score
- 22 ) Summary
- 23 ) Conclusion and Video Links
