An insurance company offers four different deductible levels—none, low, medium,

Question

An insurance company offers four different deductible levels—none, low, medium, and high—for its homeowner's policyholders and three different levels—low, medium, and high—for its automobile policyholders. The accompanying table gives proportions for the various categories of policyholders who have both types of insurance. For example, the proportion of individuals with both low homeowner's deductible and low auto deductible is 0.06 (6% of all such individuals).

if possible, please solve showing the excel formulas

Homeowner's Auto 0.04 0.06 0.05 0.02 0.07 0.10 0.20 0.11 0.02 0.03 0.15 0.15 Suppose an individual having both types of policies is randomly selected. (a) What is the probability that the individual has a medium auto deductible and a high homeowner's deductible? (b) What is the probability that the individual has a low auto deductible? A low homeowner's deductible? auto deductible homeowner's deductible (c) What is the probability that the individual is in the same category for both auto and homeowner's deductibles? (d) Based on your answer in part (c), what is the probability that the two categories are different? (e) What is the probability that the individual has at least one low deductible level? (f) Using the answer in part (e), what is the probability that neither deductible level is low?

Explanation / Answer

a) probability P(M and H) =0.11

b)

probability of low auto deductible=0.17

low homeowner's deductible=0.19

c) probability =0.06+0.2+0.15=0.41

d) probability =1-0.41 =0.59

e) P(at least one low deductible) =0.17+0.1+0.03=0.30

f)probability =1-0.30 =0.7 ( here formulas are not required only we need to look at the table and get the required values)

N L M H total L 0.04 0.06 0.05 0.02 0.17 M 0.07 0.1 0.2 0.11 0.48 H 0.02 0.03 0.15 0.15 0.35 total 0.13 0.19 0.4 0.28 1

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.