Figure shows a spreadsheet doing the calculations for a t-test on the mean of two samples. Explain the results and check the calculations. How could you improve theformat?

Transcribed Image Text:

1Two samples-t-test t-Test: Two-Sample assuming equal variances 3 Data 4 Variable 1 Variable 2 Variable 1Variable 2 10.6 12.489 10 7.786 4.335 14 Mean Variance Observations Pooled variance 7.671 Hypothesised mean difference df t Stat P(T< t) one-tail 0.011 t Critical one-tail .717 P(T t) two-tail 0.023 t Critical two-tail 2.074 10 16 13 7 8 9 6 4 10 10 16 2.454 12 13 12 10 16 17 18