Using Assignment II data set, answer the following using excel: 1. Generate the output for the whole sample, (20 points) 2. List the independent variables that are insignificant? (10 points) 3. Plot and briefly discuss the residual. (20 points) 4. Does the data set represent a homogenous sample? If not, explain. (10 points) 5. What are the implication of a non-homogenous sample? (10 points) 6. How would you fix the issue of sample non-homogeneity? (10 points)

7. Show your work for number 6.

Variables in the file are: GDP per capita growth (annual %) =gdpg Gross fixed capital formation (% of GDP)= inv Population growth (annual %)=pop Government expenditure on education, total (% of GDP)=gov Trade (% of GDP)=tr Source: World Bank Development Indicators