## (Solved) Area Gas Prices - Random Sample Minneapolis Price of Regular Station Unleaded 1 \$3.24 2 \$3.03 3 \$3.63 4 \$3.58 5 \$2.94 6 \$3.68 7 \$3.14 8 \$3.36 9 \$3.40...

Question:

Use the following files, linked in the Resources under the Required Resources heading, to complete both of the scenarios for this assessment:

• Confidence Interval Calculator.
• Area Gas Prices â€“ Random Sample.
• Sample Size Estimator.
Practical Application Scenario 1

To complete this scenario, use theÂ Confidence Interval CalculatorÂ and theÂ Area Gas Prices â€“ Random SampleÂ files.

The MinneapolisÂ Star TribuneÂ newspaper has decided to write an article about gasoline prices in the Twin Cities area (Minneapolis and Saint Paul, Minnesota). TheÂ Star TribuneÂ has designed a survey and taken a simple random sample of regular, unleaded gas prices at 70 area stations. The results are in the Area Gas Prices â€“ Random Sample file. TheÂ Star Tribune'sÂ policy is that no data will be reported unless it is 95 percent confident that the numbers are correct. As the new manager of the data verification unit at theÂ Star Tribune, you need to develop a 95 percent confidence interval for the average price of regular unleaded gasoline in the area.

• Complete a confidence interval for the data provided, using tables to demonstrate your method and findings.
• Write a 3â€“5 sentence summary that communicates your results to theStar Tribune's business manager.
Practical Application Scenario 2

To complete this scenario, use theÂ Sample Size EstimatorÂ file.

The third shift at Microsoft Windows' security unit in Redmond, Washington, is considering replacing its coffee brewing units with new German-made brewers. As the newest member of this elite Microsoft team, you have been assigned to investigate this proposal. Develop a 99 percent confidence interval for the average yield (cups per pound) for the new German coffee brewer. The margin of error should be no bigger than .3 (three-tenths of a cup). Based on experience with the current coffee makers, your best guess for the population standard deviation, sigma, is 1.2 cups. How large a sample do you need?

• Calculate the estimated sample size needed for the above scenario, using tables to demonstrate your method and findings.
• Write a 3â€“5 sentence summary that communicates your results to the business manager.

Compile your work for both scenarios in one Microsoft Word file:

• Paste in the tables you used.
• Clearly title your tables, including each row and column.
• Highlight the results of your data calculations within each table.
• Summarize your findings for each scenario in a 3â€“5 sentence paragraph below each table.

Area Gas Prices â€“ Random Sample
Minneapolis
Price of
Regular
Station
1
\$3.24
2
\$3.03
3
\$3.63
4
\$3.58
5
\$2.94
6
\$3.68
7
\$3.14
8
\$3.36
9
\$3.40
10
\$3.20
11
\$2.85
12
\$3.80
13
\$3.31
14
\$3.78
15
\$3.43
16
\$3.27
17
\$3.18
18
\$3.48
19
\$3.00
20
\$3.36
21
\$3.52
22
\$3.26
23
\$3.04
24
\$3.17
25
\$3.26
26
\$3.27
27
\$3.30
28
\$3.51
29
\$3.80
30
\$3.05
31
\$3.56
32
\$3.53
33
\$2.96
34
\$3.57
35
\$3.58
End of worksheet Station
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70 St. Paul Price
of Regular
\$3.05
\$2.89
\$3.84
\$3.50
\$2.78
\$3.51
\$3.33
\$3.31
\$3.20
\$3.15
\$2.75
\$3.79
\$3.10
\$3.92
\$3.31
\$3.45
\$3.17
\$3.44
\$2.93
\$3.21
\$3.37
\$3.08
\$3.04
\$3.24
\$3.17
\$3.36
\$3.25
\$3.62
\$3.88
\$3.02
\$3.68
\$3.29
\$2.81
\$3.43
\$3.44

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 05, 2019

Solution~000200028162.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 05, 2019

EXPERT

Tutor