· Attached Files: o .strayer.edu/bbcswebdav/pid XXXXXXXXXXdt-content-rid-108160312_1/xid-108160312_1″>.gif” alt=”File”> Assignment 1 Bottling Company Case Study 2015.xlsx XXXXXXXXXXKB) Use the data...

·

Attached Files:

o .strayer.edu/bbcswebdav/pid-18612788-dt-content-rid-108160312_1/xid-108160312_1″>.gif” alt=”File”> Assignment 1 Bottling Company Case Study

2015.xlsx (8.381 KB)

Use

the data in the attached Excel file above!!!!

Students, please

view the “Submit a Clickable Rubric Assignment” in the Student

Center.

Instructors,

training on how to grade is within the Instructor Center.

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 sixteen (16) 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.

·

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 sixteen (16) 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 (16) 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, 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.

The specific course learning outcomes

associated with this assignment are:

·

Calculate measurements of central tendency and dispersal.

·

Determine confidence intervals for data.

·

Describe the vocabulary and principles of hypothesis testing.

·

Discuss application of course content to professional contexts.

·

Use technological tools to solve problems in statistics.

·

Write clearly and concisely about statistics using proper

writing mechanics.

Bottle Number

Ounces

1

16.16

2

15.69

3

15.95

4

16.16

5

15.97

6

16.41

7

16.26

8

16.27

9

15.16

10

16.18

11

14.18

12

15.75

13

16.29

14

16.86

15

16.42

16

15.82

17

15.93

18

15.06

19

15.37

20

15.77

21

14.27

22

16.2

23

15.42

24

16.91

25

15.72

26

14.93

27

15.6

28

16.46

29

16

30

14.95