A B C D E F G H J K L M N 1 2 3 4 You have two suppliers of sugar, Supplier A and Supplier B. Sugar is delivered in bags, and you've sampled the weight of 33 bags from each supplier. That data is below. You suspect that the suppliers differ in how consistent they are in filling the bags. That is, you think the weights have different variances. Test that hypothesis by answering all of the questions below. You must use the appropriate formulas and cell references to receive any credit. 5 6 7 8 A B A B 9 40.35 40.18 10 40.28 39.84 mean st dev 40.0097 40.0652 0.1947 0.3104 11 39.88 40.35 n 33 33 12 39.74 40.13 13 40.22 40.51 14 40.16 40.19 15 40.10 40.44 0.393462 F-value 0.0101 p-value Can you conclude at the 5% signficance level that the variances are different? (Answer Yes or No) 16 39.89 40.63 17 40.15 40.51 18 39.76 39.94 19 40.28 39.89 20 39.75 39.59 0.4035 21 40.39 40.11 0.0000 0 22 39.81 39.72 95.5427 0 =E10^2/F10^2 =4.12*(SQRT(B25/B26)) 23 39.72 40.15 11.8061 yes 24 40.08 39.76 #N/A #N/A 25 39.69 40.12 107.7524 26 39.93 40.14 27 40.15 39.61 28 39.84 40.19 29 39.71 40.12 30 40.15 40.25 31 39.83 39.46 32 40.08 39.78 33 40.08 40.33 34 39.95 39.86 35 40.15 39.52 36 40.01 39.93 37 39.99 40.44 38 40.09 40.01 39 40.01 40.55 40 39.99 39.85 41 40.11 40.05 42