Question
State Farm Insurance has developed the following table to describe the distribution of automobile collision claims paid during the past year. Payment($) 0, 500, 1000,2000,5000,8000,10000
State Farm Insurance has developed the following table to describe the distribution of automobile collision claims paid during the past year.
Payment($) 0, 500, 1000,2000,5000,8000,10000 Probability0.83, .06, .05, .02, .02, .01, .01 (a)Set up a table of intervals of random numbers that can be used with the Excel VLOOKUP function to generate values for automobile collision claim payments. Round your answers to two decimal places. If your answer is zero enter "0".
(b)Construct a simulation model to estimate the average claim payment amount and the standard deviation in the claim payment amounts.Round your answers to the nearest whole number.Average:$Standard Deviation:$
(c)Let X be the discrete random variable representing the dollar value of an automobile collision claim payment. Let,,, . . . ,represent possible values of. Then, the mean () and standard deviation () ofcan be computed as, and. What are the average and the standard deviation for the analytical model?Round your answers to the nearest whole number.Average:$Standard Deviation:$
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started