Data Analysis with Microsoft Excel: Updated for Office 2007

Objective Steps Refer to

Histogram, create Click the Data Analysis button from the Analysis group on the

Data tab and then click Histogram.

Histogram, create Click StatPlus > Single Variable Charts > Chapter 4

Histograms. Select the histogram options. Requires StatPlus.

Histograms, create multiple Click StatPlus > Multi-variable Charts > Multiple Chapter 10

Histograms. Select the variables and enter the histogram

options. Requires StatPlus.

Indicator variables, create Click StatPlus > Manipulate Columns > Create Chapter 10

Indicator Columns. Select the data column. Requires StatPlus.

Individuals control chart, Click StatPlus > QC Charts > Individuals Chart. Chapter 12

create Select the control data and specify the control chart options.

Requires StatPlus.

Mann-Whitney Rank test, Click StatPlus > Two Sample Tests > 2 Sample Chapter 6

perform Mann-Whitney Rank test. Enter the null and alternative

hypotheses. Requires StatPlus.

Means matrix, create Click StatPlus > Multivariate Analysis > Means Matrix. Chapter 10

Select the columns to display in the means matrix. Requires StatPlus.

Moving average, Right-click the chart series and click Add Trendline. Chapter 11

add to scatterplot Select Moving Average from the Trendline Options tab.

Moving Range control Click StatPlus > QC Charts > Moving Range Chart. Chapter 12

chart, create Select the control data and specify the control chart options.

Requires StatPlus.

Multiple regression analysis, Click the Data Analysis group from the Analysis group on the Data Chapter 9

perform tab and click Regression. Requires the Analysis ToolPak.

Normal probability plot, Click StatPlus > Single Variable Charts > Chapter 5

create Normal P-plots. Requires StatPlus.

One-sample Sign test, Click StatPlus > One Sample Tests > 1 Sample

perform Sign test. Enter the null and alternative hypotheses.

Requires StatPlus.

One-sample t test, perform Click StatPlus > One Sample Tests > 1 Sample Chapter 6

t-test. Enter the null and alternative hypotheses.

Requires StatPlus.

One-sample z test, perform Click StatPlus > One Sample Tests > 1 Sample

z-test. Enter the null and alternative hypotheses. Requires StatPlus.

One-parameter exponential Click StatPlus > Time Series > Exponential Chapter 11

smoothing, perform Smoothing. Select the options for the one-parameter model.

Requires StatPlus.

One-way analysis of variance, Click the Data Analysis group from the Analysis group Chapter 10

perform on the Data tab and click ANOVA: Single Factor.

Requires the Analysis ToolPak.

P control chart, create Click StatPlus > QC Charts > P-Chart. Select the control Chapter 12

data and specify the control chart options. Requires StatPlus.

Paired t test, perform Click StatPlus > One Sample Tests > 1 Sample Chapter 6

t-test. Enter the null and alternative hypotheses. Requires StatPlus.

Pareto chart, create Click StatPlus > QC Charts > Pareto Chart. Select the Chapter 12

control data and specify the options for the Pareto chart.

Requires StatPlus.

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