Question

Can someone please help me with this? Using the following sample data size of 30 homes for the following variables; variable a) is address, variable b) is asking price, variable c) is square footage, variable d) is number of days on market and variable e) is cost per square foot, please answer the following below.

1) for variables b-e(asking price, square footage, number of days on market and cost per square foot, determine 96% confidence interval and interpret each result using a complete sentence. Please show all calculations.

2) Were the requirements to compute a 96% confidence interval met? Explain why or why not, showing all appropriate calculations.

3) Suppose that you are qualified for a $168,000 mortgage. Do you think that you could buy the average priced home in the zip code chosen here? Explain why or why not using knowledge of confidence intervals.

4) Compute the least squares regression line for asking price as a function of square footage for the homes selected from below. If you qualified for $168.000 mortgage, how large of a home could you afford in selected zip code below? Clearly show any calculations.   

1 4123 MUNCY EXCHANGE RD, MUNCY PA 17756 2 111 DIVISION STREET, MUNCY PA 17756 3 1150 MURRAY RD, MUNCY PA 17756 4 205 QUARRY RD, MUNCY PA 17756 5 314 QUARRY RD, MUNCY PA 17756 6 311 S MARKET ST, MUN CY PA 17756 7 119 WATER STREET, MUNCY PA 17756 8 141 COOKIE DRIVE, MUNCY PA 17756 9 135 CARPENTER STREET, MUNCY PA 17756 10 688 RUBEN KEHRER RD, MUNCY PA 17756 11 750 MICHAEL HOLLOW RD, MUNCY PA 17756 12 407 S MARKET STREET, MUNCY PA 17756 13 50 GREEN STREET, MUNCY PA 17756 14 103 N MARKET STREET, MUNCY PA 17756 15 619 VILLAGE RD, MUNCY PA 17756 16 84 FOGELMAN RD, MUNCY PA 17756 17 1596 POND RD, MUNCY PA 17756 18 796 MIDDLE RD, MUNCY PA 17756 19 512 MARKET STREET, MUNCY PA 17756 20 472 OLD GLADE RUN RD, MUNCY PA 17756 21 1090 SCHMIDT RD, MUNCY PA 17756 22 265 YEAGLE RD, MUNCY PA 17756 23 102 S WASHINGTON STREET, MUNCY PA 17756 24 1240 WERTMAN SCHOOL RD, MUNCY PA 17756 25 524 S MAIN STREET, MUNCY PA 17756 26 881 OLD LAIRDSVILLE RD, MUNCY PA 17756 27 593 VILLAGE RD, MUNCY PA 17756 28 142 W WATER STREET, MUNCY PA 17756 29 304 S MARKET STREET, MUNCY PA 17756 $219,000 $159,500 $224,900 $154,900 $110,000 $195,900 $129,900 $160,000 $145,000 $245,000 $269,000 $167,000 $145,000 $149,900 $159,000 $329,900 $357,500 $409,900 $105,000 $154,900 1440 1 DAY 1436 2 DAYS 3626 23 DAYS 1680 151 DAYS 1296 131 DAYS 2722 100 DAYS 1792 50O DAYS 1742 18 DAYS 1824 59 DAYS 1905 15 DAYS 1148 14 DAYS 2132 72 DAYS 1655 53 DAYS 1680 20 DAYS 1940 92 DAYS 3920 36 DAYS 4486 515 DAYS 4210 70 DAYS 72 972 302 DAYS 1449 3 DAYS 2194 205 DAYS 1704 9 DAYS 2590 13 DAYS 1792 248 DAYS 4355 17 DAYS 4500 19 DAYS 3923 92 DAYS 1988 26 DAYS 2211 395 DAYS 1860 104 DAYS $164,900 $132,000 $189,900 $550,000 $329,000 $144,900 207 N MAIN STREET, MUNCY PA 17756 31

Answer 1

B-confidence intexval: 96 % confidence interval 土24‰ = 218286.667土2.05 ¥ ,18)6S.oy구 074092. 5, ニ()구 yog 2. 592 262500,745] Py 1829, 380, 273). ç 85] = ニ95.1671 2.05.x 123.933 E confidence erval (土24% 96.9土20's 39-95 fidence 96% con V) 30 C32.18斗, lll. 693

As per HomeworkLib policy we need to solve one question per post. Please post the remaining questions in another post.