Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 557

Periodic Sample

The StatPlus>Sampling>Periodic Sample command samples data values

from a collection of columns starting at a specifi ed row and then extracting

every i th row, where i is specifi ed by the user.

Random Sample

The StatPlus>Sampling>Random Sample command extracts a random

sample of a given size from a collection of columns. The user can choose

whether to sample with replacement or without replacement.

Single-Variable Charts

Boxplots

The StatPlus>Single Variable Charts>Boxplots command creates a boxplot.

The data values can be arranged either as separate columns or in one col-

umn with a category variable. Users can choose to add a dotted line for the

sample average and to connect the medians between the boxes. The boxplot

can be sent to an embedded chart on a worksheet or to its own chart sheet.