regression-excel

regression-excel - 1 Tutorial on Using Excel to Run OLS The...

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

View Full Document Right Arrow Icon
1 Tutorial on Using Excel to Run OLS The objective of this reading assignment is to guide you through the mechanics necessary to perform an OLS regression in Excel. Obviously, the first step is to open Excel. Assuming Excel is open, an OLS regression is performed as follows. Step One - Entering Data Your data must be in columns. The columns do not have to have a label, but labeling your data will make reading the results easier. Data for the independent variables must be in adjacent columns. It is ok to manipulate your data (such as squaring a variable), but before running the regression, make sure all the independent variables are in adjacent columns. The dependent variable and independent variables do not have to be in adjacent columns. The data set-up for this example is shown in the following figure. The dependent variable is labeled “output” and the independent variables are labeled “land, labor, capital.” Create a worksheet that has the following data as shown in the worksheet below. The tutorial works best if data is entered in the cells shown. As will be shown later, you do not have to enter the column of ones associated with the intercept.
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Step Two - Obtaining the Main Regression Menu Pop up Box Substep one: Click on “Tools” - a pop up box will appear as shown in the following figure. Then click on “Data Analysis”
Background image of page 2
3 Substep Two: After Clicking on “Data Analysis,” the following pop up box appears. Scroll down in this box until you see “Regression.” Highlight “Regression” and then click “OK,” as shown in the following figure.
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.

This note was uploaded on 05/04/2008 for the course ECON 300 taught by Professor Gang during the Spring '06 term at Rutgers.

Page1 / 9

regression-excel - 1 Tutorial on Using Excel to Run OLS The...

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