1)Using the General Social Survey data attached to this assignment {"GSS 2010 (For Assignments) USE THIS.xlsx}, determine whether there is a difference in the average number of hours spent on e-mails (EMAILHR), comparing men and women using the variable (SEX).

a.Is this a test of two means or a test of two proportions?

b.Is this a one-tailed or two-tailed test?

c.What is the null hypothesis for this test?

d.What is the alternative hypothesis for this test?

e.Calculate descriptive statistics for the two samples:

1)Sample size for men?

2)Sample size for women?

3)Mean of hours spent on e-mails for men?

4)Mean of hours spent on e-mails for women?

5)Variance of hours spent on emails for men?

6)Variance of hours spent on emails for women?

f.Conduct a t-test and report the t statistic

g.Compare this to the critical value; what p-value do you get? (if your answer is a p value less than 0.0001, just report then just report 'p < 0.0001' instead of typing out more 0's)

h.Based on the p-value, what decision do we make about the hypothesis at = 0.05? Use complete sentences to describe the decision you make and why you made it.

2)Using the General Social Survey data attached to this assignment {"GSS 2010 (For Assignments) USE THIS.xlsx},, determine whether there is a difference in the number of hours on average spent on e-mails (EMAILHR), comparing people under age 65 to people age 65 or older (AGE).

a.Is this a test of two means or a test of two proportions?

b.Is this a one-tailed or two-tailed test?

c.What is the null hypothesis for this test?

d.What is the alternative hypothesis for this test?

e.Calculate descriptive statistics for the two samples:

1)Sample size for people under 65?

2)Sample size for people 65 or older?

3)Mean of hours spent on e-mails for people under 65?

4)Mean of hours spent on e-mails for people 65 or older?

5)Variance of hours spent on emails for people under 65?

6)Variance of hours spent on emails for people 65 or older?

f.Conduct a t-test and report the t statistic

g.Compare this to the critical value; what p-value do you get? (if p < 0.0001, then just report p < 0.0001)

h.Based on the p-value, what decision do we make about the hypothesis at = 0.05? Use complete sentences to describe the decision you make and why you made it.

Here's the link to the google spreadsheet:

https://docs.google.com/spreadsheets/d/1BPyxUB6pV6TaPOedO5_59Eqa4F5dATVWgVu5BVNeMAc/edit?usp=sharing

Tips:

-As always, BE SURE TO FILTER OUT MISSING VALUES

-Make sure the "Analysis ToolPak" is installed and activated - this will make your life much, much easier. The analysis tools in that add-in will make finding the answers here much quicker and easier.

Thank you!