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 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?
c. Create a histogram of the random numbers using 10 to 15 categories of your choice. Does this histogram have approximately the shape you would expect?

Step by Step Solution

★★★★★

3.30 Rating (179 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... 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 (1 attachment)

415-M-S-S-M (181).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Simulate 100 random numbers from a Normal distribution with mean 5 and variance 4. Use set.seed so that the same samples are obtained each time you run the code. Store the samples with variable name...

You drawthese five numbers randomly from a normal distribution with mean8 and variance 15: {7, 11, 3, 2, 15}. What are the equivalent draws from a standard normal distribution?

Use @RISK to draw a normal distribution with mean 500 and standard deviation 100. Then answer the following questions. a. What is the probability that a random number from this distribution is less...

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...

ABC, Inc. is expected to pay dividends of $4.44 each year infinitely. If the required rate on the stock is 7.04%, what is today's price of the stock? Question: ABC, Inc. just paid dividend of $9.09....

Elena pays a total of $78 to visit the museum 8 times in 1 year. Tyrell pays a total $100.75 to visit the museum 15 times in 1 year. a. Define variables to represent the above situation.

Think about the backward-bending part of the labor supply curve. Why would someone work less as a result of a higher wage rate?

S14-9 Retiring bonds payable before maturity On January 1, 2014, Platz issued $200,000 of 9%, five-year bonds payable at 106. Platz has extra cash and wishes to retire the bonds payable on January 1,...

According to the Aeronautics and Space Engineering Board the probability of catastrophic failure for solid rocket motors is 1/50. Assuming rocket failures are statistically independent, determine the...

Aaron Plumbing and Bautista Electrical have both made bids in 50 of the same projects over the years. Aaron was selected for 20 of those projects. Bautista was selected for 15 of the projects, and in...

Ryu Matsuya is looking for two investors to raise capital for a new venture company. Alston Capital is interested and so is Brennan Associates. He believes it is 80% likely that Alston will invest,...

Assignment \#5 Work this problem out using an Excel spreadsheet. Short answer questions can be answered right in a cell in the spreadsheet so you just have to submit one file (your spreadsheet). You...

You are in need of regular short term financing to support your business. Three options appear attractive: 1. A standard line of credit in the sum of $500,000 at 18% annual interest for the funds...

Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 20% standard...