Normal Distribution Random Number Generator
This example shows the interested user how to create random numbers from a normal distribution given the standard deviation and the mean, and then computes the confidence interval given the level of significance, alpha. Cells C3 to C6 are input cells. Upon the completion of this program, the user can type in the alpha level, number of iterations, mean and standard deviation, then execute the Macro command to obtain the output.
This program also generates a 20 class histogram as shown on figure 1. Twenty classes of frequency will be generated on cells I3 to I22. Users who are familiar with chart generation on Excel can use the data provided on cells H3 to I22 to generate a bell shaped histogram chart.
Copyright © XL Modeling.