Assignment 1 stat | Mathematics homework help

Assignment 1: Bottling Company Case Study Due Week 10 and worth 140 points 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 thirty two (32) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) 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. 
 
 
 
Bottle Number
 
 
 
Ounces
 
 
 
Bottle Number
 
 
 
Ounces
 
 
 
Bottle Number
 
 
 
Ounces
 
 
 
1
 
 
 
30.23
 
 
 
11
 
 
 
31.77
 
 
 
21
 
 
 
32.23
 
 
 
2
 
 
 
30.32
 
 
 
12
 
 
 
31.80
 
 
 
22
 
 
 
32.25
 
 
 
3
 
 
 
30.98
 
 
 
13
 
 
 
31.82
 
 
 
23
 
 
 
32.31
 
 
 
4
 
 
 
31.00
 
 
 
14
 
 
 
31.87
 
 
 
24
 
 
 
32.32
 
 
 
5
 
 
 
31.11
 
 
 
15
 
 
 
31.98
 
 
 
25
 
 
 
32.34
 
 
 
 
 
 
 
 
 
 
 
 

 
6
 
31.21
 
16
 
32.00
 
26
 
32.46
 
 
 
7
 
 
 
31.42
 
 
 
17
 
 
 
32.02
 
 
 
27
 
 
 
32.47
 
 
 
8
 
 
 
31.47
 
 
 
18
 
 
 
32.05
 
 
 
28
 
 
 
32.51
 
 
 
9
 
 
 
31.65
 
 
 
19
 
 
 
32.21
 
 
 
29
 
 
 
32.91
 
 
 
10
 
 
 
31.74
 
 
 
20
 
 
 
32.21
 
 
 
30
 
 
 
32.96
 
Write a two to three (2-3) page report in which you: 1. Calculate the 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 thirty two (32) 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 thirty two (32) ounces in a bottle of soda, speculate on three (3) 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 (1) 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,