Question: 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
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.
Link to the spreadsheet: https://docs.google.com/spreadsheets/d/1xSlrEY4T2-S0gu-Y_dr9E5p0TaNOnFwC5z5GhTDpSWo/edit?usp=sharing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
