KAMAKURA'S FREE SOFTWARE DOWNLOADS

Kamakura Analytic Logo

<=  Click here to download all my analytical tools
      in a single add-in for Excel 2010 or newer, instead of 
      downloading and installing them one at a time

Scatterplot with Labels

 
Have you ever tried to produce a scatter plot using Excel with labels on the side of each data point? Try it, and you will find it either impossible or tedious. This spreadsheet or the equivalent Add-in will make this task much easier. Simply highlight the range containing the labels, X-coordinates and Y-coordinates, click the menu option, and presto!

 

If you are using an older versions of Excel (2003 or older), use this spreadhsheet or equivalent Add-in.

 

3D Scatterplot with Labels and Rotation

 
Have you ever tried to produce a xyz scatter plot using Excel? Try it, and you will find it impossible. This spreadsheet or the equivalent Add-in will draw the 3D scatterplot for you. Even more, it will allow you to rotate the scatterplot (around the centroid, not the origin!) so you can view it from the perspective you like. Simply highlight the range of four columns containing labels for the items to be plot, and their X, Y and Z coordinates and Y-coordinates, click the menu option, and voila'!

 

If you are using an older versions of Excel (2003 or older), use this spreadhsheet or equivalent Add-in.

 

Teaching materials

 
Here are a few examples I use in class, using Flash animation or Excel-based analytics:

 

Excel Addins (older Analytical Tools) 

The following free Excel Add-ins are for knowledgeable Excel (32-bit only!) users.  You are free to use them as you wish, but at your own risk. These Add-Ins were not thoroughly tested for accuracy. 
Please send any comments/suggestions to kamakura@rice.edu.

 

Before you install any of the add-ins below, make sure that you already have installed Excel’s “Analysis Toolpak” and “Analysis Toolpak VBA” Add-ins, which are included in your Office installation disk.

 

Each zip archive contains the following files:

 

To install the add-in:
  1.  Make sure that you already installed the “Analysis Toolpak” and “Analysis Toolpak VBA” Add-ins (see warning above)
  2. Extract the *.xla file into its own directory
  3.  Move the *.dll files to the appropriate Windows directory (probably the Windows/System directory)
  4.  If you are using 
    1. Excel 2007 or newer, open it, and use Excel Options/ Addins to install the add-in.
    2. Excel 2003 or older, open Excel, go to the Tools/Add-Ins menu, and click on “Browse”
  5.  Find the directory containing the *.xla file and click on it.
  6. Close Excel.  When you open Excel again, you should see the add-in listed under the Tools menu

 

Here are the add-ins: