The data set required for this assignment is provided in the Excel worksheet attached to this post.  Please be sure to include all citations and references.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.  Bottle Number Ounces Bottle Number Ounces Bottle Number Ounces 1 14.23 11 15.77 21 16.23 2 14.32 12 15.80 22 16.25 3 14.98 13 15.82 23 16.31 4 15.00 14 15.87 24 16.32 5 15.11 15 15.98 25 16.34 6 15.21 16 16.00 26 16.46 7 15.42 17 16.02 27 16.47 8 15.47 18 16.05 28 16.51 9 15.65 19 16.21 29 16.91 10 15.74 20 16.21 30 16.96 Write a two to three (2-3) page report in which you: Calculate the mean, median, and standard deviation for ounces in the bottles.Construct a 95% Confidence Interval for the ounces in the bottles.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.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.
copy_of_assignment_1_bottling_company_case_study_2015.xlsx

Unformatted Attachment Preview

Bottle
Number
1
Ounces
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

Purchase answer to see full
attachment