Need help understanding

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. (20 points)

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

SUMMARY OUTPUT SUMMARY OUTPUT