please answer all the questions that were given, it would be really appreciated.Thank you

thats all the data in the excel

In this lab assignment, we want to predict the price of house from the square feet of the house. We have 89 observations. There are 6 variables including (1) Price: house price, $1000s (2) assess: assessed value: $1000s (3) bdrms: number of bedrooms (4) lotsize: size of lot in square feet (5) sqrft: size of house in square feet (6) colonial: =1 if home is colonial style. Part2: Visualization and Summary statistics for the variable 'price' (total: 36 points) (1) Graph a histogram(choose auto for bins or bin width=81; The plot should include variables with their units and the title) (5) (2) Calculating Mean, Median, Mode, Range, Variance, standard deviation and IQR. (16) (3) Describing the histogram based on three dimensions we learned in the class: Shape; Center and Spread. (5) (4) Create a boxplot and give a brief description of the boxplot. (5) (5) Which one is unusual, 7,000 square feet or $700,000 house price? Why? (5) 1 G H A 3 1 price assess bdms 2 300 349.1 3 370 351.5 191 217.7 5 195 231.8 6 373 319.1 7 466.275 414.5 8 332.5 367.8 9 315 300.2 10 206 236.1 240 256.3 12 285 314 113 300 416.5 14 405 434 15 212 279.3 16 265 287.5 17 227.4 232.9 18 240 303,8 19 285 305.6 20 268 266.7 21 310 326 22 266 294.3 23 270 318.8 24 225 294.2 25 150 208 28 247 239.7 27 275 294.1 28 230 267.4 28 343 359.9 30 4775 478.1 11 350 35513 32 230 217,8 33 335 385 64 251 224,3 235 251.9 IABI 361 354.9 190 21205 360 4524 lotsize sant Icolonial 4 6126 2438 1 3 9903 2076 1 3 5200 1374 0 3 4600 1448 1 6095 2514 1 5 8566 2754 1 3 9000 2067 1 3 6210 1731 1 3 6000 1767 0 3 2892 1890 0 4 6000 2336 1 7047 2634 1 3 12237 3375 3 6460 1899 0 3 6519 2312 1 3597 1760 4 5922 2000 0 3 7123 1774 1 3 5642 1376 4 8602 1835 1 3 5494 2048 1 3 7800 2124 1 3 6003 1768 0 4 5218 1732 0 3 9425 1440 1 3 6114 1932 3 6710 1932 0 3 8577 2106 1 7 8400 3529 1 4 9773 2051 1 4 4806 1573 1 4 15086 2829 0 3 5763 1630 1 4 6383 1840 1 9000 2066 4 3500 1702 0 10892 2.750 1 COPIC + 3 CE D E G 0 4 3 1 1 1 0 1 1 1 0 1 1 1 0 3 4 4 4 4 5 4 2 3 5 4 3 5 3 3 4 3 4 33 335 34 251 35 235 36 361 37 190 38 360 39 575 40 209.001 41 225 42 246 713.5 44 248 45 230 46 375 47 265 48 313 49 417.5 50 253 51 315 52 264 53 255 54 210 55 180 56 250 57 250 58 209 59 258 80 289 61 316 62 225 63 266 64 310 65 471.25 335 67 495 68 279.5 69 380 70 325 43 385 224.3 251.9 354.9 212.5 452.4 518.1 289.4 268.1 278.5 655.4 273.3 212.1 354 252.1 324 475.5 256.8 279.2 313.9 279.8 198.7 221.5 268.4 282.3 230.7 287 298.7 314.6 291 286.4 253.5 482 384.3 543.6 336.5 5 15.1 437 15086 5763 6383 9000 3500 10892 15634 6400 8880 6314 28231 7050 5305 6637 7834 1000 8112 5850 6660 6637 15267 5146 6017 8410 5625 5600 6525 6060 5539 7566 5484 5348 15834 8022 11966 8460 15105 10859 2829 1630 1840 2066 1702 2750 3880 1854 1421 1662 3331 1656 1171 2293 1764 2768 3733 1536 1638 1972 1478 1408 1812 1722 1780 1674 1850 1925 2343 1567 1664 1386 2617 2321 2638 1915 2589 2709 4 3 2 3 3 3 4 4 4 3 4 3 4 6 5 4 4 1 1 0 0 1 1 1 0 1 1 1 1 1 1 1 o 0 1 1 86 1 1 1 4 4 4 1 A B C E G 66 61 316 62 225 63 266 64 310 65 471.25 335 67 495 68 279.5 69 380 70 325 220 72 215 73 240 74 725 75 230 76 306 77 425 78 318 79 330 80 246 81 225 82 111 83 268.125 84 244 85 295 86 236 87 202.5 BB 219 89 242 an 314.6 291 286.4 253.6 482 384.3 543.6 336.5 515.1 437 263.4 300.4 250.7 708.6 276.3 388.6 252.5 295.2 359.5 276.2 249.8 202.4 254 306.8 318.3 259.4 258.1 232 252 4 3 4 6 5 4 4 4 4 4 3 3 3 5 3 2 3 3 5 3 2 5539 7566 5484 5348 15834 8022 11966 8460 15105 10859 6300 11554 6000 31000 4054 20700 5525 92681 8178 5944 18838 4315 5167 7893 6056 5828 6341 6362 4950 2343 1567 1664 1386 2617 2321 2638 1915 2589 2709 1587 1694 1536 3662 1736 2205 1502 1696 2186 1928 1294 1535 1980 2090 1837 1715 1574 1185 1774 0 1 1 1 1 1 1 1 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 1 0 0 0 3 3 3 4 3 4 3 3 3 2 4 In this lab assignment, we want to predict the price of house from the square feet of the house. We have 89 observations. There are 6 variables including (1) Price: house price, $1000s (2) assess: assessed value: $1000s (3) bdrms: number of bedrooms (4) lotsize: size of lot in square feet (5) sqrft: size of house in square feet (6) colonial: =1 if home is colonial style. Part2: Visualization and Summary statistics for the variable 'price' (total: 36 points) (1) Graph a histogram(choose auto for bins or bin width=81; The plot should include variables with their units and the title) (5) (2) Calculating Mean, Median, Mode, Range, Variance, standard deviation and IQR. (16) (3) Describing the histogram based on three dimensions we learned in the class: Shape; Center and Spread. (5) (4) Create a boxplot and give a brief description of the boxplot. (5) (5) Which one is unusual, 7,000 square feet or $700,000 house price? Why? (5) 1 G H A 3 1 price assess bdms 2 300 349.1 3 370 351.5 191 217.7 5 195 231.8 6 373 319.1 7 466.275 414.5 8 332.5 367.8 9 315 300.2 10 206 236.1 240 256.3 12 285 314 113 300 416.5 14 405 434 15 212 279.3 16 265 287.5 17 227.4 232.9 18 240 303,8 19 285 305.6 20 268 266.7 21 310 326 22 266 294.3 23 270 318.8 24 225 294.2 25 150 208 28 247 239.7 27 275 294.1 28 230 267.4 28 343 359.9 30 4775 478.1 11 350 35513 32 230 217,8 33 335 385 64 251 224,3 235 251.9 IABI 361 354.9 190 21205 360 4524 lotsize sant Icolonial 4 6126 2438 1 3 9903 2076 1 3 5200 1374 0 3 4600 1448 1 6095 2514 1 5 8566 2754 1 3 9000 2067 1 3 6210 1731 1 3 6000 1767 0 3 2892 1890 0 4 6000 2336 1 7047 2634 1 3 12237 3375 3 6460 1899 0 3 6519 2312 1 3597 1760 4 5922 2000 0 3 7123 1774 1 3 5642 1376 4 8602 1835 1 3 5494 2048 1 3 7800 2124 1 3 6003 1768 0 4 5218 1732 0 3 9425 1440 1 3 6114 1932 3 6710 1932 0 3 8577 2106 1 7 8400 3529 1 4 9773 2051 1 4 4806 1573 1 4 15086 2829 0 3 5763 1630 1 4 6383 1840 1 9000 2066 4 3500 1702 0 10892 2.750 1 COPIC + 3 CE D E G 0 4 3 1 1 1 0 1 1 1 0 1 1 1 0 3 4 4 4 4 5 4 2 3 5 4 3 5 3 3 4 3 4 33 335 34 251 35 235 36 361 37 190 38 360 39 575 40 209.001 41 225 42 246 713.5 44 248 45 230 46 375 47 265 48 313 49 417.5 50 253 51 315 52 264 53 255 54 210 55 180 56 250 57 250 58 209 59 258 80 289 61 316 62 225 63 266 64 310 65 471.25 335 67 495 68 279.5 69 380 70 325 43 385 224.3 251.9 354.9 212.5 452.4 518.1 289.4 268.1 278.5 655.4 273.3 212.1 354 252.1 324 475.5 256.8 279.2 313.9 279.8 198.7 221.5 268.4 282.3 230.7 287 298.7 314.6 291 286.4 253.5 482 384.3 543.6 336.5 5 15.1 437 15086 5763 6383 9000 3500 10892 15634 6400 8880 6314 28231 7050 5305 6637 7834 1000 8112 5850 6660 6637 15267 5146 6017 8410 5625 5600 6525 6060 5539 7566 5484 5348 15834 8022 11966 8460 15105 10859 2829 1630 1840 2066 1702 2750 3880 1854 1421 1662 3331 1656 1171 2293 1764 2768 3733 1536 1638 1972 1478 1408 1812 1722 1780 1674 1850 1925 2343 1567 1664 1386 2617 2321 2638 1915 2589 2709 4 3 2 3 3 3 4 4 4 3 4 3 4 6 5 4 4 1 1 0 0 1 1 1 0 1 1 1 1 1 1 1 o 0 1 1 86 1 1 1 4 4 4 1 A B C E G 66 61 316 62 225 63 266 64 310 65 471.25 335 67 495 68 279.5 69 380 70 325 220 72 215 73 240 74 725 75 230 76 306 77 425 78 318 79 330 80 246 81 225 82 111 83 268.125 84 244 85 295 86 236 87 202.5 BB 219 89 242 an 314.6 291 286.4 253.6 482 384.3 543.6 336.5 515.1 437 263.4 300.4 250.7 708.6 276.3 388.6 252.5 295.2 359.5 276.2 249.8 202.4 254 306.8 318.3 259.4 258.1 232 252 4 3 4 6 5 4 4 4 4 4 3 3 3 5 3 2 3 3 5 3 2 5539 7566 5484 5348 15834 8022 11966 8460 15105 10859 6300 11554 6000 31000 4054 20700 5525 92681 8178 5944 18838 4315 5167 7893 6056 5828 6341 6362 4950 2343 1567 1664 1386 2617 2321 2638 1915 2589 2709 1587 1694 1536 3662 1736 2205 1502 1696 2186 1928 1294 1535 1980 2090 1837 1715 1574 1185 1774 0 1 1 1 1 1 1 1 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 1 0 0 0 3 3 3 4 3 4 3 3 3 2 4