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 [email protected]

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?