areviewsheet

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

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

View Full Document Right Arrow Icon
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
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 11/24/2011 for the course ECON 345 taught by Professor Jakiela during the Fall '11 term at Maryland.

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