GENERAL NOTE: Questions 3 through 5 are all based on this first regression.
The “Excel File for Test 3\" (also posted under Assignments) contains information about the selling price of houses as well as related information about the houses. Please open the file in Excel and run a regression in which “Selling Price” is your Y input and “Number of Bedrooms” is your X input. Instructions on how to do that are in the Chapter 13 Notes.
Using your regression results, what is the (rounded) value of the estimated intercept “a”?
$161,119
$15,797
$11,716
$13.75
What is the value of the estimated slope “b”?
$161,119
$15,797
$11,716
$13.75
| | $161,119 |
| | $15,797 |
| | $11,716 |
| | $13.75 What is the value of the estimated slope “b”? | | $161,119 | | | $15,797 | | | $11,716 | | | $13.75 | Selling Prices of Houses and Related Information | | | | | | | | | | | Selling Price (in $) | Size (in square feet) | Number of Baths | Number of Bedrooms | Pool (dummy) | Garage (dummy) | Distance to Town Center | | 221100 | 2300 | 1.5 | 3 | 1 | 0 | 18 | | 266600 | 2400 | 2 | 4 | 0 | 1 | 13 | | 292400 | 2100 | 2 | 4 | 0 | 1 | 14 | | 213600 | 2200 | 2.5 | 2 | 0 | 0 | 16 | | 139900 | 2100 | 1.5 | 2 | 0 | 0 | 28 | | 245400 | 2100 | 2 | 2 | 1 | 1 | 12 | | 327200 | 2500 | 2 | 6 | 0 | 1 | 15 | | 271800 | 2100 | 2.5 | 2 | 0 | 1 | 9 | | 221100 | 2300 | 1.5 | 3 | 1 | 0 | 18 | | 266600 | 2400 | 2 | 4 | 0 | 1 | 13 | | 292400 | 2100 | 2 | 4 | 0 | 1 | 14 | | 209000 | 1700 | 1.5 | 2 | 0 | 1 | 8 | | 270800 | 2500 | 2 | 6 | 0 | 1 | 7 | | 246100 | 2100 | 2 | 4 | 0 | 1 | 18 | | 194400 | 2300 | 2 | 2 | 0 | 0 | 11 | | 281300 | 2100 | 2 | 3 | 0 | 1 | 16 | | 172700 | 2200 | 2 | 4 | 1 | 0 | 16 | | 207500 | 2300 | 2.5 | 5 | 1 | 0 | 21 | | 198900 | 2200 | 2 | 3 | 1 | 1 | 10 | | 209300 | 1900 | 2 | 6 | 1 | 1 | 15 | | 252300 | 2600 | 2 | 4 | 0 | 1 | 8 | | 192900 | 1900 | 2.5 | 4 | 1 | 1 | 14 | | 209300 | 2100 | 1.5 | 5 | 0 | 0 | 20 | | 345300 | 2600 | 2 | 8 | 0 | 1 | 9 | | 326300 | 2100 | 3 | 6 | 0 | 1 | 11 | | 173100 | 2200 | 1.5 | 2 | 1 | 1 | 21 | | 187000 | 1900 | 2 | 2 | 0 | 0 | 26 | | 257200 | 2100 | 2 | 2 | 0 | 1 | 9 | | 233000 | 2200 | 1.5 | 3 | 0 | 1 | 14 | | 177100 | 1900 | 2 | 2 | 0 | 1 | 10 | | 182700 | 2000 | 2.5 | 4 | 1 | 0 | 14 | | 216000 | 2300 | 2 | 4 | 0 | 0 | 19 | | 312100 | 2600 | 2.5 | 6 | 0 | 1 | 7 | | 199800 | 2100 | 2 | 3 | 0 | 1 | 19 | | 273200 | 2200 | 3 | 5 | 0 | 1 | 16 | | 206000 | 2100 | 1.5 | 3 | 1 | 0 | 9 | | 232200 | 1900 | 1.5 | 3 | 1 | 1 | 16 | | 198300 | 2100 | 1.5 | 4 | 1 | 1 | 19 | | 205100 | 2000 | 2 | 3 | 1 | 0 | 20 | | 175600 | 2300 | 2 | 4 | 1 | 1 | 24 | | 307800 | 2400 | 3 | 3 | 1 | 1 | 21 | | 269200 | 2200 | 3 | 5 | 0 | 1 | 8 | | 224800 | 2200 | 2.5 | 3 | 0 | 1 | 17 | | 171600 | 2000 | 2 | 3 | 1 | 0 | 16 | | 216800 | 2200 | 2 | 3 | 0 | 1 | 15 | | 192600 | 2200 | 2 | 6 | 1 | 0 | 14 | | 236400 | 2200 | 2 | 5 | 0 | 1 | 20 | | 172400 | 2200 | 2 | 3 | 0 | 0 | 23 | | 251400 | 1900 | 2 | 3 | 0 | 1 | 12 | | 246000 | 2300 | 3 | 6 | 0 | 1 | 7 | | 147400 | 1700 | 2 | 6 | 1 | 0 | 12 | | 176000 | 2200 | 2 | 4 | 0 | 1 | 15 | | 228400 | 2300 | 1.5 | 3 | 0 | 1 | 17 | | 166500 | 1600 | 2.5 | 3 | 1 | 0 | 19 | | 189400 | 2200 | 2 | 4 | 0 | 1 | 24 | | 312100 | 2400 | 3 | 7 | 0 | 1 | 13 | | 289800 | 2000 | 3 | 6 | 0 | 1 | 21 | | 269900 | 2200 | 2.5 | 5 | 1 | 1 | 11 | | 154300 | 2000 | 2 | 2 | 0 | 0 | 13 | | 222100 | 2100 | 2 | 2 | 0 | 1 | 9 | | 209700 | 2200 | 2 | 5 | 1 | 1 | 13 | | 190900 | 2200 | 2 | 3 | 1 | 1 | 18 | | 254300 | 2500 | 2 | 4 | 1 | 1 | 15 | | 207500 | 2100 | 2 | 3 | 1 | 0 | 10 | | 209700 | 2200 | 2 | 4 | 1 | 1 | 19 | | 294000 | 2100 | 2.5 | 2 | 0 | 1 | 13 | | 176300 | 2000 | 2 | 2 | 1 | 0 | 17 | | 294300 | 2400 | 2 | 7 | 0 | 1 | 8 | | 224000 | 1900 | 2 | 3 | 1 | 1 | 6 | | 125000 | 1900 | 1.5 | 2 | 0 | 0 | 18 | | 236800 | 2600 | 2 | 4 | 1 | 1 | 17 | | 164100 | 2300 | 2 | 4 | 0 | 0 | 19 | | 217800 | 2500 | 2 | 3 | 0 | 0 | 12 | | 192200 | 2400 | 2.5 | 2 | 0 | 0 | 16 | | 125900 | 2400 | 1.5 | 2 | 0 | 0 | 28 | | 220900 | 2300 | 2 | 2 | 1 | 1 | 12 | | 294500 | 2700 | 2 | 6 | 0 | 1 | 15 | | 253200 | 2300 | 2 | 3 | 0 | 1 | 16 | | 155400 | 2400 | 2 | 4 | 1 | 0 | 16 | | 186700 | 2500 | 2.5 | 5 | 1 | 0 | 21 | | 179000 | 2400 | 2 | 3 | 1 | 1 | 10 | | 188300 | 2100 | 2 | 6 | 1 | 1 | 15 | | 227100 | 2900 | 2 | 4 | 0 | 1 | 8 | | 173600 | 2100 | 2.5 | 4 | 1 | 1 | 14 | | 188300 | 2300 | 1.5 | 5 | 0 | 0 | 20 | | 310800 | 2900 | 2 | 8 | 0 | 1 | 9 | | 293700 | 2400 | 3 | 6 | 0 | 1 | 11 | | 179000 | 2400 | 2 | 3 | 0 | 1 | 8 | | 188300 | 2100 | 2.5 | 6 | 1 | 1 | 14 | | 227100 | 2900 | 1.5 | 4 | 0 | 0 | 20 | | 173600 | 2100 | 2 | 4 | 0 | 1 | 9 | | 188300 | 2300 | 3 | 5 | 0 | 1 | 11 | | 254300 | 2500 | 2 | 4 | 1 | 1 | 15 | | 207500 | 2100 | 2 | 3 | 1 | 0 | 10 | | 209700 | 2200 | 2 | 4 | 1 | 1 | 19 | | 294000 | 2100 | 2.5 | 2 | 0 | 1 | 13 | | 176300 | 2000 | 2 | 2 | 1 | 0 | 17 | | 294300 | 2400 | 2 | 7 | 0 | 1 | 8 | | 224000 | 1900 | 2 | 3 | 1 | 1 | 6 | | 125000 | 1900 | 1.5 | 2 | 0 | 0 | 18 | | 236800 | 2600 | 2 | 4 | 1 | 1 | 17 | | 164100 | 2300 | 2 | 4 | 0 | 0 | 19 | | 173600 | 2100 | 2.5 | 4 | 1 | 1 | 14 | | 188300 | 2300 | 1.5 | 5 | 0 | 0 | 20 | | 310800 | 2900 | 2 | 8 | 0 | 1 | 9 | | 293700 | 2400 | 3 | 6 | 0 | 1 | 11 | | |
Homework Sourse![GENERAL NOTE: Questions 3 through 5 are all based on this first regression. The “Excel File for Test 3\](/WebImages/20/general-note-questions-3-through-5-are-all-based-on-this-fir-1042749-1761541900-0.webp "GENERAL NOTE: Questions 3 through 5 are all based on this first regression. The “Excel File for Test 3\")
![GENERAL NOTE: Questions 3 through 5 are all based on this first regression. The “Excel File for Test 3\](/WebImages/20/general-note-questions-3-through-5-are-all-based-on-this-fir-1042749-1761541900-1.webp "GENERAL NOTE: Questions 3 through 5 are all based on this first regression. The “Excel File for Test 3\")
![GENERAL NOTE: Questions 3 through 5 are all based on this first regression. The “Excel File for Test 3\](/WebImages/20/general-note-questions-3-through-5-are-all-based-on-this-fir-1042749-1761541900-2.webp "GENERAL NOTE: Questions 3 through 5 are all based on this first regression. The “Excel File for Test 3\")
