Week 8 Project 2

User Generated

PQ11155

Business Finance

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

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 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 300 315 375 200 260 100 576 150 152 200 286 144 250 240 97 125 500 549 97 100 352 50 100 200 55 476 100 148 250 275 100 75 100 150 185 314 296 225 500 200 280 187 300 285 260 107 85 300 213 200 205 180 220 311 432 70 300 150 180 249 250 138 94 260 194 259 227 197 225 200 180 105 300 136 450 325 265 375 250 200 200 120 500 475 150 225 200 225 262 423 214 270 242 443 400 139 144 250 287 225 335 98 420 140 324 300 115 125 132 420 225 246.2108 Average
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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

...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags