HWdata is about housing data in certain area. Answer the following questions based on the data provided.

1. Model the sellprice by use listprice, comment on your model. Also predict the sellprice if the list price is 880 thousand dollars. (in the given data, both variables have 1000 dollar as measurement unit)
2. Prove statistically that average sellprice is lower than average listprice.
3. (Bonus question) Averagely speaking, can we bargain more than 30 thousand dollars?
4. Study if the sellprice is similar for the two bed groups (newly defined variable).
5. Study if Bed is associate with Bath.
6. 

ACRES TAXES 0.28 60 12 41 22 sellprice listprice LIVINGARI ROOMS BEDRMS BATHRMS AGE 710.00 800 28 10 5 3 875.00 900 18 8 4 1 645.00 660 13 6 3 1 690.00 700 17 7 3 1 1160.00 1200 25 8 4 3 675.00 700 18 7 4 3 750.00 800 20 8 3 1035.00 1125 22 8 4 2 1355.00 1425 30 10 5 2 445.00 450 10 5 3 1 5 3167 4033 1471 3204 3613 3028 3131 5158 5702 2054 0.43 0.33 0.46 2.05 0.57 4.00 2.22 0.53 0.30 0.38 9 18 16 30 43 765.00 785 22 8 3 3 18 4127 450 16 7 3 1 50 0.65 1.61 1445 2087 1190 25 8 4 2 2 13 580 20 4 0.22 2818 432.50 1170.00 527.50 875.00 825.00 830.00 8 8 900 22 4 1 2 2 15 2.06 3917 850 17 8 4 33 750 16 7 3 1 31 2220 3498 730.00 850.00 2950 3346 850 9 23 4 37 2 3 950 24 10 2 33 700 19 7 1 22 3 3607 635.00 4 20 1 8 680.00 740.00 0.46 0.27 0.63 0.36 0.34 1.55 65 33 0.36 0.57 0.40 1.20 1.13 800 17 7 6 2 13 650 1350 815 36 10 3 3 4 3648 3561 1325.00 785.00 3334 5853 3982 765 19 8 2 24 18 8 4 755.00 900.00 2 1 12 25 950 24 2 10 4681 675 4 9 17 4 0.52 3374 1465.00 1525 26 9 8 9 4 6 0.46 7088 640.00 550.00 615.00 15 8 4 11 0.59 3119 600 650 2 2 835.00 3 2 2 850 4 46 3482 18 8 4 43 0.39 20 22 3268 0.46 0.48 950.00 965 9 5 37 1060.00 1150 39 12 5 3 3648 202 44 4.29 0.22 950 2 27 18 8 4 2 2783 920.00 785.00 550.00 21 20 9 8 8 1.30 0.30 825 7 10 3920 4162 3785 3103 3363 6 3 1 15 1.00 5 4 4 4 2438 2 1 575 16 8 26 725.00 645.00 715.00 1235.00 555.00 4 2 10 1.20 0.29 0.43 3529 725 675 725 1260 600 725 21 29 7 9 725 18 675.00 4 4 7 1 2 1.25 4626 3125 11 3 15 8 35 4 11 1 3 97 1.11 2835.00 900.00 3205 64 20 4 4 0.85 1.00 8 2 665.00 26 7 3 1 42 0.36 3059 925 940 7 3 2 16 3.00 915.00 925,00 17 20 12192 3831 3564 3765 3361 3950 965 9 3 2 56 6.49 775 17 1 33 760.00 740.00 8 6 4 3 0.70 0.39 765 13 2 22 760.00 795 15 7 3 1 25 0.59 3055 ACRES TAXES 0.28 60 12 41 22 sellprice listprice LIVINGARI ROOMS BEDRMS BATHRMS AGE 710.00 800 28 10 5 3 875.00 900 18 8 4 1 645.00 660 13 6 3 1 690.00 700 17 7 3 1 1160.00 1200 25 8 4 3 675.00 700 18 7 4 3 750.00 800 20 8 3 1035.00 1125 22 8 4 2 1355.00 1425 30 10 5 2 445.00 450 10 5 3 1 5 3167 4033 1471 3204 3613 3028 3131 5158 5702 2054 0.43 0.33 0.46 2.05 0.57 4.00 2.22 0.53 0.30 0.38 9 18 16 30 43 765.00 785 22 8 3 3 18 4127 450 16 7 3 1 50 0.65 1.61 1445 2087 1190 25 8 4 2 2 13 580 20 4 0.22 2818 432.50 1170.00 527.50 875.00 825.00 830.00 8 8 900 22 4 1 2 2 15 2.06 3917 850 17 8 4 33 750 16 7 3 1 31 2220 3498 730.00 850.00 2950 3346 850 9 23 4 37 2 3 950 24 10 2 33 700 19 7 1 22 3 3607 635.00 4 20 1 8 680.00 740.00 0.46 0.27 0.63 0.36 0.34 1.55 65 33 0.36 0.57 0.40 1.20 1.13 800 17 7 6 2 13 650 1350 815 36 10 3 3 4 3648 3561 1325.00 785.00 3334 5853 3982 765 19 8 2 24 18 8 4 755.00 900.00 2 1 12 25 950 24 2 10 4681 675 4 9 17 4 0.52 3374 1465.00 1525 26 9 8 9 4 6 0.46 7088 640.00 550.00 615.00 15 8 4 11 0.59 3119 600 650 2 2 835.00 3 2 2 850 4 46 3482 18 8 4 43 0.39 20 22 3268 0.46 0.48 950.00 965 9 5 37 1060.00 1150 39 12 5 3 3648 202 44 4.29 0.22 950 2 27 18 8 4 2 2783 920.00 785.00 550.00 21 20 9 8 8 1.30 0.30 825 7 10 3920 4162 3785 3103 3363 6 3 1 15 1.00 5 4 4 4 2438 2 1 575 16 8 26 725.00 645.00 715.00 1235.00 555.00 4 2 10 1.20 0.29 0.43 3529 725 675 725 1260 600 725 21 29 7 9 725 18 675.00 4 4 7 1 2 1.25 4626 3125 11 3 15 8 35 4 11 1 3 97 1.11 2835.00 900.00 3205 64 20 4 4 0.85 1.00 8 2 665.00 26 7 3 1 42 0.36 3059 925 940 7 3 2 16 3.00 915.00 925,00 17 20 12192 3831 3564 3765 3361 3950 965 9 3 2 56 6.49 775 17 1 33 760.00 740.00 8 6 4 3 0.70 0.39 765 13 2 22 760.00 795 15 7 3 1 25 0.59 3055