TE Variation.com

Dr. Wayne Taylor - Taylor Enterprises, Inc.
Applied Statistics
for Engineers and Quality in the FDA Regulated Industries

Search variation.com

Enter keywords: 

Exact Match Search


Site Map

Products (HOME)






Acceptance Sampling

Process Validation

CAPAs and Trending of Quality Data


Measurement Systems Analysis

Spec Setting, Tolerance Analysis and Robust Design

General Statistics

Statistical Process Control

Design of Experiments

Six Sigma


What's New

Technical Library


  Contact Info

Dr. Wayne A. Taylor   linkedin
Ann Taylor
1 (847) 367-1032
1 (847) 367-1037
Postal address
5510 Fairmont Rd.
Libertyville, IL 60048
Electronic mail


Subscribe to our Web Site

By entering your e-mail address and clicking the Subscribe button, you will automatically be added to our mailing list.  You will receive an e-mail when new versions of our software or books are available as well as other significant announcements.  (privacy policy).

E-mail address to send notifications to:



Change-Point Analyzer - Excel Add-In

The Excel Add-In allows you to perform a change-point analysis directly from Excel.  However, the Excel Add-In must be installed first.  Below are instructions for both installing and using the Excel Add-In.  More detailed instructions can be found in Tutorial 3.  The Add-In works with versions 95/97/2000/XP/2007/2010 of Excel.

Instructions for Installing Add-In:

  1. Install the most recent version of Change-Point Analyzer.  The Add-In is copied to your hard drive during the installation process.

  2. Start Excel. 

  3. Display Add-In dialog box.  For version 2000 select the Add-In menu item from the Tool menu.  For version 2007, select the EXCEL Options menu item from the start menu and then click the Go button on the Add-Ins tab.  This will display the Add-In dialog box.

  4. Locating the Add-In.  Click the browse button and locate the file Change-Point Analyzer.xla in the directory which Change-Point Analyzer was installed. The default directory is C:\Program Files (x86)\Taylor Enterprises\Change-Point Analyzer. However, a different directory could have been selected when the program was installed.  Once the file has been located, click the OK button.

  5. Make sure Change-Point Analyzer Add-In is checked.  Change-Point Analyzer will now appear in the list of Add-Ins. Make sure it is checked. Then click the OK button to close the Add-In dialog box.

Once the Add-In is installed, two new menu items are added.  In EXCEL 2000 they are added to the Tools menu.  In EXCEL 2007, a new Add-Ins menu is added.  The Change-Point Analysis menu item performs a change-point analysis on the selected data.    The CPA - Select Column or Row for Labels menu item can be used to select a row or column to be used as labels for the data points.  Labels, if desired, must be selected before performing the change-point analysis.  These two menu items will appear every time you run Excel.  To perform a change-point analysis:

Instructions for Using Add-In:

  1. Optionally select labels for data points.  If you want to use a row or column as labels, select the row or column to be used and select the CPA - Select Column or Row for Labels menu item.  If you don't specify labels, the row or column headers are used as labels.

  2. Select the data to be analyzed.  You can select an entire row or column or just a part of a row or column. If you have multiple observations per time period, select all the rows or columns containing values.

  3. Select the Change-Point Analysis menu item.

The above procedure will start Change-Point Analyzer, copy the data into it and perform an analysis on the selected data.  When you are done viewing the results, close Change-Point Analyzer and you will return to Excel.


Copyright 1997-2017 Taylor Enterprises, Inc.
Last modified: September 08, 2017