Below you will find a list of the the top serve speeds of female competitors from the 2012 Australian Open tennis tournament. 1) Compute the mean top serve speed from this list usinga single Excel...

//

Extracted text: Below you will find a list of the the top serve speeds of female competitors from the 2012 Australian Open tennis tournament. 1) Compute the mean top serve speed from this list usinga single Excel formula in Cell B40. 2) Compute the standard deviation of the top serve speed from this list using a single Excel formula in Cell B41. 3) Compute the z-score for each player's top serve speed and enter these values in cells C19- C38. lexpect you to use a formula and reference the cells containing the mean and standard deviation cells (B40 and B41). Itis wise to use the permanent reference option (ie., SB540) so you can easily copy the formula down the column. Be sure cell C19 correctly copies over to the answer sheet for Question 3. 4) Compute the mean and standard deviation of this data in z-score using the appropriate formulas in cells C40 and C41, respectfully. If you have computed these correctly, these are the values for the mean and standard deviation for any sample that has been converted to z-score. 5) Returning to the original values of the serve speeds (not the z-scores), use the Excel formula to compute the median serve speed and report it in cell B44. 6) Compare the mean from cell B41 and the median from cell B44. Based on this comparison, do you expect the data to be positively or negatively skewed? Explain your reasoning in a single sentence in cell B47. 7) Use the Descriptive Statistics function found in Excel's Data Analysis application to produce the summary statistics for this sample of top serve speeds such that the upper left hand corner of this output is found in cell B49. 8) In cell B66, evaluate your expectations of the skewness from 06 with the reported skewness statistic from the summary statistics in Q7. Serve Speed (km/h) Z-score 191 190 187 187 Player S. Williams S. Lisicki M. Keys L. Hradecka J. Gajdosova J. Hampton B. Mattek-Sands F. Schiavone P. Parmentier N. Petrova G. Am V. Azarenka A. Ivanovic P. Kvitova M. Krajicek V. Dushevina S. Stosur S. Cirstea M. Barthel P. Ormaechea 187 181 181 179 179 179 179 178 178 178 178 178 178 177 177 177 Mean St.Dev. Q5 Median Q6 Probability Q7 QB Skewness