how to use the calculations to determine the null hypothesis
Oak601
m2_a2340_excel.xlsxSheet1
| Group1 | Group2 | Statistic | Group1 | Group2 | |
| 50,000 | 58,000 | Sum | 622000 | 637000 | |
| 75,000 | 69,000 | Count | 10 | 10 | |
| 72,000 | 73,000 | Mean | 62200 | 63700 | |
| 67,000 | 67,000 | Variance | 87066666.6666667 | 47788888.8888889 | |
| 54,000 | 55,000 | Standard Deviation | 9330.952077182 | 6912.9508090893 | |
| 58,000 | 63,000 | Pooled Variance | 67427777.7777778 | ||
| 52,000 | 53,000 | Pooled Standard Deviation | 8211.4418817756 | ||
| 68,000 | 70,000 | Mean Difference | -1500 | ||
| 71,000 | 69,000 | Standard Error of Mean Difference | 3672.2684481878 | ||
| 55,000 | 60,000 | df | 18 | ||
| t obtained | -0.4084668703 | ||||
| one-tailed probability | 0.344 | ||||
| two-tailed probability | 0.688 | ||||
| Cohen's d | 0.1826719377 | ||||
| Lower Limit | Upper Limit | ||||
| 95% Confidence Interval for Mean Diff. | -9215.1497204795 | 6215.1497204795 | |||
Remove any pre-existing data and enter two groups of observations in the green-shaded data entry areas in columns A and B, starting with cells A2 and B2. The worksheet is programmed to conduct an independent-samples t test assuming equal variances. The worksheet is protected to keep the user from changing the formulas. This template is copyright © 21010, Larry A. Pace, Ph.D. All rights are reserved. Permission for personal and educational use is freely granted.
