please use excel as well Watch the above video, and solve the...

50.1K

Verified Solution

Question

Accounting

please use excel as well image
Watch the above video, and solve the problem on a Microsoft Excel and submit the Excel file and the PDF file on the Canvas, prior to Midnight of the due date. 9.16 A bottled water distributor wants to determine whether the mean amount of water contained in 1-gallon bottles purchased from a nationally known water bottling company is actually 1 gallon. You know from the water bottling company specifications that the standard deviation of the amount of water per bottle is 0.02 gallon. You select a random sample of 50 bottles, and the mean amount of water per 1-gallon bottle is 0.995 gallon. a. Is there evidence that the mean amount is different from 1.0 gallon? (Use =0.01.) b. Compute the p-value and interpret its meaning. c. Construct a 99% confidence interval estimate of the population mean amount of water per bottle. d. Compare the results of (a) and (c). What conclusions do you reach

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students