{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

areviewsheet

# areviewsheet - A Review Sheet World Poverty and Economic...

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

A Review Sheet World Poverty and Economic Development ! = ! + ! ! + ! x : independent variable, explanatory variable, control variable, hypothesis variable y : dependent variable ! : intercept of the equation and the baseline average value of the y when x is 0. ! : estimate of the effect of x on y ! : error term, noise How to run a regression using Excel 1. Highlight a 2 x (# of independent variables + 1) box on the spread sheet a. ie. x variables are abs latitude and exports slaves then you should have a 2x3 box 2. type in =linest(yrange, xrange, true, true) a. When using more than 1 x variable, you indicate them by using “:” =linest(yrange, b2:b:48 : c2:c48 : d2:d48, true, true) 3. MAC: use the buttons COMMAND+RETURN PC: use the buttons COMMAND+SHIFT+ENTER 4. The data would be presented in this order: ! ! ! ! Intercept ! SE( ! ! ) SE( ! ! ) SE( ! ) The standard error of ^b is a measure of the relative importance of noise and variation in the independent variable in explaining the observed variation in the dependent variable

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.

{[ snackBarMessage ]}

### Page1 / 2

areviewsheet - A Review Sheet World Poverty and Economic...

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

View Full Document
Ask a homework question - tutors are online