please answer in excel. and if possible use the same cells.
: 4-25 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 fol- lowing table: ADMISSIONS TOTAL EXPENSES (100s) ($1,000,000s) 57 127 4 NUMBER HOSPITAL OF BEDS 215 2 336 3 520 4 135 5 6 210 7 140 157 77 160 230 43 9 155 24 4 35 14 93 45 53 4 8 90 6 6 159 9 410 99 50 18 12 11 10 11 12 13 14 15 65 42 110 305 16 29 28 98 21 63 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? CN AaBbCcDc AaBbCcDc AaBbc AaBbcc I Normal I No Spac... Heading 1 Heading 2 Paragraph Styles 1) Problem 4.25 (page 142 in the text) a) Solve the problem in excel (submit the excel file) and use the excel solution to answer the problem question(s) Note: Three regression models need to be developed: 1) total expenses as the dependent variable and number of beds as the independent variable, 1) total expenses as the dependent variable and admissions as the independent variable, i) total expenses as the dependent variable and number of beds as well as admissions as the independent variables. Upload the completed assignment using the file extension format Lastname Firstname Week5.doc. Refer to the "Submissions" section in the Annexure to Syllabus" document and the "Assessment Rubrics" document for more information instructions regarding assignment submissions. Note: To Run Regression 1) Open Excel File: Problem 4.25 2) Select Data Data Analysis 3) Select Regression 4) Simple Linear Regression: "Input Y Range" (dependent variable data), "Input X Range (independent variable data); Multiple Regression: "Input Y Range" (dependent variable data), "Input X Range" (independent variable data, i.e. both the independent variables data) 5) Tick "Labels in First Row" 6) Tick "Output Range" and indicate output choice (say, H10) 7) Tick "Residuals 8) Click OK AutoSave OH Problem 4.25 - Excel File Home Insert Page Layout Formulas Data Review View Help X ID Calibri 11 - AM Paste BIU a A- Wrap Text Merge & Center Clipboard Font Alignment L11 E 1 431 9 B C D 1 Problem 4.25 2 3 Hospital Total Expenses ($1,000,000s) Number of Beds Admissions (100s) 4 57 215 771 5 2 127 336 160 6 3 157 520 230 7 4 24 135 8 5 14 35 9 6 93 210 155 10 7 45 140 53 8 6 90 6 12 9 99 410 159 13 10 12 50 18 14 11 11 65 16 15 12 15 42 29 16 13 21 110 281 17 14 63 305 98 18 19 20 21 22 4.25 Type here to search
