EXCEL EXAM 2

# EXCEL EXAM 2 - Math 1107-Elementary Statistics Exam...

This preview shows pages 1–4. Sign up to view the full content.

Math 1107--Elementary Statistics Name This test should be an individual effort. DO NOT work with anyone else on this test!!! Please make sure to record your answers for problems 1-26 on the answer sheet!! Test is due by Tuesday, July 13, 2009!! 1. A town's snowfall in December averages 18 inches with a standard deviation of 8 inches while in February, the average snowfall is 49 inches with a standard deviation of 13 inches. In which month is it more likely to snow 32 inches? Explain. a. February. Snowfall of 32 inches is -1.3 SDs from the mean while snowfall of 32 inches is 1.75 SDs from the mean in December. b. February. Snowfall of 32 inches is 1.75 SDs from the mean while snowfall of 32 inches is -1.3 SDs from the mean in December. c. December. Snowfall of 32 inches is -1.3 SDs from the mean while snowfall of 32 inches is 1.75 SDs from the mean in February. d. December. Snowfall of 32 inches is 1.75 SDs from the mean while snowfall of 3 inches is -1.3 SDs from the mean in February. e. It is equally likely in either month. One can't predict Mother Nature. 2. For a recent English exam, use the Normal model N(73, 9.2) to find the percent of scores under 58. a. 1.63% b. 95.80% c. 4.20% d. 94.80% e. 5.20%

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
3. The weekly salaries (in dollars) of 24 randomly selected employees of a company are shown below, and displayed on the boxplot. Find the mean and the median. Which is the most appropriate measure of center? 310 320 450 460 470 500 520 540 580 600 650 700 710 840 870 900 1000 1200 1250 1300 1400 1720 2500 3700 Mean Median a. \$979.00 \$705.00 The median is the most appropriate measure of center, because of the outliers. b. \$942.00 \$700.00 The mean is the most appropriate measure of center, because of the outliers. c. \$979.00 \$705.00 The median is the most appropriate measure of center, because the outliers are not significant in the distribution. d. \$979.00 \$705.00 The median is the most appropriate measure of center, because the outliers are not significant in the distribution. e. \$979.00 \$705.00 The median is the most appropriate measure of center, because of the outliers. 4. The test scores of 19 students are listed below. Find the upper quartile (q3). 36 45 49 53 55 56 59 61 62 65 69 70 77 81 84 88 89 93 96 a. 82.5 b. 84.0 c. 65.0 d. 81.0 e. 55.5
5. The boxplots display case prices (in dollars) of white wines produced by three vineyards in the western United States. Describe these wine prices. a. Vineyards A and B have about the same average price; the boxplots show simila medians and similar IQRs. Vineyard C has higher prices except for one low outl and a more consistent pricing as shown by the smaller IQR. b. Vineyards A and B have about the same average price; the boxplots show simila medians and similar IQRs. Vineyard C has higher prices except for one low outl and a more consistent pricing as shown by the smaller IQR. The three distributio are roughly symmetric. c.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 35

EXCEL EXAM 2 - Math 1107-Elementary Statistics Exam...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online