Federer Control-First Serve Speeds (km/h) 206.80 205.40 200.70 208.57 198.96 203.18 200.90 209.09 199.95 203.18 201.01 212.35 200.03 203.76 202.70 213.21 200.54 208.10 221.76 218.34 Federer Prestige -First Serve Speeds (km/h) 197.19 201.89 202.90 211.64 197.27 199.44 203.37 212.77 198.92 199.71 204.44 212.71 199.16 201.21 205.15 205.65 199.24 202.70 209.87 226.60 (a) Use EXCEL to obtain a histogram for each racquet. Use bin steps of size 5 starting from 195 through to 230 inclusive. (6 Marks) EXCEL Instructions: Go to the Assignments page on the course web site and download EXCEL file (This link) for this question, called Problem Solving Exercise (Part 3). Refer to Topic 6 in the Excel Booklet for instructions on how to obtain and format a histogram; use the bins given in the file. (b) Use EXCEL to obtain Descriptive Statistics, Quartile 1 (Q1) and Quartile 3 (Q3) for each racquet (6 Marks) EXCEL Instructions: Refer to Topic 7 in the Excel Booklet for instructions on how to obtain Descriptive Statistics and the two quartiles. (c) Based on the histograms in (a), briefly describe the shape (symmetry, modality and outliers) of the data for each racquet. (8 Marks) Instructions for identifying outliers: Whether an observation is an outlier is a matter of judgement. One rule commonly used for identifying outliers is the so-called 1.5 x IQR rule. An observation is suspected to be an outlier if it lies more than 1.5 x IQR below the first quartile Q1 or above the third quartile Q3