Completed
) For this example, with the five column data set, we cannot spill the COUNTIFS formula
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
