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.

Link to the spreadsheet below:

https://docs.google.com/spreadsheets/d/1xSlrEY4T2-S0gu-Y_dr9E5p0TaNOnFwC5z5GhTDpSWo/edit?usp=sharing