Homework SourseI need to do a 2 sample ttest in Excel to see if men and wom
I need to do a 2 sample t-test in Excel to see if men and women get paid the same in this example. If the Salary is my Variable 1, what is my Variable 2? Can I do this again with Compa and get different results? I am lost and am having a hard time finding help.
E
| ID | Salary | Compa | Midpoint | Age | Performance Rating | Service | Gender | Raise | Degree | Gender1 | Gr |
| 1 | 66.1 | 1.159 | 57 | 34 | 85 | 8 | 0 | 5.7 | 0 | M | E |
| 2 | 25.9 | 0.834 | 31 | 52 | 80 | 7 | 0 | 3.9 | 0 | M | B |
| 4 | 55.3 | 0.971 | 57 | 42 | 100 | 16 | 0 | 5.5 | 1 | M | E |
| 5 | 49.6 | 1.033 | 48 | 36 | 90 | 16 | 0 | 5.7 | 1 | M | D |
| 6 | 78.3 | 1.168 | 67 | 36 | 70 | 12 | 0 | 4.5 | 1 | M | F |
| 9 | 78 | 1.164 | 67 | 49 | 100 | 10 | 0 | 4 | 1 | M | F |
| 12 | 60.8 | 1.067 | 57 | 52 | 95 | 22 | 0 | 4.5 | 0 | M | E |
| 16 | 37.4 | 0.934 | 40 | 44 | 90 | 4 | 0 | 5.7 | 0 | M | C |
| 19 | 23 | 1.000 | 23 | 32 | 85 | 1 | 0 | 4.6 | 1 | M | A |
| 21 | 76 | 1.135 | 67 | 43 | 95 | 13 | 0 | 6.3 | 1 | M | F |
| 25 | 25.8 | 1.122 | 23 | 41 | 70 | 4 | 0 | 4 | 0 | M | A |
| 27 | 42.3 | 1.057 | 40 | 35 | 80 | 7 | 0 | 3.9 | 1 | M | C |
| 29 | 80.9 | 1.208 | 67 | 52 | 95 | 5 | 0 | 5.4 | 0 | M | F |
| 30 | 49 | 1.020 | 48 | 45 | 90 | 18 | 0 | 4.3 | 0 | M | D |
| 32 | 27.5 | 0.886 | 31 | 25 | 95 | 4 | 0 | 5.6 | 0 | M | B |
| 33 | 63.6 | 1.115 | 57 | 35 | 90 | 9 | 0 | 5.5 | 1 | M | E |
| 34 | 28.6 | 0.922 | 31 | 26 | 80 | 2 | 0 | 4.9 | 1 | M | B |
| 38 | 63 | 1.105 | 57 | 45 | 95 | 11 | 0 | 4.5 | 0 | M | E |
| 40 | 24.3 | 1.057 | 23 | 24 | 90 | 2 | 0 | 6.3 | 0 | M | A |
| 41 | 42.8 | 1.071 | 40 | 25 | 80 | 5 | 0 | 4.3 | 0 | M | C |
| 44 | 60.7 | 1.065 | 57 | 45 | 90 | 16 | 0 | 5.2 | 1 | M | E |
| 46 | 62.2 | 1.091 | 57 | 39 | 75 | 20 | 0 | 3.9 | 1 | M | E |
| 47 | 62.2 | 1.091 | 57 | 37 | 95 | 5 | 0 | 5.5 | 1 | M | E |
| 49 | 61.7 | 1.083 | 57 | 41 | 95 | 21 | 0 | 6.6 | 0 | M | E |
| 50 | 61.4 | 1.077 | 57 | 38 | 80 | 12 | 0 | 4.6 | 0 | M | E |
| 3 | 35.2 | 1.135 | 31 | 30 | 75 | 5 | 1 | 3.6 | 1 | F | B |
| 7 | 42.3 | 1.058 | 40 | 32 | 100 | 8 | 1 | 5.7 | 1 | F | C |
| 8 | 22.8 | 0.990 | 23 | 32 | 90 | 9 | 1 | 5.8 | 1 | F | A |
| 10 | 23.3 | 1.014 | 23 | 30 | 80 | 7 | 1 | 4.7 | 1 | F | A |
| 11 | 23.6 | 1.025 | 23 | 41 | 100 | 19 | 1 | 4.8 | 1 | F | A |
| 13 | 40.6 | 1.014 | 40 | 30 | 100 | 2 | 1 | 4.7 | 0 | F | C |
| 14 | 21.7 | 0.943 | 23 | 32 | 90 | 12 | 1 | 6 | 1 | F | A |
| 15 | 21.8 | 0.949 | 23 | 32 | 80 | 8 | 1 | 4.9 | 1 | F | A |
| 17 | 57 | 1.000 | 57 | 27 | 55 | 3 | 1 | 3 | 1 | F | E |
| 18 | 33.5 | 1.081 | 31 | 31 | 80 | 11 | 1 | 5.6 | 0 | F | B |
| 20 | 36 | 1.162 | 31 | 44 | 70 | 16 | 1 | 4.8 | 0 | F | B |
| 22 | 43.7 | 0.911 | 48 | 48 | 65 | 6 | 1 | 3.8 | 1 | F | D |
| 23 | 25.3 | 1.098 | 23 | 36 | 65 | 6 | 1 | 3.3 | 0 | F | A |
| 24 | 48.9 | 1.019 | 48 | 30 | 75 | 9 | 1 | 3.8 | 0 | F | D |
| 26 | 23.3 | 1.013 | 23 | 22 | 95 | 2 | 1 | 6.2 | 0 | F | A |
| 28 | 75.2 | 1.122 | 67 | 44 | 95 | 9 | 1 | 4.4 | 0 | F | F |
| 31 | 24.2 | 1.054 | 23 | 29 | 60 | 4 | 1 | 3.9 | 1 | F | A |
| 35 | 22.4 | 0.976 | 23 | 23 | 90 | 4 | 1 | 5.3 | 0 | F | A |
| 36 | 23.6 | 1.026 | 23 | 27 | 75 | 3 | 1 | 4.3 | 0 | F | A |
| 37 | 24.3 | 1.057 | 23 | 22 | 95 | 2 | 1 | 6.2 | 0 | F | A |
| 39 | 34.8 | 1.123 | 31 | 27 | 90 | 6 | 1 | 5.5 | 0 | F | B |
| 42 | 23 | 0.998 | 23 | 32 | 100 | 8 | 1 | 5.7 | 1 | F | A |
| 43 | 75.4 | 1.125 | 67 | 42 | 95 | 20 | 1 | 5.5 | 0 | F | F |
| 45 | 57.9 | 1.206 | 48 | 36 | 95 | 8 | 1 | 5.2 | 1 | F | D |
| 48 | 70.1 | 1.230 | 57 | 34 | 90 | 11 | 1 | 5.3 | 1 | F | E |
Solution
Having the data analysis plug-in excel helps a lot in solving this kind of problem. Please find the instructions on how to get data analysis add-in in excel in the following link.
http://cameron.econ.ucdavis.edu/excel/ex01access.html
We do a sample test when we want to compare the mean of two groups or two variables. In this case one group is the values of Salary corresponding to males and second group is salary corresponding to females. The results of the test are as follows.
| t-Test: Two-Sample Assuming Unequal Variances | ||
| Variable 1 | Variable 2 | |
| Mean | 52.256 | 37.196 |
| Variance | 346.5242 | 307.7746 |
| Observations | 25 | 25 |
| Hypothesized Mean Difference | 0 | |
| df | 48 | |
| t Stat | 2.943791 | |
| P(T<=t) one-tail | 0.002492 | |
| t Critical one-tail | 1.677224 | |
| P(T<=t) two-tail | 0.004984 | |
| t Critical two-tail | 2.010635 |
