Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started