Week 2 Testing means with the t-test
(Not rated)
(Not rated)
| Week 2 | Testing means with the t-test | <Note: use right click on row numbers to insert rows to perform analysis below any question> | |||||||||||||
| For questions 2 and 3 below, be sure to list the null and alternate hypothesis statements. Use .05 for your significance level in making your decisions. | |||||||||||||||
| For full credit, you need to also show the statistical outcomes - either the Excel test result or the calculations you performed. | |||||||||||||||
| 1 | Below are 2 one-sample t-tests comparing male and female average salaries to the overall sample mean. | ||||||||||||||
| Based on our sample, how do you interpret the results and what do these results suggest about the population means for male and female salaries? | |||||||||||||||
| Males | Females | ||||||||||||||
| Ho: Mean salary = 45 | Ho: Mean salary = 45 | ||||||||||||||
| Ha: Mean salary =/= 45 | Ha: Mean salary =/= 45 | ||||||||||||||
| Note when performing a one sample test with ANOVA, the second variable (Ho) is listed as the same value for every corresponding value in the data set. | |||||||||||||||
| t-Test: Two-Sample Assuming Unequal Variances | t-Test: Two-Sample Assuming Unequal Variances | ||||||||||||||
| Since the Ho variable has Var = 0, variances are unequal; this test defaults to 1 sample t in this situation | |||||||||||||||
| Male | Ho | Female | Ho | ||||||||||||
| Mean | 52 | 45 | Mean | 38 | 45 | ||||||||||
| Variance | 316 | 0 | Variance | 334.667 | 0 | ||||||||||
| Observations | 25 | 25 | Observations | 25 | 25 | ||||||||||
| Hypothesized Mean Difference | 0 | Hypothesized Mean Difference | 0 | ||||||||||||
| df | 24 | df | 24 | ||||||||||||
| t Stat | 1.96890383 | t Stat | -1.9132 | ||||||||||||
| P(T<=t) one-tail | 0.03030785 | P(T<=t) one-tail | 0.03386 | ||||||||||||
| t Critical one-tail | 1.71088208 | t Critical one-tail | 1.71088 | ||||||||||||
| P(T<=t) two-tail | 0.0606157 | P(T<=t) two-tail | 0.06772 | ||||||||||||
| t Critical two-tail | 2.06389856 | t Critical two-tail | 2.0639 | ||||||||||||
| Conclusion: Do not reject Ho; mean equals 45 | Conclusion: Do not reject Ho; mean equals 45 | ||||||||||||||
| Interpretation: | |||||||||||||||
| 2 | Based on our sample results, perform a 2-sample t-test to see if the population male and female salaries could be equal to each other. | ||||||||||||||
| 3 | Based on our sample results, can the male and female compas in the population be equal to each other? (Another 2-sample t-test.) | ||||||||||||||
| 4 | What other information would you like to know to answer the question about salary equity between the genders? Why? | ||||||||||||||
| 5 | If the salary and compa mean tests in questions 3 and 4 provide different results about male and female salary equality, | ||||||||||||||
| which would be more appropriate to use in answering the question about salary equity? Why? | |||||||||||||||
| What are your conclusions about equal pay at this point? | |||||||||||||||
12 years ago
Best Answer Solution
NOT RATED
Purchase the answer to view it

- ttest5-26.xls