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.

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.

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

*Purchase funnel*- This Powerpoint slide will draw the "Purchase Funnel" using the percentage of customers passing through each stage of the Hierarchy of Effects.*Diffusion of Innovations*- This Powerpoint slide graphically demonstrates how potential customers become adopters, following Bass' Diffusion of Innovation model.*Choice-Based Conjoint Analysis -*a very simple example of choice-based conjoint analysis, to convince students the idea really works.-
*Perceptual Mapping -*a very simple example of perceptual mapping using Multidimensional Scaling. Pick the most similar pairs of magazines, and the Excel add-in will produce a 2-D or a 3-D mapping of your perceptions.

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

***.doc**: a short explanation of the add-in, how to install it, and how it works.*****.**xlam**: the Excel 2007 (or newer) add-in file, which should reside in its own directory***.xla :**the Excel add-in file, if you are using Office 2003 or older.***.dll :**one or more “dynamic link libraries,” which must be placed in the same directory as all your other *.dll files (probably on the Windows/ System directory, depending on the version of Windows you use).***.xls**: one data set you can try as an example

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

- Principal Components Analysis
- K-Means Clustering
- Stepwise Regression
- Partial Least Squares (PLS) Regression
- Logistic Regression
- Multidimensional Scaling (Metric MDS)
- Latent Class Analysis
- Correspondence Analysis
- Multinomial Logit Mixture
- Nearest-Neighbor Regression
- Stochastic Frontier Regression
- Data Envelopment Analysis
- Sliced Average Variance Estimator (SAVE)