Question: Use Excels functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random

Use Excel’s functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers.

a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?

b. What fraction of these random numbers are within k standard deviations of the mean? Answer for k = 1; for k = 2; for k = 3. Are the answers close to what they should be (about 68% for k = 1, about 95% for k = 2, and over 99% for k = 3)?

c. Create a histogram of the random numbers using about 10 bins of your choice. Does this histogram have approximately the shape you would expect?

Step by Step Solution

★★★★★

3.36 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Normally distributed random numbers Mean 100 Stdev 10 Counter Random number Frozen 1 100386 91637 2 93197 107552 3 122700 115069 4 94838 111496 5 94097 87330 6 95659 103161 7 87878 105418 8 107910 120... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1497_60b7412520bf6_696661.pdf

180 KBs PDF File

1497_6047609b2e4b6_696661.xlsx

300 KBs Excel File

1497_60b7412520bf6_696661.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

Repeat the previous problem, but make the correlation between the two inputs equal to 0.7. Explain how the results change. Data from Previous Problem: When you use @RISKs correlation feature to...

Read each of the following cases. Explain for each case how you could select a sample having the best chance of being representative of the population using (1) unrestricted random selection and ( 2)...

1) The following numbers represent a random sample from a normal distribution with variance of 16 and unknown mean : 7.64 6.38 6.06 5.59 2.03 1.17 8.42 -6.83 2.25 5.78 7.56 4.33 a) What is the...

Use Excels functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers. a. Calculate the mean and...

Use Excels functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation

Please use the Palisade Decision Tools Excel software (as well as step by step) Use Excel's functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard...

Use Excels functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers. Calculate the mean and standard...

Lab 4 This assignment is due before the end of your Monday/Tuesday section. For every section you will submit your handwritten work to your TA. Only neat and organized assignments will be graded for...

There are many other statistical tests beyond the ones covered in our class. In this problem we will explore the correlation test. The hypotheses of the test are as follows, where is the population...

Please I need help to code this assignemt in code by code in MATLAB. I need all of them this is my first time coding MATLAB and I'm facing defeculties. Thank you. 1 MATLAB/Octave 2D Graphics 1. Use...

Find the length of the following arc. Enter your answer with three decimal places (2.5=2.500, 2.7856=2.785). x(t) = cos(t); y(t) = sin(t), 0

Benchmarking is one of the essential ways to evaluate companies as it allows investors to compare various companies in the same industry. Pick an industry of your choice and choose 2 companies for...

5 . Which of the following transactions would increase total assets? I. Received cash from a customer as payment on account, \ $ 5 8 , 0 0 0 . II . Provided services on account, \ $ 1 3 0 , 0 0 0 ....

4.10 Compute k(x) for k = 2, 3, 4 in Example 4.10. Also verify that k, k = 0, 1, 2, 3, 4, are orthonormal; that is, they satisfy (4.41) and (4.42) with S = [0, 1].

Martha Lou owns 100 shares of Blain Corporation common stock. She purchased the stock on July 25, 1986, for $4,000. On May 2 of the current year, she receives a nontaxable distribution of 100 stock...

Beth acquired only one tract of land seven years ago as an investment. In order to sell the land at a higher price, she decides to subdivide it into 20 lots. She pays for improvements such as...

Mr. and Mrs. Dunbar have taxable income of $260,000 without considering the following sales. Consider the following independent cases where capital gains are recognized and determine the marginal tax...

Global Technology's capital structure is as follows: \ table [ [ Debt , 5 0 8 ] , [ Preferred stock, 3 5 ] , [ Common equity, 1 5 ] ] The aftertax cost of debt is 8 . 5 0 percent; the cost of...

Queen B Corp. has a current annual cash dividend policy of $3.00. The price of the stock is set to yield 10% return. What is the price of this stock today if the dividend will be paid for 10 year and...

Excess reserves of commercial banks which are deposited with Federal Reserve Banks are referred to as: (A) discount funds (B) certificates of deposit (C) excess equity funds (D) federal funds