Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would you set up a mote carlo excel data table for the following question? You are purchasing insurance for your house.You have three options:

How would you set up a mote carlo excel data table for the following question?

You are purchasing insurance for your house.You have three options:

Zero deductible policy that will pay 100% of all expenses for the year costs you $300 per month.

Low deductible policy that pays out 100% of expenses after the first $5000 for the year costs you $140 per month.

High deductible policy that pays out 100% of expenses after the first $10000 for the year costs you $75 per month.

You expect house damages to this year to follow a discrete distribution as follows:

65% chance of no damages

20% chance of damages light between $4,000 and $10,000 (uniformly distributed)

14% chance of high damages between $25,000 and $50,000 (uniformly distributed)

1% chance of catastrophic damages equal to $250,000.

What policy minimizes your expected expenses after insurance coverage for the year?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Algebra Functions & Authentic Applications

Authors: Jay Lehmann

5th Edition

0321923464, 9780321923462

More Books

Students also viewed these Mathematics questions

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago

Question

7. How can the models we use have a detrimental effect on others?

Answered: 1 week ago