Running times (Y) and maximal aerobic capacity (X) for 14female
Runners. Data collected for running times and maximal aerobiccapacity are listed
below
X: 61.32 55.29 52.83 57.94 53.31 51.32 52.18 52.37 57.91 53.9347.88 47.41
47.17 51.05
Y: 39.37 39.80 40.03 41.32 42.03 42.37 43.93 44.90 44.90 45.1245.60 46.03
47.83 48.55
(a) Calculate the mean, median, MAD, MSD, and standard deviationfor each
variable. ? [Include all your steps and explain all the stepsinvolved in details]
(b) Which of these statistics give a measure of the center of dataand which give a
measure of the spread of data? [Explain in your own words]
(c) Calculate the correlation of the two variables and pro-duce ascatterplot of Y
against X. [Use excel for scatterplot, show all your computationsconcerning
the correlation and explain all your steps]
(d) Why is it inappropriate to calculate the autocorrelation ofthese data? [Explain in
your own words]
PLEASE SHOW ANSWER WORKED CALCULATIONS ON EXCEL AS PERQUESTION REQUIREMENTS.
