Question
Is there a significant difference, at 5% level of significance, in the population average age (AGE) between houses in Eastville school district (SCHOOL = 0)
Is there a significant difference, at 5% level of significance, in the population average age (AGE) between houses in Eastville school district (SCHOOL = 0) and houses in Apple Valley school district (SCHOOL = 1)? Assume variances are equal. You have to show all the work in order to earn full credit. (25 points)
a. Define the population parameters, and state the null and alternative hypotheses. (5 points)
b. Calculate the test statistic. (5 points)
c. Find the critical value and state or graph the rejection region. (5 points)
d. Calculate the p-value. (5 points)
e. State your decision and conclusion in the context of the problem. (5 points)
SQ_FT | BEDS | BATHS | HEAT | STYLE | GARAGE | BASEMENT | AGE | FIRE | PRICE | SCHOOL |
1238 | 3 | 2 | 0 | 0 | 1 | 1 | 12 | 1 | 59.9 | 1 |
1707 | 3 | 2 | 1 | 0 | 2 | 0 | 13 | 1 | 64 | 0 |
1296 | 4 | 2 | 0 | 0 | 2 | 1 | 17 | 0 | 66.5 | 0 |
1320 | 3 | 2 | 0 | 0 | 2 | 1 | 11 | 1 | 66.5 | 0 |
1210 | 3 | 2 | 0 | 0 | 1 | 0 | 6 | 1 | 66.9 | 0 |
1296 | 3 | 2 | 0 | 0 | 2 | 1 | 17 | 1 | 68 | 0 |
1765 | 3 | 2 | 0 | 0 | 2 | 1 | 20 | 0 | 68.5 | 0 |
1725 | 4 | 3 | 0 | 0 | 2 | 1 | 12 | 0 | 69 | 0 |
1794 | 4 | 2 | 0 | 0 | 2 | 1 | 18 | 0 | 70.95 | 0 |
1294 | 3 | 2 | 0 | 0 | 2 | 0 | 13 | 1 | 71 | 0 |
1372 | 3 | 2 | 0 | 0 | 2 | 1 | 9 | 0 | 72.692 | 1 |
1162 | 3 | 2 | 0 | 0 | 1 | 0 | 8 | 1 | 72.801 | 0 |
1996 | 4 | 2 | 0 | 0 | 2 | 0 | 13 | 1 | 75.207 | 1 |
1764 | 4 | 2 | 1 | 0 | 2 | 1 | 13 | 1 | 76 | 0 |
1416 | 3 | 2 | 0 | 0 | 2 | 0 | 8 | 0 | 76 | 1 |
1730 | 4 | 2 | 0 | 0 | 2 | 0 | 15 | 1 | 77.5 | 0 |
1392 | 3 | 2 | 0 | 0 | 2 | 1 | 8 | 1 | 79.9 | 1 |
1664 | 3 | 3 | 0 | 0 | 2 | 0 | 11 | 1 | 79.9 | 0 |
1332 | 3 | 2 | 0 | 0 | 2 | 1 | 14 | 0 | 81 | 1 |
1752 | 3 | 3 | 0 | 0 | 2 | 0 | 18 | 1 | 82.8 | 0 |
2167 | 3 | 3 | 1 | 0 | 2 | 1 | 13 | 1 | 84.9 | 0 |
1664 | 3 | 2 | 0 | 0 | 2 | 0 | 9 | 1 | 85 | 0 |
1973 | 4 | 3 | 0 | 0 | 2 | 0 | 13 | 1 | 86 | 0 |
1384 | 3 | 2 | 0 | 0 | 2 | 0 | 5 | 1 | 89.28 | 0 |
1431 | 3 | 2 | 0 | 0 | 2 | 1 | 7 | 1 | 89.9 | 1 |
1950 | 5 | 3 | 0 | 0 | 2 | 0 | 13 | 1 | 90 | 0 |
1452 | 3 | 2 | 0 | 0 | 2 | 1 | 4 | 1 | 92 | 0 |
1829 | 3 | 2 | 0 | 0 | 2 | 0 | 10 | 1 | 92.439 | 1 |
1652 | 4 | 3 | 0 | 0 | 2 | 1 | 7 | 1 | 94.646 | 1 |
1516 | 3 | 2 | 0 | 0 | 2 | 1 | 10 | 1 | 97.293 | 1 |
1998 | 4 | 3 | 0 | 0 | 2 | 1 | 17 | 1 | 98.1 | 1 |
1984 | 4 | 3 | 0 | 0 | 2 | 1 | 9 | 1 | 98.149 | 0 |
1840 | 3 | 3 | 0 | 0 | 2 | 1 | 9 | 1 | 105 | 0 |
1823 | 4 | 3 | 0 | 0 | 2 | 1 | 3 | 1 | 110 | 1 |
2150 | 5 | 3 | 0 | 0 | 2 | 1 | 12 | 1 | 111.9 | 0 |
2096 | 3 | 3 | 0 | 0 | 2 | 1 | 9 | 1 | 113 | 1 |
2212 | 4 | 3 | 0 | 0 | 3 | 1 | 17 | 1 | 124 | 1 |
2375 | 4 | 3 | 0 | 0 | 2 | 1 | 11 | 1 | 133 | 1 |
2809 | 4 | 3 | 0 | 0 | 3 | 1 | 6 | 1 | 195 | 0 |
912 | 4 | 2 | 0 | 1 | 2 | 1 | 19 | 1 | 59 | 0 |
816 | 3 | 2 | 0 | 1 | 2 | 1 | 19 | 0 | 61.5 | 0 |
1008 | 5 | 2 | 0 | 1 | 2 | 1 | 17 | 0 | 63.5 | 0 |
912 | 4 | 2 | 0 | 1 | 2 | 1 | 16 | 1 | 66.95 | 1 |
1008 | 5 | 2 | 0 | 1 | 2 | 1 | 17 | 1 | 68 | 0 |
838 | 4 | 2 | 0 | 1 | 1 | 1 | 11 | 0 | 68.694 | 1 |
1008 | 4 | 3 | 0 | 1 | 2 | 1 | 19 | 1 | 69 | 0 |
1120 | 3 | 2 | 0 | 1 | 2 | 1 | 11 | 1 | 70.452 | 1 |
1242 | 4 | 3 | 0 | 1 | 2 | 1 | 12 | 0 | 75 | 0 |
912 | 4 | 2 | 0 | 1 | 2 | 1 | 18 | 1 | 76.9 | 1 |
1316 | 3 | 2 | 0 | 1 | 2 | 1 | 8 | 1 | 83 | 0 |
1490 | 3 | 2 | 0 | 1 | 2 | 1 | 13 | 1 | 88 | 0 |
1118 | 4 | 3 | 0 | 1 | 2 | 1 | 16 | 1 | 88.879 | 1 |
1278 | 3 | 2 | 0 | 1 | 2 | 1 | 11 | 1 | 89.347 | 0 |
1490 | 3 | 2 | 0 | 1 | 2 | 1 | 10 | 1 | 89.7 | 1 |
1418 | 4 | 2 | 0 | 1 | 2 | 1 | 14 | 1 | 90 | 1 |
1250 | 4 | 3 | 0 | 1 | 2 | 1 | 17 | 1 | 90.8 | 1 |
1881 | 4 | 3 | 0 | 1 | 2 | 1 | 9 | 1 | 91.5 | 1 |
1355 | 3 | 2 | 0 | 1 | 2 | 1 | 7 | 1 | 95 | 1 |
1518 | 3 | 2 | 0 | 1 | 2 | 1 | 22 | 0 | 98 | 1 |
1606 | 4 | 3 | 0 | 1 | 2 | 1 | 13 | 1 | 99.5 | 0 |
2124 | 3 | 2 | 0 | 1 | 2 | 1 | 14 | 1 | 107 | 0 |
2099 | 4 | 3 | 0 | 1 | 2 | 1 | 13 | 1 | 113.75 | 1 |
2232 | 5 | 3 | 0 | 1 | 2 | 1 | 9 | 1 | 125 | 1 |
1608 | 5 | 3 | 0 | 1 | 3 | 1 | 13 | 1 | 132 | 1 |
1320 | 3 | 2 | 0 | 2 | 2 | 1 | 13 | 1 | 76 | 1 |
1680 | 3 | 3 | 0 | 2 | 2 | 0 | 7 | 1 | 79.9 | 1 |
1434 | 3 | 3 | 0 | 2 | 2 | 1 | 12 | 1 | 79.9 | 1 |
1664 | 3 | 2 | 0 | 2 | 2 | 1 | 7 | 1 | 85 | 1 |
1379 | 3 | 2 | 0 | 2 | 2 | 1 | 8 | 1 | 87.158 | 1 |
1634 | 3 | 3 | 0 | 2 | 2 | 1 | 10 | 1 | 87.2 | 1 |
1400 | 3 | 3 | 0 | 2 | 2 | 0 | 1 | 1 | 91.5 | 1 |
1664 | 4 | 4 | 0 | 2 | 2 | 1 | 16 | 1 | 91.5 | 1 |
1548 | 3 | 3 | 0 | 2 | 2 | 1 | 8 | 1 | 92.5 | 1 |
2040 | 4 | 3 | 0 | 2 | 2 | 1 | 15 | 1 | 93.5 | 0 |
1792 | 4 | 3 | 0 | 2 | 2 | 1 | 9 | 1 | 94 | 1 |
1865 | 3 | 3 | 0 | 2 | 2 | 1 | 12 | 1 | 96.7 | 0 |
1833 | 3 | 3 | 0 | 2 | 2 | 1 | 7 | 1 | 97.4 | 1 |
1627 | 3 | 3 | 0 | 2 | 2 | 1 | 3 | 1 | 98.5 | 1 |
2198 | 4 | 3 | 0 | 2 | 2 | 1 | 12 | 1 | 99 | 0 |
1707 | 3 | 3 | 0 | 2 | 2 | 1 | 12 | 1 | 99 | 0 |
2096 | 3 | 3 | 0 | 2 | 2 | 1 | 7 | 1 | 102.4 | 1 |
2004 | 4 | 3 | 0 | 2 | 2 | 1 | 13 | 1 | 104 | 0 |
1818 | 4 | 3 | 0 | 2 | 2 | 1 | 19 | 1 | 107 | 1 |
1935 | 3 | 3 | 0 | 2 | 2 | 1 | 11 | 1 | 107.9 | 1 |
2381 | 3 | 3 | 0 | 2 | 2 | 0 | 17 | 1 | 109 | 1 |
1977 | 3 | 3 | 0 | 2 | 2 | 1 | 9 | 1 | 110 | 1 |
2317 | 5 | 3 | 0 | 2 | 2 | 1 | 9 | 1 | 110.5 | 1 |
2072 | 4 | 3 | 0 | 2 | 2 | 1 | 11 | 1 | 112 | 1 |
2108 | 3 | 3 | 0 | 2 | 2 | 1 | 7 | 1 | 112.9 | 0 |
2060 | 4 | 4 | 0 | 2 | 2 | 1 | 9 | 1 | 113.6 | 1 |
2064 | 3 | 3 | 0 | 2 | 2 | 1 | 5 | 1 | 114.5 | 1 |
2148 | 5 | 4 | 0 | 2 | 2 | 1 | 8 | 1 | 114.7 | 1 |
2170 | 6 | 4 | 0 | 2 | 2 | 1 | 21 | 1 | 115 | 1 |
1984 | 4 | 3 | 1 | 2 | 2 | 1 | 11 | 1 | 121 | 1 |
2130 | 4 | 3 | 0 | 2 | 2 | 1 | 20 | 1 | 121 | 1 |
2049 | 4 | 3 | 0 | 2 | 2 | 1 | 19 | 1 | 125 | 1 |
2035 | 3 | 3 | 0 | 2 | 3 | 1 | 6 | 1 | 128 | 1 |
2264 | 3 | 3 | 0 | 2 | 3 | 1 | 7 | 1 | 130 | 1 |
2264 | 3 | 3 | 0 | 2 | 3 | 1 | 10 | 1 | 131 | 1 |
2362 | 4 | 3 | 0 | 2 | 2 | 1 | 6 | 1 | 132 | 0 |
2262 | 5 | 3 | 0 | 2 | 2 | 1 | 12 | 1 | 132.5 | 1 |
2353 | 4 | 3 | 0 | 2 | 2 | 1 | 5 | 1 | 132.5 | 0 |
2298 | 3 | 3 | 0 | 2 | 3 | 1 | 2 | 1 | 144.5 | 1 |
2282 | 4 | 3 | 0 | 2 | 2 | 1 | 9 | 1 | 150.577 | 1 |
2542 | 4 | 3 | 0 | 2 | 2 | 1 | 6 | 1 | 153.8 | 1 |
2380 | 4 | 3 | 0 | 2 | 2 | 1 | 6 | 1 | 155 | 1 |
2505 | 4 | 3 | 0 | 2 | 2 | 1 | 7 | 1 | 156.9 | 1 |
2804 | 4 | 3 | 0 | 2 | 3 | 1 | 1 | 1 | 192 | 1 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started