Input Parameters number probability 1 0.05 Repair Bill per Claim Mean $1,700 Standard Deviation $400 Probability...

  

Transcribed Image Text:

Input Parameters number probability 1 0.05 Repair Bill per Claim Mean $1,700 Standard Deviation $400 Probability of a Totaled Car 20% Value of a Totaled Claim Random Variables Minimum $2,000 Most Likely $13,000 Maximum $35,000 # of repair claim Is there a totaled car 2 3 4 5 6 7 0.06 0.1 0.17 0.28 0.14 0.08 8 0.07 0.05 Claim Number Claim Amount Is there pay? Totaled Car Payment 1 1600.00 1 15000 2 1400.00 1 3 1650.00 1 4 1500.00 1 5 1200.00 0 6 1700.00 0 7 1750.00 0 B 1690.00 9 1300.00 Consider Vinton Auto Insurance problem and the screenshot above. Complete the function for "of repair claim' in Cell C17 using the dropdown boxes. Select [Select] C3K3) Answer 1: GenBinomial Answer 2 C2K2 Answer 3 Consider Vinton Auto Insurance problem and the screenshot above. Complete the function for "# of repair claim" in Cell C17 using the dropdown boxes. [Select] [Select] ,C3:K3) Answer 1: GenBinomial Answer 2: C2:K2 Answer 3: C3 K3 Input Parameters number probability 1 0.05 Repair Bill per Claim Mean $1,700 Standard Deviation $400 Probability of a Totaled Car 20% Value of a Totaled Claim Random Variables Minimum $2,000 Most Likely $13,000 Maximum $35,000 # of repair claim Is there a totaled car 2 3 4 5 6 7 0.06 0.1 0.17 0.28 0.14 0.08 8 0.07 0.05 Claim Number Claim Amount Is there pay? Totaled Car Payment 1 1600.00 1 15000 2 1400.00 1 3 1650.00 1 4 1500.00 1 5 1200.00 0 6 1700.00 0 7 1750.00 0 B 1690.00 9 1300.00 Consider Vinton Auto Insurance problem and the screenshot above. Complete the function for "of repair claim' in Cell C17 using the dropdown boxes. Select [Select] C3K3) Answer 1: GenBinomial Answer 2 C2K2 Answer 3 Consider Vinton Auto Insurance problem and the screenshot above. Complete the function for "# of repair claim" in Cell C17 using the dropdown boxes. [Select] [Select] ,C3:K3) Answer 1: GenBinomial Answer 2: C2:K2 Answer 3: C3 K3