Question: Requirements Hun a mutiple regression to estimate the regression equation for medical supplies coals using both number of procedures and number of patent-hours as

Requirements Hun a mutiple regression to estimate the regression equation for medical supplies coals using both number of procedures and number of patent-hours as independent variables. You should obtain the following re Regression 3 Medical supplies costs a (b, No. of procedures) (by No. of patent hours) Variable Constant Independent variable 1: No. of procedures Independent variable 2: No. of patient-hours 084: Durbin-Watson statistic-1.96 Coefficient Standand Emer Vale $3103765 30,406 54 4.10 0921 38.24 $ 100.70 0.58 0713 54.37 $ 10.33 526 0.001 More info Next question Apollo is a nonprofit inetution and places great emphasis on controling costs in ender to provide services to the community in an efficient manne Apolo's CFO Julie Chen, has been concerned of lats about the hospital's consumption of medical supplies. To better understand the behavior of this cost, Jule consults with Fett Brat, the person responsible for Apolo's cost system. After some discussion, Jule and that conclude that there a procedures performed. The second is the number of patent-hours generated by Apollo Jule and Rhett view the latter as a potentially better cost driver because the hospital does perform a variety of procedures, some more complet others Sa and am 1. Evaluate the multiple regression output using the criteria of economic plausibilty, goodness of fit, significance of independent variables, and specification of estimation assumptions 2. What potential issues could arise in multiple regression analysis that are not present in simple regression models? Is there evidence of such difficulties in the multiple regression presented in this problem? Explain 3. Which of the regression models (Regression 1, 2, or 3) would you recommend Jule Chen use? Explain Help me solv Data table Fout provides the following data relating t D Data table Regression 1: Medical supples costs a+ (b Number of procedures) Medical supples Number of Month costs procedures Number of patient-hours 2 Month 1 S 106,000 320 2.000) 3 March 2 230.000 500 3.900 Variable Constant Independent variable: No. of procedures -0.36 Durbin-Watson statistic243 Regression 2: Medical supplies costs a Variable $ Coefficient Standard Enor Value $36.330.77 $ 361.91 $ 4 Month3 84.000 240 1900 56.50486 0.45 Mont 238.000 520 4,100 15293 237 (6 Month 193.000 240 3400 7 Month 6 180,000 340 3.700 Number of patient-ho Coefficient Standard Emor Value Month? 210.000 20 5100 9 Morth 82.000 300 1200 Constant Independent variable: No. of patient-bours 70.84 Durbin-Watc $3,054.00 3 56763 23.04951 016 10 Month 9 222.000 320 3.000 7.82 1725 " Month 10 78.000 180 1300 12 Month 11 127.000 440 2.900 13 Month 12 225.000 380 3,800
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
