U. 13 QUESTION 3 10 points Please save the excel file showing your calculations and attach it here. Save the file with your name and ID Attach it here Marks will be given only if the functions in Excel are used for the calculations. NO marks will be given if your excel file shows only the answers. For grading we will click on the number in the Excel file, and see the calculation that was used. The information in the Excel file is used in the next question, to draw a Box & Whisker plot. Attach File Browse My Computer Browse Content Collection QUESTION 4 14 points say On paper, sketch a Box and Whisker plot for the data given in the previous question. Grading points: Use Excel to calculate the following (An answer Inay be used more than once.) The Mean - A 45 B. 65.5 C.53 The Median The Minimum The First Quartile 01 The Second Quartile Q2 The Third Quartie 23 The Maximum The Range The Interquartile Range IOR - I 13.5 - - 3 - - - x The Lower Fence The Upper Fence 3 The Standard Deviation z The Variance The Shape of the distribution is 0.46 Pe Skewed The left-hand whisker ends at the value a do The right hand whisker ends at the value A. Right Skewed The number of outliers in the data is - The Toth percentile 3 A ' Font = Alignment % Paste Number Format as Table Cell Styles Cells Editing Ideas Sensitivit M2 * C v D K NO Questions Mean Median fx B E F G H I J Dataset 22 46 48 33 42 31 47 39 474 36 49 32 46 1042 44 32 46 45 43 40 22 30 48 49 22 46 384046384630 4442 603041373034 2231 45 42 40 36 6350 33 31 36 44 34 37 5034 4331 383539 44 43 3431 40623338 41 4947 Min 32 Range IOR Lower fence Upper fence Standard deviation Variance 70th percentile The largest three numbers are highlighted in Red The smallest three numbers are highlighted in Green