Question
Using the following data, apply the Excel Regression tool using the wedding cost as the dependent variable and the couple's income as the independent variable,
Using the following data, apply the Excel Regression tool using the wedding cost as the dependent variable and the couple's income as the independent variable, only for those weddings paid for by the bride and groom. Interpret all key regression results, hypothesis tests, and confidence intervals in the output. Assume a level of significance of
0.050.05.
LOADING...
Click the icon to view the wedding data.
Question content area bottom
Part 1
Interpret the
Upper R squaredR2
value. Select the correct choice and fill in the answer box within your choice.
(Round to the nearest percent as needed.)
A.
It is predicted that the couple's income increases by
enter your response here%
for every $1,000 increase in the wedding cost.
B.
About
4040%
of the variability in the wedding cost can be explained by the variability in the couple's income.
Your answer is not correct.
C.
About
enter your response here%
of the variability in the couple's income can be explained by the variability in the wedding cost.
D.
It is predicted that the wedding cost increases by
enter your response here%
for every $1,000 increase in the couple's income.
Part 2
State the null and alternative hypotheses.
Upper H 0H0:
b 1b1
beta 11
beta 00
b 0b0
#38 lt<
equals=
#38 ne&ne
#38 gt>
enter your response here
Upper H 1H1:
beta 00
b 0b0
beta 11
b 1b1
not equals
equals=
greater than>
less than<
enter your response here
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