Having difficulty with parts (a), (b), (c), (d), and (e) on this Intro to Probability and Statistics homework problem. You can use Excel to help you complete this problem. Below the the homework problem, is a data set in Excel that will be used for this problem. Make sure the answers that you provide are long. Also, make sure your handwriting is neat and readable. Homework Problem Apple juice contains trace amounts of arsenic, measured in parts per billion (ppb). Over the past five years, I have been sampling apple juices and measuring their arsenic concentrations. You are being given a data set (the “Juice” sheet) containing the arsenic concentrations and the years in which I measured them. (You can assume that the experiment was conducted well, the sampling was done properly, etc.) a) Create a visualization that depicts the distribution of the concentration data, and describe that distribution. “Describe” goes beyond simply naming the shape! b) These data are stratified by year. Create an individual confidence interval about the sample mean for each year. (So, you’ll have 5 different intervals.) Is apple juice getting any more or less safe as time goes on? c) Each year, the generally accepted consensus was that the typical concentration is 2.25 ppb. Do we believe this? d) Why is the interval for 2021 so much tighter than the rest? e) Comment on whether any data values in this data set should be removed. Data Set in Excel Year Concentration 2019 1.49 2022 3.05 2020 2.53 2021 2.37 2019 3.49 2019 2.62 2023 2.8 2023 3.69 2020 3.04 2022 1.62 2021 2.11 2019 0.05 2023 3.31 2023 3.51 2019 2.66 2023 4.05 2023 1.36 2019 1.96 2019 1.12 2020 1.76 2019 1.62 2023 2.06 2019 1.17 2023 2.14 2021 0.46 2019 -0.5 2023 1.01 2022 1.66 2021 1.85 2020 2.3 2021 3.59 2020 1.56 2020 1.82 2019 1.34 2019 1.97 2023 2.46 2019 3.08 2019 2.87 2022 4.27 2022 2.52 2021 1.09 2019 0.33 2021 1.88 2021 2.52 2023 2.96 2022 1.35 2021 2.94 2022 2.6 2021 2.01 2019 1.58 2022 1.77 2022 3.25 2022 0.82 2022 3.65 2022 2.34 2021 1.67 2021 1.99 2020 0.7 2022 2.12 2021 2.36 2023 2.33 2023 1.46 2019 3.18 2021 2.92 2023 6 2023 8
Having difficulty with parts (a), (b), (c), (d), and (e) on this Intro to Probability and Statistics homework problem. You can use Excel to help you complete this problem. Below the the homework problem, is a data set in Excel that will be used for this problem. Make sure the answers that you provide are long. Also, make sure your handwriting is neat and readable.
Homework Problem
Apple juice contains trace amounts of arsenic, measured in parts per billion
(ppb). Over the past five years, I have been sampling apple juices and measuring
their arsenic concentrations. You are being given a data set (the “Juice” sheet)
containing the arsenic concentrations and the years in which I measured them.
(You can assume that the experiment was conducted well, the sampling was
done properly, etc.)
a) Create a visualization that depicts the distribution of the concentration
data, and describe that distribution. “Describe” goes beyond simply
naming the shape!
b) These data are stratified by year. Create an individual confidence interval
about the sample mean for each year. (So, you’ll have 5 different intervals.)
Is apple juice getting any more or less safe as time goes on?
c) Each year, the generally accepted consensus was that the typical concentration
is 2.25 ppb. Do we believe this?
d) Why is the interval for 2021 so much tighter than the rest?
e) Comment on whether any data values in this data set should be removed.
Data Set in Excel
Year Concentration
2019 1.49
2022 3.05
2020 2.53
2021 2.37
2019 3.49
2019 2.62
2023 2.8
2023 3.69
2020 3.04
2022 1.62
2021 2.11
2019 0.05
2023 3.31
2023 3.51
2019 2.66
2023 4.05
2023 1.36
2019 1.96
2019 1.12
2020 1.76
2019 1.62
2023 2.06
2019 1.17
2023 2.14
2021 0.46
2019 -0.5
2023 1.01
2022 1.66
2021 1.85
2020 2.3
2021 3.59
2020 1.56
2020 1.82
2019 1.34
2019 1.97
2023 2.46
2019 3.08
2019 2.87
2022 4.27
2022 2.52
2021 1.09
2019 0.33
2021 1.88
2021 2.52
2023 2.96
2022 1.35
2021 2.94
2022 2.6
2021 2.01
2019 1.58
2022 1.77
2022 3.25
2022 0.82
2022 3.65
2022 2.34
2021 1.67
2021 1.99
2020 0.7
2022 2.12
2021 2.36
2023 2.33
2023 1.46
2019 3.18
2021 2.92
2023 6
2023 8
| Year | Concentration |
| 2019 | 1.49 |
| 2022 | 3.05 |
| 2020 | 2.53 |
| 2021 | 2.37 |
| 2019 | 3.49 |
| 2019 | 2.62 |
| 2023 | 2.8 |
| 2023 | 3.69 |
| 2020 | 3.04 |
| 2022 | 1.62 |
| 2021 | 2.11 |
| 2019 | 0.05 |
| 2023 | 3.31 |
| 2023 | 3.51 |
| 2019 | 2.66 |
| 2023 | 4.05 |
| 2023 | 1.36 |
| 2019 | 1.96 |
| 2019 | 1.12 |
| 2020 | 1.76 |
| 2019 | 1.62 |
| 2023 | 2.06 |
| 2019 | 1.17 |
| 2023 | 2.14 |
| 2021 | 0.46 |
| 2019 | -0.5 |
| 2023 | 1.01 |
| 2022 | 1.66 |
| 2021 | 1.85 |
| 2020 | 2.3 |
| 2021 | 3.59 |
| 2020 | 1.56 |
| 2020 | 1.82 |
| 2019 | 1.34 |
| 2019 | 1.97 |
| 2023 | 2.46 |
| 2019 | 3.08 |
| 2019 | 2.87 |
| 2022 | 4.27 |
| 2022 | 2.52 |
| 2021 | 1.09 |
| 2019 | 0.33 |
| 2021 | 1.88 |
| 2021 | 2.52 |
| 2023 | 2.96 |
| 2022 | 1.35 |
| 2021 | 2.94 |
| 2022 | 2.6 |
| 2021 | 2.01 |
| 2019 | 1.58 |
| 2022 | 1.77 |
| 2022 | 3.25 |
| 2022 | 0.82 |
| 2022 | 3.65 |
| 2022 | 2.34 |
| 2021 | 1.67 |
| 2021 | 1.99 |
| 2020 | 0.7 |
| 2022 | 2.12 |
| 2021 | 2.36 |
| 2023 | 2.33 |
| 2023 | 1.46 |
| 2019 | 3.18 |
| 2021 | 2.92 |
| 2022 | 6 |
| 2023 | 8 |
Step by step
Solved in 7 steps with 2 images
