Help

52.82 The following dataset of 71 race times (in seconds) is given. 50.96 48.64 51.11 60.39 50.87 49.93 52.18 53.40 54.12 51.82 50.49 50.46 49.84 51.34 52.91 50.28 52.52 50.19 50.32 52.14 51.52 50.56 52.00 52.72 52.85 50.95 52.24 49.74 49.45 49.16 51.28 52.57 19.09 52.53 58.79 52.09 19.74 52.40 49.32 49.75 50.62 54.06 49.45 53.50 50.63 51.93 51.62 52.58 Using Microsoft Excel: 53.55 a) Calculate the sample mean, variance, standard deviation, range, 1st, 2nd, and 3rd quartiles, and the 60% 51.07 percentile of the data set. 49.76 b) Construct a histogram of the data using whatever number of intervals and equal interval widths you feel is 49.73 appropriate. Label the bins and axes. 50.90 59.26 c) Construct a dot diagram of the data. 49.29 d) Comment on anything unusual that you see. 52.78 112.72 49.79 49.83 52.43 51.28 52.22 49.76 49.70 52.90 50.19 54.33 62.45 51.93 52.24