Please if posssible also say how you did it thank you 1. Given the data in the e
ID: 3237021 • Letter: P
Question
Please if posssible also say how you did it thank you
1. Given the data in the excel sheet for HW4, create a scatter plot (chart) of the data and discuss what you see, include a linear trend line.
2. Given the data in the excel sheet for HW4, execute a regression. 3. Given the data in the excel sheet for HW4, discuss the relevance (how good is the model) of the regression model overall and for the intercept and the coefficient of the independent variable. R, R^2, adjusted R^2, standard error, F test, significance of F, t Stat, P-value, and confidence interval.
4. Given the data in the excel sheet for HW4, calculate the point estimate and confidence interval prediction for each measure and the associated residual/error.
Employee Education Grade Years1 Years2 Age Gender 0=m, 1=f PC Job Salary 1 3 1 3 1 26 0 1 $32.000 2 1 1 14 1 38 1 1 $39.100 3 1 1 12 0 35 1 1 $33.200 4 2 1 8 7 40 1 1 $30.600 5 3 1 3 0 28 0 1 $29.000 6 3 1 3 0 24 1 1 $30.500 7 3 1 4 0 27 1 1 $30.000 8 3 1 8 2 33 0 1 $27.000 9 1 1 4 0 62 1 1 $34.000 10 3 1 9 0 31 1 1 $29.500 11 3 1 9 2 34 1 1 $26.800 12 2 1 8 8 37 1 1 $31.300 13 2 1 9 0 37 1 1 $31.200 14 2 1 10 6 58 1 1 $34.700 15 3 1 4 0 33 1 1 $30.000 16 3 1 3 0 27 1 1 $31.000 17 3 1 6 0 30 1 1 $27.000 18 2 1 8 9 37 1 1 $29.600 19 3 1 5 6 44 1 1 $32.600 20 2 1 4 3 29 1 1 $29.600 21 3 1 4 2 36 1 1 $29.500 22 2 1 3 3 28 0 1 $31.000 23 1 1 5 0 45 1 1 $28.500 24 2 1 3 4 33 0 1 $26.700 25 3 1 3 1 24 0 1 $30.750 26 3 1 3 1 27 0 1 $29.500 27 2 1 16 6 60 1 1 $42.200 28 1 1 13 0 48 1 1 $37.600 29 1 1 12 6 40 1 1 $34.000 30 2 1 4 7 33 1 1 $33.000 31 1 1 7 4 35 1 1 $28.760 32 1 1 11 0 44 1 1 $35.400 33 3 1 3 8 43 0 1 $31.000 34 2 1 18 2 46 1 1 $38.800 35 2 1 14 0 42 1 1 $34.300 36 1 1 19 0 47 1 1 $35.000 37 3 1 3 2 25 1 0 $34.600 38 2 1 2 4 30 1 1 $28.500 39 1 1 11 0 40 1 1 $29.500 40 3 1 3 2 26 0 1 $30.500 41 3 1 5 1 32 1 1 $34.200 42 1 1 15 0 51 1 1 $43.600 43 5 1 7 0 35 1 0 $33.500 44 3 1 12 1 37 1 1 $33.000 45 1 1 18 0 44 1 1 $45.300 46 1 1 17 3 53 0 1 $38.800 47 1 1 10 0 40 1 1 $29.900 48 3 1 5 10 51 0 1 $31.200 49 1 1 15 0 42 1 1 $34.000 50 2 1 2 0 53 1 1 $30.450 51 1 1 3 3 58 0 1 $35.500 52 1 1 4 10 44 1 0 $34.000 53 2 1 7 0 31 1 1 $29.100 54 1 1 8 0 64 1 1 $29.650 55 3 1 15 1 47 1 1 $29.200 56 3 1 9 0 37 1 0 $29.800 57 2 1 16 0 46 1 1 $33.500 58 1 1 8 0 55 1 1 $34.000 59 1 1 9 0 39 1 1 $29.600 60 3 1 18 0 51 1 1 $34.000 61 2 2 3 8 37 1 1 $37.250 62 2 2 6 3 30 0 1 $33.000 63 3 2 4 0 26 1 1 $28.600 64 5 2 5 1 41 1 0 $36.000 65 3 2 4 4 34 1 0 $37.300 66 2 2 7 4 57 0 1 $29.900 67 1 2 11 8 53 1 1 $31.500 68 3 2 5 4 32 1 0 $41.400 69 1 2 17 5 44 1 1 $32.740 70 3 2 3 1 25 0 1 $33.500 71 1 2 5 9 31 1 1 $32.000 72 1 2 9 0 50 1 1 $30.800 73 5 2 3 3 47 1 0 $42.000 74 3 2 4 0 35 0 1 $34.000 75 2 2 16 0 43 1 1 $32.500 76 2 2 9 10 46 1 1 $31.700 77 5 2 3 0 35 0 1 $36.500 78 3 2 4 0 22 0 1 $33.000 79 2 2 8 0 58 1 1 $31.200 80 5 2 8 0 40 1 1 $34.000 81 3 2 6 0 30 1 1 $33.000 82 5 2 4 4 29 1 1 $33.900 83 1 2 3 9 31 1 0 $39.000 84 2 2 12 18 52 0 1 $34.920 85 5 2 3 5 33 0 1 $39.000 86 1 2 8 0 49 1 1 $34.000 87 2 2 6 7 34 1 1 $31.900 88 5 2 3 1 26 0 1 $37.000 89 5 2 4 0 28 0 1 $34.000 90 5 2 3 2 35 1 1 $36.400 91 1 2 15 1 47 1 0 $38.200 92 1 2 15 0 51 1 1 $35.300 93 3 2 3 2 26 0 1 $34.500 94 3 2 12 0 33 1 1 $30.500 95 4 2 2 2 27 0 1 $30.000 96 5 2 8 0 34 1 0 $37.300 97 4 2 5 0 29 1 1 $40.200 98 3 2 5 0 27 0 1 $35.500 99 1 2 11 0 43 1 1 $35.000 100 3 2 4 3 36 1 1 $38.000 101 1 2 9 0 38 1 1 $35.300 102 2 2 14 0 60 1 1 $34.100 103 3 3 4 5 43 1 0 $43.200 104 2 3 15 5 48 1 1 $36.100 105 5 3 7 3 32 1 1 $34.600 106 3 3 5 0 31 0 1 $36.000 107 5 3 7 2 29 1 1 $36.200 108 3 3 7 0 35 1 1 $37.500 109 3 3 4 12 37 1 1 $41.000 110 2 3 10 0 43 1 1 $35.600 111 3 3 5 5 33 1 1 $39.800 112 4 3 11 4 58 1 0 $41.300 113 3 3 9 7 44 1 1 $42.500 114 3 3 4 8 37 1 0 $45.800 115 5 3 5 6 48 1 1 $34.900 116 5 3 4 0 26 0 1 $41.500 117 3 3 5 0 25 1 1 $38.000 118 4 3 6 0 38 1 1 $35.000 119 3 3 6 0 41 1 1 $40.000 120 3 3 5 0 29 0 1 $36.000 121 2 3 9 0 59 1 1 $33.700 122 2 3 5 4 29 0 1 $36.300 123 3 3 3 2 27 1 0 $38.000 124 5 3 4 0 30 1 1 $39.500 125 2 3 7 5 34 1 1 $36.300 126 3 3 8 2 35 1 1 $32.500 127 2 3 12 6 50 1 1 $37.000 128 5 3 3 1 33 1 1 $32.600 129 3 3 4 0 26 1 1 $36.000 130 5 3 3 0 36 1 1 $35.000 131 5 3 3 5 33 1 0 $43.600 132 3 3 8 0 47 1 1 $33.800 133 1 3 21 0 51 1 1 $35.300 134 1 3 16 6 42 1 1 $42.400 135 5 3 5 0 31 0 1 $39.500 136 2 3 25 10 62 1 1 $43.500 137 5 3 6 1 46 0 1 $42.000 138 3 3 21 9 60 1 1 $40.300 139 4 3 6 5 43 0 1 $44.000 140 1 3 25 2 53 1 1 $40.660 141 3 3 13 1 38 1 1 $39.700 142 5 3 6 5 39 1 1 $45.000 143 5 3 7 0 35 1 1 $43.900 144 4 3 8 3 40 1 1 $38.000 145 5 3 5 3 32 1 1 $39.020 146 5 4 5 3 33 0 1 $44.500 147 5 4 4 1 30 0 1 $41.000 148 5 4 6 3 37 0 1 $44.000 149 5 4 6 0 30 0 1 $44.000 150 5 4 5 4 32 1 1 $42.500 151 5 4 7 3 37 1 1 $40.260 152 5 4 5 1 29 0 1 $44.500 153 1 4 13 9 50 1 1 $35.500 154 5 4 6 0 29 0 1 $42.500 155 5 4 7 0 32 1 1 $44.000 156 5 4 6 2 31 0 1 $45.000 157 2 4 15 4 47 1 1 $44.400 158 3 4 17 0 44 1 1 $38.000 159 5 4 4 0 27 0 1 $41.800 160 1 4 23 0 55 0 1 $45.500 161 3 4 5 4 52 0 1 $42.500 162 5 4 3 12 50 1 1 $44.000 163 3 4 19 8 59 1 0 $54.300 164 3 4 26 0 47 1 1 $44.800 165 3 4 6 4 43 0 1 $47.000 166 5 4 15 0 41 1 1 $43.800 167 1 4 12 4 39 1 0 $48.000 168 5 4 9 0 39 1 1 $42.700 169 3 4 14 1 40 1 0 $48.500 170 3 4 16 0 49 1 1 $42.000 171 2 4 16 1 53 1 1 $45.500 172 3 4 11 0 37 1 1 $44.500 173 2 4 13 2 40 1 1 $51.200 174 5 5 7 0 34 0 1 $47.500 175 5 5 8 0 37 1 1 $44.500 176 5 5 8 0 31 0 1 $47.000 177 5 5 6 10 41 0 1 $47.000 178 3 5 17 4 46 1 1 $43.100 179 5 5 8 2 37 0 1 $49.000 180 5 5 8 0 33 0 1 $48.500 181 3 5 8 5 35 1 1 $45.000 182 5 5 16 5 49 1 1 $52.500 183 5 5 6 2 33 0 1 $47.500 184 5 5 7 0 31 0 1 $48.000 185 5 5 8 4 49 0 1 $46.500 186 5 5 12 2 40 1 1 $61.500 187 5 5 9 2 37 1 1 $50.000 188 5 5 12 2 46 1 1 $61.800 189 4 5 16 0 43 1 1 $43.000 190 5 5 11 1 36 0 1 $47.000 191 5 5 9 6 37 1 1 $58.500 192 5 5 16 7 40 0 1 $55.000 193 3 5 24 3 54 0 1 $57.000 194 5 5 17 1 57 0 1 $57.000 195 5 6 14 0 49 0 1 $60.000 196 3 6 13 0 41 0 1 $60.000 197 5 6 19 4 59 0 1 $59.000 198 5 6 12 0 51 0 1 $60.000 199 5 6 20 0 45 0 1 $65.000 200 5 6 20 1 56 0 1 $52.000 201 5 6 22 0 57 0 1 $58.000 202 4 6 21 0 53 0 1 $60.000 203 5 6 39 0 65 0 1 $74.000 204 3 6 34 0 60 0 1 $95.000 205 5 6 36 0 61 0 1 $97.000 206 5 6 32 0 62 0 1 $88.000 207 5 6 35 0 59 0 1 $94.000 208 5 6 33 0 62 1 1 $30.000Explanation / Answer
d)
SUMMARY OUTPUT Regression Statistics Multiple R 0.862485 R Square 0.74388 Adjusted R Square 0.734915 Standard Error 5.795385 Observations 208 ANOVA df SS MS F Significance F Regression 7 19509.81 2787.116 82.98323 1.06E-55 Residual 200 6717.298 33.58649 Total 207 26227.11 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 27.13686 2.853755 9.509174 6.3E-18 21.50955 32.76417 21.50955 32.76417 Education 0.938144 0.400185 2.344278 0.020045 0.149021 1.727266 0.149021 1.727266 Grade 3.458762 0.412144 8.392126 8.61E-15 2.646057 4.271466 2.646057 4.271466 Years1 0.658441 0.092855 7.091088 2.24E-11 0.475341 0.841541 0.475341 0.841541 Years2 0.07279 0.137946 0.52767 0.598313 -0.19923 0.344805 -0.19923 0.344805 Age 0.019962 0.057098 0.349609 0.727 -0.09263 0.132552 -0.09263 0.132552 Gender 0=m, 1=f -3.75163 0.96552 -3.8856 0.000139 -5.65554 -1.84772 -5.65554 -1.84772 PC Job -5.00333 1.455478 -3.43759 0.000714 -7.87338 -2.13328 -7.87338 -2.13328