W AutoSave @ Off Assignment Two . Saved to this PC v Search (Alt+Q) jockey watkins JW X File Home Insert Draw Design Layout References Mailings Review View Help Comments Share Times New Roman ( * 12 ~ A" A Aa~ A Find Normal No Spacing Heading 1 c Replace Paste BIU~ X x A LA. Dictate Editor Select Undo Clipboard Font Paragraph Styles Editing Voice Editor 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 Source: World Bank Development Indicators Instructions (failing to follow the instructions will cost you points): 1. Be concise, factual, and deliberate with your answers. 2. Just need the output table in word (no data) 3. 1 question per page and number the pages. 4. Write your name on all pages provided. O Page 1 of 1 202 words X Text Predictions: On Accessibility: Good to go [ Focus + 100% w X 10:13 AM 10/1/2022