Multiple Regression. Patient satisfaction. A hospital administrator wished to study the relation be- tween patient satisfaction (7) and patient's age (X,, ini year), severity of illness (X2, m index), and anxiety level (Ky, an index). She randomly selected 23 pa- tients and collected the data presented below, where larger values of Y', X2, and X, are, respectively, associated with more satisfaction, Increased severity of illness. and more anxiety. 12 1 2 3 4 S 6 7 8 9 10 II 50 36 41 25 45 45 SL 46 45 44 43 54 50 48 50 53 2.3 2.2 1.8 1.8 2.9 2.2 2.4 2.9 2.1 24 2.4 2.3 57 65 70 36 46 54 26 89 48 20 21 15 14 17 44 43 35 34 33 33 29 58 50 51 54 23 2.2 23 2.2 20 1.9 21 2.3 29 52 YA 47 57 49 a) Obtain the regression equation using Excel b) Test whether there is a regression relation (for each independent variable): use a .10 level of significance. State the alternatives, decision rule, and conclusion. What does your test imply about Pa, Pz, Ps? c) (Bonus-2 points) Suppose you found out fa has no regression relationship (not necessarily true in this case), what do you do with that information