As a general rule, the cost of land in small towns and cities is less than in large cities. Consequently, property values and property taxes are also lower. To investigate, a realtor conducted a survey that collected property tax bills along with the size of the city the bill was from. The data is found in the provided file, with information from a fairly large sample.

(a) Conduct a hypothesis test on the slope to determine whether there is evidence of a linear relationship between property tax amount and population size of the city. from the Data Analysis tool select Regression. This will open a window with some options to fill in. Fill in the range for both variables and choose the option to have the output start in a specific cell rather than on a new page. Include the cells with column labels and then select the Labels box so that the plot will be properly labelled. Since it seems most likely that the realtor would want to predict property taxes based on city size, use population as the x variable and tax amount as the y variable. Select the option to show Residual Plots. For your answer to part (a), include a page that shows the summary output tables and the property tax residuals plot. You do not need to verify that all necessary conditions have been met.

(b) For the hypothesis test in part (a), state the null and alternative hypotheses, the observed value of the test statistic, and the p-value.

(c) What percentage of the variation in tax amount is explained by the variation in population?

(d) If you decide to use the simple linear regression line obtained from the output in part (a), what is the equation of the regression line?

Put the bottom data into excel

Property Tax	Population Size
914.15	68,545
3,240.17	1,021,928
3,531.04	447,874
3,894.60	218,402
1,539.15	8,582
5,023.79	1,591,357
4,293.88	425,420
2,856.17	540,414
3,328.82	24,481
3,373.67	850,558
3,315.01	1,942,335
3,345.33	32,987
3,457.99	41,223
2,169.43	227,910
3,114.14	752,503
2,209.18	1,127,354
1,953.24	3,638,798
2,705.09	3,470,336
4,618.74	116,084
3,459.00	4,650,258
2,932.64	509,125
3,701.01	380,581
3,761.59	26,287
471.47	876,858
3,239.43	1,995,163
2,443.64	1,503,052
2,676.08	6,405,927
1,446.78	462,455
4,992.25	2,717,444
1,819.28	680,860
4,410.32	881,619
3,127.89	15,057
5,370.37	6,908,200
2,823.45	710,822
3,251.18	262,246
3,010.20	21,029
1,985.84	3,404,187
4,222.88	823,984
4,386.39	454,627
1,875.21	62,087
2,177.59	320,383
4,181.09	907,987
1,840.23	46,843
3,648.95	3,210,852
4,034.76	792,879
3,207.18	818,285
2,419.08	371,632
1,144.22	696,608
4,028.54	4,265,191
2,034.40	11,749
4,253.57	560,831
2,721.75	661,222
1,699.99	139,216
3,082.42	749,733
2,497.95	109,276
4,198.50	62,500
1,343.10	3,686,865
1,475.34	145,745
2,243.34	3,664,434
2,571.52	232,052
2,920.40	3,604,465
4,725.27	6,402,264
961.17	35,735
4,585.15	106,798
2,186.88	84,623
3,716.40	764,359
2,856.12	1,851,695
3,878.76	38,828
5,057.65	1,915,738
3,575.99	4,301,050
3,255.53	1,904,935
1,758.57	403,974
2,687.70	639,889
4,178.02	38,490
3,388.45	6,287,088
2,096.07	189,317
1,711.95	64,899
161.66	1,191,671
3,472.11	9,587
3,294.41	1,922,605
4,858.18	2,280,633
2,006.51	206,970
3,136.74	1,339,442
2,901.52	472,686
3,220.71	6,758,049
5,750.84	6,902,615
2,909.99	175,816
2,977.54	6,395,764
2,158.71	1,397,305
3,375.93	4,700,995
718.25	5,346,904
4,169.67	234,940
3,261.71	661,359
3,059.90	768,227
3,797.13	4,338,816
2,928.78	54,877
2,205.82	457,694
4,075.76	1,833,750
2,910.47	358,539
3,405.92	3,193,991
2,954.93	5,353,862
2,868.99	21,948
3,732.23	2,188,528
5,613.07	5,853,755
3,235.26	718,329
3,836.68	4,548,479
3,676.83	591,937
2,933.15	931,333
2,534.04	819,750
2,101.49	937,582
3,991.81	4,407,025
2,531.56	29,320
3,621.28	7,017,151
1,988.32	1,304,376
2,760.31	799,242
2,647.22	71,126
2,797.88	253,548
2,613.03	347,507
3,467.63	5,278,512
3,995.72	5,174,505
3,027.24	2,243,782
3,178.27	198,703
3,458.95	1,443,724
1,509.29	3,924,223
3,785.78	995,239
2,461.24	203,564
3,235.32	911,969
2,808.67	3,097,324
1,881.43	41,543
2,020.13	415,464
3,661.92	6,363,903
2,561.89	5,880,215
1,804.98	2,104,572
4,085.33	50,247
4,517.37	77,562
2,471.60	12,619
2,252.30	1,746,635
2,710.38	24,663
3,499.69	225,091
2,102.49	2,210,959
3,549.16	411,184
3,542.96	17,518
4,283.51	1,120,441
4,273.13	370,441
1,132.02	2,046,571
2,453.90	1,632,603
2,128.03	332,766
2,868.25	3,390,072
2,224.24	1,338,755
5,084.74	6,268,227
2,213.99	2,399,838
4,042.83	257,714
1,788.22	607,822
4,211.32	2,846,385
3,150.15	7,771,935
3,442.32	144,017
2,313.43	365,474
1,988.94	60,113
2,502.25	2,825,327
2,738.30	518,899
2,029.81	1,607,334
3,284.21	499,397
2,166.19	11,013
3,119.55	998,878
4,390.72	7,034,639
4,083.09	4,786,218
2,614.80	38,532
4,402.65	875,851
2,813.47	1,348,094
3,517.06	422,994
5,405.94	3,218,940
2,990.10	3,009,430
5,152.74	3,666,265
826.96	1,233
3,232.73	4,082,690
3,545.96	16,199
2,077.86	1,702,414
1,186.69	845,500
3,660.35	243,466
1,588.52	5,955,107
3,454.80	790,498
3,220.17	3,143,635
1,395.84	31,429
2,804.51	492,531
2,517.30	35,224
3,927.95	894,208
2,234.43	7,687,613
2,672.93	95,531
4,896.75	4,176,687
4,372.97	4,751,350
3,314.82	785,073
4,599.36	5,546,953
2,399.51	1,545,305
2,419.61	189,244
3,063.75	2,083
2,171.06	62,581
2,258.90	4,810,251
4,217.08	957,907
5,565.18	7,762,230
2,622.36	490,631
3,262.15	5,543,565
2,663.28	1,911,252
2,495.82	181,701
731.74	214,800
1,290.90	239,182
1,625.38	317,316
2,744.71	3,301,569
2,849.33	323,038
2,631.10	7,906
2,289.67	3,285,318
1,663.90	303,217
3,269.93	33,528
2,781.40	1,007,279
4,310.15	5,304,880
2,975.50	4,361,171
1,929.27	27,361
2,732.45	3,593,402
3,130.76	1,879,574
3,278.48	4,642,018
1,865.09	53,052
715.48	1,280,206
3,629.49	248,868
2,906.46	86,483
4,201.70	6,233,436
2,724.44	167,595
3,255.36	980,773
3,749.46	4,965,896
2,241.79	1,239,738
3,289.26	6,070,559
4,251.34	979,583
1,917.97	2,135,746
3,012.10	1,828,394
2,077.54	46,158
2,717.00	1,952,040
3,906.30	122,409
2,046.31	178,104
3,482.55	6,430,738
4,302.23	858,684
6,400.43	6,956,084
3,467.57	359,684
2,163.19	2,067,171
3,750.52	2,753,685
2,492.61	12,685
1,358.05	878,140
2,454.13	257,141
2,601.76	2,578,661
4,624.26	5,897,702
3,617.61	168,100
4,382.42	1,154,042
1,889.71	631,146
1,224.85	1,982,711
2,735.92	141,171
1,861.77	665,593
2,345.10	23,655
2,155.70	26,464
2,451.84	4,546,266
3,829.28	7,276,162
2,221.54	2,226,753
3,269.78	1,322,871
1,321.94	1,540,086
2,609.36	4,827,647
2,364.44	5,455,672
1,636.05	4,528,642
4,790.75	947,195
3,796.35	422,308
2,031.85	1,717,383
3,165.59	178,981
3,836.23	1,392,270
1,138.15	1,450,865
1,792.77	781,228
3,437.17	469,527
1,773.16	1,775,979
4,445.68	7,555,498
6,039.76	5,718,436
3,909.25	28,542
3,025.97	1,608,844
4,398.50	7,377,606
2,830.89	6,052,522
1,675.76	1,607,379
975.74	77,505
2,093.84	2,603,763
2,051.20	25,564
3,101.40	2,081,637
3,264.05	6,653,493
2,640.54	354,122
3,455.05	5,093,936
4,504.31	5,441,115
3,383.10	7,905,423
3,260.01	6,636,280
5,707.67	1,376,751
5,039.21	6,780,114
4,012.72	3,862,423
3,140.03	258,400
3,510.38	443,274
3,019.10	623,363
3,201.39	250,114
1,431.92	636,914
2,524.19	119,121
5,289.10	5,157,018
1,697.71	501,480
1,641.94	5,400,098
2,117.78	658,887
2,468.62	1,129,093
2,391.29	547,235
2,621.04	399,167
3,047.68	102,660
1,512.39	1,891,293
4,404.34	4,994,659
2,655.28	76,853
3,340.60	690,313
2,180.47	2,358,318
4,211.62	5,986,602
3,755.94	596,126
3,128.52	2,432,844
4,141.60	4,652,394
3,725.31	7,851,131
2,192.81	79,482
2,138.71	355,312
1,590.35	7,599,536
2,822.07	907,346
3,019.77	782,121
3,123.15	7,755,913
2,332.78	6,130,528
5,989.53	2,276,605
856.13	295,663
4,084.65	7,933,164
1,590.70	80,128
2,382.56	464,949
3,761.67	2,222,083
4,478.33	790,841
3,109.93	5,535,875
1,033.31	2,198,325
1,792.51	438,307
2,629.51	87,423
2,817.87	3,999,908
1,160.78	359,912
2,252.41	2,317,484
2,565.72	873,997
3,326.40	1,980,972
2,676.57	53,570
2,839.60	370,121
2,756.57	1,723,975
4,319.20	75,214
3,705.98	833,850
3,176.49	492,531
1,811.73	2,787,408
4,914.66	7,851,772
5,420.01	7,391,980
3,107.07	837,970
1,681.47	755,524
1,696.03	1,739,082
3,446.05	740,371
3,930.60	5,909,146
3,709.95	6,989,319
4,506.33	3,906,598
4,857.81	7,578,570
2,427.89	943,899
3,002.34	985,122
3,895.12	60,978
3,902.90	405,370
3,006.95	749,207
2,190.85	7,299,966
3,002.82	3,511,231
4,143.53	121,145
3,255.29	5,456,587
4,409.69	7,480,239
4,498.48	3,580,126
1,212.47	17,198
2,142.31	1,372,814
3,603.83	7,099,277
2,290.10	678,182
2,887.36	7,926,115
2,818.40	113,019
644.80	506,767
3,731.13	205,492
5,917.51	6,160,192
2,744.84	6,174,657
2,429.47	532,884
1,198.45	6,769,951
3,384.14	6,364,269
3,586.19	3,817,179
3,044.76	558,954
1,584.20	2,024,552
2,810.80	3,069,704
2,492.82	3,996,323
3,072.07	791,070
2,052.72	3,752,022
1,261.71	98,046
3,428.22	456,687
4,202.68	591,548
3,320.21	2,462,050
2,113.12	3,076,495
1,364.45	6,168,889
2,516.65	3,111,209
4,538.18	4,044,923
3,596.75	2,360,973
2,864.31	3,620,182
1,610.47	3,329,264
3,988.80	116,088
1,622.67	393,010
2,671.29	2,247,169
2,533.87	44,367
5,250.73	94,804
3,260.01	2,806,330
2,629.14	564,379
4,735.09	4,878,994
4,635.56	2,900,937
2,849.82	5,000,000
2,552.30	7,124,088
3,799.68	61,492
2,943.17	496,994
2,222.03	6,912,687
1,530.51	88,015
3,801.36	1,645,192
3,163.66	503,883
3,424.53	743,851
3,656.38	5,245,735
2,720.69	152,662
3,846.30	1,473,891
3,509.26	118,289
4,067.61	17,085
1,110.75	90,461
4,126.81	5,999,329
1,678.99	768,296
3,805.64	4,308,756
2,392.11	1,872,295
3,921.40	3,650,090
4,328.73	4,695,425
3,864.07	901,738
4,307.64	2,229,591
3,518.15	470,786
300.21	3,379,620
2,854.18	1,116,550
3,748.35	1,108,997
4,186.13	1,758,217
2,877.99	1,675,130
3,329.84	2,891,781
2,174.90	439,840
1,296.99	138,288
3,467.34	3,283,258
4,218.25	3,718,604
3,142.45	1,909,970
5,139.75	7,304,361
3,918.38	6,226,386
1,446.47	81,483
3,607.50	682,211
703.81	188,708
1,206.37	863,193
1,504.15	862,415
3,456.87	4,207,892
2,010.03	2,714,698
3,597.02	2,806,177
4,973.37	5,992,279
5,802.68	6,485,488
3,388.88	7,212,073
4,066.26	6,156,346
4,881.58	4,769,356
2,608.82	7,307,749
1,296.30	301,248
3,069.65	6,242,225
2,197.70	4,091,998
3,179.74	85,362
3,718.37	4,968,642
3,410.45	3,275,628
2,440.28	887,616
3,325.12	36,345
2,568.52	6,024,598
2,887.15	2,921,766
4,434.74	7,464,309
4,513.96	787,843
3,247.91	648,129
4,732.97	5,393,048
3,260.54	367,168
3,221.14	603,450
4,564.03	4,181,799
3,313.43	7,164,647
1,488.40	671,155
2,900.24	6,499,496
2,201.23	46,024
3,968.03	4,004,791
4,170.08	861,614
3,254.31	3,351,009
2,702.05	521,760
1,684.02	1,986,969
3,049.34	6,819,117
3,221.01	1,821,940
2,470.97	737,854
4,078.99	96,314
2,070.50	5,888,730
2,537.25	3,475,066
1,368.07	16,074
4,004.24	6,656,148
5,094.32	2,136,799
2,683.28	64,591
3,115.10	6,391,461
3,432.29	744,743
3,768.08	6,889,340
2,504.74	23,608
2,248.98	66,298
2,618.69	220,111
2,758.26	7,125,095
3,523.42	254,326
3,446.11	5,983
1,918.91	23,123
3,884.43	37,676
3,569.02	4,630,116
2,375.14	2,094,821
936.68	777,886
5,539.60	4,529,633
3,890.48	2,196,127
4,704.31	48,398
2,047.86	783,288
2,661.82	7,814,966
2,543.16	3,375,729
2,118.81	1,839,930
4,045.03	3,732,871
3,825.38	47,100
3,201.83	5,264,321
4,712.63	1,640,660
3,597.65	1,949,889
2,577.72	1,910,611
1,913.48	177,385
2,684.01	6,360,057
4,760.16	5,421,705
2,750.66	79,006
2,180.24	523,614
3,178.74	7,671,407
2,997.89	7,119,419
4,084.30	5,039,827
3,166.73	5,136,967
3,685.52	971,114
1,227.99	337,046
2,782.31	1,952,177
1,896.69	972,877
1,614.56	941,748
3,404.59	5,493,301
3,815.80	6,211,829
2,417.90	5,307,260
4,801.55	2,755,516
5,225.47	7,097,720
1,736.99	940,512
3,451.88	532,243
2,906.87	2,443,968
3,682.73	631,924
4,727.28	7,885,830
4,588.20	21,583
1,580.28	5,674,490
1,447.74	4,320
4,041.86	227,028
4,322.69	2,661,748
3,313.66	7,697,317
2,720.71	6,903,623
3,628.42	272,225
4,127.53	2,762,993
4,595.06	46,783
3,274.53	769,875
1,637.17	664,747
4,290.84	6,810,144
3,262.70	666,326
1,996.98	833,163
3,356.50	7,526,109
3,170.45	608,325
2,572.06	676,260
3,193.54	5,056,398
2,731.58	1,758,263
3,262.54	5,139,348
2,283.07	5,522,874
4,655.89	7,241,188
5,506.60	7,013,947
3,352.09	7,028,138
2,588.85	6,602,954
5,161.89	5,059,236
1,942.69	266,961
2,451.23	6,914,884
2,942.22	79,793