Chapter 5 Probability Distributions 199
Because these are randomly generated values, your numbers will look
different.
EXCEL TIPS
You can also create random samples using the Analysis ToolPak
add-in available with Excel. To create a random sample, load the
Analysis ToolPak, click the Data Analysis button from the
Analysis group on the Data tab and select Random Number
Generation from the Data Analysis dialog box.
StatPlus adds several new functions to Excel to generate random
numbers, including the RANDNORM command to create a random
number from a normal distribution.
Charting Random Normal Data
Now that you’ve created a random sample of normal data, your next task is
to create a histogram of the distribution. The StatPlus Histogram command
also includes an option to overlay a normal curve on your histogram to com-
pare the distribution of your data with the normal distribution.
•
•
Figure 5-13
One
hundred
random
normal
observations
