Use Excel 2007 Regression-1 (1)

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

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

View Full Document Right Arrow Icon
A Quick Guide to Using Excel 2007’s Regression Analysis Tool
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online