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.
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?
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.
Observations 25 25 Observations 25 25
Hypothesized Mean Difference 0 Hypothesized Mean Difference 0
df 24 df 24
t Stat 1.
968903827 t Stat -1.
P(T<=t) one-tail 0.
03030785 P(T<=t) one-tail 0.
t Critical one-tail 1.
71088208 t Critical one-tail 1.
P(T<=t) two-tail 0.
060615701 P(T<=t) two-tail 0.
t Critical two-tail 2.
063898562 t Critical two-tail 2.
Conclusion: Do not reject Ho; mean equals 45 Conclusion: Do not reject Ho; mean equals 45
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?