Answer:
Explained below.
Step-by-step explanation:
Consider the data provided.
(a)
Compute the mean of the data in seconds as follows:
Mean =AVERAGE(array)
= 225.280 seconds
(b)
Compute the median of the data in seconds as follows:
Median =QUARTILE.EXC(array,2)
= 229 seconds
(c)
Compute the variance of the data in seconds as follows:
Variance =VAR.S(array)
= 1148.043 seconds
(d)
Compute the standard deviation of the data in seconds as follows:
Standard deviation =STDEV.S(F2:F26)
= 33.883 seconds.
(e)
Compute the median of the data in minutes as follows:
Median =QUARTILE.EXC(array,2)
= 3.755 minutes.
(f)
Compute the median of the data in minutes as follows:
Median =QUARTILE.EXC(array,2)
= 3.817 minutes
(g)
Compute the variance of the data in minutes as follows:
Variance =VAR.S(array)
= 0.319 minutes
(h)
Compute the standard deviation of the data in minutes as follows:
Standard deviation =STDEV.S(F2:F26)
= 0.565 minutes.
