BusinessStats Q10.47.xlsx - Pooled Variance t Test for Difference in Two Means(assumes equal population variances Data Hypothisized Difference Level of

# BusinessStats Q10.47.xlsx - Pooled Variance t Test for...

• 4

This preview shows page 1 - 4 out of 4 pages.

Pooled Variance t Test for Difference in Two Means (assumes equal population variances) Data Hypothisized Difference 0 Level of Significance 0.05 Population 1 Sample Sample Size 15 COUNT(Data1047!A2:H3) Sample Mean 4.2867 AVERAGE(Data1047!A2:H3) Sample Standard Deviation 1.6380 STDEV.S(Data1047!A2:H3) Sample Variance 2.683 VAR.S(Data1047!A2:H3) Population 2 Sample Sample Size 15 COUNT(Data1047!I2:P3) Sample Mean 7.1147 AVERAGE(Data1047!I2:P3) Sample Standard Deviation 2.0822 STDEV.S(Data1047!I2:P3) Sample Variance 4.336 VAR.S(Data1047!I2:P3) Intermediate Calculations F Test Statistic (2.0822^2)/(1.6380^2) 1.6159 (B14^2)/(B9^2) Population 1 Sample Degrees of freedom 15-1 14 B7-1 Population 2 Sample Degrees of freedom 15-1 14 B12-1 Total Degrees of Freedom 14+14 28 B19+B20 Pooled Variance (14*1.6380^2)+(14*2.082^2)/28 3.509254 ((B19*B9^2)+(B20*B14^2))/B21 Standard Error SQRT(3.5092*(1/15+1/15)) 0.6840 SQRT(B22*(1/B7+1/B12)) Difference in Sample Means 4.2867-7.1147 -2.8280 B8-B13 t Test Statistic -2.8280/0.6840 -4.134 B24/B23 Two-Tail Test Lower Critical Value F.INV(0.05/2,14,14) 0.3357 Upper Critical Value F.INV.RT(0.05/2,14,14) 2.9786 F.INV.RT(B5/2,B19,B20) p- Value 2*F.Dist.RT(1.6159,14,14) 0.3800 2*F.DIST.RT(B18,B19,B20) Do not reject the null hypothesis
F Test for Difference in Two Variances Data Level of Significance 0.05 Larger Variance Sample Sample Size 15 COUNT(Data1047!A2:H3) 1.63799 STDEV.S(Data1047!A2:H3) Sample Variance 3.0668267 VAR.S(Data1047!A2:E3) Population 2 Sample Sample Size 15 COUNT(Data1047!I2:P3) 2.0822 STDEV.S(Data1047!I2:P3) Sample Variance 8.2116 VAR.S(Data1047!F2:J3) Intermediate Calculations F Test Statistic 1.6159 (B11^2)/(B7^2) Population 1 Sample Degrees of Freedom 14 B6-1 Population 2 Sample Degrees of Freedom 14 B10-1 Two-Tail Test Lower Critical Value 0.3357 F.INV(B4/2,B16,B17) Upper Critical Value 2.9786 F.INV.RT(B4/2,B16,B17) p- Value 0.3800 2*F.DIST.RT(B15,B16,B17) Do not reject the null hypothesis Sample Standard Deviation S 1 Sample Standard Deviation S 1
Bank 1 4.21 5.55 3.02 5.13 4.77 2.34 3.54 3.2 9.66 5.9 4.5 6.1 0.38 5.12 6.46 6.19 3.79 10.49 6.68
Bank 2 8.02 5.79 8.73 3.82 8.01 8.35 5.64 4.08 6.17 9.91 5.47