MS Student Data AD Q 1 . . . AB AC AD AE AF AG AH Al A AK AL At M N O P Q R S T U V W X Y Z AA B C D G H MW Marsh Woods AT Aspen Tallow T+G Cottage has a thatched roof and a Garden After creating 0/1's for thatched roof and Garden if you multiply the two times each other when would the new variable be a 1? BD Badger's Drift Price Stories SqFt Village Thatched Garage WaterFront Garden T+G Wall Murder obs 4,016 MW NO No NO No No No 1 358,520 No No 352,670 4,128 MW NO No NO No No No 350,950 4,267 AT No Yes No Yes W N 3,626 MW No Yes No No 311,538 No No 4 No Yes No Yes No No UNNNNNN 5 332,225 3,969 BD No 356,354 3,909 BD Yes Yes No Yes Yes Yes No No No No 304,487 3,278 MW No No No 301,947 3,108 AT No No No Yes No No No 318,125 3,414 AT No No Yes No No Yes 10 330,607 4,248 BD Yes Yes No Yes No Yes No Yes 11 337,930 3,789 BD Yes Yes No 12 3,270 No Yes No 278,758 BD No Yes 13 366,841 4,451 BD No Yes No Yes No No Yes No No 378,837 4,046 MW No Yes Yes No No No 15 352,456 4,222 BD Yes Yes NN No 289,415 3,474 BD Yes No No Yes No 16 No No 17 306,168 3,238 MW No No No No UN No No No No Yes No 18 375,302 4,092 MW 4,300 AT No Yes No No Yes No 19 360,684 UN No Yes No Yes No 29 20 350,886 4,003 AT No No Yes No 30 21 350,734 No Yes Yes UN 3,904 AT Yes 22 423,318 4,431 AT Yes Yes Yes No Yes No No Yes Yes 23 318,141 3,935 BD Yes Yes UN No 24 315,050 3,236 AT No Yes No Yes Yes Yes No 25 307,074 2 3,540 AT No Yes No NO 2 3,303 MW No Yes No Yes Yes No 26 327,510 fx Enter text or formula here . . . F CT CEAB AG AH Al AJ AK AL AC AD AE AF N o P Q R S U W Z AA M G No 27 324,483 2 3,281 MW No Yes NO Yes Yes Yes No No Yes 28 382,769 2 4,161 MW No Yes No Yes NO No No Yes 29 353,590 4,345 AT No No Nc No Yes 3 30 350,868 4,221 AT Yes Yes 3,294 AT Yes NO Yes No 31 324,962 Yes No 3,294 AT Yes Yes No E 41 32 338,837 No No No No Yes 42 33 285,103 3,278 MW No Yes Yes 34 325,276 3,444 AT Yes No Yes No Yes Yes No 35 286,172 Yes No UN 3,109 BD Yes No 359,648 4,028 MW No No No 36 Yes No Yes Yes No 46 37 280,318 3,115 BD Yes No Yes No No 47 38 304,431 3,170 MW Yes No 3,972 AT No No No No 48 39 355,789 No No Yes No No Yes 49 40 371,868 4.027 MW No No Yes No 41 290,820 UNNNNNNN 3,560 AT Yes No 50 No Yes No 51 42 366,899 4,207 MW No Yes No No No No Yes Yes No 52 43 393,916 4,283 MW No No Yes No No Yes 53 44 303,673 ,519 MW No No Yes No 54 45 4,238 AT No Yes 347,035 No 3,178 MW NO Yes No No Yes 55 46 273,136 Yes No Yes Yes Yes 56 47 321,122 3,567 BD No Yes NO No Yes Yes 57 48 312,800 3,533 AT Yes No Yes Yes No 3,148 BD No 58 49 275,415 Yes No Yes No No 345,807 3,652 MW NO Yes No No No 356,961 4,073 BD Yes No No No No No No No 61 393,713 4,358 MW No Yes No No 313,375 3,645 BD Yes No No Yes No No 63 387,810 4,021 MW No Yes No No 308,170 3,682 BD No Yes No Yes No No 372,429 4,293 AT Yes No No 4,274 BD Yes No Yes Yes No No 66 368,739 No No No UNNNNNNNNNN No No No 67 359,426 4,408 MW AT No 3,476 Yes Yes No 68 59 327,713 Yes 3,357 AT Yes Yes Yes No No No 69 60 296,303 No No Yes 61 250,066 3,221 BD Yes No No 3,239 BD Yes Yes No Yes No Yes 62 298,037 Yes No No No No No 63 332,162 3,567 AT 4,041 BD No No Yes No No Yes 64 331,998 3,368 AT Yes No Yes No No Yes 315,545 2 Yes Yes No No 66 394,890 4,347 AT Yes No fx Enter text or formula here . . . F CTAC AG AH AJ AA AB AF Al AK AD AE W M N O P Q G D No No No 2 3,324 AT No Yes Yes No No 76 67 296,777 NO NO 347,337 4,085 BD Yes No 68 UN Yes No No No No 59 394,562 4,350 MW No No No NO No Yes 4,266 AT No 70 393,718 UN NO No NC No 80 71 364,873 4,291 MW NO No No Yes NO Yes Yes 81 No No No 72 372,751 4,393 BD No AT No Yes No 82 73 349,624 4,331 No No No 74 312,679 3,192 MW No No 83 No No No Yes Yes Yes AT 84 75 368,608 4,262 No Yes No No 315,330 3,387 AT No Yes 76 No No No 85 MW NO Yes Yes 77 361,700 UNNNNNNNNN 3,939 No No No No 86 MW No No No 87 78 357,285 4,068 No No No 88 79 352,213 3,994 AT Yes No No Yes No No 294,404 3,257 MW No No 89 No No No No Yes No 80 90 81 273,720 3,273 BD Yes Yes No No No 3,282 AT Yes 91 82 299,884 No No Yes 92 83 299,957 3,668 BD No Yes 327,605 3,537 MW No No No 93 84 No Yes 4,456 AT No No 94 85 387,740 No Yes No No 95 86 355,726 3,982 MW No MW No Yes 96 87 350,449 3,801 Yes 4,103 MW No Yes No 97 88 412,598 Yes No No Yes 98 89 294,713 3,430 BD No Yes No No 99 90 314,710 3,885 Yes No 91 3,821 Yes No 100 338,993 3,854 MW No No No No 101 92 361,519 No NO Yes 102 93 4,342 MW No 393,121 3,257 MW No No No Yes 103 94 292,550 UNNNNNNNNNN 3,599 BD NO Yes No Yes 104 95 316,938 No No No No 105 96 314,703 3,560 MW No 4,418 MW No Yes No 106 97 386,676 3,193 No No Yes 98 273,823 No No Yes 107 99 274,640 3,261 BD Yes No Yes 108 No AT Yes Yes 368,904 4,263 No No No 109 100 No Yes No Yes No 101 385,856 4,315 MW No 4,185 No Yes No No 102 358,893 No No Yes 4,173 LAT Yes No Yes 366,126 N N 103 No No No No No No 361,714 3,881 MW 104 No Yes No No No Yes No No UN 105 320,245 3,823 BD 4,122 MW No Yes No No 115 106 368,400 fx Enter text or formula here . . . F CTAF AG AH Al AJ AK O P Q R W AA AB AC AD AE M N D G 107 370,949 4,339 MW No No No No No No 116 4,349 BD Yes No Yes Yes No 117 108 362,972 No Yes No Yes No 118 109 307,603 3,212 MW No 119 110 416,179 4,359 MW No Yes No Yes 3,322 AT Yes No Yes No Yes 120 111 335,970 UNI AT Yes Yes Yes No Yes 121 112 346,083 3,829 Yes Yes Yes No No 122 113 374,622 4,061 BD Yes 4,408 MW No No No Yes No No 123 114 416,162 NO No No No 124 115 291,458 3,215 MW NO No No No Yes 125 116 336,549 4,010 BD Yes No No NO No 126 363,319 3,656 MW NO Yes 117 Yes Yes No Yes 127 118 398,753 4,303 Yes No UNNNNNNNNNN 128 119 308,502 3,509 AT No No No Yes No 120 371,609 4,128 BD Yes Yes Yes Yes 129 Yes No 130 121 333,104 3,894 AT No No No 3,596 BD No Yes No 122 309,582 No Yes Yes Yes No 123 366,162 3,838 BD Yes Yes Yes Yes No 124 354,173 3,805 MW No Yes No Yes Yes No 125 341,242 3,859 MW No No No No No 126 307,913 4,147 BD No No No Yes Yes Yes 127 334,452 NN 3,799 BD Yes No No Yes Yes = Yes No Yes No 128 298,754 3,660 BD Yes No Yes 129 342 ,158 3,934 AT Yes Yes No No Yes No 130 350,043 3,740 MW No No No Yes Yes No Yes No 131 293,478 3,310 MW No No No Yes Yes No Yes No 132 273,728 3,274 BD No No Yes Yes Yes No UNNNNNN 133 328,874 3,682 BD Yes No No Yes Yes No 134 363,020 3,544 MW No 3,621 BD Yes Yes Yes Yes Yes No 135 312,160 288,644 3,228 AT Yes Yes No No Yes No 136 Yes No 137 334,407 3,824 AT Yes No No No 3,892 AT Yes Yes Yes No Yes No 138 344,634 Yes No 326,386 3,452 MW No Yes No No 139 Yes No 337,708 3,325 MW No Yes No Yes 140 No Yes No 150 141 319,594 3,952 BD No No Yes 3,201 AT No No No No Yes No 151 142 292,395 No No 152 143 343,069 2 3,771 BD Yes Yes Yes Yes No 153 144 309,589 AT No Yes No No Yes Yes 154 145 220,826 2 3,100 BD Yes No No No Yes 2 3,744 MW No No No Yes Yes No 155 146 346,119 fx Enter text or formula here . . . CTAK N S Z AA AB AC AD AE AF AG AH Al AJ M o P Q R U W G 147 311,732 2 3,619 AT No No No Yes Yes No 156 3,753 BD Yes No No Yes Ye No 148 318,587 Yes 149 275,533 3,292 BD Yes Yes No No Yes Yes No UNNNN 150 379,823 4,086 MW No Yes No No No Yes Yes No 160 151 321,736 3,194 MW NO Yes Yes Yes 161 152 306,897 3,126 AT Yes No Yes Yes 162 153 328,025 3,942 BD Yes Yes No Yes 313,687 3,452 AT Yes No Yes No Yes Yes 163 154 Yes Yes No No Yes Yes 164 155 344,369 4,038 BD 377,634 3,815 MW No Yes No Yes No 165 156 NO No No Yes No 166 157 366,450 4,064 MW Yes Yes Yes Yes Yes No 167 158 335,729 3,650 BD No 351,367 4,024 BD Yes No Yes Yes Yes 168 159 Yes Yes 160 381,071 4,462 BD Yes Yes No No 169 337,854 4,158 BD No Yes No Yes Yes No 170 161 3,871 MW No No No Yes Yes No 171 162 327,538 Yes No 163 270,423 3,236 Yes No Yes Yes BD No No Yes No 173 164 353,609 3,833 MW No No 3,491 BD Yes Yes No No Yes Yes 174 165 321,104 Yes Yes 175 166 372,435 4,171 AT Yes Yes No No 3,439 AT No Yes No No Yes No 176 167 298,429 Yes No 177 168 330,266 3,846 BD No Yes No Yes No No Yes No 178 169 370,414 4,302 MW No No UN No No Yes No 170 AT Yes 179 308,598 3,482 No Yes No 180 171 368,184 UN 4,348 BD Yes Yes Yes Yes 3,966 BD Yes No No No Yes Yes 181 2 327,229 3,271 BD Yes Yes Yes Yes Yes No 182 173 343,628 UN No No 183 MW No Yes Yes No 174 326,540 3,393 Yes Yes 184 175 315,010 3,966 BD Yes Yes No No No Yes No No Yes No 185 176 359,727 3,689 MW Yes No 186 177 391,061 4,184 MW No Yes No No Yes Yes UNNNNNN 187 178 328,077 3,635 AT Yes No Yes No No Yes No No Yes Yes 188 179 353,925 3,662 MW Yes 3,731 AT Yes Yes No No Yes 189 180 335,967 No No No Yes No 190 389,132 4,437 MW No 181 294,948 3,491 AT No No No No Yes No 191 182 346,085 3,787 MW No No No No Yes No 192 183 Yes Yes 193 319,466 4,024 BD Yes No No No 184 4,144 AT Yes No Yes No Yes Yes 194 185 373,446 2 3,776 AT No No No Yes Yes No 195 186 331,643 fx Enter text or formula here . . . CTAA AB AC AD AE AF AG AH Al AJ AK M N O P Q R W D G Yes NO Yes Yes 196 187 341,641 2 3,946 BD No 197 188 366,321 3,900 AT Yes Yes No 198 189 357,200 3,758 MW No Yes No 199 190 344,942 3,769 AT Yes No No 200 391,151 4,249 BD Yes Yes Yes 191 UNNNNNNNN 201 192 291,794 3,385 BD No Yes No 202 193 309,512 3,398 AT No Yes No 339,425 No No 203 194 3,830 BD Yes 204 195 354,829 3,950 AT No Yes No 205 196 357,936 3,471 MW No Yes No No Yes 206 197 397,315 4,261 Yes No Yes 198 356,754 3,976 AT Yes Yes No Yes 207 199 372,890 4,224 MW No No No 208 No No NN 321,419 3,903 AT No Yes No No No 200 360,113 4,477 BD Yes No Yes No No 201 No No 202 3,457 AT No Yes No No 352,246 378,720 4,448 MW No No No No No No 203 No No Yes 204 279,824 Yes No UNNNNNNN 3,391 BD No 4,322 BD Yes Yes No Yes 205 347,065 No No 206 393,043 4,487 BD Yes No Yes Yes No No 207 368,487 4,343 AT Yes Yes No No No Yes No No 208 358,153 3,625 MW No Yes No 4,182 BD Yes No No No Yes 209 322 , 816 No Yes No No 210 398,506 4,236 MW No Yes 3,216 AT NO Yes No No No No 211 307,003 No No 212 308,427 2 3,427 AT No No No Yes No Yes No Yes 213 396,101 4,432 BD Yes Yes UN No 214 351,994 2 4,173 BD Yes Yes Yes No No 224 225 226 227 228 229 230 231 232 233 234 235 fx Enter text or formula here . . . CTRegression Homework MS Page 1: Previous Page Next Page Page 1 of 5 Question 1 (3 points) Page 2: The model with all useable variables is? Round to 2 decimal places 3 Page 3: If an answer is 0 (Zero ) enter 0.00 Price - 25099.34 + Page 4: A/ * SqFt + Page 5: *Thatched Roof + 11 A/ *Garage + Quiz Information A/ * Wall + A/ * WaterFront + Q Search 1 9 P X DELL . . Optiplex UltraA/ Garden + A/ * Murder + A/ *Aspen Tallow + A/ * Midsummer Worthy + A/ * Gardent and Thatched Roof Together Question 2 (2 points) For the overall test of the model The test statistics is A/ Previous Page Next Page Page 1 of 5 Q Search TO O P X DELL Optiplex Ultran Homework MS Previous Page Next Page Pa Question 3 (2 points) For the overall test of the model the decision is 1) Reject Ho and Accept Ha 2) Reject Ha and Accept Ho 3) Do not Reject Ho ( 4) Do not Reject Ha Previous Page Next Page Page 10 Submit Quiz 0 of 11 questions saved nation Q SearchThe overall test indicates 1) All the independent variables are related to y 2) This is a bad model 3) Some or all of the independent variables are related to y O 4) This is the final good model Question 5 (2 points) The marginal test for Garages indicates 1) Grages are related to house price 10 2) Walls are related to house price by a factor of 5.22 3) A Garage lowers the house price ion 4) Garages are not related to house price Previous Page Next Page Page 3 Search TkaPrevious Page Next Page Page 4 of 5 Question 6 (5 points) The reduced equation with all variables meeting a 10% significance level is? Enter 0.00 for variables not in model Price = 26306.07 + A/ * Sq Ft + A/ * Thatched Roof + A/ Garage + A/ * Wall + * WaterFront + Q Search DELL .A/ * Garden + A * Murder + * Aspen Tallow + A/ * Mid Summer Worthy + * Garden and Thatched Roof Question 7 (3 points) How much does having a Thached Roof but no Garden change the house price? Previous Page Next Page Page 4 of 5 Q Search H O P X DELL . . . . OpiPlex UnceQuestion 8 (3 points) The total amount added to a house (cottege) price for having both a Gardent and a Thtached Roof (versus a house wihtout either) would be? Question 9 (3 points) The average price difference between Badgers Drift and Aspen Tallow is? A/ Question 10 (3 points) The least expensvie village is 1) Badgers Drift 2) Mid Summer Worthy 3) Aspen Tallow 4) Can not be detrmined Q Search H O P X DELLQuestion 11 (6 points) For a cottage in Aspen Tallow, 3300 sf, 2 stories, with a thatced roof and a garden, a wall, no water frontage, no garage and no murders nearby the estimate dprice would be? The approximate 95% confidence interval for the price would be? Low of A/ to High of A/ Previous Page Next Page Page 5 of 5 Submit Quiz O of 11 questions saved Q Search X DELL . . Optiplex UltraBarnaby is moving to MidSommer County. He would like to know how to value cottages in the area. He is looking at 3 villages, Midsomer Worthy, Aspen Tallow and Badgers Drift. Data includes square feet of each cottage, stories, if it has a thatched roof, does it have a garage, does it have a wall out front at the road, does it have water on the property (lake, stream etc.), does it have a garden and has there been a murder nearby. The estate agent also tells you that cottages that have both a thatched roof and a garden have an extra premium in the price in addition to a thatched roof or garden by themselves. Use Badgers Drift as the base regression. Before you start trying to put answers in Folio you might want to think about, What is your estimated regression equation with all the variables included? The overall test of the model is? (Ho, Ha test stat etc.) What is the reduced equation with all remaining variables meeting a 10% significance level? The model (part C) explains how much of the variation price? How much is the extra premium for having both a garden and a thatched roof? moow