(Solved): 1. (Submit a screenshot of the histogram) Create a histogram for column "Midterm" using Excel Data ...

1. (Submit a screenshot of the histogram) Create a histogram for column "Midterm" using Excel Data Analysis Function with the following bin in data range C2: C7. Output range is \( E 1 \). Adjust the chart so that the lower right corner is in cell P20. Edit the chart title so that it is read as "Created by Pauline Fu" (replace Pauline Fu with your name). Rename the bin in column E so that it includes both the lower limit and upper limit (for example, 0 to 49,50 to 59,60 to 69 etc). Add data labels - outside end. Remove gap among bars (set gap width to \( 0 \% \) ). Bin 49 59 69 79 89 99 2. (Submit a screenshot of your written or typed answer) Describe the natures of the histograms (uniform, normal, skewed left, skewed right). 3. (Submit a screenshot of the frequency distribution table.) Using Excel to construct a frequency distribution table, relative frequency distribution, and cumulative relative frequency distribution of the data using the following class limit. For relative frequency and cumulative relative frequency, use percent format with zero decimal. 4. (Submit a screenshot from Excel with your name in cell F32) Using Excel to calculate the descriptive statistic: mean, median, standard deviation (consider the given data as a sample), first quartile (Q1), third quartile (Q3), and interquartile range (IQR). Use QUARTILE.INC for quartile. Keep 3 decimals where applicable. 5. (Submit a screenshot of Box-plots). Construct a box-plot for the data. Use your name as the chart title. Identify 5-number summary on the box-plot. Calculate \( 1.5^{*} \mid Q R \). How do you determine the outliers? Keep whole numbers. 6. (Submit a screenshot of your written or typed answer) Suppose a student has a midterm 6. calculate the z-score for this student. Keep 3 decimals. Provide an explanation that you would say to someone about this z-score who does not have statistics knowledge.