Question

Question 2: Multiple Regression: Effect of Age and General Health Status Score on Total ER Cost. 1. Purpose 2. Importance 3.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Using Excel

data -> data analysis-> regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.4689
R Square 0.2199
Adjusted R Square 0.2073
Standard Error 3732.5434
Observations 127
ANOVA
df SS MS F Significance F
Regression 2 486961883.1374 243480941.5687 17.4765 0.0000
Residual 124 1727553135.0201 13931880.1211
Total 126 2214515018.1575
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 2070.5160 752.3254 2.7522 0.0068 581.4533
Age -26.9953 13.6582 -1.9765 0.0503 -54.0286
GHSS 71.3223 12.2760 5.8099 0.0000 47.0247

y^ = 2070.5160 -26.9953 Age +71.3223 GHSS

the model is overall significant as p-value = 0.0000 < alpha

when Age increases by 1 year, on averege ER cost decrease by 27

when GHSS increases by 1 unit, on average ER cost increase by 71.3223

Add a comment
Know the answer?
Add Answer to:
Question 2: Multiple Regression: Effect of Age and General Health Status Score on Total ER Cost. 1. Purpose 2. Importance 3. Variables 4. Sample Size 5. Hypothesis 6. Methodology 7. Findings 8. I...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT