a.Provide 95% confidence intervals for mean price and square footage of homes, overall and by bedrooms, by bathrooms, and by grade. Discuss

I have the following data:

AutoSave @ OFF House Sales - Dataset Q~ Search Sheet Home Insert Page Layout Formulas Data Review View Share X Cut Calibri (Body) * 11 A- A E Ed Wrap Text General AutoSum A Copy Fill Paste Merge & Center Conditional Format Cell Insert Delete Format Format Styles Clear Sort & Formatting as Table Filter G12 X V fx A C D E F G H I J K L M N 0 P Q R S T U V W X 436 51000 2260 1834 437 732500 2470 10321 438 352000 1850 $712 439 425000 0091 6180 440 489000 2120 11479 441 199950 1370 10317 442 2060 58341 443 202500 1120 8576 444 620000 2910 6110 445 000071 1130 5413 446 400000 2090 7634 447 000058 1430 7921 448 57000 3420 115434 449 179000 1790 7175 450 000091 1453 2225 451 1680 11250 452 500000 2990 216057 453 40300 1840 13020 454 655000 1660 5422 455 399888 2370 30200 456 450000 1350 7200 457 $19000 1950 2617 458 269950 1520 8720 459 185000 1080 9262 460 246500 940 0009 461 689000 3250 10000 462 185000 1490 6600 463 400000 2393 4788 464 420000 1620 1075 465 932990 466 006648 467 320000 468 288790 469 OOOOZE N W N D W W A D N W A D W W B W W A A N W W A W A N W W W W A A N W W N W W W S A F W W NNNNNNNNI 3640 6389 1800 2791 1400 9000 1390 745 2223 5780 470 $15000 2600 ;4626 471 377000 1000 1251 472 580000 3250 5000 473 740000 3050 8000 474 436000 1150 1193 475 1670 4020 476 DOO019 2910 5260 477 278000 UNNWNNNN 1610 1968 478 289950 2099 4275 479 306000 1090 1183 HouseSales_data + - + 100% Enter