Solved by verified expert:Instruction for assignment or below Candy Statistics please help.
candy_statistics.pdf
Unformatted Attachment Preview
Candy Statistics
Introduction
In this activity, you will work to describe a set of numbers and then make accurate
inferences (aka educated guesses) about your group of data based on incomplete
information.
Equipment
3 packages of colored candy such as M & M’s
Excel® software
Procedure
1. Predict how many individual candy pieces are in your bag.
____________
2. Open the candy bag.
3. Sort the candy into categories based upon color.
4. Tabulate and record the amount of candy per color category below (your colors
may differ from this chart based on the type of candy you are using).
Yellow
Red
Blue
Brown
Green
Orange
Total
5. What was the difference in the total number you predicted versus the actual
number?
6. Open an Excel® program and create the spreadsheet shown below. You will
have 3 trials (one for each package of candy).
7. Enter your candy categorical data into the Trial Number 1 data column.
8. Obtain data from other packages and record the data in additional trial number
columns.
9. Calculate the mean value for each color category within the experiment.
a. Select the cell that corresponds with the category Yellow Mean.
b. Select Insert.
c. Select Function.
d. Select Average from the Insert Function dialog box.
e. Select OK.
f. Select the cells that contain the Yellow category data.
g. Select OK.
h. Select the bottom right corner of cell Yellow, Mean and drag to cell
Orange, Mean.
i.
The mean should now be calculated for all color categories.
10. Calculate the median, mode, and standard deviation for all color categories.
Follow procedure steps 13a – 13i. Modify step 13d to select the required
function.
11. Calculate the package total using the SUM function.
12. Create a ± 3ϭ histogram for each candy color.
a. Create a frequency distribution table for each candy color as illustrated
below.
Yellow Candy
ϭ = 1.155
Bin
3Ϭ
Mean + (3 ϭ )
9.7983
2Ϭ
Mean + (2 ϭ )
8.6433
1Ϭ
Mean + (1 ϭ )
Mean
7.4883
-1 Ϭ
Mean – (1 ϭ )
6.3333
5.1783
-2 Ϭ
Mean – (2 ϭ )
4.0233
-3 Ϭ
Mean – (3 ϭ )
2.8683
Frequency (how often the value
occurs within the data array)
b. Create a histogram for each candy color using your bin and frequency
data.
Conclusion
1. Which color is most likely to occur with the same frequency in each bag? Explain
your answer.
2. Do your histograms fit a classic bell curve? Why or why not?
3. After performing this experiment, do you think most packages of colored candies
will have approximately the same percentages of colors? Why or why not?
…
Purchase answer to see full
attachment
