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
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...
Title: ER Operations Manager Used the files attached to answer the following Questions: o Use this Excel file C 3 and C 4 Excel file.xlsx o Use this file to submit your work C4 Part IIdocx 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. Interpretations/Implications ting: Monthly Patient Volume. Question 3: Forec Scenario: You are the...
Organization: Freestanding ER Services Title: ER Operations Manager Outline: Multiple Regression: Effect of Age and General Health Status Score on Total ER Cost. Purpose Importance Variables Sample Size Hypothesis Methodology Findings Interpretations/Implications Description of each Section Purpose: Identify the purpose of the analysis in this section. What questions do you hope to answer? Importance: State and explain the importance of this analysis to the department/organization. How will the findings be used? Variables: List all variables, explain how they will be...