Quick Reference Guide
for Berk & Carey’s Data Analysis with Microsoft® Excel: Updated for Office 2007®.
Objective Steps Refer to
StatPlus, hidden data viewing Click StatPlus > General Utilities > View Hidden Chapter 1
Data. Requires StatPlus.
StatPlus, installing Access the online installation program from the website and follow the
instructions on the Installation Wizard.
StatPlus, set options Click StatPlus > StatPlus Options. Requires StatPlus. Chapter 1
StatPlus, update links Click StatPlus > General Utilities > Resolve Chapter 1
StatPlus Links.
Stem and Leaf plot, create Click StatPlus > Single Variable Charts > Stem Chapter 4
and Leaf. Select the Stem and Leaf options. Requires StatPlus.
Table statistics, calculate Click StatPlus > Descriptive Statistics > Table Chapter 7
Statistics. Select the cell range containing the cell counts and
table labels but not the column and row totals. Requires StatPlus.
Three-parameter exponential Click StatPlus > Time Series > Exponential Chapter 11
smoothing, perform Smoothing. Select the options for the three-parameter model.
Requires StatPlus.
Two-sample t test, perform Click StatPlus > Two Sample Tests > 2 Sample Chapter 6
t-test. Enter the null and alternative hypotheses.
Requires StatPlus.
Two-sample z test, perform Click StatPlus > Two Sample Tests > 2 Sample
z-test. Enter the null and alternative hypotheses.
Requires StatPlus.
Two-parameter exponential Click StatPlus > Time Series > Exponential Chapter 11
smoothing, perform Smoothing. Select the options for the two-parameter model.
Requires StatPlus.
Two-way analysis of variance Click the Data Analysis button from the Analysis Group on the Chapter 10
with replication, perform Data tab and click ANOVA: Two-Factor with Replication.
Requires the Analysis ToolPak.
Two-way analysis of variance Click the Data Analysis button from the Analysis group on the Data
without replication, perform tab and click ANOVA: Two-Factor without Replication.
Requires the Analysis ToolPak.
Two-way table, create Click StatPlus > Manipulate Columns > Create Chapter 10
Two-Way Table. Select the columns for the table. Requires StatPlus.
Univariate statistics, display Click the Data Analysis button from the Analysis group on the Data tab
and click Descriptive Statistics. Requires the Analysis ToolPak.
Univariate statistics, display Click StatPlus > Descriptive Statistics > Univariate Chapter 4
Statistics. Select the statistics to display. Requires StatPlus.
Unpaired t test, perform Click StatPlus > Two Sample Tests > 2 Sample Chapter 6
t-test. Enter the null and alternative hypotheses. Requires StatPlus.
Wilcoxon Signed Rank test, Click StatPlus > One Sample Tests > 1 Sample Chapter 6
perform Wilcoxon Signed Rank test. Enter the null and alternative
hypotheses. Requires StatPlus.
XBar control chart, create Click StatPlus > QC Charts > XBar Chart. Select the Chapter 12
control data and specify the control chart options. Requires StatPlus.