Question: Create a scatter plot with a trend line to show the relationship between disposable income and life insurance coverage. Reach your conclusion about the two

  1. Create a scatter plot with a trend line to show the relationship between disposable income and life insurance coverage. Reach your conclusion about the two variable
  1. This is done on excel

    An insurance company is interested in determining whether life insurance coverage is influenced linearly by disposable income. A randomly chosen sample of size 20 produced the data shown in the table below. Construct a scatterplot with a trend line. What conclusions can you draw?

    Disposable Income ($ thousands) Life Insurance Coverage ($ thousands)
    45 60
    40 58
    65 100
    50 50
    70 120
    75 140
    70 100
    40 50
    50 70
    45 60
    65 80
    60 90
    45 50
    40 50
    55 70
    55 60
    60 80
    75 120
    45 50
    65 70

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 Accounting Questions!