Главная
Study mode:
on
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
Description:
Dive into advanced Excel techniques for statistical analysis in this comprehensive 26-minute tutorial. Master Power Query for data import and transformation, utilize array formulas to create a 5-Number Summary, and learn to construct Box & Whiskers Charts from both improper and proper data sets. Explore topics including QUARTILE.INC function, calculating means and outliers, and interpreting CPA data set box plots. Gain proficiency in using COUNTIFS, FILTER array functions, and converting single input-output formulas to spilled array formulas. Understand the difference between improper and proper data sets, and learn how to use Power Query's unpivot feature for data transformation. By the end of this tutorial, create professional Box & Whisker Charts and enhance your Excel skills for statistical analysis.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Mathematics #Statistics & Probability #Statistical Analysis #Data Science #Data Analysis #Data Interpretation #Data Processing #Data Transformation #Business Intelligence #Power Query #Spreadsheets #Array Formulas
0:00 / 0:00
1 of 23

) Introduction to Box & Wisker Chart and Power Query to convert an Improper Data Set to a Proper Data Set