MATH 120 WK 6 The Average Price of A Gallon of Gas in Your Region Analysis

Imagine that you want to estimate the average price of a gallon of gas in your region. You record the price of gas at 36 different gas stations (you can make these up). In your initial post, you will simply give those values, then use Excel to compute a 95% Confidence Interval for the average price. Rather than just attaching your Excel file, paste your results (or upload as an image) into the post.

1. List all 36 gas prices in cells A1 to A36 in your excel spreadsheet.
2. Type =average(A1:A36) to find the sample mean
3. Type =stdev.s(A1:A36) to find the sample standard deviation
4. Let’s assume your sample mean is 3.65 with a std of 0.43.
5. Determine the Margin of Error (for 0.05 significance) by typing =confidence.norm(.05,.43,36). This is your E value
6. Finally, compute the 95% Confidence Interval by adding and subtracting the Margin of error from your mean: =(3.65 + E) for the Upper bound and =(3.65 – E) for the Lower bound

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back