Question

In: Math

The accompanying data file shows the square footage and associated property taxes for 20 homes in...

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

Solutions

Expert Solution

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.


Related Solutions

The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21972 2330 17347 2427 18263 1873 15636 1098 43971 5639 33623 2429 15188 2332 16750 1898 18236 2108 16089 1245 15126 1227 36053 3027 31050 2814 42032 3329 14362 1635 38961 4074 25312 4016 22960 2470 16162...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21987 2352 17343 2362 18279 1776 15645 1118 43954 5712 33653 2592 15105 2134 16749 1905 18239 2024 16048 1389 15135 1381 36016 3028 31083 2771 42000 3374 14370 1556 38953 3971 25373 3934 22971 2321 16169...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21913 2357 17307 2531 18258 1906 15606 1061 43962 5639 33679 2520 15197 2165 16733 1825 18211 2139 16061 1268 15194 1261 36018 3060 31036 2869 42098 3448 14377 1574 38934 3919 25341 3949 22969 2514 16241...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21928 2438 17356 2455 18214 1871 15652 1063 43957 5715 33631 2567 15131 2260 16698 1824 18277 2010 16038 1438 15198 1337 36089 3049 31008 2843 42044 3411 14414 1454 38940 4057 25329 3939 22907 2505 16152...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21922 2446 17362 2521 18285 1732 15662 1039 43973 5633 33629 2523 15195 2163 16693 1938 18247 2061 16036 1267 15163 1306 36002 3034 31043 2880 42063 3376 14432 1491 38914 3943 25383 3930 22991 2390 16236...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21922 2446 17362 2521 18285 1732 15662 1039 43973 5633 33629 2523 15195 2163 16693 1938 18247 2061 16036 1267 15163 1306 36002 3034 31043 2880 42063 3376 14432 1491 38914 3943 25383 3930 22991 2390 16236...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. a. Estimate the sample regression equation that enables us to predict property taxes on the basis of the size of the home. (Round your answers to 2 decimal places.) Taxes= [ ] + [ ]Size c. Predict the property...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. Taxes Size 21934 2345 17334 2434 18262 1903 15646 1103 43973 5739 33660 2572 15119 2374 16702 1828 18230 2017 16038 1338 15140 1246 36030 3042 31034 2849 42077 3447 14364 1451 38925 3953 25378 3951 22956 2523 16216...
The accompanying table shows a portion of a data set that refers to the property taxes...
The accompanying table shows a portion of a data set that refers to the property taxes owed by a homeowner (in $) and the size of the home (in square feet) in an affluent suburb 30 miles outside New York City. 21918 2359 17318 2340 18284 1936 15624 1094 43998 5664 33670 2577 15158 2139 16691 1856 18278 2052 16070 1357 15181 1222 36077 3110 31037 2782 42061 3446 14365 1524 38971 3976 25313 4014 22984 2332 16210 3586 29229...
The data is the square footage and selling price of single-family homes for the month of...
The data is the square footage and selling price of single-family homes for the month of February and the first week of March. Square Footage Selling Price 1746 129320 1764 97000 676 35000 2788 400000 1944 68000 1960 117000 1056 148400 1564 35000 1100 165000 1120 114480 4080 175000 1442 65000 1937 60000 1900 18000 1150 258000 1650 134800 1953 30000 2424 69100 512 63000 1540 82500 1200 50000 1316 37500 1840 69000 3500 270000 5000 485000 1564 27000 1018...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT