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 (16) ounces of product. Your boss wants to solve the problem at

profileMichelle_Michy
20180903222619mat300_writing_assignment_excel_template_v2.xlsx
Home>Applied Sciences homework help>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 (16) ounces of product. Your boss wants to solve the problem at

Sheet1

Hypothesis Test H0: µ 16
Observation Number Data H1: µ
1 15.0
2 15.0 Mean 15
3 15.0 Standard Deviation 0
4 15.0 Median 15
5 15.0
6 15.0 T Test Statistic ERROR:#DIV/0!
7 15.0 T Crit Value(alpha=.05) 1.6991270265
8 15.0 T Crit Value(alpha=.025) 2.0452296421
9 15.0
10 15.0 P-Value ERROR:#DIV/0!
11 15.0 95% CI
12 15.0 Lower Bound 15 0
13 15.0 Upper Bound 15 0
14 15.0
15 15.0
16 15.0 Cells in Blue need to be keyed
17 15.0 Cells in Orange are formulas
18 15.0
19 15.0
20 15.0
21 15.0
22 15.0
23 15.0
24 15.0
25 15.0
26 15.0
27 15.0
28 15.0
29 15.0
30 15.0

Sheet2

Sheet3