Data Analysis with Microsoft Excel: Updated for Office 2007

Patterned data, create Click StatPlus > Create Data > Patterned Data. Chapter 7

Specify the data pattern. Requires StatPlus.

PivotTable, create Click the PivotTable button from the Tables group on the Insert tab.

PivotTable, Select cells from the PivotTable and then click the Group Chapter 7

grouping categories in Selection button from the Group group on the Options tab of the

PivotTable Tools ribbon.

PivotTable, Click and drag the row or column label off of Chapter 7

remove categories from the pivot table.

Random numbers, create Click the Data Analysis button from the Analysis group on the

Data tab and then click Random Number Generation.

Random numbers, create Click StatPlus > Create Data > Random Numbers. Chapter 5

Select the probability distribution, number of samples, and sample

size. Requires StatPlus.

Range control chart, Click StatPlus > QC Charts > Range Chart. Select the Chapter 12

create control data and specify the control chart options. Requires StatPlus.

Range names, Select the cell range and then click the Create from Chapter 2

create from column labels Selection button from the Defined Names group on the Formulas

tab; then click the Top Row check box and click OK.

Regression analysis, Click the Data Analysis button from the Analysis group on Chapter 8

perform the Data tab and then click Regression. Requires the

Analysis ToolPak

Regression line, Right-click the chart series and click Add Trendline. Select the Chapter 8

add to scatterplot regression type from the Trendline Options dialog sheet.

Runs test, perform Click StatPlus > Time Series > Runs test. Enter the Chapter 8

options of the test. Requires StatPlus.

Sample, Click StatPlus > Sampling > Conditional Sample.

create a conditional Enter the sampling conditions. Requires StatPlus.

Sample, create a periodic Click StatPlus > Sampling > Periodic Sample. Enter

the sampling conditions. Requires StatPlus.

Sample, create a random Click StatPlus > Sampling > Random Sample. Enter

the sampling conditions. Requires StatPlus.

Scatterplot matrix, create Click StatPlus > Multi-variable Charts > Chapter 8

Scatterplot Matrix. Enter the variables in the scatterplot

matrix. Requires StatPlus.

Scatterplot, Select the chart and click StatPlus > Display by Category. Chapter 3

break into categories Specify the categorical variable to use. Requires StatPlus.

Scatterplot, create quickly Click StatPlus > Single Variable Charts > Fast Chapter 11

Scatterplot. Enter the data columns for the x and y axes.

Requires StatPlus.

Seasonal adjustment, Click StatPlus > Time Series > Seasonal Adjustment. Chapter 11

perform Select the data column and the period of the season. Requires StatPlus.

Standardize data Click StatPlus > Manipulate Columns > Standardize. Enter the

data columns and select the method of standardization. Requires StatPlus.

StatPlus modules, unloading Click StatPlus > Unload Modules, select the module’s Chapter 1

checkbox and click OK. Requires StatPlus.

Objective Steps Refer to

Quick Reference Guide
for Berk & Carey’s Data Analysis with Microsoft® Excel: Updated for Office 2007®.