TITLE: Data Exercise 1 (Page 1 of 2) Course: ECN 5050 LEARNING OUTCOME/S: CC#5, CC#6, CC#7 Date: PURPOSES: Locate, analyze, and interpret macroeconomic data; Utilize Microsoft Excel to analyze data, and graph macroeconomic data effectively. Student Name: VALIDITY: Okun’s Law Evaluator Name: Takashi Yamashita COMPANION DOCUMENTS: Downloaded data from the Economic Report of the President Section 1: Okun’s Law In this section, a student has to (i) download two series from the Economic Report of the President web site, (ii) calculate percentage point changes in the unemployment rate, (iii) calculate the growth rate of GDP, (iv) graph them following the sample, (v) insert a linear trend line and a regression equation, (vi) find the most recent unemployment rate from the BLS web site, and (vii) calculate the required GDP growth rate to reduce the unemployment rate as specified by the instruction. Graphs must be clean and readable, with an appropriate tile and axis titles. Earning maximum points in each box in ‘PROFICIENT’ column and/or points in columns to the right of ‘PROFICIENT’ meets standard. >>>>>>>>> Performance Criteria Basic Developing Proficient Accomplished Exemplary Score Download correct data series (CC #5) Does not download any of the appropriate series. (0 point) Identifies and downloads one of the two series correctly. (2 points) Identifies and downloads both series correctly. (4 points) Calculate percentage-point changes in the unemployment rate. (CC #6) Does not calculate the percentage-point changes. (0 point) Does not calculate the percentage point changes (but calculates year-to-year percentage changes in the unemployment rate and it’s done incorrectly) (1 points) Does not calculate the percentage point changes (but calculates year-to-year percentage changes in the unemployment rate and it’s done correctly) (3 points) Calculates the percentage-point…