Reference no: EM131190297

Assignment: Bottling Company Case Study

Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull a sample of bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment.

Use the data provided by Prof Jenkins by email in Excel format.Use 4 decimals of accuracy for all statistical calculations.

Write a two to three page report in which you:

1. Calculate the sample size, mean, median, and standard deviation for ounces in the bottles.

2. Construct a 95% Confidence Interval for the ounces in the bottles.

3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.

4. Provide the following discussion based on the conclusion of your test

a. If you conclude that there are less than sixteen ounces in a bottle of soda, speculate on three possible causes. Next, suggest the strategies to avoid the deficit in the future

OR

b. If you conclude that the claim of less soda per bottle is not supported or justified, provide a detailed explanation to your boss about the situation. Include your speculation on the reason(s) behind the claim, and recommend one strategy geared toward mitigating this issue in the future.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides. No citations and references are required, but if you use them, they must follow APA format. Check with your professor for any additional instructions.

• Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

• Be sure to read the rubric contained in Week 10 - Week 10 assignment 1. This rubric tells you exactly how I have to grade the paper.

Case Study Paper is due Sunday Jun 12 by midnight - NO EXCEPTIONS!Submit your paper through Blackboard Week - Week 10 - Assignment 1.

I will review your statistical calculations prior to the paper submission according to the following schedule.

Descriptive Statistics: The first intermediate assignment is to compute the sample size, mean, median, and standard deviation of the data. Use 4 decimals of accuracy. By SundayMay 1, midnight, send me an email with

1. Name:
2. Sample size:
3. Mean:
4. Median:
5. Standard Deviation:

Example:These are not the correct answers

1. Name: Gerry Jenkins
2. Sample size: 30
3. Mean:16.4412
4. Median:15.015
5. Standard Deviation: 0.4457

Confidence Interval: The second intermediate assignment is to compute a 95% confidence interval for the data. Use 4 decimals of accuracy. By SundayMay 22, midnight, send me an email with

1. Name: Gerry Jenkins
2. Which Distribution you are using (Z, t, X2, or F) and why you are using that distribution?
3. Degrees of Freedom (df), if applicable
4. Value of E, if applicable
5. Lower Limit of the confidence interval
6. Upper Limit of the confidence interval
7. Conclusion based on the confidence interval as to whether the bottles are being filled correctly. That is, is 16 oz in the interval?

Example:These are not the correct answers

1. Name: Gerry Jenkins
2. Distribution: t distribution Why: because Population standard deviation is unknown and n >=30
3. df: 29
4. E: 0.2367
5. Lower Limit: 15.4596
6. Upper Limit: 15.9104l
7. Conclusion: Since 16 zo in not in the confidence interval, I concluded that the process is not filling bottles correctly.

Hypothesis Test: The thirdintermediate assignment is to conduct a hypothesis test with a level of significance of 0.05. Use 4 decimals of accuracy. By SundayMay 29, send me an email with

1. Name
2. Null Hypothesis
3. Alternative Hypothesis
4. Tail Test?:State whether this is a Left Tail, Right Tail, or Two Tail test.
5. Which Distribution you are using (Z, t, X2, or F) and Whyyou are using that distribution?
6. Degrees of Freedom (df), if applicable
7. Value of the Test Statistic
8. Approach:State whether you are using the Critical Value(s) or P-value approach

i) If using the critical value(s), state the critical value(s)
ii) If using the p-value approach, state the p-value

9. Reject?: State whether you Reject H0 or Do Not Reject H0 .

10. Conclusion:Based on the hypothesis test as to whether the bottles are being filled correctly.

Example:These are not the correct answers

1. Name: Gerry Jenkins
2. Null Hypothesis: Ho: μ = 16
3. Alternative Hypothesis: Ha: μ ≠ 16
4. Tail Test?: - Two Tail test.
5. Distribution: t distribution Why: because Population standard deviation is unknown and n >=30
6. df: 29
7. Test Statistic: - 1.7689
8. Approach:Critical Value(s)

i) critical value(s):-1.6450, +1.6450

9. Reject Ho?: I reject Ho

10. Conclusion: The bottles are not being filled correctly.

Attachment:- Bottling_Company_Data.xlsx