Question: 3 Home Insert Draw Jet Page Layout Formulas Data Review Paste BIU A1 F 1 2 3 4 5 6 7 8 9 10 11

3 Home Insert Draw Jet Page Layout Formulas Data Review Paste BIU A1 F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Open recovered workbooks? Your recent changes were saved. Do you want to con x vfx Period (t) B D E F G Period (t) Enrollment (1000s) 1 6.5 2 8.1 3 8.4 4 10.2 5 12.5 6 13.3 7 13.7 8 17.2 9 18.1 Data Sheet2 Sheet3 + Ready Scre 2021-10 ar No late assignment will be accepted. No technical di Question 1: Find the "Jefferson" files. Develop a linear regression with a dependent variable 1. What is the value of Rsquare? (Make sure two decimal places.) 2. What is the value of intercept? (Make sure two decimal places.) 3. What is the coefficient value of Period (t)? (Make sure two decimal places.) 4. Is the coefficient of Period (t) significant? (Yes:1, No: 0) 5. What is the forecast for year 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
