Chapter 6 Excel Regression

Chapter 6 Excel Regression - 4/19/2011 Chapter 6 Excel...

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

View Full Document Right Arrow Icon
Chapter 6 Excel Regression 2007 Regression is a method of estimating the portion of a cost that is variable and the portion that is fixed. The following tutorial will help you use Excel to 'run' a regression. Open the Excel program. To use the linear regression in Excel, the data analysis pak must be installed. Verify the Analysis ToolPak is installed by clicking Data from the Excel 2007 menu. If you see the Data Analysis command in the Analysis group (far right), the data analysis pak is installed. Follow the steps below if it not already installed. 1. Click the Microsoft Office Button , and then click Excel Options. 2. Click Add-Ins, and then in the Manage box, select Excel Add-ins. 3. Click Go. 4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it. How to Run a Basic Excel Regression Step 1: Create a table in Excel and paste the following data into columns A, B, and C beginning in row 1: Data Year # of Units Cost 2006 9 33413 2005 12 36382 2004 13 37200 2003 7 35566 2002 11 36641 2001 6 32936
Background image of page 1

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

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

This note was uploaded on 04/20/2011 for the course ACC 101 taught by Professor Xyz during the Spring '11 term at Ohio State.

Page1 / 4

Chapter 6 Excel Regression - 4/19/2011 Chapter 6 Excel...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online