Excel analysis - Engineering Statistics

CENE 225 Sample First Quiz

Name:_______________________________(last, first) Section ______

Please put your name here and on the top left side of the back- minus 2 points if missing Consider the following 26 integer numbers which constitute a population of data describing an issue of importance:

Provide the formula you are using with appropriate variable and symbols. (Precision 0.00 – 2 digits past decimal)

a) Compute the simple mean of this data: (2pts) Ans________________

b) Compute the median (Q50 or 50% value) of the data: (2pts) Ans________________

c) Find the standard deviation of this data. (2pts) Ans________________

d) Distribute this data to the 5 intervals listed below and compute the percentages.

Illustrate the distribution on the chart provided using frequency.

(4pts)

frequency percentage

>0 to ≤5 >5 to ≤10 >10 to ≤15 >15 to ≤20 >20 to ≤25 totals

e) Using the distribution numerically estimate the mean. (2 pts) Ans________________

f) Using the distribution numerically estimate the median. (2 pts) Ans________________

g) Using the distribution numerically estimate the standard deviation (2 pts) Ans________________

h) Using the original data calculate Q25 Q75 and the IQR. Develop a Box and Whisker Plot. (4pts)

i Xi X*i

1 8.5

2 24.1

3 14.8

4 21.4

5 16.2

6 19.0

7 17.3

8 13.1

9 6.1

10 18.1

11 12.7

12 4.2

13 0.5

14 9.1

15 13.5

16 23.9

17 9.9

18 11.1

19 15.2

20 24.9

21 5.1

22 14.1

23 13.9

24 6.2

25 12.1

26 15.5