Excel Work Solution 1 and 2

Excel Work Solution 1 and 2

Excel Work Solution Questions 1 and 2

1 (TCO 3) Use this table to answer the questions.Height (in inches)Frequency

8-11      18

12-15    23

16-19    38

20-23    47

24-27    32

1. Identify the class width.

2. Identify the midpoint of the first class.

3. Identify the class boundaries of the first class.

4. Give the relative frequency for each class.

(Points : 10)

2. (TCO 3) The numbers of homeruns that Sammy Sosa hit in the first 13 years of his major league baseball career are listed as: 4, 15, 10, 8, 33, 25, 36, 66, 63, 50, 64, 49, 40.

1. Display the data in a stem-and-leaf plot.

2. Find the mean.

3. Find the median.

4. Find the mode.

5. Find the range.

6. Find the variance.

7. Find the standard deviation.