Hi there,could you help me with this, please? Thank you so much!Life insurance companies are keenly...

Question

Hi there,could you help me with this, please? Thank you so much!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.	Perform a multiple regression analysis on these data.	Interpret the coefficient estimates and their signs.	Test for the significance of all the independent variable coefficients. ( = 0.05)	Is the model likely to be useful in predicting men’s longevity?	Are 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.						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							68			75			63			65			65							74			82			66			72			62							71			73			72			68			71							80			84			73			77			68							72			75			61			77			61							77			82			76			71			63							76			88			69			75			67							62			65			57			68			57							70			75			57			67			57							71			72			67			67			64							69			72			63			68			67							73			79			71			74			65							72			77			69			72			65							84			80			90			72			71							73			76			74			69			65							70			78			70			78			54							78			75			74			58			70							82			83			78			77			65							77			75			66			72			60							67			68			69			73			62							72			69			72			69			68							67			67			67			72			66							72			78			64			67			66							75			73			69			71			61							72			71			66			68			68							75			73			73			66			59							80			84			75			71			74							72			78			64			66			61							71			76			61			74			61							71			77			70			73			61							89			86			77			74			69							74			79			71			70			77							72			72			77			71			68							74			78			68			67			72							77			85			77			77			71							77			72			72			63			64							73			67			71			65			69							72			74			64			74			62							65			66			63			72			60							81			82			77			73			69							76			80			70			63			60							64			71			67			66			66							72			73			69			64			67							69			75			67			60			62							59			59			62			68			56							69			73			69			72			53							76			82			65			72			69							63			71			56			61			53							66			74			64			72			63							72			85			60			67			67							68			72			66			65			68							73			80			75			67			67							78			82			72			71			72							83			82			82			76			72							78			82			70			76			64							67			73			62			65			59							70			77			60			69			67							68			74			79			72			65							66			80			63			75			59							75			76			72			69			64							71			71			60			71			66							72			77			64			70			69							71			76			67			66			64							77			79			74			73			70							67			68			68			70			57							68			71			61			66			64							67			76			62			66			62							74			77			64			66			69							70			66			68			63			66							72			78			70			71			64							69			73			60			74			60

Hi there, could you help me with this, please? Thank you so much! Life insurance companies are keenly interested in predicting how long their customers will live, because their premiums and...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment

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
68	75	63	65	65
74	82	66	72	62
71	73	72	68	71
80	84	73	77	68
72	75	61	77	61
77	82	76	71	63
76	88	69	75	67
62	65	57	68	57
70	75	57	67	57
71	72	67	67	64
69	72	63	68	67
73	79	71	74	65
72	77	69	72	65
84	80	90	72	71
73	76	74	69	65
70	78	70	78	54
78	75	74	58	70
82	83	78	77	65
77	75	66	72	60
67	68	69	73	62
72	69	72	69	68
67	67	67	72	66
72	78	64	67	66
75	73	69	71	61
72	71	66	68	68
75	73	73	66	59
80	84	75	71	74
72	78	64	66	61
71	76	61	74	61
71	77	70	73	61
89	86	77	74	69
74	79	71	70	77
72	72	77	71	68
74	78	68	67	72
77	85	77	77	71
77	72	72	63	64
73	67	71	65	69
72	74	64	74	62
65	66	63	72	60
81	82	77	73	69
76	80	70	63	60
64	71	67	66	66
72	73	69	64	67
69	75	67	60	62
59	59	62	68	56
69	73	69	72	53
76	82	65	72	69
63	71	56	61	53
66	74	64	72	63
72	85	60	67	67
68	72	66	65	68
73	80	75	67	67
78	82	72	71	72
83	82	82	76	72
78	82	70	76	64
67	73	62	65	59
70	77	60	69	67
68	74	79	72	65
66	80	63	75	59
75	76	72	69	64
71	71	60	71	66
72	77	64	70	69
71	76	67	66	64
77	79	74	73	70
67	68	68	70	57
68	71	61	66	64
67	76	62	66	62
74	77	64	66	69
70	66	68	63	66
72	78	70	71	64
69	73	60	74	60