Question

The data below indicate the time (in seconds) that it takes 25 separate employees to complete a certain task. hw1_q5.csva) What is the mean of the data in seconds? Give your answer to three decimal places.b) What is the median of the data in seconds?c) What is the variance of the data in seconds? Give your answer to three decimal places.d) What is the standard deviation of the data in seconds? Give your answer to three decimal places.e) What is the mean of the data in minutes? Give your answer to three decimal places.f) What is the median of the data in minutes? Give your answer to three decimal places.g) What is the variance of the data in minutes? Give your answer to three decimal places.h) What is the standard deviation of the data in minutes? Give your answer to three decimal places.seconds260224221255236215193285244284222185182197253191255231229168152221244239246

Answer 1

Explained below.

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.