Given the data in the spreadsheet, Reg Data for HW4.xlsx, discuss the relevance (how good is the model) of theregression model overall and for the intercept and the coefficient of the independent variable. R, R^2, adjustedR^2, standard error, F test, significance of F, t Stat, P-value, and confidence interval.

AutoSave O Off) H - C Reg Data for HW4(1) - Search travis defilippo X File Home Insert Page Layout Formulas Data Review View Help Share Comments SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. Reactivate X M22 v fx Education K M N O P Q R S T U V W X Y Z lower bound of Cl upper bound of CI Intercept Education Grade Years1 Gender 0= PC Job 10 19,535.72 33,262.66 Adjusted R Square 0.736844 11 22,377.00 40,576.11 Standard Error 5774.268 12 22,377.00 40,576.11 Observations 208 13 21,745.78 38,138.43 14 22,272.05 38,951.13 ANOVA 15 22,798.33 39,763.83 df SS MS F gnificance F 16 19,745.63 36,512.61 Regression 5 1.95E+10 3.98+09 116.9209 1.17E-57 17 19,219.35 35,699.91 Residual 202 6.74E+09 33342174 18 20,798.18 38,138.01 Total 207 2.62E+10 19 21,745.78 38,138.43 20 20,271.90 37,325.31 Coefficientsandard Err t Stat P-value Lower 95%Upper 95%ower 95.09/pper 95.0% 21 19,640.68 34,887.63 Intercept 28195.9 2101.934 13.41427 9.3E-30 24051.35 32340.44 24051.35 32340.44 22 19,745.63 36,512.61 Education 864.965 385.4455 2.244066 0.025913 104.9523 1624.978 104.9523 1624.978 23 24,731.37 35,902.51 Grade 3507.844 405.0956 8.659301 1.51E-15 2709.086 4306.603 2709.086 4306.603 24 20,062.00 34,075.36 Years1 669.4872 72.63098 9.217654 4.05E-17 526.2751 812.6993 526.2751 812.6993 25 24,731.37 35,902.51 Gender 0=m, 1=f -3722.27 960.9065 -3.87371 0.000145 -5616.97 -1827.58 -5616.97 -1827.58 26 24,836.32 37,527.49 PC Job -5125.19 1438.881 -3.56193 0.000459 -7962.34 -2288.04 -7962.34 -2288.04 27 24,836.32 37,527.49 28 25,955.98 44,640.03 29 24,272.20 40,576.95 30 23,745.92 39,764.25 31 19,640.68 34,887.63 Activate Windows Source Data Sheet2 Sheet1 + go to set tings to activate Windows. Count: 5 + 110% Type here to search w X 9:58 AM 6/19/2020AutoSave O Off) H - C Reg Data for HW4(1) - Search travis defilippo X File Home Insert Page Layout Formulas Data Review View Help Share Comments i ) SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. Reactivate X 034 X V H K M N 0 P Q R S T U V W X Y Z AA AB AC 1 PC Job Salary 2 w 1 $32,000 SUMMARY OUTPUT 1 $39,100 Salary 1 $33,200 Regression Statistics 1 $30,600 Multiple F 0.86248 $120,000 1 $29,000 R Square 0.74388 $100,000 co 1 $30,500 Adjusted F 0.73492 1 $30,000 Standard | 5795.39 $80,000 $27,000 Observati 208 10 $34,000 $60,000 11 $29,500 ANOVA 12 $26,800 df SS MS F ignificance F $40,000 13 $31,300 Regression 2E+10 2.8E+09 82.9832 1.1E-55 14 $31,200 Residual 200 6.7E+09 3.4E+07 $20,000 15 $34,700 Total 207 2.6E+10 16 $30,000 0.2 0.4 0.6 0.8 1 1.2 17 $31,000 Coefficientsandard Em t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.09. 18 1 $27,000 Intercept 27136.9: 2853.76 9.50917 6.3E-18 21509.5 32764.2 21509.54883 32764.2 19 1 $29,600 Education 938.144 400.185 2.34428 0.02004 149.021 1727.27 149.0214874 1727.27 Salary 20 1 $32,600 Grade 3458.76 412.144 8.39213 8.6E-15 2646.06 6 4271.47 2646.057188 4271.47 21 1 $29,600 Years1 658.441 92.8548 7.09109 2.26-11 475.341 841.541 475.3413187 841.541 22 $29,500 Years2 72.79 137.946 0.52767 0.59831 -199.225 344.805 -199.2254017 344.805 23 $31,000 Age 19.9618 57.0976 0.34961 0.727 -92.6286 132.552 92.62864553 132.552 24 $28,500 Gender 0= -3751.63 965.52 -3.8856 0.00014 -5655.54 -1847.72 5655.536664 -1847.72 25 $26,700 PC Job -5003.33 1455.48 -3.43759 0.00071 -7873.38 -2133.28 -7873.382336 -2133.28 26 $30,750 27 $29,500 28 1 $42,200 Activate Windows 70 $27 cool Source Data Sheet2 Sheet1 + go to settings to activate Windows. 90% Type here to search O W X 9:59 AM 6/19/2020