In: Math
Running times (Y) and maximal aerobic capacity (X) for 14
female
Runners. Data collected for running times and maximal aerobic
capacity are listed
below
X: 61.32 55.29 52.83 57.94 53.31 51.32 52.18 52.37 57.91 53.93
47.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.12
45.60 46.03
47.83 48.55
(a) Calculate the mean, median, MAD, MSD, and standard deviation
for each
variable. ? [Include all your steps and explain all the steps
involved in details]
(b) Which of these statistics give a measure of the center of data
and 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 a
scatterplot of Y
against X. [Use excel for scatterplot, show all your computations
concerning
the correlation and explain all your steps]
(d) Why is it inappropriate to calculate the autocorrelation of
these data? [Explain in
your own words]
PLEASE SHOW ANSWER WORKED CALCULATIONS ON EXCEL AS PER QUESTION REQUIREMENTS.