Could I please get a step-by step for this? DO NOT GIVE ME THE ANSWERS, PLEASE. I simply want to know how to go about solving it myself, such as how to get each number for each equation or how to place it in an Excel or Word equation Thanks in advance. Here is the prompt:

You have been hired by the D. M. Pan National Real Estate Company to develop a model to predict housing prices for homes sold in 2019. The CEO of D. M. Pan wants to use this information to help their real estate agents better determine the use of square footage as a benchmark for listing prices on homes. Your task is to provide a report predicting the housing prices based square footage. To complete this task, use the provided real estate data set for all U.S. home sales as well as national descriptive statistics and graphs provided.

Directions

Using the Project One Template, generate a report including your tables and graphs to determine if the square footage of a house is a good indicator for what the listing price should be. Reference the National Statistics and Graphs document for national comparisons and the Real Estate Dataspreadsheet (both found in the Supporting Materials section) for your statistical analysis.

Note: Present your data in a clearly labeled table and using clearly labeled graphs.

Specifically, include the following in your report:

Introduction

1. Describe the report:Give a brief description of the purpose of your report.
   1. Define the question your report is trying to answer.
   2. Explain when using linear regression is most appropriate.
      1. When using linear regression, what would you expect the scatterplot to look like?
   3. Explain the difference between response and predictor variables in a linear regression to justify the selection of variables.

Data Collection

1. Sampling the data: Select a random sample of 50 houses.
   1. Identify your response and predictor variables.
2. Scatterplot: Create a scatterplot of your response and predictor variables to ensure they are appropriate for developing a linear model.

Data Analysis

1. Histogram: For your two variables, create histograms.
2. Summary statistics: For your two variables, create a table to show the mean, median, and standard deviation.
3. Interpret the graphs and statistics:
   1. Based on your graphs and sample statistics, interpret the center, spread, shape, and any unusual characteristic (outliers, gaps, etc.) for the two variables.
   2. Compare and contrast the shape, center, spread, and any unusual characteristic for your sample of house sales with the national population. Is your sample representative of national housing market sales?

Develop Your Regression Model

1. Scatterplot: Provide a graph of the scatterplot of the data with a line of best fit.
   1. Explain if a regression model is appropriate to develop based on your scatterplot.
2. Discuss associations: Based on the scatterplot, discuss the association (direction, strength, form) in the context of your model.
   1. Identify any possible outliers or influential points and discuss their effect on the correlation.
   2. Discuss keeping or removing outlier data points and what impact your decision would have on your model.
3. Find r: Find the correlation coefficient (r).
   1. Explain how the r value you calculated supports what you noticed in your scatterplot.

Determine the Line of Best Fit. Clearly define your variables. Find and interpret the regression equation. Assess the strength of the model.

1. Regression equation: Write the regression equation (i.e., line of best fit) and clearly define your variables.
2. Interpret regression equation: Interpret the slope and intercept in context.
3. Strength of the equation: Provide and interpret R-squared.
   1. Determine the strength of the linear regression equation you developed.
4. Use regression equation to make predictions: Use your regression equation to predict how much you should list your home for based on the square footage of your home.

Conclusions

1. Summarize findings: In one paragraph, summarize your findings in clear and concise plain language for the CEO to understand. Summarize your results.
   1. Did you see the results you expected, or was anything different from your expectations or experiences?
      1. What changes could support different results, or help to solve a different problem?
      2. Provide at least one question that would be interesting for follow-up research.

Here is the Project One Template:

Introduction

[Describe the report:Include in this section a brief overview, including the purpose of the report and your approach.]

Data Collection

[Sampling the data:Outline how you obtained your sample data, including the response and predictor variables.]

[Scatterplot:Insert a correctly labeled scatterplot of your chosen variables.]

Data Analysis

[Histogram:Insert the histogram of the two variables. Be sure to include appropriate labels.]

[Summary statistics:Insert a table to show the summary statistics.]

[Interpret the graphs and statistics:Describe the shape, center, spread, and any unusual characteristic (outliers, gaps, etc.) and what they mean based on your sample data and the graphs you created.]

[Explain how these characteristics of the sample data compare to the same characteristics of the national population. Also, determine whether your sample is representative of the national housing market sales.]

The Regression Model

[Scatterplot:Include the scatterplot graph of the sample with a line of best fit and the regression equation.]

[Based on your graph, explain whether a regression model can be developed for the data and how.]

[Discuss associations:Explain the associations in the scatterplot, including the direction, strength, form in the context of your model.]

[Find r:Calculate the correlation coefficient and explain how it aligns with your interpretation of the data from the scatterplot.]

The Line of Best Fit

[Regression equation:Insert the regression equation.]

[Interpret regression equation:Interpret the slope and intercept in context.]

[Strength of the equation:Interpret the strength of the regression equation, R-squared.]

[Use regression equation to make predictions:Use the regression equation to make a sample prediction.]

Conclusions

[Summarize findings:Summarize your findings in clear and concise plain language. Outline any questions arising from the study that might be interesting for follow-up research.]

Real Estate Data (Warning: This spreadsheet is rather large):

Real Estate County Data for 2019
2019 Data (n=1000)
Region	State	County	listing price	$'s per square foot	square feet
East North Central	in	grant	219,500	$116	1,898
East North Central	il	vermilion	254,500	$156	1,632
East North Central	in	henry	235,000	$148	1,588
East North Central	in	wayne	203,800	$141	1,441
East North Central	il	coles	220,800	$117	1,893
East North Central	il	macoupin	197,600	$111	1,783
East North Central	in	vigo	165,800	$122	1,362
East North Central	oh	jefferson	246,500	$136	1,814
East North Central	il	jackson	154,300	$105	1,463
East North Central	oh	marion	149,700	$116	1,296
East North Central	mi	bay	145,100	$117	1,239
East North Central	il	whiteside	283,700	$136	2,087
East North Central	oh	trumbull	243,000	$133	1,827
East North Central	in	madison	229,100	$187	1,224
East North Central	il	knox	205,100	$118	1,740
East North Central	il	stephenson	235,600	$140	1,682
East North Central	il	macon	212,900	$128	1,659
East North Central	in	delaware	221,600	$134	1,651
East North Central	il	henry	257,700	$123	2,087
East North Central	oh	seneca	211,900	$168	1,263
East North Central	oh	darke	160,800	$114	1,416
East North Central	oh	scioto	204,200	$131	1,562
East North Central	oh	belmont	172,500	$101	1,710
East North Central	oh	sandusky	253,900	$146	1,738
East North Central	il	rock island	166,300	$127	1,305
East North Central	oh	clark	240,500	$137	1,752
East North Central	oh	columbiana	241,400	$164	1,469
East North Central	in	howard	304,300	$152	1,996
East North Central	oh	richland	248,900	$132	1,880
East North Central	il	peoria	187,900	$131	1,434
East North Central	il	la salle	311,100	$154	2,015
East North Central	il	madison	254,500	$156	1,628
East North Central	mi	wayne	213,800	$172	1,243
East North Central	in	vanderburgh	214,100	$134	1,596
East North Central	oh	mahoning	207,500	$123	1,688
East North Central	il	williamson	171,600	$141	1,218
East North Central	il	winnebago	236,700	$140	1,692
East North Central	il	adams	266,100	$166	1,599
East North Central	mi	saginaw	171,800	$118	1,452
East North Central	oh	montgomery	225,300	$151	1,493
East North Central	oh	allen	227,600	$147	1,550
East North Central	oh	lucas	228,300	$115	1,978
East North Central	oh	ashtabula	177,000	$107	1,658
East North Central	oh	lawrence	248,300	$156	1,587
East North Central	oh	huron	199,700	$147	1,359
East North Central	il	tazewell	278,700	$165	1,693
East North Central	oh	summit	185,800	$101	1,847
East North Central	il	sangamon	213,500	$130	1,643
East North Central	oh	ashland	188,000	$151	1,246
East North Central	oh	tuscarawas	270,700	$149	1,815
East North Central	oh	ross	257,200	$127	2,018
East North Central	mi	shiawassee	192,400	$129	1,494
East North Central	mi	calhoun	266,200	$130	2,042
East North Central	il	kankakee	148,700	$115	1,293
East North Central	in	lawrence	270,600	$137	1,978
East North Central	wi	manitowoc	181,400	$140	1,294
East North Central	il	st. clair	201,400	$164	1,225
East North Central	mi	ingham	222,500	$125	1,777
East North Central	il	mclean	203,800	$134	1,526
East North Central	mi	jackson	139,200	$116	1,201
East North Central	mi	isabella	163,000	$125	1,307
East North Central	wi	wood	266,500	$144	1,853
East North Central	mi	montcalm	218,300	$105	2,081
East North Central	wi	grant	243,200	$121	2,014
East North Central	oh	cuyahoga	265,100	$136	1,947
East North Central	oh	stark	201,000	$163	1,230
East North Central	oh	athens	246,400	$158	1,560
East North Central	wi	milwaukee	184,900	$111	1,666
East North Central	mi	lenawee	191,500	$118	1,628
East North Central	wi	fond du lac	135,300	$103	1,312
East North Central	in	st. joseph	193,000	$111	1,736
East North Central	mi	ionia	193,600	$137	1,416
East North Central	mi	genesee	194,800	$166	1,173
East North Central	oh	muskingum	188,300	$94	1,999
East North Central	il	ogle	236,600	$208	1,138
East North Central	oh	washington	324,400	$156	2,081
East North Central	oh	wayne	256,700	$129	1,986
East North Central	mi	muskegon	230,400	$131	1,757
East North Central	oh	pickaway	265,700	$143	1,853
East North Central	mi	st. joseph	188,500	$135	1,397
East North Central	il	champaign	246,700	$121	2,031
East North Central	oh	knox	192,200	$127	1,510
East North Central	oh	lorain	226,200	$126	1,789
East North Central	wi	calumet	226,400	$111	2,033
East North Central	mi	midland	174,500	$151	1,157
East North Central	mi	marquette	172,500	$120	1,433
East North Central	in	elkhart	202,300	$182	1,113
East North Central	mi	monroe	228,600	$136	1,679
East North Central	oh	lake	225,900	$135	1,676
East North Central	mi	eaton	189,900	$96	1,976
East North Central	wi	douglas	461,400	$129	3,581
East North Central	wi	marathon	431,200	$119	3,638
East North Central	il	dekalb	347,500	$97	3,574
East North Central	in	marion	323,300	$95	3,408
East North Central	in	allen	398,000	$113	3,525
East North Central	oh	hancock	380,300	$94	4,028
East North Central	in	lake	470,600	$109	4,316
East North Central	wi	portage	531,000	$109	4,888
East North Central	wi	rock	513,100	$104	4,950
East North Central	oh	greene	581,800	$113	5,146
West South Central	ar	baxter	286,900	$132	2,176
West South Central	ar	benton	232,900	$138	1,690
West South Central	ar	craighead	251,100	$110	2,285
West South Central	ar	crawford	172,900	$100	1,734
West South Central	ar	crittenden	298,800	$155	1,928
West South Central	ar	faulkner	280,500	$129	2,168
West South Central	ar	garland	274,800	$134	2,056
West South Central	ar	jefferson	314,600	$144	2,179
West South Central	ar	lonoke	289,000	$132	2,190
West South Central	ar	pope	273,200	$114	2,389
West South Central	ar	pulaski	211,300	$121	1,745
West South Central	ar	saline	273,500	$114	2,396
West South Central	ar	sebastian	208,600	$111	1,879
West South Central	ar	washington	215,600	$126	1,712
West South Central	ar	white	254,800	$145	1,763
West South Central	la	acadia	226,300	$135	1,681
West South Central	la	ascension	303,200	$149	2,030
West South Central	la	bossier	305,500	$140	2,177
West South Central	la	caddo	278,500	$158	1,768
West South Central	la	calcasieu	214,300	$115	1,871
West South Central	la	east baton rouge	254,100	$135	1,881
West South Central	la	iberia	188,700	$125	1,511
West South Central	la	jefferson	306,100	$131	2,344
West South Central	la	lafayette	221,000	$108	2,040
West South Central	la	lafourche	297,000	$128	2,320
West South Central	la	livingston	297,300	$139	2,135
West South Central	la	orleans	258,600	$152	1,698
West South Central	la	ouachita	304,300	$158	1,921
West South Central	la	rapides	347,800	$151	2,297
West South Central	la	st. charles	171,400	$99	1,724
West South Central	la	st. landry	254,700	$118	2,150
West South Central	la	st. martin	252,600	$137	1,845
West South Central	la	st. mary	260,400	$141	1,842
West South Central	la	st. tammany	280,300	$150	1,869
West South Central	la	tangipahoa	242,300	$110	2,202
West South Central	la	terrebonne	254,700	$156	1,637
West South Central	la	vermilion	270,600	$164	1,650
West South Central	la	vernon	255,900	$113	2,256
West South Central	ok	canadian	218,000	$95	2,290
West South Central	ok	carter	263,000	$142	1,856
West South Central	ok	cherokee	302,100	$167	1,809
West South Central	ok	cleveland	263,800	$117	2,262
West South Central	ok	comanche	252,100	$140	1,806
West South Central	ok	creek	362,200	$157	2,305
West South Central	ok	garfield	220,300	$132	1,670
West South Central	ok	grady	229,500	$158	1,455
West South Central	ok	le flore	292,200	$128	2,291
West South Central	ok	muskogee	206,400	$125	1,646
West South Central	ok	oklahoma	219,000	$121	1,804
West South Central	ok	osage	194,800	$129	1,515
West South Central	ok	payne	272,200	$124	2,204
West South Central	ok	pottawatomie	204,800	$136	1,510
West South Central	ok	rogers	183,700	$104	1,769
West South Central	ok	tulsa	295,000	$130	2,267
West South Central	ok	wagoner	209,100	$134	1,560
West South Central	ok	washington	167,100	$110	1,526
West South Central	tx	angelina	270,200	$172	1,568
West South Central	tx	bastrop	179,600	$103	1,736
West South Central	tx	bell	323,100	$143	2,262
West South Central	tx	bexar	260,800	$111	2,359
West South Central	tx	bowie	223,600	$153	1,463
West South Central	tx	brazoria	246,300	$130	1,900
West South Central	tx	brazos	242,500	$132	1,835
West South Central	tx	cameron	269,200	$151	1,781
West South Central	tx	collin	374,700	$161	2,325
West South Central	tx	comal	249,200	$165	1,510
West South Central	tx	coryell	184,100	$126	1,460
West South Central	tx	dallas	279,600	$144	1,940
West South Central	tx	denton	254,500	$124	2,052
West South Central	tx	ector	151,300	$102	1,477
West South Central	tx	el paso	249,200	$123	2,023
West South Central	tx	ellis	163,400	$112	1,459
West South Central	tx	fort bend	222,800	$114	1,958
West South Central	tx	galveston	296,100	$139	2,127
West South Central	tx	grayson	248,700	$135	1,837
West South Central	tx	gregg	188,200	$112	1,679
West South Central	tx	guadalupe	263,800	$146	1,804
West South Central	tx	hardin	283,500	$152	1,867
West South Central	tx	harris	196,200	$115	1,700
West South Central	tx	harrison	255,300	$107	2,396
West South Central	tx	hays	230,000	$154	1,490
West South Central	tx	henderson	285,700	$122	2,343
West South Central	tx	hidalgo	224,600	$121	1,853
West South Central	tx	hood	207,200	$91	2,278
West South Central	tx	hunt	306,900	$133	2,299
West South Central	tx	jefferson	213,500	$99	2,154
West South Central	tx	johnson	234,900	$115	2,040
West South Central	tx	kaufman	264,300	$134	1,977
West South Central	tx	kerr	262,900	$139	1,888
West South Central	tx	liberty	206,400	$113	1,822
West South Central	tx	lubbock	476,700	$133	3,583
West South Central	tx	mclennan	407,300	$104	3,920
West South Central	tx	midland	515,000	$141	3,648
West South Central	tx	montgomery	480,300	$116	4,142
West South Central	tx	nacogdoches	630,800	$124	5,107
West South Central	tx	nueces	496,200	$115	4,310
West South Central	tx	orange	610,600	$118	5,196
West South Central	tx	parker	727,900	$122	5,962
West South Central	tx	potter	726,800	$126	5,777
West South Central	tx	randall	476,700	$90	5,284
East South Central	al	autauga	289,800	$117	2,468
East South Central	al	baldwin	197,100	$120	1,646
East South Central	al	blount	214,200	$116	1,846
East South Central	al	calhoun	257,100	$148	1,738
East South Central	al	coffee	297,200	$129	2,295
East South Central	al	colbert	219,900	$111	1,987
East South Central	al	cullman	239,500	$121	1,978
East South Central	al	dale	317,500	$123	2,579
East South Central	al	elmore	262,700	$114	2,313
East South Central	al	etowah	167,700	$71	2,372
East South Central	al	houston	263,700	$103	2,549
East South Central	al	jackson	284,900	$118	2,417
East South Central	al	jefferson	317,300	$135	2,351
East South Central	al	lauderdale	291,600	$137	2,130
East South Central	al	lee	291,100	$162	1,792
East South Central	al	limestone	248,800	$144	1,733
East South Central	al	madison	252,500	$115	2,199
East South Central	al	marshall	233,700	$134	1,743
East South Central	al	mobile	316,900	$128	2,476
East South Central	al	montgomery	298,500	$136	2,200
East South Central	al	morgan	285,500	$134	2,133
East South Central	al	russell	207,400	$124	1,679
East South Central	al	shelby	190,100	$89	2,133
East South Central	al	st. clair	235,200	$102	2,306
East South Central	al	talladega	203,500	$113	1,800
East South Central	al	tuscaloosa	259,000	$137	1,895
East South Central	al	walker	206,500	$115	1,803
East South Central	ky	boone	325,000	$142	2,290
East South Central	ky	boyd	213,600	$102	2,104
East South Central	ky	bullitt	319,300	$126	2,527
East South Central	ky	campbell	269,400	$145	1,864
East South Central	ky	christian	325,600	$136	2,390
East South Central	ky	daviess	239,800	$113	2,118
East South Central	ky	fayette	227,800	$109	2,085
East South Central	ky	franklin	272,400	$112	2,432
East South Central	ky	hardin	223,600	$133	1,675
East South Central	ky	henderson	311,400	$127	2,460
East South Central	ky	hopkins	208,000	$104	2,007
East South Central	ky	jefferson	265,900	$117	2,279
East South Central	ky	jessamine	174,900	$98	1,777
East South Central	ky	kenton	273,600	$110	2,479
East South Central	ky	laurel	256,800	$105	2,450
East South Central	ky	madison	265,400	$135	1,960
East South Central	ky	mccracken	229,300	$126	1,824
East South Central	ky	oldham	232,500	$127	1,834
East South Central	ky	pulaski	234,200	$117	2,003
East South Central	ky	scott	217,500	$111	1,964
East South Central	ky	warren	279,300	$158	1,773
East South Central	ms	desoto	288,300	$118	2,438
East South Central	ms	forrest	254,800	$111	2,295
East South Central	ms	hancock	336,800	$143	2,357
East South Central	ms	harrison	281,200	$130	2,158
East South Central	ms	hinds	268,600	$106	2,532
East South Central	ms	jackson	179,400	$92	1,947
East South Central	ms	jones	187,200	$116	1,607
East South Central	ms	lafayette	295,100	$119	2,482
East South Central	ms	lamar	251,400	$142	1,770
East South Central	ms	lauderdale	275,800	$134	2,063
East South Central	ms	lee	273,100	$132	2,066
East South Central	ms	lowndes	283,400	$155	1,827
East South Central	ms	madison	279,400	$110	2,538
East South Central	ms	oktibbeha	264,400	$124	2,135
East South Central	ms	pearl river	256,100	$146	1,759
East South Central	ms	rankin	240,500	$119	2,019
East South Central	ms	warren	191,100	$105	1,826
East South Central	tn	anderson	329,700	$138	2,389
East South Central	tn	blount	308,500	$135	2,278
East South Central	tn	bradley	181,300	$92	1,973
East South Central	tn	carter	293,000	$126	2,328
East South Central	tn	coffee	174,700	$93	1,887
East South Central	tn	cumberland	266,600	$108	2,466
East South Central	tn	davidson	326,400	$126	2,585
East South Central	tn	dickson	250,300	$117	2,140
East South Central	tn	greene	226,000	$116	1,950
East South Central	tn	hamblen	309,000	$124	2,482
East South Central	tn	hamilton	303,200	$136	2,232
East South Central	tn	hawkins	269,000	$113	2,385
East South Central	tn	jefferson	264,900	$129	2,048
East South Central	tn	knox	300,500	$139	2,162
East South Central	tn	loudon	291,600	$133	2,200
East South Central	tn	madison	292,500	$167	1,756
East South Central	tn	maury	275,300	$110	2,507
East South Central	tn	mcminn	234,900	$108	2,176
East South Central	tn	montgomery	250,300	$151	1,663
East South Central	tn	putnam	169,700	$97	1,744
East South Central	tn	roane	217,200	$129	1,690
East South Central	tn	robertson	305,600	$134	2,281
East South Central	tn	rutherford	159,900	$87	1,847
East South Central	tn	sevier	229,600	$120	1,908
East South Central	tn	sullivan	207,500	$104	1,996
East South Central	tn	sumner	544,400	$117	4,666
East South Central	tn	washington	505,500	$119	4,245
East South Central	tn	williamson	532,300	$117	4,562
East South Central	tn	wilson	476,600	$114	4,177
East South Central	tn	madison	564,900	$99	5,719
East South Central	ms	jones	630,100	$127	4,947
East South Central	ms	lafayette	605,300	$115	5,248
East South Central	al	talladega	675,500	$104	6,498
East South Central	al	tuscaloosa	633,100	$107	5,894
East South Central	al	jackson	715,300	$111	6,420
Northeast	ny	albany	297,400	$207	1,439
Northeast	ny	bronx	314,100	$207	1,515
Northeast	ny	broome	310,300	$154	2,017
Northeast	ny	cattaraugus	372,600	$179	2,077
Northeast	ny	cayuga	265,400	$166	1,602
Northeast	ny	chautauqua	336,400	$177	1,905
Northeast	ny	chemung	282,600	$228	1,242
Northeast	ny	clinton	351,500	$179	1,969
Northeast	ny	columbia	266,000	$165	1,610
Northeast	ny	cortland	343,200	$181	1,893
Northeast	ny	dutchess	298,300	$175	1,708
Northeast	ny	erie	275,200	$189	1,453
Northeast	ny	franklin	302,600	$192	1,577
Northeast	ny	fulton	379,900	$193	1,965
Northeast	ny	genesee	329,700	$166	1,983
Northeast	ny	herkimer	306,900	$171	1,797
Northeast	ny	jefferson	287,800	$191	1,504
Northeast	ny	kings	247,900	$189	1,310
Northeast	ny	livingston	353,400	$220	1,603
Northeast	ny	madison	311,800	$158	1,973
Northeast	ny	monroe	318,400	$206	1,545
Northeast	ny	montgomery	259,300	$156	1,658
Northeast	ny	new york	314,400	$191	1,644
Northeast	ny	niagara	261,400	$172	1,517
Northeast	ny	oneida	308,500	$168	1,840
Northeast	ny	onondaga	307,300	$179	1,714
Northeast	ny	ontario	295,800	$186	1,594
Northeast	ny	orange	329,300	$168	1,963
Northeast	ny	oswego	266,500	$237	1,126
Northeast	ny	otsego	225,700	$204	1,104
Northeast	ny	putnam	272,300	$178	1,532
Northeast	ny	rensselaer	347,000	$190	1,827
Northeast	ny	richmond	313,300	$168	1,862
Northeast	ny	rockland	302,300	$165	1,835
Northeast	ny	saratoga	304,600	$157	1,946
Northeast	ny	schenectady	331,300	$163	2,031
Northeast	ny	st. lawrence	256,900	$148	1,734
Northeast	ny	steuben	270,600	$191	1,416
Northeast	ny	suffolk	244,700	$160	1,528
Northeast	ny	tioga	257,400	$218	1,183
Northeast	ny	tompkins	238,000	$142	1,678
Northeast	ny	ulster	228,600	$162	1,407
Northeast	ny	warren	236,500	$205	1,156
Northeast	ny	washington	257,300	$203	1,265
Northeast	ny	wayne	321,300	$204	1,573
Northeast	ny	westchester	330,000	$159	2,072
Northeast	pa	adams	247,000	$158	1,566
Northeast	pa	allegheny	224,200	$196	1,145
Northeast	pa	armstrong	289,200	$186	1,558
Northeast	pa	beaver	315,300	$157	2,010
Northeast	pa	berks	207,400	$173	1,199
Northeast	pa	blair	323,900	$178	1,815
Northeast	pa	bradford	251,400	$208	1,206
Northeast	pa	bucks	325,800	$182	1,794
Northeast	pa	cambria	302,200	$176	1,716
Northeast	pa	carbon	192,900	$143	1,349
Northeast	pa	centre	290,200	$184	1,574
Northeast	pa	chester	234,800	$156	1,506
Northeast	pa	clearfield	257,900	$170	1,517
Northeast	pa	columbia	277,800	$174	1,595
Northeast	pa	crawford	292,400	$204	1,435
Northeast	pa	cumberland	270,900	$186	1,456
Northeast	pa	dauphin	282,800	$140	2,025
Northeast	pa	delaware	242,100	$184	1,315
Northeast	pa	erie	229,200	$181	1,263
Northeast	pa	fayette	272,900	$184	1,485
Northeast	pa	franklin	277,700	$204	1,363
Northeast	pa	indiana	284,600	$166	1,713
Northeast	pa	lackawanna	251,000	$184	1,365
Northeast	pa	lancaster	248,500	$170	1,465
Northeast	pa	lawrence	418,800	$203	2,063
Northeast	pa	lebanon	377,800	$201	1,881
Northeast	pa	lehigh	305,800	$194	1,579
Northeast	pa	luzerne	386,500	$186	2,077
Northeast	pa	lycoming	185,600	$145	1,283
Northeast	pa	mifflin	309,500	$164	1,888
Northeast	pa	monroe	414,000	$199	2,085
Northeast	pa	montgomery	289,000	$175	1,648
Northeast	pa	northampton	286,100	$218	1,313
Northeast	pa	northumberland	301,600	$163	1,852
Northeast	pa	philadelphia	246,700	$166	1,489
Northeast	pa	pike	256,400	$168	1,529
Northeast	pa	schuylkill	315,900	$188	1,682
Northeast	pa	somerset	323,900	$164	1,972
Northeast	pa	venango	284,800	$163	1,749
Northeast	pa	washington	315,500	$173	1,820
Northeast	pa	york	368,600	$178	2,068
Northeast	ny	richmond	320,600	$170	1,887
Northeast	ny	rockland	269,200	$150	1,796
Northeast	ny	saratoga	277,300	$151	1,842
Northeast	ny	schenectady	596,900	$163	3,656
Northeast	ny	st. lawrence	507,400	$142	3,583
Northeast	ny	cattaraugus	585,600	$161	3,637
Northeast	ny	cayuga	523,300	$167	3,141
Northeast	ny	chautauqua	532,600	$144	3,697
Northeast	ny	chemung	614,600	$153	4,022
Northeast	pa	centre	626,500	$144	4,354
Northeast	pa	chester	786,800	$149	5,290
Northeast	pa	northumberland	633,300	$134	4,736
Northeast	pa	philadelphia	822,200	$161	5,108
West North Central	ia	black hawk	286,700	$204	1,404
West North Central	ia	cerro gordo	361,000	$193	1,869
West North Central	ia	clinton	301,200	$214	1,405
West North Central	ia	dallas	401,900	$184	2,183
West North Central	ia	dubuque	331,100	$180	1,839
West North Central	ia	johnson	421,400	$195	2,165
West North Central	ia	linn	425,300	$188	2,265
West North Central	ia	polk	393,600	$192	2,048
West North Central	ia	pottawattamie	297,400	$186	1,603
West North Central	ia	scott	286,600	$191	1,501
West North Central	ia	story	395,000	$170	2,325
West North Central	ia	warren	402,400	$199	2,022
West North Central	ia	woodbury	245,500	$139	1,761
West North Central	ks	butler	268,300	$160	1,677
West North Central	ks	douglas	267,600	$179	1,498
West North Central	ks	johnson	369,000	$155	2,387
West North Central	ks	leavenworth	321,700	$188	1,712
West North Central	ks	reno	402,000	$196	2,052
West North Central	ks	riley	356,900	$158	2,261
West North Central	ks	saline	245,200	$142	1,721
West North Central	ks	sedgwick	303,400	$194	1,563
West North Central	ks	shawnee	247,100	$164	1,511
West North Central	ks	wyandotte	259,500	$159	1,631
West North Central	mn	anoka	292,300	$201	1,455
West North Central	mn	blue earth	315,900	$208	1,518
West North Central	mn	carver	290,500	$156	1,868
West North Central	mn	chisago	309,900	$196	1,583
West North Central	mn	clay	350,900	$163	2,158
West North Central	mn	crow wing	263,200	$164	1,602
West North Central	mn	dakota	262,800	$144	1,824
West North Central	mn	goodhue	340,200	$148	2,296
West North Central	mn	hennepin	353,300	$158	2,236
West North Central	mn	olmsted	211,000	$148	1,427
West North Central	mn	otter tail	315,400	$173	1,828
West North Central	mn	ramsey	344,400	$166	2,073
West North Central	mn	rice	263,800	$187	1,412
West North Central	mn	scott	426,800	$181	2,361
West North Central	mn	sherburne	361,600	$177	2,041
West North Central	mn	st. louis	337,200	$163	2,066
West North Central	mn	stearns	362,000	$163	2,223
West North Central	mn	washington	282,100	$172	1,642
West North Central	mn	winona	270,600	$149	1,816
West North Central	mn	wright	420,500	$179	2,351
West North Central	mo	boone	418,900	$179	2,341
West North Central	mo	buchanan	266,200	$168	1,589
West North Central	mo	cape girardeau	292,100	$162	1,798
West North Central	mo	cass	291,200	$180	1,620
West North Central	mo	christian	351,600	$197	1,786
West North Central	mo	clay	294,000	$177	1,659
West North Central	mo	cole	408,200	$187	2,183
West North Central	mo	franklin	310,900	$143	2,173
West North Central	mo	greene	388,900	$166	2,341
West North Central	mo	jackson	409,400	$181	2,262
West North Central	mo	jasper	319,600	$176	1,813
West North Central	mo	jefferson	324,000	$183	1,766
West North Central	mo	johnson	371,300	$155	2,388
West North Central	mo	lincoln	260,100	$144	1,804
West North Central	mo	newton	322,600	$146	2,205
West North Central	mo	platte	269,200	$184	1,467
West North Central	mo	saint louis city	273,200	$172	1,592
West North Central	mo	st. charles	309,400	$143	2,158
West North Central	mo	st. francois	325,500	$167	1,951
West North Central	mo	st. louis	387,900	$195	1,994
West North Central	mo	taney	351,700	$194	1,816
West North Central	nd	burleigh	345,300	$162	2,132
West North Central	nd	cass	259,700	$179	1,454
West North Central	nd	grand forks	390,700	$173	2,258
West North Central	nd	ward	402,800	$252	1,599
West North Central	ne	buffalo	471,600	$197	2,393
West North Central	ne	douglas	324,500	$162	2,006
West North Central	ne	hall	276,900	$154	1,794
West North Central	ne	lancaster	354,400	$149	2,379
West North Central	ne	sarpy	273,200	$164	1,665
West North Central	sd	lincoln	461,000	$195	2,359
West North Central	sd	minnehaha	414,900	$217	1,908
West North Central	sd	pennington	233,600	$146	1,600
West North Central	mo	platte	289,100	$189	1,530
West North Central	mo	saint louis city	253,900	$156	1,623
West North Central	mo	st. charles	430,300	$187	2,302
West North Central	mo	st. francois	355,600	$200	1,774
West North Central	mo	st. louis	440,100	$197	2,229
West North Central	mo	taney	264,200	$187	1,410
West North Central	nd	burleigh	428,200	$178	2,400
West North Central	nd	cass	389,000	$183	2,120
West North Central	nd	grand forks	394,400	$169	2,338
West North Central	nd	ward	370,900	$175	2,125
West North Central	ne	buffalo	360,800	$152	2,375
West North Central	ne	douglas	278,700	$191	1,458
West North Central	ne	hall	324,900	$185	1,756
West North Central	ne	lancaster	300,700	$191	1,574
West North Central	ne	sarpy	510,600	$149	3,431
West North Central	sd	lincoln	543,800	$158	3,431
West North Central	sd	minnehaha	623,500	$162	3,854
West North Central	ia	johnson	643,300	$160	4,021
West North Central	ia	linn	745,500	$165	4,531
West North Central	ia	polk	720,300	$162	4,459
West North Central	ia	pottawattamie	815,200	$157	5,182
West North Central	ia	scott	869,200	$151	5,774
West North Central	ia	story	930,400	$178	5,223
West North Central	ia	warren	745,100	$140	5,315
Mid Atlantic	nj	atlantic	214,600	$173	1,239
Mid Atlantic	nj	burlington	309,600	$169	1,833
Mid Atlantic	nj	camden	238,700	$208	1,148
Mid Atlantic	nj	cape may	351,300	$199	1,763
Mid Atlantic	nj	cumberland	314,800	$260	1,209
Mid Atlantic	nj	gloucester	253,300	$209	1,211
Mid Atlantic	nj	hudson	290,300	$194	1,498
Mid Atlantic	nj	hunterdon	352,500	$249	1,415
Mid Atlantic	nj	mercer	446,400	$220	2,032
Mid Atlantic	nj	monmouth	278,800	$241	1,159
Mid Atlantic	nj	ocean	316,000	$156	2,028
Mid Atlantic	nj	salem	237,000	$201	1,182
Mid Atlantic	dc	district of columbia	286,600	$212	1,349
Mid Atlantic	de	kent	370,000	$224	1,653
Mid Atlantic