The probability distribution for damage claims paid by the Newton Automobile Insurance Company on collision insurance is as follows. Payment ($) Probability 0 0.85 500 0.04 1,000 0.04 3,000 0.03 5,000 0.02 8,000 0.01 10,000 0.01 Use the expected collision payment to determine the collision insurance premium that would enable the company to break even. The insurance company charges an annual rate of $520 for the collision coverage. What is the expected value of the collision policy for a policyholder? (Hint: It is the expected payments from the company minus the cost of coverage.) Why does the policyholder purchase a collision policy with this expected value?

College Algebra
10th Edition
ISBN:9781337282291
Author:Ron Larson
Publisher:Ron Larson
Chapter8: Sequences, Series,and Probability
Section: Chapter Questions
Problem 41CT: On a game show, a contestant is given the digits 3, 4, and 5 to arrange in the proper order to form...
icon
Related questions
Topic Video
Question

Can someone solve this using Microsoft Excel?

 

The probability distribution for damage claims paid by the Newton Automobile Insurance Company on collision insurance is as follows.

Payment ($)

Probability

0

0.85

500

0.04

1,000

0.04

3,000

0.03

5,000

0.02

8,000

0.01

10,000

0.01

  1. Use the expected collision payment to determine the collision insurance premium that would enable the company to break even.

  2. The insurance company charges an annual rate of $520 for the collision coverage. What is the expected value of the collision policy for a policyholder? (Hint: It is the expected payments from the company minus the cost of coverage.) Why does the policyholder purchase a collision policy with this expected value?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Discrete Probability Distributions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL