CRIM ZN INDUS NOX RM AGE DIS RAD TAX PTRATIO B LSTAT 2.924 0 19.58 0.605 6.101 93 2.2834 5 403 14.7 240.16 9.81 38.352 0 18.1 0.693 5.453 100 1.4896 24 666 20.2 396.9 30.59 0.022 82.5 2.03 0.415 7.61 15.7 6.27 2 348 14.7 395.38 3.11 0.111 0 27.74 0.609 5.983 83.5 2.1099 4 711 20.1 396.9 13.35 0.140 22 5.86 0.431 6.487 13 7.3967 7 330 19.1 396.28 5.9 41.529 0 18.1 0.693 5.531 85.4 1.6074 24 666 20.2 329.46 27.38 2.450 0 19.58 0.605 6.402 95.2 2.2625 5 403 14.7 330.04 11.32 3.775 0 18.1 0.655 5.952 84.7 2.8715 24 666 20.2 22.01 17.15 0.229 0 8.56 0.52 6.405 85.4 2.7147 5 384 20.9 70.8 10.63 0.376 0 10.59 0.489 5.404 88.6 3.665 4 277 18.6 395.24 23.98 0.318 0 9.9 0.544 5.914 83.2 3.9986 4 304 18.4 390.7 18.33 0.624 0 6.2 0.507 6.879 77.7 3.2721 8 307 17.4 390.39 9.93 0.045 0 11.93 0.573 6.12 76.7 2.2875 1 273 21 396.9 9.08 0.545 0 21.89 0.624 6.151 97.9 1.6687 4 437 21.2 396.9 18.46 0.222 20 6.96 0.464 7.691 51.8 4.3665 3 223 18.6 390.77 6.58 7.404 0 18.1 0.597 5.617 97.9 1.4547 24 666 20.2 314.64 26.4 0.020 80 1.76 0.385 6.23 31.5 9.0892 1 241 18.2 341.6 12.93 7.752 0 18.1 0.713 6.301 83.7 2.7831 24 666 20.2 272.21 16.23 3.164 0 18.1 0.655 5.759 48.2 3.0665 24 666 20.2 334.4 14.13 4.898 0 18.1 0.631 4.97 100 1.3325 24 666 20.2 375.52 3.26 0.340 22 0.040 0 0.035 95 0.290 0 0.034 82.5 0.079 45 0.105 40 0.136 0 5.708 0 0.015 90 4.261 0 0.128 30 0.066 0 0.061 40 0.087 45 25.046 0 0.442 0 0.051 0 0.341 0 0.050 35 0.045 0 3.474 0 0.239 0 4.647 0 22.597 0 0.051 0 0.029 40 0.094 12.5 0.082 30 5.86 0.431 6.108 5.19 0.515 6.037 2.68 0.4161 7.853 10.59 0.489 5.412 2.03 0.415 6.162 3.44 0.437 6.782 6.41 0.447 7.267 10.59 0.489 6.064 18.1 0.532 6.75 3.75 0.394 7.454 18.1 0.77 6.112 4.93 0.428 6.393 3.24 0.46 5.868 6.41 0.447 6.826 3.44 0.437 7.178 18.1 0.693 5.987 6.2 0.504 6.552 4.49 0.449 6.389 7.38 0.493 6.415 6.06 0.4379 5.706 3.24 0.46 6.144 18.1 0.718 8.78 9.69 0.585 6.019 18.1 0.614 6.98 18.1 0.7 5 5.19 0.515 6.316 1.25 0.429 6.939 7.87 0.524 5.889 4.93 0.428 6.481 34.9 34.5 33.2 9.8 38.4 41.1 49 59.1 74.9 34.2 81.3 7.8 25.8 27.6 26.3 100 21.4 48 40.1 28.4 32.2 82.9 65.3 67.6 89.5 38.1 34.5 39 18.5 8.0555 5.9853 5.118 3.5875 6.27 3.7886 4.7872 4.2392 3.3317 6.3361 2.5091 7.0355 5.2146 4.8628 6.4798 1.5888 3.3751 4.7794 4.7211 6.6407 5.8736 1.9047 2.4091 2.5329 1.5184 6.4584 8.7921 5.4509 6.1899 7 5 4 4 2 5 4 4 24 3 24 6 4 4 5 24 8 3 5 1 4 24 6 24 24 5 1 5 6 330 224 224 277 348 398 254 277 666 244 666 300 430 254 398 666 307 247 287 304 430 666 391 666 666 224 335 311 300 19.1 20.2 14.7 18.6 14.7 15.2 17.6 18.6 20.2 15.9 20.2 16.6 16.9 17.6 15.2 20.2 17.4 18.5 19.6 16.9 16.9 20.2 19.2 20.2 20.2 20.2 19.7 15.2 16.6 390.18 396.9 392.78 348.93 393.77 393.87 389.25 381.32 393.07 386.34 390.74 374.71 382.44 393.45 390.49 396.9 380.34 396.9 396.9 394.02 368.57 354.55 396.9 374.68 396.9 389.71 389.85 390.5 379.41 9.16 8.01 3.81 29.55 7.43 6.68 6.05 14.66 7.74 3.11 12.67 5.19 9.97 4.16 2.87 26.77 3.76 9.62 6.12 12.43 9.09 5.29 12.92 11.66 31.99 5.68 5.89 15.71 6.36 0.032 4.422 0.352 0.028 0.025 1.519 5.824 1.834 0.349 0.056 0.358 0.091 3.674 0.139 0.132 0.065 0.214 0.141 0.540 0.141 8.717 0.102 0.773 0.082 11.108 0.100 0.113 0.206 0.038 0.025 0.191 0.149 8.792 1.152 0.245 0.151 0.043 0.217 0.222 0.092 0.054 1.629 0.066 9.514 0.575 0.412 0.014 0.178 0.106 1.343 95 0 0 75 55 0 0 0 0 0 0 20 0 0 0 70 22 0 20 0 0 0 0 22 0 0 30 22 80 0 22 0 0 0 0 0 28 0 0 0 21 0 0 0 0 0 60 0 30 0 1.47 18.1 21.89 2.95 3.78 19.58 18.1 19.58 9.9 2.46 6.2 6.96 18.1 4.05 10.01 2.24 5.86 10.59 3.97 13.92 18.1 12.83 8.14 5.86 18.1 2.46 4.93 5.86 1.52 1.89 5.86 8.56 18.1 8.14 9.9 27.74 15.04 10.59 10.01 10.81 5.64 21.89 2.46 18.1 6.2 6.2 2.93 9.69 4.93 19.58 0.403 0.584 0.624 0.428 0.484 0.605 0.532 0.605 0.544 0.488 0.507 0.464 0.583 0.51 0.547 0.4 0.431 0.489 0.647 0.437 0.693 0.437 0.538 0.431 0.668 0.488 0.428 0.431 0.404 0.518 0.431 0.52 0.584 0.538 0.544 0.609 0.464 0.489 0.547 0.413 0.439 0.624 0.488 0.713 0.507 0.504 0.401 0.585 0.428 0.605 6.975 6.003 6.454 6.595 6.696 8.375 6.242 7.802 5.972 7.831 6.951 5.92 6.312 5.572 6.176 6.345 6.438 6.375 7.203 5.79 6.471 6.279 6.495 6.957 4.906 6.563 6.897 5.593 7.274 6.54 6.718 6.727 5.565 5.701 5.782 5.454 6.249 5.807 6.092 6.065 6.511 5.019 7.765 6.728 8.337 7.163 6.604 5.569 6.095 6.066 15.3 94.5 98.4 21.8 56.4 93.9 64.7 98.2 76.7 53.6 88.5 61.5 51.9 88.5 72.5 20.1 8.9 32.3 81.8 58 98.8 74.5 94.4 6.8 100 95.6 54.3 76.5 38.3 59.7 17.5 79.9 70.6 95 71.7 92.7 77.3 53.8 95.4 7.8 21.1 100 83.3 94.1 73.3 79.9 18.8 73.5 65.1 100 7.6534 2.5403 1.8498 5.4011 5.7321 2.162 3.4242 2.0407 3.1025 3.1992 2.8617 3.9175 3.9917 2.5961 2.7301 7.8278 7.3967 3.9454 2.1121 6.32 1.7257 4.0522 4.4547 8.9067 1.1742 2.847 6.3361 7.9549 7.309 6.2669 7.8265 2.7778 2.0635 3.7872 4.0317 1.8209 3.615 3.6526 2.548 5.2873 6.8147 1.4394 2.741 2.4961 3.8384 3.2157 6.2196 2.3999 6.3361 1.7573 3 24 4 3 5 5 24 5 4 3 8 3 24 5 6 5 7 4 5 4 24 5 4 7 24 3 6 7 2 1 7 5 24 4 4 4 4 4 6 4 4 4 3 24 8 8 1 6 6 5 402 666 437 252 370 403 666 403 304 193 307 223 666 296 432 358 330 277 264 289 666 398 307 330 666 193 300 330 329 422 330 384 666 307 304 711 270 277 432 305 243 437 193 666 307 307 265 391 300 403 17 20.2 21.2 18.3 17.6 14.7 20.2 14.7 18.4 17.8 17.4 18.6 20.2 16.6 17.8 14.8 19.1 18.6 13 16 20.2 18.7 21 19.1 20.2 17.8 16.6 19.1 12.6 15.9 19.1 20.9 20.2 21 18.4 20.1 18.2 18.6 17.8 19.2 16.8 21.2 17.8 20.2 17.4 17.4 15.6 19.2 16.6 14.7 396.9 331.29 394.08 395.63 396.9 388.45 396.9 389.61 396.24 392.63 391.7 391.34 388.62 396.9 393.3 368.24 377.07 385.81 392.8 396.9 391.98 373.66 387.94 386.09 396.9 396.9 391.25 372.49 392.2 389.96 393.74 394.76 3.65 358.77 396.9 395.09 396.9 390.94 396.9 390.91 396.9 396.9 395.56 6.68 385.91 372.08 376.7 395.77 394.62 353.89 4.56 21.32 14.59 4.32 7.18 3.32 10.74 1.92 9.97 4.45 9.71 13.65 10.58 14.69 12.04 4.97 3.59 9.38 9.59 15.84 17.12 11.97 12.8 3.53 34.77 5.68 11.38 12.5 6.62 8.65 6.56 9.42 17.16 18.35 15.94 18.06 10.59 16.03 17.09 5.52 5.28 34.41 7.56 18.71 2.47 6.36 4.38 15.1 12.4 6.43 6.801 0 0.095 0 0.039 0 0.299 20 9.724 0 0.013 35 0.054 0 0.015 80 0.408 0 0.049 33 14.236 0 0.069 0 0.159 0 1.252 0 0.268 0 0.047 0 0.083 0 0.034 75 23.648 0 67.921 0 0.043 52.5 0.061 20 0.171 0 0.303 0 0.224 0 0.145 0 3.693 0 1.425 0 0.131 0 0.057 0 0.097 0 9.823 0 0.082 0 0.198 0 2.149 0 6.288 0 0.127 25 4.752 0 0.128 12.5 0.033 0 0.259 0 0.154 25 0.115 0 8.152 0 0.006 18 0.298 0 0.171 0 0.057 0 0.032 0 0.041 25 18.1 0.713 6.081 12.83 0.437 6.286 3.41 0.489 6.405 6.96 0.464 5.856 18.1 0.74 6.406 1.52 0.442 7.241 4.05 0.51 6.315 2.01 0.435 6.635 6.2 0.507 6.164 2.18 0.472 6.849 18.1 0.693 6.343 2.89 0.445 7.416 6.91 0.448 6.211 8.14 0.538 5.57 9.69 0.585 5.794 11.93 0.573 6.03 2.46 0.488 5.604 2.95 0.428 7.024 18.1 0.671 6.38 18.1 0.693 5.683 5.32 0.405 6.565 3.33 0.4429 7.645 8.56 0.52 5.836 7.38 0.493 6.312 9.69 0.585 6.027 10.01 0.547 5.731 18.1 0.713 6.376 19.58 0.871 6.51 8.56 0.52 6.127 3.41 0.489 7.007 5.96 0.499 5.841 18.1 0.671 6.794 13.92 0.437 6.009 10.59 0.489 6.182 19.58 0.871 5.709 18.1 0.74 6.341 5.13 0.453 6.762 18.1 0.713 6.525 6.07 0.409 5.885 5.19 0.515 6.059 21.89 0.624 5.693 5.13 0.453 6.145 2.89 0.445 6.163 18.1 0.7 5.39 2.31 0.538 6.575 6.2 0.504 7.686 10.01 0.547 5.928 4.49 0.449 6.63 2.18 0.458 6.998 4.86 0.426 6.727 84.4 45 73.9 42.1 97.2 49.3 73.4 29.7 91.3 70.3 100 62.5 6.5 98.1 70.6 80.8 89.8 15.8 96.2 100 22.9 49.7 91.9 28.9 79.7 65.2 88.4 100 85.2 86.3 61.4 98.8 42.3 42.4 98.5 96.4 43.4 86.5 33 37.3 96 29.2 69.6 98.9 65.2 17 88.2 56.1 45.8 33.5 2.7175 4.5026 3.0921 4.429 2.0651 7.0379 3.3175 8.344 3.048 3.1827 1.5741 3.4952 5.7209 3.7979 2.8927 2.505 2.9879 5.4011 1.3861 1.4254 7.3172 5.2119 2.211 5.4159 2.4982 2.7592 2.5671 1.7659 2.1224 3.4217 3.3779 1.358 5.5027 3.9454 1.6232 2.072 7.9809 2.4358 6.498 4.8122 1.7883 7.8148 3.4952 1.7281 4.09 3.3751 2.4631 4.4377 6.0622 5.4007 24 5 2 3 24 1 5 4 8 7 24 2 3 4 6 1 3 3 24 24 6 5 5 5 6 6 24 5 5 2 5 24 4 4 5 24 8 24 4 5 4 8 2 24 1 8 6 3 3 4 666 398 270 223 666 284 296 280 307 222 666 276 233 307 391 273 193 252 666 666 293 216 384 287 391 432 666 403 384 270 279 666 289 277 403 666 284 666 345 224 437 284 276 666 296 307 432 247 222 281 20.2 18.7 17.8 18.6 20.2 15.5 16.6 17 17.4 18.4 20.2 18 17.9 21 19.2 21 17.8 18.3 20.2 20.2 16.6 14.9 20.9 19.6 19.2 17.8 20.2 14.7 20.9 17.8 19.2 20.2 16 18.6 14.7 20.2 19.7 20.2 18.9 20.2 21.2 19.7 18 20.2 15.3 17.4 17.8 18.5 18.7 19 396.9 383.23 393.55 388.65 385.96 394.74 395.6 390.94 395.24 396.9 396.9 396.9 394.46 376.57 396.9 396.9 391 395.62 396.9 384.97 371.72 377.07 395.67 396.9 396.9 391.5 391.43 364.31 387.69 396.9 377.56 396.9 396.9 393.63 261.95 318.01 395.58 50.92 396.9 396.14 392.11 390.68 391.83 396.9 396.9 377.51 344.91 392.3 394.63 396.9 14.7 8.94 8.2 13 19.52 5.49 6.29 5.99 21.46 7.53 20.32 6.19 7.44 21.02 14.1 7.88 13.98 1.98 23.69 22.98 9.51 3.01 18.66 6.15 14.33 13.61 14.65 7.39 14.09 5.5 11.41 21.24 10.4 9.47 15.79 17.79 9.5 18.13 8.79 8.51 17.19 6.86 11.34 20.85 4.98 3.92 15.76 6.53 2.94 5.29 0.069 0.188 4.669 0.035 0.062 2.300 0.493 0.803 1.273 0.520 0.115 0.402 1.193 0.107 0.159 0.340 1.131 0.009 0.036 2.447 0.062 0.323 0.762 6.444 2.242 0.976 0.114 0.151 0.179 0.080 3.850 5.821 5.670 0.030 0.988 3.678 4.349 5.666 0.011 1.355 0.072 4.556 0.387 0.067 1.800 1.388 0.055 9.187 4.542 0.183 45 0 0 35 40 0 0 0 0 20 20 0 0 80 0 0 0 90 80 0 0 0 20 0 0 0 0 0 0 0 0 0 0 55 0 0 0 0 55 0 0 0 0 0 0 0 33 0 0 0 3.44 0.437 6.739 6.91 0.448 5.786 18.1 0.713 5.976 6.06 0.4379 6.031 1.25 0.429 6.49 19.58 0.605 6.319 9.9 0.544 6.635 8.14 0.538 5.456 19.58 0.605 6.25 3.97 0.647 8.398 6.96 0.464 6.538 9.9 0.544 6.382 21.89 0.624 6.326 1.91 0.413 5.936 10.81 0.413 5.961 21.89 0.624 6.458 8.14 0.538 5.713 2.97 0.4 7.088 3.37 0.398 6.29 19.58 0.871 5.272 5.19 0.515 5.968 21.89 0.624 5.942 3.97 0.647 5.56 18.1 0.584 6.425 19.58 0.605 5.854 21.89 0.624 5.757 13.89 0.55 6.373 10.01 0.547 6.021 9.69 0.585 5.67 5.96 0.499 5.85 18.1 0.77 6.395 18.1 0.713 6.513 18.1 0.631 6.683 3.78 0.484 6.874 8.14 0.538 5.813 18.1 0.77 5.362 18.1 0.58 6.167 18.1 0.74 6.219 2.25 0.389 6.453 8.14 0.538 6.072 4.49 0.449 6.121 18.1 0.718 3.561 25.65 0.581 5.613 4.05 0.51 6.546 19.58 0.605 5.877 8.14 0.538 5.95 2.18 0.472 7.236 18.1 0.7 5.536 18.1 0.77 6.398 27.74 0.609 5.414 30.8 6.4798 33.3 5.1004 87.9 2.5806 23.3 6.6407 44.4 8.7921 96.1 2.1 82.5 3.3175 36.6 3.7965 92.6 1.7984 91.5 2.2885 58.7 3.9175 67.2 3.5325 97.7 2.271 19.5 10.5857 17.5 5.2873 98.9 2.1185 94.1 4.233 20.8 7.3073 17.8 6.6115 94 1.7364 58.5 4.8122 93.5 1.9669 62.8 1.9865 74.8 2.2004 91.8 2.422 98.4 2.346 92.4 3.3633 82.6 2.7474 28.8 2.7986 41.5 3.9342 91 2.5052 89.9 2.8016 96.8 1.3567 28.1 6.4654 100 4.0952 96.2 2.1036 84 3.0334 100 2.0048 31.9 7.3073 100 4.175 56.8 3.7476 87.9 1.6132 95.6 1.7572 33.1 3.1323 79.2 2.4259 82 3.99 41.1 4.022 100 1.5804 88 2.5182 98.3 1.7554 5 3 24 1 1 5 4 4 5 5 3 4 4 4 4 4 4 1 4 5 5 4 5 24 5 4 5 6 6 5 24 24 24 5 4 24 24 24 1 4 3 24 2 5 5 4 7 24 24 4 398 233 666 304 335 403 304 307 403 264 223 304 437 334 305 437 307 285 337 403 224 437 264 666 403 437 276 432 391 279 666 666 666 370 307 666 666 666 300 307 247 666 188 296 403 307 222 666 666 711 15.2 17.9 20.2 16.9 19.7 14.7 18.4 21 14.7 13 18.6 18.4 21.2 22 19.2 21.2 21 15.3 16.1 14.7 20.2 21.2 13 20.2 14.7 21.2 16.4 17.8 19.2 19.2 20.2 20.2 20.2 17.6 21 20.2 20.2 20.2 15.3 21 18.5 20.2 19.1 16.6 14.7 21 18.4 20.2 20.2 20.1 389.71 396.9 10.48 362.25 396.9 297.09 396.9 288.99 338.92 386.86 394.96 395.21 396.9 376.04 376.94 395.04 360.17 394.72 396.9 88.63 396.9 378.25 392.4 97.95 395.11 262.76 393.74 394.51 393.29 396.9 391.34 393.82 375.33 387.97 394.54 380.79 396.9 395.69 394.72 376.73 395.15 354.7 359.29 390.96 227.61 232.6 393.68 396.9 374.56 344.05 4.69 14.15 19.01 7.83 5.98 11.1 4.54 11.69 5.5 5.91 7.73 10.36 12.26 5.57 9.88 12.6 22.6 7.85 4.67 16.14 9.29 16.9 10.45 12.03 11.64 17.31 10.5 10.3 17.6 8.77 13.27 10.29 3.73 4.61 19.88 10.19 16.29 16.59 8.23 13.04 8.44 7.12 27.26 5.33 12.14 27.71 6.93 23.6 7.79 23.97 0.050 0.142 0.315 0.123 0.657 0.790 0.083 8.267 0.122 2.379 1.127 9.967 0.590 0.173 5.293 24.802 0.164 1.054 0.117 0.612 15.288 0.129 0.031 4.097 0.162 0.017 0.230 2.314 4.836 0.325 0.114 0.252 21 0 0 0 20 0 0 0 0 0 0 0 0 0 0 0 22 0 12.5 20 0 0 0 0 20 90 0 0 0 0 0 0 5.64 6.91 6.2 10.01 3.97 9.9 13.92 18.1 2.89 18.1 19.58 18.1 21.89 9.69 18.1 18.1 5.86 8.14 7.87 3.97 18.1 13.92 4.39 19.58 6.96 2.02 10.59 19.58 18.1 21.89 8.56 10.59 0.439 0.448 0.504 0.547 0.647 0.544 0.437 0.668 0.445 0.583 0.871 0.74 0.624 0.585 0.7 0.693 0.431 0.538 0.524 0.647 0.671 0.437 0.442 0.871 0.464 0.41 0.489 0.605 0.583 0.624 0.52 0.489 5.998 6.169 8.266 5.913 6.842 6.122 6.127 5.875 6.625 5.871 5.012 6.485 6.372 5.707 6.051 5.349 6.433 5.935 6.009 8.704 6.649 6.678 6.014 5.468 6.24 6.728 6.326 5.88 5.905 6.431 6.781 5.783 21.4 6.6 78.3 92.9 100 52.8 18.4 89.6 57.8 41.9 88 100 97.9 54 82.5 96 49.1 29.3 82.9 86.9 93.3 31.1 48.5 100 16.3 36.1 52.5 97.3 53.2 98.8 71.3 72.7 6.8147 5.7209 2.8944 2.3534 2.0107 2.6403 5.5027 1.1296 3.4952 3.724 1.6102 1.9784 2.3274 2.3817 2.1678 1.7028 7.8265 4.4986 6.2267 1.801 1.3449 5.9604 8.0136 1.4118 4.429 12.1265 4.3549 2.3887 3.1523 1.8125 2.8561 4.3549 4 3 8 6 5 4 4 24 2 24 5 24 4 6 24 24 7 4 5 5 24 4 3 5 3 5 4 5 24 4 5 4 243 233 307 432 264 304 289 666 276 666 403 666 437 391 666 666 330 307 311 264 666 289 352 403 223 187 277 403 666 437 384 277 16.8 17.9 17.4 17.8 13 18.4 16 20.2 18 20.2 14.7 20.2 21.2 19.2 20.2 20.2 19.1 21 15.2 13 20.2 16 18.8 14.7 18.6 17 18.6 14.7 20.2 21.2 20.9 18.6 396.9 383.37 385.05 394.95 391.93 396.9 396.9 347.88 357.98 370.73 343.28 386.73 385.76 396.9 378.38 396.9 374.71 386.85 396.9 389.7 363.02 396.9 385.64 396.9 396.9 384.46 394.87 348.13 388.22 396.9 395.58 389.43 8.43 5.81 4.14 16.21 6.9 5.98 8.58 8.88 6.65 13.34 12.12 18.85 11.12 12.01 18.76 19.77 9.52 6.58 13.27 5.12 23.24 6.27 10.53 26.42 6.59 4.5 10.97 12.03 11.45 15.39 7.67 18.06 MEDV_TGT 25 5 42.3 20.1 24.4 8.5 22.3 19 18.6 19.3 17.8 27.5 20.6 17.8 35.2 17.2 20.1 14.9 19.9 50 24.3 21.1 48.5 23.7 24.1 32 33.2 24.4 23.7 44 22.6 23.7 19.3 33.1 36.4 5.6 31.5 23.9 25 17.1 19.8 21.9 21.2 29.8 7.4 22.2 26.6 21.7 23.7 PROBLEM 2 Please create a regression model in Excel to answer the following questions (OUT The data set on the left contains housing values in the suburbs of Boston Description of each attribute: CRIM per capita crime rate by town ZN proportion of residential land INDUS proportion of non-retail busin NOX nitric oxides concentration (pa RM average number of rooms per AGE proportion of owner-occupied u DIS weighted distances to five B RAD index of accessibility to radia TAX full-value property-tax rate p PTRATIO pupil-teacher ratio by town B 1000(Bk - 0.63)^2 where Bk is LSTAT % lower status of the populat MEDV_TGT Median value of owner-occupi Answer all questions below using the full model: 1. Please write the mathematical model equation and comment on the overall model. (10 p 2. Which variable(s) are most signifcant in determining the median value of homes and wh 3. Calculate the MSE of the model, show your work (5 pts) 4. Forecast values for cases below. (10 pts) CRIM 0.10574 0.84054 0.01778 0.05644 1.23247 0.01311 6.71772 4.22239 ZN 0 0 95 40 0 90 0 0 INDUS 27.74 8.14 1.47 6.41 8.14 1.22 18.1 18.1 NOX 0.609 0.538 0.403 0.447 0.538 0.403 0.713 0.77 RM 5.983 5.599 7.135 6.758 6.142 7.249 6.749 5.803 AGE 98.8 85.7 13.9 32.9 91.7 21.9 92.6 89 DIS 1.8681 4.4546 7.6534 4.0776 3.9769 8.6966 2.3236 1.9047 RAD 4 4 3 4 4 5 24 24 TAX 711 307 402 254 307 226 666 666 PTRATIO 20.1 21 17 17.6 21 17.9 20.2 20.2 34.9 19.1 17.1 30.8 23.9 50 23 50 20.3 50 26.7 20.7 21.2 23.1 21.2 22.5 24.8 28.1 33.8 20.3 13.1 20 18.4 29.6 13.8 32.5 22 17.6 34.6 16.5 26.2 27.5 11.7 13.1 19.8 15.2 20.6 22.4 18.7 22.8 25 14.4 39.8 14.9 41.7 31.6 29.1 17.5 20.1 24.3 20 21.4 22 21.1 17.1 32.7 24.6 24.5 21.7 28.2 7.2 33.2 24.7 13.6 18.3 11.9 26.4 34.9 13.1 5 24.8 46 19.5 23 16.8 19.3 17.7 23.3 20.4 23.6 20 13.3 21.7 25 19.4 14.9 25 14.1 20.9 20.6 16.2 23.3 21.4 11.5 24 46.7 18.3 26.6 33.4 28 30.5 20 12.7 19.4 22.9 23.8 22.8 20.2 27 48.8 24.4 23.1 19.6 20.6 21.7 19.2 12.7 32.2 23.5 13.1 18.7 17.4 22.8 16.1 22.7 15.6 23 19.2 23.1 21 21.7 20.2 50 31.2 14.5 20.8 19.9 18.4 22 14.5 22.2 27.5 15.7 29.4 23.8 13.2 36.1 11.3 25 7 23.4 25.3 44.8 18.8 30.1 22.1 23.9 50 28.4 20.6 15.3 15.4 23 21.8 23.2 8.3 24.5 23.1 18.9 50 13.9 28.6 17.5 15.6 25.2 30.1 24.4 19.1 20.6 18 26.5 22.5 e following questions (OUTPUT to new sheet): on the overall model. (10 pts) ian value of homes and why? (5 pts) B 390.11 303.42 384.3 396.9 396.9 395.93 0.32 353.04 LSTAT MEDV_TGT 18.07 16.51 4.45 3.53 18.72 4.81 17.44 14.64