Description
I will attached the documents that has the assignment on it. The excel sheet has the data that you will need on it. Also the data is in the word document is the same as the excel sheet.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Thank you so much
RUNNING HEAD: BOTTLING COMPANY CASE ANALYSIS
.
BOTTLING COMPANY CASE ANALYSIS
Student Name:
Institution affiliation:
Date
1
BOTTLING COMPANY CASE ANALYSIS
2
1) Calculate the mean, median, and standard deviation for ounces in the bottles.
Mean
(14.23+14.32+14.98+15+15.11+15.21+15.42+15.47+15.65+15.74+15.77+15.80+15.82
+15.87+15.98+16.00+16.02+16.05+16.21+16.21+16.23+16.25+16.31+16.32+16.34+16
.46+16.47+16.51+16.96)/30=15.81 ounces
Median= (15.93+15.95)/2=15.94
mean
15.81
Median
15.94
standard
deviation 0.66538
2) Construct a 95% Confidence Interval for the ounces in the bottles.
𝑥̅ = 15.81 ,
𝑠 ...
