1. Plywood, Inc. reported these returns on stockholder equity for the past 5 years: 4.3, 4.9, 7.2, 6.7, and 11.6. Consider these as population values.

a. Compute the range, the arithmetic mean, the variance, and the standard deviation.

2. The annual incomes of the five vice presidents of TMV Industries are: $125,000; $128,000; $122,000; $133,000; and $140,000;. Consider this a population.

a. What is the range?

b. Whats is the arithmetic mean income?

c. What is the population variance? The standard deviation?

d. The annual incomes of officers of another firm similar to TMV Industries were also studied. The mean was $129,000 and the standard deviation $8,612. Compare the means and dispersions in the two firms.

3. Construct a histogram, a frequency polygon, and an ogive for the following frequency distribution.

Class Interval Frequency

50-under 60 13

60-under 70 27

70-under 80 43

80-under 90 31

90-under 100 9

4. Construct a stem and leaf plot for the following data.

Let the leaf contain one digit.

312 324 289 335 298

314 309 294 326 317

290 311 317 301 316

306 286 308 284 324

5. An examination of rejects shows at least 10 problems.A frequency tally of the problems follows. Construct a Pareto chartfor these data.

Problem Frequency

1 673

2 29

3 108

4 379

5 73

6 564

7 12

8 402

9 54

10 202

6. The top music genres according to sound scan for a recent year R & B, Alternative (Rock) Music, Rap, and Country. These and other music genres along with the number of albums sold in each (in millions) are shown.

Genre Albums Sold

R&B 146.4

Alternative 102.6

Rap 73.7

Country 64.5

Soundtrack 56.4

Metal 26.6

Classical 14.8

Latin 14.5

Construct a pie chartfor these data displaying the percentage of the whole that each of these genres represents.

This solution provides answers to various statistics questions in Excel.