Undo Clipboard Font IN Alignment D11 X v fx A B C D E F blood pressure Age 2 132 52 143 59 153 67 162 73 NOU 154 64 168 74 CO 137 54 149 61 10 159 65 11 128 46 12 166 72 13 14 15 Simple linear regression 16 Y=atb*X genereal function regression + Ready Accessibility Good to go 71F Mostly cloudy 10 A-Q (1) Using Excel, generate and ex, X + edu/d21/le/content/9170965/viewContent/85561818/View Automatic Zoom View as Te Using Assignment 1 data answer the following: 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 Adj. R-Square The Intercept The Coefficient for the independent variable 3. Write down the following: 30 points General functional form Specific Functional form Instructions (failing to follow the instructions will cost you points): Be concise, factual, and deliberate with your answers 2. 1 question per page and number the pages. Write your name on all pages provided, only legible exams will be marked. UJ 4 . One Submission per group (make sure to state both group members). 3 U X Port so 19 144 10