Multiple Regression Analysis for a Special Decision (Requires Computer Spreadsheet) For billing purposes, assume Phoenix Family Medical Clinic classifies its services into one of four major procedures, X1 through X4. A local business has proposed that Phoeni provide health services to its employees and their families at the following set rates per procedure: X1 $100 X2200 x3 00 X4 300 Because these rates are significantly below the current rates charged for these services, management has asked for detailed cost information on each procedure. The following information is available for the most recent 12 months. Month Total Cost X1 x2 Number of Procedures i x3 X4 $17.250 30 25 155 19 2 18,750 38 30 135 23 3 20,250 50 20 105 38 4 14,250 20 25 90 25 5 15,000 68 15 120 20 6 20.250 7 19,125 20 " 16125 16 9 19.500 10 16.500 20 15 17,100 20 12 19.875 72 222322E 90 19 158 14 30 143 28 30 132) 20 21 93 35 22 75 35 18 113 33 15 150 30