Use Excel 2007 Regression-1 (1)

# Use Excel 2007 Regression-1 (1) - A Quick Guide to Using...

This preview shows pages 1–4. Sign up to view the full content.

A Quick Guide to Using Excel 2007’s Regression Analysis Tool

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Table of Contents Page The Analysis Toolpak . ............................................................................................................. 1 If the Add-In is ALREADY Installed. .................................................................................... 1 If the Add-In is NOT ALREADY Installed . .......................................................................... 1 Run a Multiple Regression: An Example Introduction. ................................................................................................................. 2 Steps to Follow. ............................................................................................................ 2 1. Rearrange the Data as Necessary . ............................................................... 2 2. Open the Regression Analysis Tool . ........................................................... 3 3. Complete the “Regression” Dialog Box. ..................................................... 4 4. Run the Regression Analysis and View the Results . ................................ 5 The Regression Results Areas. ................................................................................... 6 Run Another Regression Analysis . ........................................................................... 6 9-11-2009
1 Using Excel 2007’s Regression Analysis Tool The Analysis Tookpak Excel 2007 has a built-in regression analysis tool that’s packaged as part of its “Analysis Toolpak”. The Analysis Toolpak is a standard component of Excel. Microsoft makes it available as an Excel add-in. If you loaded your copy of Excel on your computer, you may recall that you had a choice during the installation process whether or not to include add-ins such as the Analysis Toolpak. If the Add-In is ALREADY Installed

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/11/2011 for the course FIN 322 taught by Professor Gillette during the Winter '07 term at Grand Valley State.

### Page1 / 8

Use Excel 2007 Regression-1 (1) - A Quick Guide to Using...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online