For Daisy Arabella Only

profiletall1081
excelproblems.xlsx
Home>Mathematics homework help>Probability homework help>For Daisy Arabella Only

Problems

Problem 1 Before finalizing the design of a keyboard, an electronics company decided to conduct an experiment to see the effect of two design choices (backlight: red vs. blue; product weight: heavy vs. light) on customers' attitude towards the product (measured on a scale of 1 to 7). Run the appropriate statistical test and at .05 level identify whether these design choices have an effect on consumers' attitude towards the product. Identify if there is a significant interaction effect (at .05 level).
Problem 2 A retailer wants to know if the amount of sales (in $) is affected by time of the day (morning vs. afternoon) and the method customers use to place order (online vs. phone). Run the appropriate statistical test and at .05 level identify whether these factors have an effect on the sales amount. Identify if there is a significant interaction effect (at .05 level).

Problem 1

blue red
heavy 1 7
7 7
5 6
5 7
5 7 Anova: Two-Factor With Replication
1 7 Blue Red
3 7 SUMMARY blue red Total Heavy 4.35 6.3
7 6 heavy Light 5.6 5.3
3 7 Count 20 20 40
7 6 Sum 87 126 213
2 7 Average 4.35 6.3 5.325
3 4 Variance 4.3447368421 0.7473684211 3.4557692308
1 6
7 6 light
7 7 Count 20 20 40
4 7 Sum 112 106 218
5 5 Average 5.6 5.3 5.45
5 6 Variance 0.9894736842 2.3263157895 1.6384615385
4 5
5 6 Total
light 7 6 Count 40 40
7 7 Sum 199 232
5 4 Average 4.975 5.8
7 6 Variance 2.9993589744 1.7538461538
5 7
5 6
5 3 ANOVA
4 4 Source of Variation SS df MS F P-value F crit
6 3 Sample 0.3125 1 0.3125 0.1486697966 0.7008869444 3.966759784
7 4 Columns 13.6125 1 13.6125 6.476056338 0.0129611665 3.966759784
5 6 Interaction 25.3125 1 25.3125 12.0422535211 0.0008605121 3.966759784
6 3 Within 159.75 76 2.1019736842
6 7
5 7 Total 198.9875 79
6 4
5 6
5 7
7 5
5 7
4 4

Heavy Blue Red 4.3499999999999996 6.3 Light Blue Red 5.6 5.3

Problem 2

Phone Online
Morning 366 406
372 348
358 369
353 409 Phone Online
396 370 Anova: Two-Factor With Replication morning 360.933 375.633
396 407 afternoon 349.5333 317.667
301 354 SUMMARY Phone Online Total
396 408 Morning
369 404 Count 30 30 60
349 381 Sum 10828 11269 22097
398 377 Average 360.9333333333 375.6333333333 368.2833333333
390 394 Variance 912.1333333333 600.7229885057 798.545480226
392 331
315 410 Afternoon
383 366 Count 30 30 60
380 385 Sum 10486 9530 20016
329 374 Average 349.5333333333 317.6666666667 333.6
321 337 Variance 910.6712643678 575.2643678161 988.5491525424
327 339
355 374 Total
382 405 Count 60 60
370 378 Sum 21314 20799
361 347 Average 355.2333333333 346.65
394 361 Variance 928.995480226 1432.2991525424
383 354
360 402
301 376 ANOVA
325 396 Source of Variation SS df MS F P-value F crit
382 364 Sample 36088.0083333333 1 36088.0083333333 48.1367282381 0.0000000002 3.9228793616
324 343 Columns 2210.2083333333 1 2210.2083333333 2.948131604 0.0886457441 3.9228793616 sales amount
Afternoon 337 290 Interaction 16263.4083333333 1 16263.4083333333 21.6932799376 0.0000085868 3.9228793616 interaction siganificant
333 288 Within 86964.9666666667 116 749.6979885057
336 345
328 284 Total 141526.591666667 119
312 319
360 327
369 352
377 320
306 326
380 321
328 322
304 359
391 282
365 300
300 325
306 327
395 290
357 289
317 329
384 320
374 345
366 287
337 291
390 301
365 323
397 307
346 359
348 335
364 359
314 308

morning Phone Online 360.93299999999999 375.63299999999998 afternoon Phone Online 349.5333 317.66699999999997