Question: 3 . Look back at the table in the example that give the annual premiums for a $250 , 000 20 - year term- life

3 . Look back at the table in the example that give the annual premiums for a $250 , 000 20 - year term- life insurance policy . a. Use Excel to make a scatterplot for just the 55 -, 60 - and 65- year olds . b. Have Excel draw the linear regression line and give the linear equation . C . Compare the actual premiums with the linear Exponential linear regression and the exponential BEE premium prediction prediction 5 5 1455 1348 1558 regression by completing the table . 50 2492 65 4172 d . Which regression would be better to predict the annual premium for a sixty - four old - old person , and why ? Answer in complete sentences . c . Which regression would be better to predict the annual premium for a twenty - seven year - old person , and why ? Answer in complete sentences
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
