Question

Please solve step by step. USE PYTHON OR EXCELL NO OTHERS.

The actuaries for an insurance company represent the total losses experienced during a week as follows: Let N represent the n

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)The Python code for doing the Monte Carlo Simulation and finding the sample mean, sample standard deviation, 25th and 75th percentiles, 95% confidence interval and the probabilities is given below.

import math
import numpy as np
X = []
N = np.random.randint(low=50, high=145, size=5000)
for i in range(5000):
    s = 0
    for j in range(N[i]):
        Z = np.random.triangular(left=280, right=740, mode=510, size=1)
        s += Z
    X.append(s)
m= np.mean(X)
sd = np.std(X)
print("Sample mean is:", m)
print("Sample standard deviation is:", sd)
conf1 = m - 1.96*sd/np.sqrt(5000)
conf2 = m + 1.96*sd/np.sqrt(5000)
print("The 95% confidence interval is:", conf1, " ,", conf2)
print("The 25th and 75th percentiles are:", np.percentile(X, 25), " ,", np.percentile(X, 75))
X = np.array(X)
X1 = X[X < 40000]
X2 = X[X > 70000]
print("The probability that the loss will be less than $40,000 is:", len(X1)/5000)
print("The probability that the loss will be greater than $70,000 is:", len(X2)/5000)

The sample output is:

Sample mean is: 49859.333663659585
Sample standard deviation is: 13889.666862680726
The 95% confidence interval is: 49474.33174068026 , 50244.33558663891
The 25th and 75th percentiles are: 38091.16156246797 , 61866.255521021754
The probability that the loss will be less than $40,000 is: 0.2872
The probability that the loss will be greater than $70,000 is: 0.0776

b) We have sample mean is X $49,859.334 , sample standard deviation is S $13,889.667 , 95% confidence interval is (49,474.332,50,244.336) , 25th and 75th percentiles are 38,091.162, 61,866.256 , and the probabilities are P(X 40,000) = 0.2872, P(X> 70,000) = 0.0776

c) We have

E(X) E(N)E(Z) E(X) =50+ 145 2 280 510 740 3 E(X) 49725

E(X2) E(N2)E(Z2) 50145 2802 5102 7402 280(510) + 280(740) + 740(510) 952 280510 740 E(X2) 18 12 E(X2) Var(X) 2758636806- 4972The 95% CI is

Xt 1.96- Vn 49725 1,9616913.343 V5000 (49, 256.19, 50,193.81)

The CI has shifted to left.

d)The probabilities are P(X 40,000) = 0.2872, P(X> 70,000) = 0.0776

Add a comment
Know the answer?
Add Answer to:
Please solve step by step. USE PYTHON OR EXCELL NO OTHERS. The actuaries for an insurance...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Monte Carlo Simulation This lab assignment consists of two problems involving Monte Carlo simulation. You should...

    Monte Carlo Simulation This lab assignment consists of two problems involving Monte Carlo simulation. You should use either Excel or Python for this assignment. References: Seila, A. F., V. Ceric, and P. Tadikamalla, Applied Simulation Modeling, Duxbury - Brooks/Cole, Belmont, CA, 2003. Schriber, T. J., "Simulation for the Masses: Spreadsheet-based Monte Carlo Simulation," Proceedings of the 2009 Winter Simulation Conference, Rossetti, Hill, Johansson, Dunkin, and Ingalls, Eds., December 2009. Adopted from Problem 2.13 from Seila et al. (page 74) with...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • I must use R Program to solve them. Please help! Thank you ünif uniform random variable...

    I must use R Program to solve them. Please help! Thank you ünif uniform random variable 1) Draw the graphs of the p.d.f. of the following distributions (a) The standard normal p.d.f (b) The normal pdf with ? = 50, ? = 10 (c) The uniform p.d.f. over interval [10, 20] (d) The exponential P.d.f with parameter ? 4. 2) Illustrating the central limit theorem. Let X be a random variable having the uniform distribution over the interval [6, 12]...

  • Let Xi , i = 1, · · · , n be a random sample from...

    Let Xi , i = 1, · · · , n be a random sample from Poisson(θ) with pdf f(x|θ) = e −θ θ x x! , x = 0, 1, 2, · · · . (a) Find the posterior distribution for θ when the prior is an exponential distribution with mean 1; (b) Find the Bayesian estimator under the square loss function. (c) Find a 95% credible interval for the parameter θ for the sample x1 = 2, x2...

  • Please be as clear as possible, needs work and theorems explained/noted. No excel please, urgent thanks...

    Please be as clear as possible, needs work and theorems explained/noted. No excel please, urgent thanks Textbook - Applied Statistics and Probability for Engineers by Montgomery, 6th Edition PART 1. For each of the following statements, circle the letter “T” if it is true, and “F” if it is false. TF If events A and B are mutually exclusive, they must be independent. т F P[A B C] P[CB] P[B] = P[CAB] P[AB] P[B]. T F If the 95% confidence...

  • Please be as clear as possible. Textbook - Applied Statistics and Probability for Engineers by Montgomery,...

    Please be as clear as possible. Textbook - Applied Statistics and Probability for Engineers by Montgomery, 6th Edition PART 1. For each of the following statements, circle the letter “T” if it is true, and “F” if it is false. TF If events A and B are mutually exclusive, they must be independent. т F P[A B C] P[CB] P[B] = P[CAB] P[AB] P[B]. T F If the 95% confidence interval for a particular situation is (-5,5), then the 90%...

  • Step 1. Open Excel and complete first two columns with any numbers Make 7-8 rows. Type...

    Step 1. Open Excel and complete first two columns with any numbers Make 7-8 rows. Type below first column "R = " We will use Excel function CORREL(Array-1, Array-2). STEP 2. Click on cell B11 and type: =CORREL( Highlight all numbers in A-column starting with cell A2 (do not include title). That will be Array-1 (input range). Type comma after Array-1 and highlight Array-2 from B-column. Press ENTER. You will see in cell B11 Coefficient of Linear Correlation. STEP 3....

  • please be as clear as possible, take note of units and significant figures. thanks for the...

    please be as clear as possible, take note of units and significant figures. thanks for the help PART 1. For each of the following statements, circle the letter “T” if it is true, and “F” if it is false. TF If events A and B are mutually exclusive, they must be independent. т F P[A B C] P[CB] P[B] = P[CAB] P[AB] P[B]. T F If the 95% confidence interval for a particular situation is (-5,5), then the 90% confidence...

  • PLEASE HELP ME TO SOLVE THIS STEP BY STEP 9. Suppose the age that children learn...

    PLEASE HELP ME TO SOLVE THIS STEP BY STEP 9. Suppose the age that children learn to walk is normally distributed with mean 13 months and standard deviation 1.1 month. 10 randomly selected people were asked what age they learned to walk. Round all answers to 4 decimal places where possible. A What is the distribution of X? X B What is the distribution of ¯x? ¯x ~ N C What is the probability that one randomly selected person learned...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT