2. This assignment is designed to familiarize you with using Excel to graph and estimate the relationship between two variables. You will use a scatter plot to visualize data, present and interpret a correlation coefficient, and present and interpret regression estimates. Use the data provided below on the real consumption expenditure and the real disposable income for a country for the years 2012 to 2016. f. From the last table in the summary output, - Report your estimate of the slope (b1).b1= - Interpret your estimate of the slope (b1). g. From the last table in the summary output, - Report your estimate of the intercept (b0).b0= - Interpret your estimate of the intercept (b0). h. Identify and report the R-square (the coefficient of determination). Interpret the R-square statistic. What does it tell you? i. Do the results you obtained in parts a and c make economic sense to you? Explain based on the knowledge you learned in Macroeconomics. 2. This assignment is designed to familiarize you with using Excel to graph and estimate the relationship between two variables. You will use a scatter plot to visualize data, present and interpret a correlation coefficient, and present and interpret regression estimates. Use the data provided below on the real consumption expenditure and the real disposable income for a country for the years 2012 to 2016. f. From the last table in the summary output, - Report your estimate of the slope (b1).b1= - Interpret your estimate of the slope (b1). g. From the last table in the summary output, - Report your estimate of the intercept (b0).b0= - Interpret your estimate of the intercept (b0). h. Identify and report the R-square (the coefficient of determination). Interpret the R-square statistic. What does it tell you? i. Do the results you obtained in parts a and c make economic sense to you? Explain based on the knowledge you learned in Macroeconomics