Quick Reference Guide
for Berk & Carey’s Data Analysis with Microsoft® Excel: Updated for Office 2007®.Objective Steps Refer to
Add-Ins, installing Click the Office button, click the Excel Options button, click Chapter 1
Add-Ins from the list of Excel options, click the Go button,
and click the Browse button from within the Add-Ins dialog
box to locate and load the add-in file.
Autocorrelation, plot Click StatPlus > Time Series > ACF Plot. Select the Chapter 11
data column and range of lag values. Requires StatPlus.
Bivariate Normal data, Click StatPlus > Create Data > Bivariate Normal.
create Specify the parameters of the bivariate distribution. Requires StatPlus.
Boxplot, create Click StatPlus > Single Variable Charts > Boxplots. Chapter 4
Select the boxplot options. Requires StatPlus.
Bubble plots, create Click the Other Charts button from the Charts group on the Chapter 3
Insert tab and then click a bubble chart subtype.
C control chart, create Click StatPlus > QC Charts > C-Chart. Select the control Chapter 12
data and specify the control chart options. Requires StatPlus.
Chart axis, reformat With a chart selected, click the Axes button from the Axes group on
the Layout tab of the ChartTools ribbon and then select whether to
reformat the horizontal or vertical axis.
Chart background, format With the chart selected, click the Plot Area button from the Chapter 3
Background group on the Layout tab of the ChartTools ribbon and select
the background option.
Chart point labels, create With the chart selected, click StatPlus > Label series Chapter 3
points. Requires StatPlus.
Chart points, format With the chart selected, click any data point in the chart and click Chapter 3
Format Selection from the Current Selection group on the Format
tab of the ChartTools ribbon.
Columns, stack Click StatPlus > Manipulate Columns > Stack.
Select the columns to stack. Requires StatPlus.
Columns, unstack Click StatPlus > Manipulate Columns > Unstack. Chapter 10
Select the columns to unstack. Requires StatPlus.
Correlation matrix, create Click StatPlus > Multivariate Analysis > Correlation Chapter 8
Matrix. Enter the variables in the correlation matrix. Requires StatPlus.
Data, enter from keyboard Click the cell and type the data values. Chapter 2
Data, import from a Click the Get External Data button on the Data tab; then select Chapter 2
database the From Other Sources button and select the data source.
Data, import from text files Click the Office button, click the Excel Options button, click Add-Ins Chapter 2
from the list of Excel options, click the Go button, and click the Browse
button from within the Add-Ins dialog box to locate and load the add-in file.
Data, query with Enter the query conditions in the worksheet, and click the Chapter 2
advanced filter Advanced button from the Sort & Filter group on the Data tab.
Data, query with AutoFilter Select the cell range and click the Filter button from the Sort & Chapter 2
Filter group on the Data tab.
Data, sort Select the cell range and then click the Sort button from the Sort & Chapter 2
Filter group on the Data tab.
Frequency table, create Click StatPlus > Descriptive Statistics > Frequency Chapter 4
Tables. Select the frequency table options. Requires StatPlus.http://www.cengage.com/brookscole