Twelve husbands were asked how much housework they completed last week and how many children were in the home. Use the following data to complete the questions in this section. Use Excel, SPSS, or work by hand to show your work finding. Show detailed work. Children Husband’s Housework Children Husband’s Housework 2 4 4 6 1 1 1 3 3 0 3 5 5 4 2 3 1 5 2 1 5 7 4 3 State the null hypothesis. ANSWERED Null hypothesis : There no difference between housework done by husband's and how many children were in the home State the alternative hypothesis. ANSWERED Alternative hypothesis : There is a difference between housework done by husband's and how many children were in the home Write out the linear model (i.e., the equation) with one predictor in its most basic form. ANSWERED linear model using Excel enter data in excel Data -> Data analysis -> Regression -> ok Input y variable : select Husband's housework input x variable : select children Excel Output: SUMMARY OUTPUT Regression Statistics Multiple R 0.449653 R Square 0.202188 Adjusted R Square 0.122407 Standard Error 1.97719 Observations 12 ANOVA df SS MS F Significance F Regression 1 9.907216 9.907216 2.534283 0.142482 Residual 10 39.09278 3.909278 Total 11 49 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 1.742268 1.242942 1.40173 0.191263 -1.02718 4.511715 -1.02718 4.511715 childern 0.639175 0.401506 1.591943 0.142482 -0.25544 1.533787 -0.25544 1.533787 the linear model is y = a+bx where a = intercept, b = slope y = 1.7423 + 0.6392x (from above excel output) where x = independent variable =childern y = dependent variable = Husband's Housework Assign the above variables short, relevant names (e.g., “Grade on Midterm” might be simply “Grade”) and then substitute those names in the linear model and rewrite it below. PLEASE ANSWER Estimate (round to three decimal places) and report it. PLEASE ANSWER Using your estimated regression coefficients, write out the predicted linear model below. PLEASE ANSWER Interpret as it relates the two variables in the model. Evaluate and explain the significance of the relationship between the two variables. Calculate the standardized regression coefficient. Interpret as it relates the two variables in the model using the original units scaled by the standard deviations. What is the correlation between the two variables? Report and interpret the coefficient of determination?
Twelve husbands were asked how much housework they completed last week and how many children were in the home. Use the following data to complete the questions in this section. Use Excel, SPSS, or work by hand to show your work finding. Show detailed work.
Children |
Husband’s Housework |
|
Children |
Husband’s Housework |
2 |
4 |
|
4 |
6 |
1 |
1 |
|
1 |
3 |
3 |
0 |
|
3 |
5 |
5 |
4 |
|
2 |
3 |
1 |
5 |
|
2 |
1 |
5 |
7 |
|
4 |
3 |
- State the null hypothesis. ANSWERED
Null hypothesis : There no difference between housework done by husband's and how many children were in the home
- State the alternative hypothesis. ANSWERED
Alternative hypothesis : There is a difference between housework done by husband's and how many children were in the home
- Write out the linear model (i.e., the equation) with one predictor in its most basic form. ANSWERED
linear model using Excel
enter data in excel
Data -> Data analysis -> Regression -> ok
Input y variable : select Husband's housework
input x variable : select children
Excel Output:
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
|
Multiple R |
0.449653 |
|
|
|
|
|
|
|
R Square |
0.202188 |
|
|
|
|
|
|
|
Adjusted R Square |
0.122407 |
|
|
|
|
|
|
|
Standard Error |
1.97719 |
|
|
|
|
|
|
|
Observations |
12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
Regression |
1 |
9.907216 |
9.907216 |
2.534283 |
0.142482 |
|
|
|
Residual |
10 |
39.09278 |
3.909278 |
|
|
|
|
|
Total |
11 |
49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
Intercept |
1.742268 |
1.242942 |
1.40173 |
0.191263 |
-1.02718 |
4.511715 |
-1.02718 |
4.511715 |
childern |
0.639175 |
0.401506 |
1.591943 |
0.142482 |
-0.25544 |
1.533787 |
-0.25544 |
1.533787 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
the linear model is
y = a+bx
where a = intercept, b = slope
y = 1.7423 + 0.6392x (from above excel output)
where x = independent variable =childern
y = dependent variable = Husband's Housework
- Assign the above variables short, relevant names (e.g., “Grade on Midterm” might be simply “Grade”) and then substitute those names in the linear model and rewrite it below. PLEASE ANSWER
- Estimate (round to three decimal places) and report it. PLEASE ANSWER
- Using your estimated regression coefficients, write out the predicted linear model below. PLEASE ANSWER
- Interpret as it relates the two variables in the model.
- Evaluate and explain the significance of the relationship between the two variables.
- Calculate the standardized regression coefficient.
- Interpret as it relates the two variables in the model using the original units scaled by the standard deviations.
- What is the
correlation between the two variables? - Report and interpret the coefficient of determination?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images