Preliminary:

Look under “Tools” in Excel, if you don’t have “Data Analysis” in your pull down menu, you’ll need to add it in. You may need your original program CD-ROM for Microsoft Office. If you work in a business with a network, that data is probably on your network, and you won’t need the CD-ROM

[CLICK ON] TOOLS

                  ADD INS

                  Analysis ToolPak (Check off box)

OK

To start do an analysis

Open a new spreadsheet

Enter the name of the disease or condition

Enter the years in one column, and the disease rates in the column next to them

Now you’re ready to do analysis

To do regression analysis

TOOLS

           DATA ANALYSIS

REGRESSION

OK

You’ll get a box here

Input Y range - click little symbol at the end of the box, then highlight the disease or condition rates

Input X range - click little symbol at the end of the box, then highlight the years.

OK