All questions should be answered on word document. 1 . Using Excel, generate and explain the correlation between the dependent variable and the independent variable (copy paste the table to a word document, excel tables are not accepted). 30 points 2. Using Excel, generate the Regression output table (copy paste the table into word document, excel tables are not accepted) and explain the following: 40 points o Adj. R-Square O The Intercept o The Coefficient for the independent variable 3. Write down the following: 30 points o General functional form Specific Functional form Instructions (failing to follow the instructions will cost you points): 1. Be concise, factual, and deliberate with your answers. 2. 1 question per page and number the pages. 3. Write your name on all pages provided, only legible exams will be marked. 4. One Submission per group (make sure to state both group members)