In: Math
The accompanying data file shows the square footage and associated property taxes for 20 homes in an affluent suburb 30 miles outside of New York City. Estimate a home’s property taxes as a linear function of its square footage. At the 5% significance level, is square footage significant in explaining property taxes? Show the relevant steps of the test.
Please use Minitab and explain the various steps involved.
Property Taxes | Square Footage |
21928 | 2449 |
17339 | 2479 |
18229 | 1890 |
15693 | 1000 |
43988 | 5665 |
33684 | 2573 |
15187 | 2200 |
16706 | 1964 |
18225 | 2092 |
16073 | 1380 |
15187 | 1330 |
36006 | 3016 |
31043 | 2876 |
42007 | 3334 |
14398 | 1566 |
38968 | 4000 |
25362 | 4011 |
22907 | 2400 |
16200 | 3565 |
29235 | 2864 |
Using Minitab, (Stat -> Regression -> Regression -> Fit Regression Model), we get the following output -
Testing whether square footage significant in explaining property taxes,
We get the T value = 4.94
and P-value = 0
Since P-value < 0.05, so we reject the null hypothesis at 5% level of significance and we conclude that square footage significant in explaining property taxes.