Question

Randomly generate 100 numbers in Excel. These numbers are supposed to be from a normal distribution...

Randomly generate 100 numbers in Excel. These numbers are supposed to be from a normal distribution with mean equal to 1 and standard deviation equal to 5. Use Excel to do the Normality Check. Compare the estimated mean and standard deviation to the actual value (i.e., 1 and 5). Use Monte Carlo Analysis in Excel to estimate the value of π. Choose N= 100, 1000, and 10000 and compare the results.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use R. Generate a random sample with n=15 random observations from an exponential distribution with mean=1....
Use R. Generate a random sample with n=15 random observations from an exponential distribution with mean=1. Calculate the sample median, which is an estimator of the population median. Use bootstrap (nonparametric, with B=1000) methods to estimate the variance of the estimator for the population median. use the Monte Carlo method, e.g. generate 1000 samples of size 15 to estimate the true variance of the median estimator. Compare and comment on your results.
Continuous distributions: Generate and store in column c1 10,000 values from the uniform distribution on the...
Continuous distributions: Generate and store in column c1 10,000 values from the uniform distribution on the interval [4,8] as follows: random 10000 c1; uniform 4 8. (Do not forget the ”dot”) [3] a. Use mean command to find the sample mean ¯x of these data, ¯x=————- Note: The mean µ of a uniform distribution over an interval [a, b] is simply the middle of this interval, i.e. µ = (a + b)/2. [3] b. What is the mean µ of...
for a normal distribution with mean 100 and standard deviation 10, find the probability of obtaining...
for a normal distribution with mean 100 and standard deviation 10, find the probability of obtaining a value greater than or equal to 80 but less than or equal to 115. Using excel please.
Start with the Excel spreadsheet Insurance Company An insurance company, based on past experience, estimates the...
Start with the Excel spreadsheet Insurance Company An insurance company, based on past experience, estimates the mean damage for a natural disaster in its area is $5,000. After introducing several plans to prevent loss, it randomly samples 200 policyholders and finds the mean about per claim was $4,800 with a standard deviation of $1,300. Does it appear that prevention plans were effective in reducing the mean amount of a claim? Use a 0.05 significance level. Use this information to determine...
#5. You can find 20 RANDOM NUMBERS in a Table or you can generate them with...
#5. You can find 20 RANDOM NUMBERS in a Table or you can generate them with software like Excel. The Excel functions are “RAND” and “RANDBETWEEN”. With “Randbetween” you simply input how many numbers you want, the number of digits you want in your random number and the range of values you want those numbers to fall between. For example you may want twenty, 2-digit numbers that fall between 00 and 100 (like “34”). TWO CONSIDERATIONS: (1) You must systematically...
Suppose samples of size 100 are drawn randomly from a population that has a mean of...
Suppose samples of size 100 are drawn randomly from a population that has a mean of 20 and a standard deviation of 5. What is the probability of observing a sample mean equal to or greater than 20.5? 0.1587 0.4192 0.9192 0.1634 0.8384
For the standard normal distribution, compute Z0.69. Use Excel and round the answer to two decimal...
For the standard normal distribution, compute Z0.69. Use Excel and round the answer to two decimal places. Consider the following test performed with the level of significance 0.01: A random sample of size 28 is obtained from a normally distributed population. The population standard deviation is equal to 3.6. The sample mean happened to be 24. For this hypothesis test, what will be the critical value (the relevant z-alpha)?  Round the answer to three decimal places. A probability distribution of all...
5. Bottles of a popular cola are supposed to contain 300 ml of cola. There is...
5. Bottles of a popular cola are supposed to contain 300 ml of cola. There is some variation from bottle to bottle because the filling machinery is not perfectly precise. The distribution of the contents is normal with standard deviation  = 3 ml. An inspector who suspects that the bottler is underfilling measures the contents of 6 bottles. The results are 299.4 297.7 298.9 301.0 300.2 297.0 a. State the hypothesis that you will test. b. Find the sample...
Open the Excel program Suppose we want to know the standard normal distribution up to the...
Open the Excel program Suppose we want to know the standard normal distribution up to the given value. That is P(Z < a). Lets use Excel instead of the standard normal distribution table In cell A1 type mean. In cell B1 type 0. That means that we are letting mean be zero. click on cell A2 and type SD. In cell B2 type 1. That means that we are letting standard deviation be one. That is, the normal distribution is...
Randomly selected students were given five seconds to estimate the value of a product of numbers...
Randomly selected students were given five seconds to estimate the value of a product of numbers with the results shown below. Estimates from students given 1×2×3×4×5×6×7×81×2×3×4×5×6×7×8: 200, 1500, 1000, 10000, 1560, 856, 200, 2040, 200, 45000 Estimates from students given 8×7×6×5×4×3×2×18×7×6×5×4×3×2×1: 550, 450, 500, 3500, 2000, 350, 400, 49000, 25000, 40320 Use a 0.050.05 significance level to test the claim that the two populations have the same mean. (a) The test statistic is
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT