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 biggest determining the value of a home square footage accompanying data represent the square footage...
The biggest determining the value of a home square footage accompanying data represent the square footage and selling price for a random sample of homes for sale in a certain region Sample Footage, x. Selling Price ($000s), y 2292. 393.8 3216 381.5 1074 181.5 1948 333.8 3196 634 2670 354 4126 629.7 2126 363.8 2637 429.4 1707 298.1 1855 281.9 3930 708.6 a.) determine the linear correlation coefficient between square footage and asking price b.) find the least squares regression...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT