## 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 ,

𝑠 ...