Quantum Analysis

Assume there is a 5000 dollar deductible which means if there is a claim and the damage is less than 5000, user pays it out of pocket. If the charges are more than 5000 dollars, first 5000 is paid by the user and remaining by the insurance firm. The probability of getting a claim this year is .085. If you get claim for damages , the damage amount is normally distributed with mean of 7000 and standard deviation of 2000 dollars. The ask is to build a monte carlo simulation show out of pocket expenses in this scenario. Use a data table to run 5000 iterations of the model and anaylze the results of the 5000 iterations to find how often a claim was filed.