Life insurance companies are keenly interested in predicting how long their customers will live, because their premiums and profitability depend on such numbers. An actuary for one insurance company gathered data from 100 recently deceased male customers. He recorded the age at death of the customer plus the ages at death of his mother and father, the mean ages at death of his grandmothers and the mean ages at death of his grandfathers. These data are recorded in columns 1 to 5 respectively, in file LONGEVITY.xlsx.

aPerform a multiple regression analysis on these data.

bInterpret the coefficient estimates and their signs.

cTest for the significance of all the independent variable coefficients. (a= 0.05)

dIs the model likely to be useful in predicting men's longevity?

eAre the required conditions satisfied? Justify your answer.

Predict the longevity of a man whose parents lived to the age of 70, whose grandmothers averaged 80 years and whose grandfathers averaged 75.

data link - https://drive.google.com/file/d/1wJyr3mBOtodsP-YsWRJhxQzX3cBdCjV5/view?usp=sharing

Longevity |Mother Father Gmothers Gfathers 80 85 78 72 71 73 88 63 76 66 70 66 75 67 57 72 72 67 68 55 79 88 73 64 73 83 90 72 74 62 70 67 65 70 59 72 76 71 74 61 72 66 75 71 63 71 78 64 76 61 67 69 66 61 69 74 71 76 73 60 80 74 77 69 68 63 68 66 67 67 71 70 70 71 67 66 64 66 63 57 74 82 71 75 65 71 71 71 68 62 65 75 60 63 62 74 76 66 66 69 66 69 68 61 65 71 76 67 63 71 73 69 80 64 61 74 79 70 77 60 68 74 62 59 63 77 81 78 73 62 77 85 69 80 65 74 77 69 75 69 68 72 71 72 66 76