Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5 (Problem Scenario taken from Basic Business Statistics Concepts and Applications, eighth edition, by Berenson, Levine, and Krehbiel) A machine used for packaging seedless golden

5 (Problem Scenario taken from Basic Business Statistics Concepts and Applications, eighth edition, by Berenson, Levine, and Krehbiel) A machine used for packaging seedless golden raisins is set so that the standard deviation in the weight of raisins packaged per box is 0.25 ounces. The operations manager is concerned that the machine is out of calibration and that the variability in weights significantly differs from the stated value of 0.25 ounces. Place your answers for Question 5 in the worksheet named Raisins. a. b. c. d. e. f. 1 Point: Calculate the best point estimate of the population mean using a built-in Excel function. Place your answer in cell E5. 1 Point: Calculate the sample standard deviation using a built-in Excel function. Place your answer in cell F5. 4 Points: Using the StatTools One-Sample Confidence Interval, develop 95% confidence intervals for the mean weight of raisins packaged per box and the standard deviation of the weights. Place your output with the upper left hand cell in cell J5. 2 Points: Place the cell references for the Lower Limit and the Upper Limit of the 95% Confidence Interval for the Mean Weight of Raisins Packaged per Box from StatTools in cells D12 and F12, respectively. 2 Points: Place the cell references for the Lower Limit and the Upper Limit of the 95% Confidence Interval for the Standard Deviation of Weights of Raisins Packaged per Box from StatTools in cells D19 and F19, respectively. 4 Points: Based on your confidence interval results, make a conclusion regarding the variability in weights for a report to the operations manager. Place your statement in cell D27. Grade = 100 Question Worth 1 2 3 4 5 Total 20 14 12 40 14 100 Points Lost 0 0 0 0 0 0 Package Weight in Number Ounces 1 15.2 2 15.0 3 14.3 4 15.3 5 15.2 6 14.4 7 15.1 8 9 15.4 15.5 10 11 15.7 15.6 12 13 14 15 15.4 15.3 15.7 15.2 16 17 15.0 15.4 18 19 20 21 22 23 24 25 26 27 28 29 30 15.5 15.1 15.3 15.6 14.3 14.9 15.1 14.6 14.8 15.3 14.5 14.6 15.1 Question 5 Confidence Interval Estimates for the Weights of Raisins Packaged p Sample Statistics Mean = Std Dev = StatTools LL Grader a b 95% C. I. for m UL

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discrete Mathematics and Its Applications

Authors: Kenneth H. Rosen

7th edition

0073383090, 978-0073383095

More Books

Students also viewed these Mathematics questions