Confidence interval | Statistics homework help


Initial Post: Assuming .05 as your alpha value, make up a problem similar to this one below. (Make up 36 gas prices for your example – be sure they are similar to the prices you have had in your area.)  List the values in your post.

In your response, describe what you did and give the mean, standard deviation and confidence interval.

Example below:

  • First find the      mean. List all 36 gas prices in cells A1 to A36 in your excel spreadsheet.
  • On a different      cell type in =average(A1:A36) and the hit enter to find the average
  • Assume your      answer is 2.65
  • On a different      cell type in =stdev.s(A1:A36) or =stdevA(A1:A36) and      enter to find the standard deviation
  • Assume your      answer is .43
  • Then type this      in an excel cell =confidence(.05,.43,36) and hit enter.      This is the E value
  • So take the mean      of 2.65 and you have (2.65-E, 2.65+E) for your confidence interval

Formula you used above for the confidence interval:

The formula is E= zsubc * sigma / sqrt n

Where the left-hand endpoint is xbar – E and the right-hand endpoint is xbar + E

The above is an example. Please come up with something similar. Keep the answer separate please

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.