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
They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more