Question: Exercise 4 The FOREST. XLS data set contains data on deforestation (Y) , population density (X), change in cropland (W) change in pasture land (Z).


Exercise 4 The FOREST. XLS data set contains data on deforestation (Y) , population density (X), change in cropland (W) change in pasture land (Z). Use Excel for this exercise. You are going to need the Excel Analysis ToolPak for this. Information for installing this on your particular version of Excel is available on the Internet. Here is an example: https:/ /support. office. com/en-us/article/Load-the-Analysis- ToolPak-6a63e598-cd6d-42e3-9317-6b40bala66b4 You are going to have to run regressions for this exercise. We covered this during the last half of the last class. There is information on regressions in the class notes and on the Internet. a. Run a regression of Y on X and interpret (i.e. , what do they mean) the results. Focus on the following results that are generated in the Excel output of the regression: R', the adjusted R , t-statistic, the coefficients, and the standard error
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
