BD1Golden State 5kRunner # AgeTimeDuration Frequency34880620 0:18:430:14:2453092200:16:340:28:486756210:28:480:43:1273768220:14:240:57:3686062220:57:361:12:004746220:27:221:26:24103503230:22:19118113230:28:48122913240:17:17Age138526250:22:1918149205270:27:2221151897270:50:5230163569280:25:3840177294280:17:4350183428290:16:3460193299360:43:12>60204022430:57:36212987441:01:12Correlatior Covariance Variance Standard Deviation229309440:19:03235215461:01:12248683471:04:48254305470:35:17265796471:03:22276689480:19:03284673491:04:48298613491:04:48309469510:33:24311936511:04:48325436551:37:12334752551:04:48342398551:04:48RaceResultsVolunteerInfoParticipantsE.A,2.O E N Ensure the RaceResults worksheet is active, then use the FREQUENCY function to calculatethe frequency distribution of the race results in column D. Place your results in the rangeG4:G9.Enter a function in cell F22 to calculate the correlation between age (Columns C) and racetime (Column D).Enter a function in cell G22 to calculate the covariance between age and race time.Enter a function in cell H22 to calculate the variance of the ages in the data set. Note this is asample of data not a population.Enter a function in cell 122 to calculate the standard deviation of the ages in the data set.

Correlation: By correlation we mean the association or interdependence between two variables. If two variables are related in such a manner that a change in the value of one of them is accompanied by a change in the value of the other, they are said to be correlated. Covariance: Let (x1, y1), (x2, y2), ... , (xn, yn) be n set of observations for the variables (x, y). Then the covariance between x and y is given by, Variance: For a set of n observations, x1, x2, ... , xn, variance is given by, Standard deviation: For a set of n observations, x1, x2, ... , xn, standard deviation is given by,Correlation between age and race time In cell F22, write the formula =CORREL(C4:C34,D4:D34) and hit enter. This will calculate the correlation between age and race. Covariance between age and race time In cell G22, write the formula =COVARIANCE.P(C4:C34,D4:D34) and hit enter. This will calculate the covariance between age and race. Variance of ages In cell H22, write the formula =VAR.S(C4:C34) and hit enter. This will calculate the variance of ages of the data. Standard deviation of ages In cell I22, write the formula =STDEV.S(C4:C34) and hit enter. This will calculate the standard deviation of ages of the data. (Answer)