(9) Following questions must be answered using R. Turn in your code along with the output. Use SENNICDATACSV.csv to answer the following questions. (a) What proportion of data has y 10.24. (b) Make a histogram for Xs and com- ment on it. (c) Regress y on 2 14 and 11. Record the estimates for coefficients and R2 Use biases.csv to answer the following questions. (a) Make an identical plot as the one shown below but switch the red dots with blue squares. Plot should be exactly identical except the red dots. Bias of fitted values for OLS v WLS for single variable case 2.00-17 Bias for OLS estimator 1.0e-17 0.0e+00 -0.004 -0.002 0.000 0.002 0.004 0.006 0.008 Blas for WLS estimator (b) Answer (a) with your name as the heading of the plot. AutoSave R SennicdataCSV - Saved File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri 23 Wrap Tort General xan in Copy - Paste Format Painter Clipboard 0.A.EE Normal Conditional Formats Check Cell Formatting Table $ -% 923 Merge Center - Font Alignment Number A1 si.no B C. D F - K M N o A sl.no M 13 1 2 3 241 52 4 7.13 8.82 8.34 8.95 112 9.76 39.6 51.7 74 122.8 3 E x4 9 3.8 8.1 18.9 34.5 21.9 16.7 60.5 24.4 X3 4.1 1.6 2.7 5.6 5.7 5.1 4.6 5.4 4.3 4 60 40 20 40 40 40 $ 5 6 7 8 9 10 11 12 13 97 79 85.8 90.8 60 143 151 106 129 360 113 66 656 $ 122 H X7 207 51 82 53 134 147 151 399 130 59 591 105 252 59 61 325 84 113 103 547 55.7 58.2 56.9 53.7 56.5 50.9 57.8 45.7 48.2 56.3 53.2 57.2 56.8 56.7 56.3 50.2 48.1 53.9 52.8 53.8 42 43 52.3 62.2 52.2 349 7.7 3.7 20.5 6.8 46 20.8 14.6 18.6 26 40 30 40 57.1 37.1 17.1 57.1 5 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37.1 25.5 5.5 4.5 6.4 4.2 4.1 4.2 11.18 8.67 8.84 11.07 8.3 12.78 7.58 9 11.08 8.28 11.62 9.06 9.35 7.53 10.24 9.78 9.84 9.2 8.28 9.31 8.19 11.65 9.89 11.03 9.84 11.77 13.59 9.74 10.33 9.97 7.84 10.47 G x6 279 80 107 147 180 150 186 540 182 85 758 167 322 97 72 337 108 133 134 833 95 195 270 600 298 546 170 176 248 167 318 210 196 312 221 256 so 60 196 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 38 405 73 101 125 519 49 170 198 497 236 163 240 468 5 4.8 4 3.9 4.5 3.2 116.9 88 76.4 63.6 101.8 99.2 75.9 30.9 98.9 112.6 95.9 82.3 71.1 113.1 101.3 59.2 96.1 103.6 102.1 72.6 55 111.7 76.1 104.3 76.5 87.9 69.1 37.1 37.1 77.1 17.1 37.1 57.1 57.1 57.1 57.1 37.1 37.1 173 6.9 15.9 23.1 35.3 17.6 12 17.5 12 30.2 10.8 18.6 17.7 19.7 17.7 17.3 24.2 114 21.2 16.5 7.1 5.7 105 47.2 52.1 54.5 50.5 49.9 53 541 54 54.4 55.8 58.2 49.1 53.2 4.9 5 5.2 5.3 6.1 6.3 37.1 57.1 543 124 156 217 113 270 200 164 258 170 181 69 50 168 503 165 169 172 149 543 18 39 10 5 2.8 4.6 4.1 343 543 153 AutoSave QOR R SennicdataCSV - Saved File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri - 11 xou la Copy Format Painter General Paste BIV- AA == 2 Wrap Text A.A. E. Merge & Center Alignment $ - % 4848 Normal Conditional Format as Check Cell Formatting Table Clipboard Font Number A1 sl.no A w D H 40 M N o 39 40 41 5.7 1.9 41 42 43 4.1 1.3 3.7 4.7 42 43 12.1 23.2 44 7 14.9 15.1 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 F 69.1 58 92.8 94.1 78.9 79.1 84.8 51.5 113.7 71.9 40.4 86.9 82 42.6 97.9 105.3 G 196 73 166 113 130 362 115 831 306 593 106 305 252 620 535 157 76 5.6 5.5 4.6 6.5 5.5 1.8 4.2 5.6 4.3 7.6 7.8 3.1 3.9 3.7 4.3 3.9 4.5 3.4 5.7 5.4 4.4 5 56.2 8 10.47 8.16 8.48 10.72 11.2. 10.12 8.37 10.16 19.56 10.9 7.67 8.88 11.48 9.23 11.41 12.07 8.63 11.15 7.14 7.65 10.73 11.46 10.42 11.16 7.93 9.66 7.78 9.42 10.02 8.58 9.61 8.03 7.39 7.08 9.53 10.03 8.45 6.7 8.9 10.23 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 281 53.2 60.9 51.1 53.8 45 51.7 50.7 54.2 59.9 57.2 51.7 51.5 57.6 51.6 61.1 43.7 54 56.5 59 47.1 50.6 56.9 58 51 64.1 52.1 45.5 50.6 49.5 55 52.4 54.2 51 52 51.5 52 38.8 48.6 49.7 53.2 153 21 118 107 56 264 88 629 172 211 35 197 251 420 273 76 44 199 35 314 345 17.2 10.6 2.5 10.1 20.3 11.6 16.6 52.4 8.4 7.7 2.6 16.4 19.3 15.6 8 18.8 7.5 9.9 20.9 24.8 8.3 7.4 6.9 24.3 14.6 12.3 15 36.7 12.9 13 12.7 9.9 168 49 145 90 95 313 96 581 273 446 93 238 207 413 330 115 39 217 37 265 374 153 67 546 42 66 391 421 191 248 404 65 38 52 241 144 143 51 37 595 73.81 75.81 65.7 101 97.7 59 55.9 98.1 98.3 71.6 62.8 93 95.9 87.2 87.3 88.4 56.4 65.7 87.5 85 80.8 36.9 77.9 J 54.3 14.3 34.3 34.3 34.3 54.3 343 74.3 51.4 51.4 11.4 51.4 51.4 71.4 51.4 31.4 31.4 51.4 31.4 51.4 51.4 31.4 31.4 68.6 28.6 28.6 48.6 48.6 48.6 48.6 48.6 28.6 28.6 28.6 48.6 68.6 48.6 28.6 28.6 70 318 445 191 119 595 68 83 489 SOB 265 304 487 97 72 87 298 184 235 76 52 752 44 3.7 132 64 392 49 95 329 528 202 65 66 67 68 69 70 71 72 72 74 75 76 218 220 3.5 4.2 2. 5.2 45 3.4 4.5 2.9 55 67 57 193 151 124 79 35 446 78 79 AutoSave OP SennicdataCSV - 5a File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri -11 General Paste Xcut Copy Format Painter Clipboard AA EE 25 Wrap Text A.A. EI Merge & Center BIU.2- $ . % 13:43 Normal Conditional Format as Check Cell Formatting Table Font Alignment Number A1 sl.no D G - J K M N B 10.23 8.88 10.3 10.79 7.94 7.63 8.77 8.09 9.05 7.91 H 595 165 113 320 139 109 85 61 127 349 223 127 10.39 79 78 80 79 81 80 81 83 82 84 83 85 84 86 85 87 86 88 87 89 88 90 89 91 90 92 91 93 92 94 93 95 94 96 95 97 96 98 97 99 98 100 99 101 100 102 101 103 102 104 103 105 104 106 105 107 106 108 107 109 108 110 109 110 112 111 113 112 114 113 115 116 656 53.2 55.8 59.6 44.2 49.5 52.1 54.5 56.9 51.2 52.8 54.6 54.1 50.4 51.3 56 53.9 54.9 50.2 56.1 52.8 52.8 51.8 51.9 53.2 45.2 57.6 65.9 52.5 63.9 51.7 55 53.8 49.3 56.9 56,2 59.5 E 9.9 14.1 27.8 2.6 6.2 11.6 5.2 7.6 205 11.9 14 18.3 23.8 9.5 6.2 2.2 12.3 15.7 27 6.8 10.8 4.6 16.4 6.9 11.8 9.36 11.41 8.86 8.93 8.92 8.15 9.77 8.54 8.66 12.01 7.95 10.15 9.76 9.89 7.14 13.95 5.1 2.9 3.5 5.5 4.7 1.7 4.1 2.9 4.3 4.8 5.8 2.9 2 1.3 5.3 5.3 2.5 3.8 4.8 2.3 6.2 2.6 4.3 2.7 6.6 F 77.9 76.8 88.9 56.6 92.3 61.1 47 56.9 79.8 79.5 88.3 90.6 73 87.5 72.5 79.5 79.8 89.7 82.5 09.5 96.9 54.9 59.2 80.1 100,7 92.6 133.5 58.5 57.4 45.7 46,5 116.9 70.9 446 182 73 196 116 110 87 61 112 188 200 158 335 53 56 14 71 148 75 177 752 237 175 461 195 197 143 92 195 477 353 165 424 100 95 56 99 154 98 246 298 163 568 64 190 92 356 297 130 115 91 571 98 129 835 29 68.6 48.6 45.7 65.7 45.7 45.7 25.7 45.7 45.7 65.7 65.7 45.7 45.7 25.7 25.7 5.7 25.7 25.7 45.7 45.7 45.7 42.9 62.9 22.9 42.9 22.9 62.9 42.9 22.9 22.9 22.9 62.9 22.9 62.9 62.9 22.9 59 40 55 123 57 178 237 128 452 47 141 40 308 230 69 90 44 441 68 85 791 20 115 13.1 10.8 7.14 8.02 11.8 9.5 7.7 17.94 9.41 2.9 1.4 2.1 5.7 5.8 4.4 5.9 3.1 15.6 10.9 1.6 4.1 3.8 9.1 42 12.2 26.4 20.6 93 371 55 112 50 182 263 62 19 32 469 46 136 407 22 91.7 AutoSave R Biasas - Saved File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri - 11 General Paste X Cut Copy - Format Painter Clipboard - AAEE a. A E BIU. 2 Wrap Text Merge & Center - $ . % ) Condition Formattin Font Alignment Number A1 fr Bias for yhatWLS D E F G H L M B C 1 Bias for yBias for yhat OLS 2 -6.20E-06 3.61E-20 3 -3.99E-05 -2.31E-19 4 -2.79E-03 -1.85E-18 5 -2.69E-03 2.78E-18 6 7.79E-05 5.55E-18 J-3.36E-05 5.78E-20 8 -5.44E-04 -3.70E-18 19 1.19E-04 -9.25E-19 10 -1.98E-03 -3.24E-18 11 -5.38E-03 1.30E-17 12 3.31E-04 -9.26E-19 13 4.16E-OS -4.63E-19 14 -6.55E-05 4.34E-19 15 -1.26E-04 0.00E 400 16 -1.99E-04 -1.85E-18 17 3.54E-05 2.31E-19 18 -3.10E-04 -1.16E-18 19 1.59E-03 2.04E-17 20 7.60E-03 5.56E-18 21 22 23 (9) Following questions must be answered using R. Turn in your code along with the output. Use SENNICDATACSV.csv to answer the following questions. (a) What proportion of data has y 10.24. (b) Make a histogram for Xs and com- ment on it. (c) Regress y on 2 14 and 11. Record the estimates for coefficients and R2 Use biases.csv to answer the following questions. (a) Make an identical plot as the one shown below but switch the red dots with blue squares. Plot should be exactly identical except the red dots. Bias of fitted values for OLS v WLS for single variable case 2.00-17 Bias for OLS estimator 1.0e-17 0.0e+00 -0.004 -0.002 0.000 0.002 0.004 0.006 0.008 Blas for WLS estimator (b) Answer (a) with your name as the heading of the plot. AutoSave R SennicdataCSV - Saved File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri 23 Wrap Tort General xan in Copy - Paste Format Painter Clipboard 0.A.EE Normal Conditional Formats Check Cell Formatting Table $ -% 923 Merge Center - Font Alignment Number A1 si.no B C. D F - K M N o A sl.no M 13 1 2 3 241 52 4 7.13 8.82 8.34 8.95 112 9.76 39.6 51.7 74 122.8 3 E x4 9 3.8 8.1 18.9 34.5 21.9 16.7 60.5 24.4 X3 4.1 1.6 2.7 5.6 5.7 5.1 4.6 5.4 4.3 4 60 40 20 40 40 40 $ 5 6 7 8 9 10 11 12 13 97 79 85.8 90.8 60 143 151 106 129 360 113 66 656 $ 122 H X7 207 51 82 53 134 147 151 399 130 59 591 105 252 59 61 325 84 113 103 547 55.7 58.2 56.9 53.7 56.5 50.9 57.8 45.7 48.2 56.3 53.2 57.2 56.8 56.7 56.3 50.2 48.1 53.9 52.8 53.8 42 43 52.3 62.2 52.2 349 7.7 3.7 20.5 6.8 46 20.8 14.6 18.6 26 40 30 40 57.1 37.1 17.1 57.1 5 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37.1 25.5 5.5 4.5 6.4 4.2 4.1 4.2 11.18 8.67 8.84 11.07 8.3 12.78 7.58 9 11.08 8.28 11.62 9.06 9.35 7.53 10.24 9.78 9.84 9.2 8.28 9.31 8.19 11.65 9.89 11.03 9.84 11.77 13.59 9.74 10.33 9.97 7.84 10.47 G x6 279 80 107 147 180 150 186 540 182 85 758 167 322 97 72 337 108 133 134 833 95 195 270 600 298 546 170 176 248 167 318 210 196 312 221 256 so 60 196 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 38 405 73 101 125 519 49 170 198 497 236 163 240 468 5 4.8 4 3.9 4.5 3.2 116.9 88 76.4 63.6 101.8 99.2 75.9 30.9 98.9 112.6 95.9 82.3 71.1 113.1 101.3 59.2 96.1 103.6 102.1 72.6 55 111.7 76.1 104.3 76.5 87.9 69.1 37.1 37.1 77.1 17.1 37.1 57.1 57.1 57.1 57.1 37.1 37.1 173 6.9 15.9 23.1 35.3 17.6 12 17.5 12 30.2 10.8 18.6 17.7 19.7 17.7 17.3 24.2 114 21.2 16.5 7.1 5.7 105 47.2 52.1 54.5 50.5 49.9 53 541 54 54.4 55.8 58.2 49.1 53.2 4.9 5 5.2 5.3 6.1 6.3 37.1 57.1 543 124 156 217 113 270 200 164 258 170 181 69 50 168 503 165 169 172 149 543 18 39 10 5 2.8 4.6 4.1 343 543 153 AutoSave QOR R SennicdataCSV - Saved File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri - 11 xou la Copy Format Painter General Paste BIV- AA == 2 Wrap Text A.A. E. Merge & Center Alignment $ - % 4848 Normal Conditional Format as Check Cell Formatting Table Clipboard Font Number A1 sl.no A w D H 40 M N o 39 40 41 5.7 1.9 41 42 43 4.1 1.3 3.7 4.7 42 43 12.1 23.2 44 7 14.9 15.1 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 F 69.1 58 92.8 94.1 78.9 79.1 84.8 51.5 113.7 71.9 40.4 86.9 82 42.6 97.9 105.3 G 196 73 166 113 130 362 115 831 306 593 106 305 252 620 535 157 76 5.6 5.5 4.6 6.5 5.5 1.8 4.2 5.6 4.3 7.6 7.8 3.1 3.9 3.7 4.3 3.9 4.5 3.4 5.7 5.4 4.4 5 56.2 8 10.47 8.16 8.48 10.72 11.2. 10.12 8.37 10.16 19.56 10.9 7.67 8.88 11.48 9.23 11.41 12.07 8.63 11.15 7.14 7.65 10.73 11.46 10.42 11.16 7.93 9.66 7.78 9.42 10.02 8.58 9.61 8.03 7.39 7.08 9.53 10.03 8.45 6.7 8.9 10.23 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 281 53.2 60.9 51.1 53.8 45 51.7 50.7 54.2 59.9 57.2 51.7 51.5 57.6 51.6 61.1 43.7 54 56.5 59 47.1 50.6 56.9 58 51 64.1 52.1 45.5 50.6 49.5 55 52.4 54.2 51 52 51.5 52 38.8 48.6 49.7 53.2 153 21 118 107 56 264 88 629 172 211 35 197 251 420 273 76 44 199 35 314 345 17.2 10.6 2.5 10.1 20.3 11.6 16.6 52.4 8.4 7.7 2.6 16.4 19.3 15.6 8 18.8 7.5 9.9 20.9 24.8 8.3 7.4 6.9 24.3 14.6 12.3 15 36.7 12.9 13 12.7 9.9 168 49 145 90 95 313 96 581 273 446 93 238 207 413 330 115 39 217 37 265 374 153 67 546 42 66 391 421 191 248 404 65 38 52 241 144 143 51 37 595 73.81 75.81 65.7 101 97.7 59 55.9 98.1 98.3 71.6 62.8 93 95.9 87.2 87.3 88.4 56.4 65.7 87.5 85 80.8 36.9 77.9 J 54.3 14.3 34.3 34.3 34.3 54.3 343 74.3 51.4 51.4 11.4 51.4 51.4 71.4 51.4 31.4 31.4 51.4 31.4 51.4 51.4 31.4 31.4 68.6 28.6 28.6 48.6 48.6 48.6 48.6 48.6 28.6 28.6 28.6 48.6 68.6 48.6 28.6 28.6 70 318 445 191 119 595 68 83 489 SOB 265 304 487 97 72 87 298 184 235 76 52 752 44 3.7 132 64 392 49 95 329 528 202 65 66 67 68 69 70 71 72 72 74 75 76 218 220 3.5 4.2 2. 5.2 45 3.4 4.5 2.9 55 67 57 193 151 124 79 35 446 78 79 AutoSave OP SennicdataCSV - 5a File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri -11 General Paste Xcut Copy Format Painter Clipboard AA EE 25 Wrap Text A.A. EI Merge & Center BIU.2- $ . % 13:43 Normal Conditional Format as Check Cell Formatting Table Font Alignment Number A1 sl.no D G - J K M N B 10.23 8.88 10.3 10.79 7.94 7.63 8.77 8.09 9.05 7.91 H 595 165 113 320 139 109 85 61 127 349 223 127 10.39 79 78 80 79 81 80 81 83 82 84 83 85 84 86 85 87 86 88 87 89 88 90 89 91 90 92 91 93 92 94 93 95 94 96 95 97 96 98 97 99 98 100 99 101 100 102 101 103 102 104 103 105 104 106 105 107 106 108 107 109 108 110 109 110 112 111 113 112 114 113 115 116 656 53.2 55.8 59.6 44.2 49.5 52.1 54.5 56.9 51.2 52.8 54.6 54.1 50.4 51.3 56 53.9 54.9 50.2 56.1 52.8 52.8 51.8 51.9 53.2 45.2 57.6 65.9 52.5 63.9 51.7 55 53.8 49.3 56.9 56,2 59.5 E 9.9 14.1 27.8 2.6 6.2 11.6 5.2 7.6 205 11.9 14 18.3 23.8 9.5 6.2 2.2 12.3 15.7 27 6.8 10.8 4.6 16.4 6.9 11.8 9.36 11.41 8.86 8.93 8.92 8.15 9.77 8.54 8.66 12.01 7.95 10.15 9.76 9.89 7.14 13.95 5.1 2.9 3.5 5.5 4.7 1.7 4.1 2.9 4.3 4.8 5.8 2.9 2 1.3 5.3 5.3 2.5 3.8 4.8 2.3 6.2 2.6 4.3 2.7 6.6 F 77.9 76.8 88.9 56.6 92.3 61.1 47 56.9 79.8 79.5 88.3 90.6 73 87.5 72.5 79.5 79.8 89.7 82.5 09.5 96.9 54.9 59.2 80.1 100,7 92.6 133.5 58.5 57.4 45.7 46,5 116.9 70.9 446 182 73 196 116 110 87 61 112 188 200 158 335 53 56 14 71 148 75 177 752 237 175 461 195 197 143 92 195 477 353 165 424 100 95 56 99 154 98 246 298 163 568 64 190 92 356 297 130 115 91 571 98 129 835 29 68.6 48.6 45.7 65.7 45.7 45.7 25.7 45.7 45.7 65.7 65.7 45.7 45.7 25.7 25.7 5.7 25.7 25.7 45.7 45.7 45.7 42.9 62.9 22.9 42.9 22.9 62.9 42.9 22.9 22.9 22.9 62.9 22.9 62.9 62.9 22.9 59 40 55 123 57 178 237 128 452 47 141 40 308 230 69 90 44 441 68 85 791 20 115 13.1 10.8 7.14 8.02 11.8 9.5 7.7 17.94 9.41 2.9 1.4 2.1 5.7 5.8 4.4 5.9 3.1 15.6 10.9 1.6 4.1 3.8 9.1 42 12.2 26.4 20.6 93 371 55 112 50 182 263 62 19 32 469 46 136 407 22 91.7 AutoSave R Biasas - Saved File Home Insert Page Layout Formulas Data Review View Developer Help Search Calibri - 11 General Paste X Cut Copy - Format Painter Clipboard - AAEE a. A E BIU. 2 Wrap Text Merge & Center - $ . % ) Condition Formattin Font Alignment Number A1 fr Bias for yhatWLS D E F G H L M B C 1 Bias for yBias for yhat OLS 2 -6.20E-06 3.61E-20 3 -3.99E-05 -2.31E-19 4 -2.79E-03 -1.85E-18 5 -2.69E-03 2.78E-18 6 7.79E-05 5.55E-18 J-3.36E-05 5.78E-20 8 -5.44E-04 -3.70E-18 19 1.19E-04 -9.25E-19 10 -1.98E-03 -3.24E-18 11 -5.38E-03 1.30E-17 12 3.31E-04 -9.26E-19 13 4.16E-OS -4.63E-19 14 -6.55E-05 4.34E-19 15 -1.26E-04 0.00E 400 16 -1.99E-04 -1.85E-18 17 3.54E-05 2.31E-19 18 -3.10E-04 -1.16E-18 19 1.59E-03 2.04E-17 20 7.60E-03 5.56E-18 21 22 23
