Respuesta :
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.
