Question: when I run this regression it gets an error saying non numerical data ... how do I fix this I am trying to answer this

when I run this regression it gets an error saying non numerical data ... how do I fix this

when I run this regression it gets an error

when I run this regression it gets an error

I am trying to answer this question how do I do that without getting an error.

B Sh D F G H M N o P Patient Number Q BMI Cholesterol level Does the patient regularly use tobacco? Does the patient have family history of heart attack? Risk of heart attack (%) Regression 1 2 1 Input Input Y Range: OK SEST-SE522 + Input X Range Cancel SA$1:$D$22 Co Now N- OU UN 4 Help No No No No No Yes No Labels Confidence Level Constant is Zero 95 25 SH54 9 5 17 20 11 44 61 57 29 27 24 13 14 37 No No No Yes No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes 5 6 7 8 9 10 11 12 13 14 15 19.5 225 21.6 21.0 28.5 31.3 31.0 24.6 24.0 23.5 21.5 22.1 26.5 28.0 29.0 29.4 26.0 23.0 19.8 19.0 30.0 10 143 160 165 143 215 310 300 185 182 180 150 153 190 202 260 227 183 171 148 140 274 11 Output options O Output Range New Worksheet Ply: O New Workbook Residuals Residuals Standardized Residua 12 Residual Plots Line Fit Plots 13 Normal Probability Normal Probability Plots 14 39 15 No No No No No No Yes No No No No No Yes 54 16 17 16 Yes 18 19 17 18 19 20 21 20 48 33 21 8 3 58 No No No Yes 21 22 23 + 100 Data Heart attack.xls. a) Develop an estimated multiple regression equation that estimates risk of heart attack based on body mass index (BMI), cholesterol level, family history of heart attacks, and regular use of tobacco

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!