Excel Add-In - Installing and Using

Contents - Index

Excel Add-In - Installing and Using

The program comes with an Excel Add-In that allows one to perform a change-point analysis from within Excel. To install the add-in:

INSTALLATION PROCEDURE

1. Select the Add-In menu item from the Tool menu.

2. Click the Browse button.

3. Locate the file Change-Point Analyzer.xla in the directory which Change-Point Analyzer was installed and click on the OK button. The default directory is C:\Program Files\Taylor Enterprises\Change-Point Analyzer. However, a different directory could have been selected when the program was installed.

4. 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, a new menu item will have been added to the Tools menu for performing a change-point analysis. To perform a change-point analysis:

PROCEDURE FOR PERFORMING CHANGE-POINT ANALYSIS

1. 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.

2. Select the Change-Point Analysis menu item from the Tools menu. Alternatively, you can press the Ctrl+Shift+C key combination.

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

You can select a column or row to use as labels by first selecting that column or row and then selecting the CPA - Select Column or Row for Labels menu item from the Tools menu. To clear this selection, select a single cell and then select the same menu item.