Sunday, July 28, 2013

No Tools Menu with Excel 2007

I was following an Excel exercise in The Complete Idiot's Guide to Statistics* with instructions to use the data analysis option under the tools menu.

I didn't have a tools menu on my version of Excel (2007).

This is the procedure for finding the data analysis option:

Click the home button

Choose Excel options

Under add ins select add analysis tool

Click go

Now you can find data analysis under the data tab.

Of course, if the data analysis option was loaded previously, it would already be under the data tab.

*By Robert A. Donnelly, Jr., Ph.D. (2nd edition)
This is a fabulous statistics book, and it's very funny!