Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Bob White is conducting research on individual adult's monthly expenses for medical care, including over the counter medicine. His dependent variable is monthly expenses for
Bob White is conducting research on individual adult's monthly expenses for medical care, including over the counter medicine. His dependent variable is monthly expenses for medical care while his independent variables are number of family members (X1) and insurance type (government funded, private insurance and no insurance). He has coded insurance type like the following: X2 = 1 if government funded; X3 = 1 if private insurance. Below is his excel output:
Regression Statistics Multiple R 0.8590 R Square 0.7379 Adjusted R 0.7182 Square Standard Error 952.3605 Observations 18 ANOVA df SS MS F Significance F Regression w 1.32E+08 43977657 48.48745 1.21E-07 Residual 14 12697866 906990.4 Total 17 1.45E+08 Coefficients Standard Error t Stat P-value Intercept 144.91 1025.911 0.141246 0.889688 X1 11.63 1.247247 9.330762 2.19E-07 X2 -13.70 8.786907 -1.55916 0.141272 X3 -9.11 1.166068 7.810781 1.81E-06Step 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