Excel Assignment 2
Direction: Use Microsoft Excel to answer the following threequestions (Excel Instructions are provided in previousassignment)
1. An Economist was interested in sex differences in the number ofbooks a person reads (see file: Number of Books). Two randomsamples were taken, one of men and the other, and the number ofbooks read during the last month was recorded. Is there adifference with respect to the number of books read by females andmales?
| Female | Male |
| 8 | 1 |
| 3 | 5 |
| 1 | 8 |
| 7 | 3 |
| 7 | 2 |
| 6 | 1 |
| 8 | 2 |
| 5 | 6 |
| 6 | 4 |
| 5 | 2 |
| 4 | 9 |
| 2 | 3 |
| 9 | 4 |
| 7 | 8 |
| 6 | 7 |
| 8 | 2 |
| 2 | 6 |
| 4 | 12 |
| 5 | 4 |
| 6 | 5 |
| 9 | 3 |
| 1 | 1 |
| 2 | 3 |
| 4 | 6 |
| 6 | 7 |
| 8 | 4 |
| 7 | 1 |
| 5 | 2 |
| 9 | 6 |
| 6 | 3 |
| 1 |
| 2 |
| 3 |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
