Question
must be done in Exel The data stored in Drink represents the amount of soft drink in a sample of 50 2-liter bottles. Construct a
must be done in Exel
The data stored in Drink represents the amount of soft drink in a sample of 50 2-liter bottles.
Construct a histogram and a percentage polygon.
Construct a cumulative percentage polygon.
On the basis of the results in (a) and (b), does the amount of soft drink filled in the bottles concentrate around specific values?
AMOUNT | INTERVALS | BIN | FREQUENCY | PERSENTEGE | COMULATIVE PERSENTEGE | |
2.109 | 1.850 - 1.899 | 1.899 | 1 | 2 | 2 |
|
2.086 | 1.900 - 1.949 | 1.949 | 5 | 10 | 12 |
|
2.066 | 1.950 -1.999 | 1.999 | 18 | 36 | 48 |
|
2.075 | 2.000 -2.049 | 2.049 | 19 | 38 | 86 |
|
2.065 | 2.050 -2.099 | 2.099 | 6 | 12 | 98 |
|
2.057 | 2.100 - 2.149 | 2.149 | 1 | 2 | 100 |
|
2.052 |
|
| 50 |
|
|
|
2.044 |
|
|
|
|
|
|
2.036 |
|
|
|
|
|
|
2.038 |
|
|
|
|
|
|
2.031 |
|
|
|
|
|
|
2.029 |
|
|
|
|
|
|
2.025 |
|
|
|
|
|
|
2.029 |
|
|
|
|
|
|
2.023 |
|
|
|
|
|
|
2.02 |
|
|
|
|
|
|
2.015 |
|
|
|
|
|
|
2.014 |
|
|
|
|
|
|
2.013 |
|
|
|
|
|
|
2.014 |
|
|
|
|
|
|
2.012 |
|
|
|
|
|
|
2.012 |
|
|
|
|
|
|
2.012 |
|
|
|
|
|
|
2.01 |
|
|
|
|
|
|
2.005 |
|
|
|
|
|
|
2.003 |
|
|
|
|
|
|
1.999 |
|
|
|
|
|
|
1.996 |
|
|
|
|
|
|
1.997 |
|
|
|
|
|
|
1.992 |
|
|
|
|
|
|
1.994 |
|
|
|
|
|
|
1.986 |
|
|
|
|
|
|
1.984 |
|
|
|
|
|
|
1.981 |
|
|
|
|
|
|
1.973 |
|
|
|
|
|
|
1.975 |
|
|
|
|
|
|
1.971 |
|
|
|
|
|
|
1.969 |
|
|
|
|
|
|
1.966 |
|
|
|
|
|
|
1.967 |
|
|
|
|
|
|
1.963 |
|
|
|
|
|
|
1.957 |
|
|
|
|
|
|
1.951 |
|
|
|
|
|
|
1.951 |
|
|
|
|
|
|
1.947 |
|
|
|
|
|
|
1.941 |
|
|
|
|
|
|
1.941 |
|
|
|
|
|
|
1.938 |
|
|
|
|
|
|
1.908 |
|
|
|
|
|
|
1.894 |
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started