Description
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.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello,Attached find the completed work together with its plagiarism report. Go through it and in case you need anything I'll be here to assist you. All the best.
317
55
350
212
350
200
150
330
336
300
475
103
600
255
235
335
320
285
360
300
350
210
262
257
209
512
150
120
203
297
220
320
700
400
404
411
100
250
75
300
243
200
150
115
125
217
Descriptive Statistics
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
246
8.526089
226
200
121.7769
14829.62
0.615318
0.786283
650
50
700
50227
204
250
377
120
535
260
277
280
200
200
240
223
130
145
145
350
320
175
275
412
316
104
62
95
96
250
280
350
108
469
194
70
90
340
350
210
250
200
350
500
260
213
189
180
50
60
470
200
...