Question

In: Statistics and Probability

The total expenses of a hospital are related to many factors. Two of these factors are...

The total expenses of a hospital are related to many factors. Two of these factors are the number of beds in the hospital and the number of admissions. Data were collected on 14 hospitals, as shown in the following table:Find the best regression model to predict the total expenses of a hospital. Discuss the accuracy of this model. Should both variables be included in the model? Why or why not?

Hospital # Beds Admissx1000 Total Exp x$1mil
1 120 77 57
2 336 160 127
3 310 230 157
4 55 33 24
5 30 19 14
6 190 155 93
7 110 53 45
8 40 6 6
9 210 159 99
10 25 18 12

Solutions

Expert Solution

Regression Statistics
Multiple R 0.997641
R Square 0.995288
Adjusted R Square 0.993942
Standard Error 4.12342
Observations 10
ANOVA
df SS MS F Significance F
Regression 2 25139.38 12569.69 739.2809 7.18E-09
Residual 7 119.0181 17.00259
Total 9 25258.4
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -0.62223 2.149332 -0.2895 0.780585 -5.70459 4.46013 -5.70459 4.46013
X Variable 1 0.1953 0.035172 5.552634 0.000858 0.11213 0.27847 0.11213 0.27847
X Variable 2 0.3975 0.051374 7.737414 0.000113 0.27602 0.518979 0.27602 0.518979

Total expenses=-0.62223+0.1953 beds+0.3975 admission

Here R2=0.99 i.e. 99% .The model is 99% good fit. The 99% variation in the total expenses explained by the regressors.

For bed p-value is 0.000858 <0.05 and for admission 0.000113<0.05.

Therefore number of bed and number of admission both are contributing significantly. So both variables should included in the model.


Related Solutions

The total expenses of a hospital is determined by many different factors but two of these...
The total expenses of a hospital is determined by many different factors but two of these factors are the number of beds and the number of patients that are admitted to the hospital. Data was collected on 14 hospitals and is listed in the table. Hospital Number of beds Admissions (1,000s) Total expenses ($1,000,000 1 215 77 57 2 336 160 127 3 520 230 157 4 135 43 24 5 35 9 14 6 210 155 93 7 140...
3) The total expenses of a hospital is determined by many different factors but two of...
3) The total expenses of a hospital is determined by many different factors but two of these factors are the number of beds and the number of patients that are admitted to the hospital. Data was collected on 14 hospitals and is listed in the table. Hospital Number of beds Admissions (1,000s) Total expenses ($1,000,000 1 215 77 57 2 336 160 127 3 520 230 157 4 135 43 24 5 35 9 14 6 210 155 93 7...
In two companies making the same product and with the same total sales and total expenses,...
In two companies making the same product and with the same total sales and total expenses, the contribution margin ratio will be higher in the company with a higher proportion of fixed expenses in its cost structure. True False
Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1...
Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1 American Red Cross 3352089148 3.8 3.9 92.0 2 World Vision 1208111251 4.0 7.5 88.3 3 Smithsonian Institution 1081275619 23.5 2.5 73.8 4 Food For the Poor 1049984888 0.6 2.6 96.8 5 American Cancer Society 1007342150 6.0 22.3 71.4 6 Volunteers of America 931512538 8.5 1.8 89.2 7 Dana-Farber Cancer Institute 876227147 13.1 1.5 85.3 8 AmeriCares 858665385 0.3 0.8 98.9 9 ALSAC - St....
1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses...
1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses - Total fixed expenses c). Sales revenue per unit x Sales quantity d). Variable expense per unit x Sales quantity 2). When preparing segmented income statements fixed expense are separated into the following categories: a). Traceable and common b).Fixed and Variable c).Direct and indirect d).Product and period 3).A Co. reported: Sales $125000; Contribution margin $62000; Total fixed expenses $42000; Common fixed expenses $15000. How...
Prepaid and accrued expenses: Determine whether there are any prepaid and/or accrued expenses related to insurance...
Prepaid and accrued expenses: Determine whether there are any prepaid and/or accrued expenses related to insurance and/or wages for the year ending 30 June 2019. If there are any, calculate the amount. Include all workings Insurance: Insurance is now $1,200 per calendar month and is paid in advance on the 21st day of each month. So, for example, GreenEarth pays $1,200 insurance on 21 March 2019 for the period from 22 March 2019 to 21 April 2019. The insurance increased...
1) Net income: A) is calculated by subtracting total expenses and total dividends from total revenues....
1) Net income: A) is calculated by subtracting total expenses and total dividends from total revenues. B) occurs when total revenues are less than total expenses. C) is often referred to as the "bottom line" on an income statement. D) decreases total stockholders' equity. 2) On January 1, 2017, total assets for Wininger Technologies were $140,000; on December 31, 2017, total assets were $155,000. On January 1, 2017, total liabilities were $111,000; on December 31, 2017, total liabilities were $118,000....
identify the environmental factors related to influenza
identify the environmental factors related to influenza
Determine the effect of the following errors on a company's total revenue, total expenses, and net...
Determine the effect of the following errors on a company's total revenue, total expenses, and net income. Indicate the effect by selecting Overstated (too much), Understated (too little),or Not Affected. Transactions Total Revenue Total Expenses Net Income Example: A check for $325 was written to pay on account. The accountant debited Rent Expense for $325 and credited Cash for $325. Not Affected Overstated Understated a. $615 was received on account from customers. The accountant debited Cash for $615 and credited...
ABC had total revenues of $625,000 for the month of July. Total expenses for the same...
ABC had total revenues of $625,000 for the month of July. Total expenses for the same period were, salaries $200,000, supplies $21,000, utilities $13,000 and depreciation $57,000. Prepare the closing entries.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT