Question: Using Excel, create a box plot (also known as a box-and-whisker plot) for the Grade variable. This plot should display the following: Minimum (excluding outliers):
Using Excel, create a box plot (also known as a box-and-whisker plot) for the "Grade" variable. This plot should display the following: Minimum (excluding outliers): The lowest value within 1.5 times the interquartile range (IQR) from the lower quartile. First Quartile (Q1): The 25th percentile of the data. Median (Q2): The 50th percentile or middle value of the data. Third Quartile (Q3): The 75th percentile of the data. Maximum (excluding outliers): The highest value within 1.5 times the IQR from the upper quartile. Outliers: Data points that fall outside the "whiskers" (1.5 times the IQR from the quartiles)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
