Statistics Homework Solutions
Problem
#6873

I need to know how to solve this using EXCEL

I need to know how to do this using microsoft excel. Do not address this unless you can do it in EXCEL. thank you

Dunkin Donuts advertises that a dozen of their donuts weighs about 43 oz. A certain baker has figured out that she can stay out of trouble with her manager if each donut weighs about 3.6 oz. To test her donut-making process, she randomly selects thirty-one donuts after baking and weighs them. The average of the sample is 3.504 oz with s = 0.109 oz. Construct a 95% confidence interval for the true population mean of donut weights, and then explain whether or not she will be in trouble.

Solution
What is this?
By OTA - Overall OTA Rating
Jiong Tu, PhD (IP) - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
  • Plain text response
  • Attached file(s):
    • 95 CI.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Confidence Interval - Dunkin Donuts advertises that a dozen of their donuts weighs about 43 oz. A certain baker has figured out that she can stay out of trouble with her manager if each donut weighs about 3.6 oz. To test ...
  • Statistics Problem - (See attached file for full problem description) --- 1. Given the following population data: 1,2,4,5,8,9,12, and the lists of all samples of size 2 and 5: Samples of n = 2 xbar Samples ...
  • Confidence interval - Dunkin Donuts advertises that a dozen of their donuts weighs about 43 oz. A certain baker has figured out that she can stay out of trouble with her manager if each donut weighs about 3.6 oz. To test ...
  • Construct a 95% confidence interval for the true population mean of donut weights, and then explain whether or not she will be in trouble. - 1. Dunkin Donuts advertises that a dozen of their donuts weighs about 43 oz. A certain baker has figured out that she can stay out of trouble with her manager if each donut weighs about 3.6 oz. T ...
  • Confidence interval for a population mean - A researcher wishes to construct a 95% confidence interval for a population mean. She selects a simple random sample of size n=20 from the population. The population is normally distributed and sigma ...
Browse