Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas

Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas

ExcelIsFun via YouTube Direct link

) Create Box & Whisker Chart from table with five columns of CPA Score data

16 of 23

16 of 23

) Create Box & Whisker Chart from table with five columns of CPA Score data

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.