Question: the question in the picture Problem 1 (Logistic Regression using Excel) Suppose that we are working with some doctors on heart attack patients. See the
the question in the picture
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 exceedStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
