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

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
, sample standard deviation is
, 95% confidence interval is
, 25th and 75th percentiles are
, and the probabilities are
c) We have
The
95% CI is
The CI has shifted to left.
d)The probabilities are
Please solve step by step. USE PYTHON OR EXCELL NO OTHERS. The actuaries for an insurance...
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 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 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 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 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
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, 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 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 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 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...