Excel Assignment 2
Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment)
1.
An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?
An Economist was interested in sex differences in the sociability of teenagers (see file: Number of Good Friends). Using the number of good friends as a measure, he compared the sociability of eight female and seven male teenagers. Is there a difference in the average with respect to sociability between teenage females and males?
An Economist was interested in comparing obesity levels among the 52 US states (see file: obesity).
Compute:
- The mean, standard deviation, minimum and maximum of the two variables and interpret the results.
- Find the correlation coefficient and interpret your finding.
- is there a difference between the average obesity over the two years. What can you conclude?
- is there a difference between the obesity variance over the two years. What can you conclude?