Get Instant Help From 5000+ Experts For
question

Writing Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Optimizing Auto Insurance Deductible: A Simulation Study

8 Pages / 1,798 Words Published On: 06-11-2020
Questions:
Suppose you own an expensive car and purchase auto insurance. This insurance has a $1000 deductible, so that if you have an accident and the damage is less than $1000, you pay for it out of your pocket. However, if the damage is greater than $1000, you pay the first $1000 and the insurance pays the rest. In the current year there is probability 0.025 that you will have an accident. If you have an accident, the damage amount is normally distributed with mean $3000 and standard deviation $750.
 
1.Use Excel to simulate the amount you have to pay for damages to your car. This should be a one-line simulation, so run 5000 iterations by copying it down. Then find the average amount you pay, the standard deviation of the amounts you pay, and a 95% confidence interval for the average amount you pay. (Note that many of the amounts you pay will be 0 because you have no accidents).
 
2.Continue, the simulation by creating a two-way data table, where the row input is the deductible amount, varied from $500 to $2000 in multiples of $500. Now find the average amount you pay, the standard deviation of the amounts you pay, and a 95% confidence internal for the average amount you pay for each deductible amount.
 
3.Do you think it is reasonable to assume that damage amounts are normally distributed? What would you criticize about this assumption? What might you suggest instead?
 
4.Suppose instead that the damage amount is triangularly distributed with parameters 500,1500, and 7000. That is, the damage in an accident can be as low as $500, and there is definite skewness to the right. (It turns out, as you an verify in @RISK, that the mean of this distribution is $3000). Use @RISK to simulate the amount you pay for damage. Run 5000 iterations, then answer the following questions. In each case, explain how the indicated event would occur.
 
a.What is the probability that you pay a positive amount but less than $750?
b.What is the probability that you pay more than $600?
c.What is the probability that you pay exactly $1000(the deductible)?
Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Optimizing Auto Insurance Deductible: A Simulation Study. Retrieved from https://myassignmenthelp.com/free-samples/cen4017-risk-management-in-projects/standard-deviation.html.

"Optimizing Auto Insurance Deductible: A Simulation Study." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/cen4017-risk-management-in-projects/standard-deviation.html.

My Assignment Help (2020) Optimizing Auto Insurance Deductible: A Simulation Study [Online]. Available from: https://myassignmenthelp.com/free-samples/cen4017-risk-management-in-projects/standard-deviation.html
[Accessed 02 October 2023].

My Assignment Help. 'Optimizing Auto Insurance Deductible: A Simulation Study' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/cen4017-risk-management-in-projects/standard-deviation.html> accessed 02 October 2023.

My Assignment Help. Optimizing Auto Insurance Deductible: A Simulation Study [Internet]. My Assignment Help. 2020 [cited 02 October 2023]. Available from: https://myassignmenthelp.com/free-samples/cen4017-risk-management-in-projects/standard-deviation.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Other Samples
icon
5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.