Turn in Project 2 (Estimation and Triangulation)
This is a project that you can do to check your estimation and triangulation skills. Given a glass container (I did the experiment for survey and you can use the data I collected so that you do not need to purchase the jar...but by all means if you would like to duplicate the experiment please be my guest). I filled the jar with Whoppers candy malted milk balls. The jar is 11.5 inches high and 3.25 inches across on all four sides. There is a glass top that covers the candies. I had a group of students collect guesses from other students, faculty, staff and guests at the university as to how many candies they thought were in the jar. The data we collected is in the attached spreadsheet n=204. This would represent one leg in the triangulation process - wisdom of crowds. You should conduct your own analysis on the data average, standard deviation, skewness, kurtosis...etc. new data candy.xlsx
Your task is to complete this leg of triangulation, conduct a case study (I would recommend buying a box of Whoppers and using how many candies fit in that box and then extrapolating to the size of the container above) and a mathematical analysis based on the geometry of the milk ball and the container. Then you should conduct a PERT analysis of the three and submit a paper detailing your experiments including a chart of all three measurements and the PERT. In the past, the student work usually predicts the number of candies in the jar within 5%.
PERT needs to be conducted using three calculations
1. Average based on data set given to you in excel spreadsheet
2. How much candy fits in a jar given the size of a jar and candy
3. Estimate based on a box
A. Size of the box and number of candy in the box
B. how many candies will fit in the jar based on A
Calculations need to be part of your submission.