bussines stat assignment
|
|
Gulf University for Science & Technology Department of Economics & Finance ECO-380: Business Statistics |
Dr. Khalid Kisswani Room: N1-116 Tel: 2530-7339 kisswani.k@gust.edu.kw
|
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?
2.
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?
3.
An Economist was interested in comparing obesity levels among the 52 US states (see file: obesity).
Compute:
a. The mean, standard deviation, minimum and maximum of the two variables and interpret the results.
b. Find the correlation coefficient and interpret your finding.
c. is there a difference between the average obesity over the two years. What can you conclude?
d. is there a difference between the obesity variance over the two years. What can you conclude?