Use Excels functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100
Question:
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?
Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Analysis And Decision Making
ISBN: 415
4th Edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted: