PREFFERED IN EXCEL AND SHOWING ALL STEPS QUESTION 1 The foll

**PREFFERED IN EXCEL AND SHOWING ALL STEPS**

QUESTION 1
The following data represent salaries, in thousands of dol- lars, for employees of a small company. Notice that the data have been sorted in increasing order.
24 25 25 27 27 29 30 35 35 35 36 38 38 39 39 40 40 40 45 45 45 45 47 52 52 52 58 59 59 61 61 67 68 68 68 250
(a) Make a histogram using the class boundaries 23.5, 69.5, 115.5, 161.5, 207.5, 253.5.
(b) Look at the last data value. Does it appear to be an outlier? Could this be the owner’s salary?
(c) Eliminate the high salary of 250 thousand dollars. Make a new histogram using the class boundaries 23.5, 32.5, 41.5, 50.5, 59.5, 68.5. Does this his- togram reflect the salary distribution of most of the employees better than the histogram in part (a)?

QUESTION 2

Wetlands offer a diversity of benefits. They provide a habitat for wildlife, spawning grounds for U.S. commercial fish, and renewable timber resources. In the last 200 years, the United States has lost more than half its wetlands. Environmental Almanac gives the percentage of wetlands lost in each state in the last 200 years. For the lower 48 states, the percentage loss of wetlands per state is as follows:
46 37 36 42 81 20 73 59 35 50 87 52 24 27 38 56 39 74 56 31 27 91 46 9 54 52 30 33 28 35 35 23 90 72 85 42 59 50 49
48 38 60 46 87 50 89 49 67
Make a stem-and-leaf display of these data. Be sure to indicate the scale. How are the percentages distributed? Is the distribution skewed? Are there any gaps?

Solution