Dr. Wayne Taylor - Taylor Enterprises, Inc.
for Engineers and Quality in the FDA Regulated Industries
Subscribe to our Web Site
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:
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:
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