Data Analysis with Microsoft Excel: Updated for Office 2007

552

StatPlus™ is supplied with the textbook Data Analysis with Microsoft Excel 2007

to perform basic statistical analysis not covered by Excel or the Analysis Tool-

Pak. To use StatPlus, you must fi rst verify that it is available to your workbook.

To check whether StatPlus is available:

1 If the StatPlus menu appears in the Menu Commands group of the

Add-Ins tab, StatPlus is loaded and activated on your system.

2 If the menu command does not appear, click Tools>Add-Ins from

the menu. If the StatPlus option is listed in the Add-Ins list box,

click the checkbox. StatPlus is now available to you.

3 If StatPlus is not listed in the Add-Ins list box, you will have to install

it from your instructor’s disk. See Chapter 1 for more information.

The rest of this section documents each StatPlus Add-In command, showing

each corresponding dialog box, and describes the command’s options and output.

Creating Data

Bivariate Normal Data

The StatPlus>Create Data>Bivariate Normal command creates two columns

of random normal data where the standard deviation s of the data in the fi rst

column and the correlation between the columns are specifi ed by the user.

The standard deviation of the data in the second column of data is a function

of the standard deviation of the data in the fi rst column.

StatPlus™ Commands