Question

A firm wants to establish how long it is supposed to take to assemble a certain product.

A random sample of 13 employees is selected and the company measures how long it takes each of them to assemble the product rounded to the nearest minute.

Data: 5; 45; 11; 9; 14; 22; 45; 16; 30; 25; 19; 45; 15

Solve the following by hand.

You must show your work including the formulas and all your computations.

3. The mean is: _______

4. The median is: _____

5. The mode is: ______

6. The first quartile is: ____

7. The third quartile is: ____

8. The range is: ______

9. The IQR is: ______

10. The variance is: ______

11. The standard deviation is: ______

12. The coefficient of variation is: ______

13. Convert the 8 into a Z-score: _______

14. Convert the 30 into a Z-Score _______

15. Which of the following is not a measure of location?

(a) mean   (b) median   (c) variance   (d) percentile    (e) quartile  

Answer 1

Mean	23.15385
Median	19
Mode	45
The first quartile is	14
The third quartile is	30
The range is:	40
The IQR is	16
The variance is:	198.31
The standard deviation is: _	14.08
The coefficient of variation is	0.61

Formula Ref:

Mean	=AVERAGE(A1:A13)
Median	=MEDIAN(A1:A13)
Mode	=MODE(A1:A13)
The first quartile is	=QUARTILE(A1:A13,1)
The third quartile is	=QUARTILE(A1:A13,3)
The range is:	=MAX(A1:A13)-MIN(A1:A13)
The IQR is	=F8-F7
The variance is:	=VAR(A1:A13)
The standard deviation is: _	=STDEV(A1:A13)
The coefficient of variation is	=F12/F4

Convert the 8 into a Z-score:

Z = (x- μ) / σ

Z =(8 - 23.15) / 14.08

Z = -1.08

Convert the 30 into a Z-Score

Z =(30- 23.15) / 14.08

Z = 0.49

Which of the following is not a measure of location?

Variance