In: Statistics and Probability
In her recent book, titled Lean In, Facebook COO Cheryl Sandberg suggested that, “we need to teach women to raise their hands more.” As a curious researcher, you wonder if that is really the case. Using data from a local school survey, test the research hypothesis at the 0.01 level of significance that there is a difference in the number of times boys and girls raise their hands in class. Use the file homework5.xls (posted on Blackboard) to do this on Excel first. In the file you will find two variables, one for gender and one for hands up. Boys are coded as 1, and girls are coded with 2. Do this problem by hand as well, and double check your answers. What is your conclusion regarding the research hypothesis? Do you reach the same conclusion using Excel? Make sure you include your calculations by hand and the Excel outcome (copy and paste) to receive full credit.
Gender | Hand Up |
1 | 9 |
1 | 8 |
1 | 4 |
1 | 9 |
1 | 3 |
1 | 8 |
1 | 10 |
1 | 8 |
1 | 9 |
1 | 8 |
1 | 10 |
1 | 7 |
1 | 6 |
1 | 6 |
2 | 3 |
2 | 5 |
2 | 1 |
2 | 2 |
2 | 6 |
2 | 4 |
2 | 3 |
2 | 6 |
2 | 7 |
2 | 9 |
2 | 7 |
2 | 3 |
2 | 7 |
2 | 6 |
2 | 8 |
2 | 8 |