Problem 1 (Logistic Regression using Excel) Suppose that we are working with some doctors on heart attack patients. See the table below for the data. The response variable is whether the patient has had a second heart attack within 1 year (yes = 1). The predictor variable is a score on a trait anxiety scale (a higher score means more anxious). . Trait Patient | 2 Heart Attack Anxiety 1 1 TO 2 1 80 3 1 50 4 1 60 5 1 40 6 1 65 7 1 75 g 1 80 9 1 70 10 1 60 11 0 65 12 0 50 13 0 45 14 0 35 15 0 40 16 0 50 17 0 54 18 0 45 19 0 50 20 0 60 fon (ON oo 9 (3) a) Use Excel to build a logistic regression model between the two variables. Use initial v Lf 0.1, and 5= 0.2. b) Predict the probability of a second heart attack within 1 year for a patient with an anxiety score of 78. c) Ifa patient does not want the probability of a second heart attach within 1 year to be over 90%, what anxiety score should he 'she not exceed