Please see attachment below:

A B C D E F G H K L M N O 1 Longevity Mother Father Gmothers Gfathers W N 80 85 78 72 71 Part 1 73 88 63 76 66 Life insurance companies are keenly interested in predicting how long 70 66 75 67 57 their customers will live, because their premiums and profitability depend 72 72 67 68 55 on such numbers. Data were gathered for 100 deceased males, in order 79 88 73 64 73 62 to formulate a regression that predicted longevity based on: 83 90 72 74 70 67 65 70 59 * Age at death of the two parents 72 76 71 74 61 * Mean age at death of grandfather and grandmothers 10 72 66 75 71 63 11 71 78 64 76 61 Questions 12 67 69 66 61 69 a. Perform a multiple regression analysis and show the prediction 13 74 71 76 73 60 equation. 14 80 74 77 69 68 b. Is the model useful at 2.5% significance level? 15 63 68 66 67 67 c. Interpret the coefficients b1 and b2 in this model. 16 70 70 71 67 17 66 64 66 63 57 Part 2 (see Longevity (2) 18 74 82 71 75 65 A statistician working for the company suggeted smoking is a major 19 71 71 71 68 62 determinant of a person's longevity. He added this variable as a predictor 20 65 75 60 63 62 to the first group of independent variables, but also took out the 74 76 66 66 69 insignificant variables from the previous model of Part 1. 22 66 69 68 61 65 Questions 23 71 76 67 63 71 d. Run the reduced model (that now includes only three independant 24 73 69 80 64 61 25 74 79 70 77 60 variavles), and show the prediction equation. 26 68 74 62 59 63 e. Interpret the coefficient of the predictor "Smoker" in this model (that 27 77 81 78 73 62 is, if say, the value of this coefficient is 4, what does it mean in this 28 77 85 69 80 65 model). 29 74 77 69 75 69 f. A smoker, whose both parents passed at the age of 85 is 62 years old. 30 68 72 71 72 66 How many more years is he expected to live? 31 68 75 63 65 65 g. His friend is not a smoker who lost his mother when she was 70 years 32 74 82 66 72 62 old, and father when he was 60 years old. How long is he expected to 33 71 73 72 68 71 live? 34 80 84 73 77 68 h. Can you determine with 90% confidence which of the two friends will 35 72 75 61 77 61 die at a younger age?\f\fA B D E F G H Longevity Mother Father Gmothers Gfathers Smoker W N 80 85 78 72 71 No 73 88 63 76 66 Yes 70 66 75 67 57 Yes 72 72 67 68 55 Yes 79 88 73 64 73 No 1 00 83 90 72 74 62 No 70 67 65 70 59 Yes 72 76 71 74 61 Yes 10 72 66 75 71 63 Yes 11 71 78 64 76 61 Yes 12 67 69 66 61 69 Yes 13 74 71 76 73 60 No 14 80 74 77 69 68 No 15 63 68 66 67 67 Yes 16 71 70 70 71 67 Yes 17 66 64 66 63 57 Yes 18 74 82 71 75 65 No 19 71 71 71 68 62 Yes 20 65 75 60 63 62 Yes 21 74 76 66 66 69 No 22 66 69 68 61 65 Yes 23 71 76 67 63 71 Yes 24 73 69 80 64 61 Yes 25 74 79 70 77 60 No 26 68 74 62 59 63 Yes 27 77 81 78 73 62 No 28 77 85 69 80 65 No 29 74 77 69 75 69 Yes 30 68 72 71 72 66 Yes 31 68 75 63 65 65 Yes 32 74 82 66 72 62 No 33 71 73 72 68 71 Yes 34 80 84 73 77 68 No 35 72 75 61 77 61 YesA B C D E F G H J 35 72 75 61 77 61 Yes 36 77 82 76 71 63 No 37 76 88 69 75 67 No 38 62 65 57 68 57 Yes 39 70 75 57 67 57 Yes 40 71 72 67 67 64 Yes 41 69 72 63 68 67 Yes 42 73 79 71 74 65 Yes 43 72 77 69 72 65 Yes 44 84 80 90 72 71 No 45 73 76 74 69 65 Yes 46 70 78 70 78 54 Yes 47 78 75 74 58 70 No 48 82 83 78 77 65 No 49 77 75 66 72 60 No 50 67 68 69 73 62 Yes 51 72 69 72 69 68 Yes 52 67 67 67 72 66 Yes 53 72 78 64 67 66 Yes 54 75 73 69 71 61 No 55 72 71 66 68 68 Yes 56 75 73 73 66 59 No 57 80 84 75 71 74 No 58 72 78 64 66 61 Yes 59 76 61 74 61 Yes 60 71 77 70 73 61 Yes 61 89 86 77 74 69 No 62 74 79 71 70 77 No 63 72 72 77 71 68 Yes 64 74 78 68 67 72 No 65 77 85 77 77 71 No 66 77 72 72 63 64 No 67 73 67 71 65 69 Yes 68 72 74 64 74 62 Yes 69 165 63 Longevity Longevity (2) +J E G H K A D F I L B C 69 65 66 63 72 60 Yes 77 73 69 No 70 81 32 63 No 76 80 60 71 70 Yes 72 64 71 67 66 66 73 72 73 69 64 67 Yes 67 60 62 Yes 74 69 75 59 59 62 68 56 Yes 75 73 72 Yes 76 69 69 53 77 76 82 65 72 69 No Yes 78 71 56 61 53 Yes 79 66 74 64 72 63 72 85 Yes 80 60 67 67 81 68 72 66 65 68 Yes 82 73 80 75 67 67 Yes 82 72 71 72 No 83 78 84 83 82 82 76 72 No 85 78 82 70 76 64 No 86 67 73 62 65 59 Yes 87 69 67 Yes 70 77 60 88 74 79 72 65 Yes Yes 89 66 80 63 75 59 90 76 72 69 64 No 91 71 71 60 71 66 Yes Yes 92 72 77 64 70 69 76 67 66 64 Yes 93 71 70 No 94 77 79 74 73 95 67 68 68 70 57 Yes Yes 96 68 71 61 66 64 97 67 76 62 66 62 Yes 98 77 64 66 No 74 69 Yes 70 66 68 63 66 78 70 71 64 Yes 100 72 69 73 60 74 60 Yes 101 102 103 Longevity Longevity (2) +