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

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
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
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?