Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas
Offered By: ExcelIsFun via YouTube
Course Description
Overview
Syllabus
) Introduction to Box & Wisker Chart and Power Query to convert an Improper Data Set to a Proper Data Set.
) Look at csv table of data, 5-Number Summary and Chart button for Box and Wisker Chart.
) What is a Box and Wisker Chart (Box Plot)? How does it show spread in data?.
) Power Query to Import csv file.
) Create 5-Number Summary. Learn a number of different array formula tricks. Learn about COUNTIFS function also..
) QUARTILE.INC function to calculate 5 numbers for 5-Number Summary.
) Calculate Mean for each CPA Test Score Data Set using AVERAGE function.
) Look at where the numbers from 5-Number Summary are in the Box & Whiskers Chart..
) Two methods for calculating Outliers.
) Calculate Outliers for Box & Whisker Chart. Make calculations with Single Input-Output Formulas..
) Use COUNTIFS function to count the number of Outliers. Learn about Comparative Operators in COUNTIFS, SUMIFS and other similar functions..
) Using FILTER Array Function to show the number of outliers for a given data set.
) Learn about the difference between entering a comparative operator into the COUNTIFS and Direct Logical Test formula elements.
) Convert Outlier Make Single Input-Output Formulas to Spilled Array Formulas.
) For this example, with the five column data set, we cannot spill the COUNTIFS formula.
) Create Box & Whisker Chart from table with five columns of CPA Score data.
) Changing Box and Whiskers Chart from Exclusive Quartile Calculation to Inclusive.
) Interpreting the CPA Data sets Box Plots.
) What is an Improper Data Set with a Pivoted Column (Field)? What is a Proper Data Set with only Variable Fields?.
) Unpivot Power Query feature to convert an Improper Data Set to a Proper Data Set..
) Create Box & Whisker Chart from proper data set table with one column for Test Name and one for Test Score.
) Summary.
) Conclusion and Video Links.
Taught by
ExcelIsFun
Related Courses
Introduction to Operations ManagementWharton School of the University of Pennsylvania via Coursera Computational Molecular Evolution
Technical University of Denmark (DTU) via Coursera Structural Equation Model and its Applications | 结构方程模型及其应用 (普通话)
The Chinese University of Hong Kong via Coursera Fundamentals of Clinical Trials
Harvard University via edX Curso Práctico de Bioestadística con R
Universidad San Pablo CEU via Miríadax