Explore   the relationship between the selling prices (Y) and the appraised values (X)   of the 148 homes in the file P02_ 11. xlsx by estimating a simple linear   regression equation. Find a 95% confidence interval for the model’s slope   parameter ( ). What does this confidence interval tell you about the   relationship between Y and X for these data?    
          House Appraised Value Selling Price Square Feet Bedrooms Bathrooms   1 119,370 121,870 2050 4 5   2 148,930 150,250 2200 4 4   3 130,390 122,780 1590 3 3   4 135,700 144,350 1860 3 3   5 126,300 116,200 1210 2 3   6 137,080 139,490 1710 3 2   7 123,490 115,730 1670 3 3   8 150,830 140,590 1780 3 4   9 123,480 120,290 1520 4 4   10 132,050 147,250 1830 2 3   11 148,210 152,260 1700 3 3   12 139,530 144,800 1720 3 4   13 114,340 107,060 1670 3 4   14 140,040 147,470 1650 3 3   15 136,010 135,120 1610 2 1   16 140,930 140,240 1570 3 4   17 132,420 129,890 1650 4 5   18 118,300 121,140 1640 3 4   19 122,140 111,230 1420 2 3   20 149,820 145,140 2070 4 3   21 128,910 139,010 1610 2 3   22 134,610 129,340 1910 4 4   23 121,990 113,610 1410 2 2   24 150,500 141,050 1860 4 3   25 142,870 152,900 1990 4 3   26 155,550 157,790 2270 5 4   27 128,500 135,570 1965 4 4   28 143,360 151,990 1820 3 3   29 119,650 120,530 1650 3 3   30 122,570 118,640 1470 2 2   31 145,270 149,510 1850 4 3   32 149,730 146,860 2170 4 4   33 147,700 143,880 1930 3 3   34 117,530 118,520 1380 2 1   35 140,130 146,070 1810 3 4   36 136,570 135,350 1760 3 4   37 130,440 121,540 1530 2 3   38 118,130 132,980 1700 3 2   39 130,980 147,530 1980 4 4   40 131,330 128,490 1590 2 2   41 141,100 141,930 1740 3 2   42 117,870 123,550 1730 3 2   43 160,580 162,030 2100 5 6   44 151,100 157,390 2040 4 4   45 120,150 114,550 1730 2 1   46 133,170 139,540 1680 2 2   47 140,160 149,920 2050 4 4   48 124,560 122,080 1750 3 3   49 127,970 136,510 1870 4 3   50 101,930 109,410 1330 2 3   51 131,470 127,290 1700 3 3   52 121,270 120,450 1460 2 3   53 143,550 151,960 1910 3 3   54 136,890 132,540 1610 2 1   55 106,110 114,330 1470 2 1   56 137,540 141,320 1810 3 4   57 134,330 83,760 1650 2 2   58 127,590 118,200 1520 2 1   59 137,440 140,200 1920 4 5   60 114,090 113,550 1410 2 1   61 145,460 156,520 2030 3 3   62 141,900 137,350 1950 3 4   63 116,340 110,610 1340 2 1   64 149,200 153,690 1850 3 4   65 141,810 153,330 1780 3 2   66 116,440 111,950 1440 2 1   67 137,740 143,460 2040 4 4   68 144,700 142,130 2160 5 4   69 149,660 155,460 2170 4 3   70 118,170 135,440 1710 2 3   71 137,660 127,300 1640 3 2   72 119,700 113,770 1380 2 1   73 143,120 141,110 2100 5 6   74 129,910 130,080 1610 2 2   75 141,780 139,350 1950 4 4   76 159,190 160,030 2080 5 4   77 156,130 152,840 1960 3 2   78 126,720 122,270 1920 4 4   79 133,220 145,880 1920 4 3   80 118,090 115,470 1490 2 1   81 141,630 135,720 1600 2 1   82 138,560 136,160 1650 3 2   83 134,100 144,920 1890 4 5   84 132,240 131,290 1620 3 4   85 145,820 138,530 1820 3 4   86 127,150 124,050 1750 3 2   87 105,070 107,900 1460 2 1   88 127,200 123,450 1530 3 2   89 111,560 111,700 1540 2 3   90 150,410 145,140 1950 3 2   91 129,150 120,440 1480 3 2   92 130,310 136,870 2050 4 4   93 129,230 140,300 1660 3 2   94 105,060 113,780 1540 2 3   95 134,210 141,230 1720 3 4   96 109,250 104,830 1400 2 1   97 127,350 118,790 1578 3 4   98 104,010 112,040 1700 3 3   99 133,940 137,270 1880 4 5   100 141,130 145,710 1850 3 4   101 136,530 138,380 1430 2 3   102 118,040 109,460 1390 2 1   103 153,700 144,680 2130 4 5   104 126,310 133,270 1890 4 4   105 134,020 133,270 1640 2 3   106 141,560 150,380 2070 3 3   107 142,960 135,260 1810 3 2   108 118,530 112,600 1460 2 1   109 121,590 114,230 1410 2 2   110 146,400 153,240 2190 4 3   111 141,250 125,890 1580 3 4   112 130,730 135,620 1840 3 3   113 132,650 138,820 1930 3 3   114 125,570 129,430 1930 4 5   115 125,740 136,450 1820 3 4   116 120,220 126,740 1480 2 1   117 128,290 130,090 1600 2 1   118 136,890 132,680 1880 3 2   119 142,430 142,890 1780 3 2   120 119,310 127,040 1920 3 2   121 120,370 131,450 1830 4 3   122 118,830 114,570 1470 2 3   123 124,490 129,560 1690 3 4   124 140,570 149,550 1930 4 5   125 133,620 140,820 1970 2 3   126 105,050 111,550 1530 2 2   127 147,090 142,760 2030 5 6   128 115,430 124,250 1830 3 3   129 125,370 132,320 2070 3 4   130 115,970 121,450 1630 2 3   131 125,210 132,450 1580 3 2   132 130,370 135,830 1760 3 4   133 119,750 125,760 1810 4 5   134 120,930 125,840 1710 3 2   135 126,800 135,320 1890 3 3   136 118,820 120,140 1640 2 1   137 144,080 147,530 2010 4 4   138 142,490 144,940 1730 3 3   139 140,550 136,010 1770 4 3   140 130,360 119,330 1750 4 5   141 124,270 131,150 1660 3 3   142 167,730 172,360 2510 5 6   143 129,190 137,170 1700 2 3   144 125,180 124,710 1660 3 4   145 157,510 148,650 2110 4 5   146 126,670 128,520 1430 2 2   147 137,570 132,020 1710 4 5   148 133,460 128,030 1580 2 1