Could I get a step-by-step for this? Please do not give me the answer, just a guide on how to go about solving this on my own. I often struggle with equations and Excel formulas, so if you could be clear on those particular directions. I don't know if the graphs or charts are needed since I don't want the answer just handed to me, but I'm going to include them just to be safe.

Here is the assignment:

Scenario

You have been hired by your regional real estate company to determine if your region's housing prices and housing square footage are significantly different from those of the national market. The regional sales director has three questions that they want to see addressed in the report:

1. Are housing prices in your regional market lower than the national market average?
2. Is the square footage for homes in your region different than the average square footage for homes in the national market?
3. For your region, what is the range of values for the 95% confidence interval of square footage for homes in your market?

You are given a real estate data set that has houses listed for every county in the United States. In addition, you have been given national statistics and graphs that show the national averages for housing prices and square footage. Your job is to analyze the data, complete the statistical analyses, and provide a report to the regional sales director. You will do so by completing the Project Two Template.

Directions

Introduction

1. Region:Start by picking one region from the following list of regions: West South Central, West North Central, East South Central, East North Central, Mid Atlantic
2. Purpose:What was the purpose of your analysis, and what is your approach?
   1. Define a random sample and two hypotheses (means) to analyze.
3. Sample:Define your sample. Take a random sample of 500 observations for your region.
   1. Describe what is included in your sample (i.e., states, region, years or months).
4. Questions and type of test:For your selected sample, define two hypothesis questions and the appropriate type of test hypothesis for each. Address the followingfor each hypothesis:
   1. Describe the population parameter for the variable you are analyzing.
   2. Describe your hypothesis in your own words.
   3. Describe the inference test you will use.
      1. Identify the test statistic.
5. Level of confidence:Discuss how you will use estimation and confidence intervals to help you solve the problem.

1-Tail Test

1. Hypothesis:Define your hypothesis.
   1. Define the population parameter.
   2. Write null (Ho) and alternative (Ha) hypotheses.
   3. Specify your significance level.
2. Data analysis:Analyze the data and confirm assumptions have not been violated to complete this hypothesis test.
   1. Summarize your sample data using appropriate graphical displays and summary statistics.
      1. Provide at least one histogram of your sample data.
      2. In a table, provide summary statistics including sample size, mean, median, and standard deviation.
      3. Summarize your sample data, describing the center, spread, and shape in comparison to the national information.
   2. Check the conditions.
      1. Determine if the normal condition has been met.
      2. Determine if there are any other conditions that you should check and whether they have been met.
3. Hypothesis test calculations:Complete hypothesis test calculations, providing the appropriate statistics and graphs.
   1. Calculate the hypothesis statistics.
      1. Determine the appropriate test statistic (t).
      2. Calculate the probability (pvalue).
4. Interpretation:Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.
   1. Relate thepvalue and significance level.
   2. Make the correct decision (reject or fail to reject).
   3. Provide a conclusion in the context of your hypothesis.

2-Tail Test

1. Hypotheses:Define your hypothesis.
   1. Define the population parameter.
   2. Write null and alternative hypotheses.
   3. State your significance level.
2. Data analysis:Analyze the data and confirm assumptions have not been violated to complete this hypothesis test.
   1. Summarize your sample data using appropriate graphical displays and summary statistics.
      1. Provide at least one histogram of your sample data.
      2. In a table, provide summary statistics including sample size, mean, median, and standard deviation.
      3. Summarize your sample data, describing the center, spread, and shape in comparison to the national information.
   2. Check the assumptions.
      1. Determine if the normal condition has been met.
      2. Determine if there are any other conditions that should be checked on and whether they have been met.
3. Hypothesis test calculations:Complete hypothesis test calculations, providing the appropriate statistics and graphs.
   1. Calculate the hypothesis statistics.
      1. Determine the appropriate test statistic (t).
      2. Determine the probability (pvalue).
4. Interpretation:Interpret your hypothesis test results using thepvalue method to reject or not reject the null hypothesis.
   1. Relate thepvalue and significance level.
   2. Make the correct decision (reject or fail to reject).
   3. Provide a conclusion in the context of your hypothesis.
5. Comparison of the test results:See Question 3 from the Scenario section.
   1. Calculate a 95% confidence interval. Show or describe your method of calculation.
   2. Interpret a 95% confidence interval.

Final Conclusions

1. Summarize your findings:Refer back to the Introduction section above and summarize your findings of the sample you selected.
2. Discuss:Discuss whether you were surprised by the findings. Why or why not?

Here is theProject Template:

Introduction

Region: [Clearly specify the region you picked from the list of regions mentioned in Guidelines.]

Purpose: [Include in this section a brief overview, the purpose of the report, and your approach. Define your random sample and two hypotheses (means) to analyze.]

Sample:[Take a random sample of observations from your region and describe what is included in your sample (i.e., states, region, years or months).]

Questions and type of test:[For your selected sample, define two hypothesis questions and the appropriate type of test hypothesis for each. For each hypothesis question, answer questions 3a-c from the Project Two Guidelines and Rubric. This includes questions about the population parameter, your hypothesis, the inference method you will use, and how you will use estimation and confidence intervals to help you solve the problem.]

1-Tail Test

Hypothesis:[Define the population parameter. Write null and alternative hypotheses.Note: For means, define a hypothesis thatislessthanthe population parameter. Specify your significance level.]

Data analysis:[Summarize your sample data using appropriate graphical displays and summary statistics.]

[Provide at least one histogram of your sample data.]

[In a table, provide summary statistics including sample size, mean, median, and standard deviation.]

Note: For quartiles 1 and 3, use the quartile function in Excel:

=QUARTILE([data range], [quartile number])

[Summarize your sample data, describing the center, spread, and shape in context.]

[Note: For shape, think about the distribution: skewed or symmetric.]

[Check the assumptions by determining if the normal condition has been met. Determine if there are any other conditions that you should check and whether they have been met.]

[Note: Think about the central limit theorem and sampling methods.]

Hypothesis Test Calculations:

[Determine the appropriate test statistic (t).]

[Note: This calculation is (mean - target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]

[Calculate the probability (pvalue).]

[Note: This calculation is done with the T.DIST.RT function in Excel: =T.DIST.RT([test statistic], [degree of freedom]). The degree of freedom is calculated by subtracting 1 from your sample size.]

Interpretation:

[Relate thepvalue and significance level.]

[Make the correct decision (reject or fail to reject).]

[Provide a conclusion in the context of your hypothesis.]

2-Tail Test

Hypotheses:[Define the population parameter. Write null and alternative hypotheses.]

[Note: For means, define a hypothesis thatis not equal tothe population parameter.]

[State your significance level.]

Data Analysis:

[Summarize your sample data using appropriate graphical displays and summary statistics.]

[Provide at least one histogram of your sample data.]

[In a table, provide summary statistics including sample size, mean, and standard deviation.]

[Note: For quartiles 1 and 3, use the quartile function in Excel:

=QUARTILE([data range], [quartile number]) ]

[Summarize your sample data, describing the center, spread, and shape in comparison to the national information.]

[Note: For shape, think about the distribution: skewed or symmetric.]

[Check the assumptions by determining if the normal condition has been met. Determine if there are any other conditions that you should check and whether they have been met.]

Note: Think about the central limit theorem and sampling methods.

Hypothesis Test Calculations:

[Determine the appropriate test statistic (t).]

[Note: This calculation is (mean - target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]

[Calculate the probability (pvalue).]

[Note: This calculation is done with the TDIST.2T function in Excel: =T.DIST.RT([test statistic], [degree of freedom]). The degree of freedom is calculated by subtracting 1 from your sample size.]

Interpretation:

[Relate thepvalue and significance level.]

[Make the correct decision (reject or fail to reject).]

[Provide a conclusion in context to your hypothesis.]

Comparison of the Test Results:

[Calculate the 95% confidence interval and show or describe the method of calculation.]

[Interpret the confidence 95% confidence interval in context.]

Final Conclusions

[Summarize Your Findings:Refer back to Step 1 and summarize your findings of the sample you selected.]

[Discuss:Discussif you were surprised by the findings including why or why not.]

Here is theExcel chartof the region I chose (It is very large as a quick warning):

House Listing Price Data by Region
Regional sample (n = 1001)
State	County	Region	House listing price	Cost per square foot	Square footage
OR	yamhill	Pacific	$429,950	$213	2,129
OR	yamhill	Pacific	$439,950	$213	2,198
CA	sacramento	Pacific	$394,391	$232	1,659
CA	san mateo	Pacific	$1,301,950	$787	1,735
WA	grays harbor	Pacific	$225,000	$150	1,527
CA	nevada	Pacific	$497,336	$248	2,271
CA	alameda	Pacific	$799,050	$488	1,563
CA	marin	Pacific	$1,314,050	$654	2,044
WA	skagit	Pacific	$450,050	$236	1,914
CA	kings	Pacific	$236,040	$134	1,659
CA	alameda	Pacific	$797,050	$485	1,605
HI	honolulu	Pacific	$699,050	$539	1,208
AK	matanuska-susitna	Pacific	$270,000	$151	1,820
CA	san diego	Pacific	$660,550	$377	1,761
CA	sutter	Pacific	$329,950	$176	1,874
AK	fairbanks north star	Pacific	$222,750	$134	1,665
CA	kings	Pacific	$269,950	$152	1,786
OR	clackamas	Pacific	$542,475	$225	2,553
CA	el dorado	Pacific	$544,550	$269	2,050
CA	santa clara	Pacific	$1,254,550	$680	1,940
OR	polk	Pacific	$378,040	$172	2,280
CA	fresno	Pacific	$325,050	$174	1,863
WA	kitsap	Pacific	$409,994	$201	2,118
CA	sacramento	Pacific	$389,500	$229	1,673
WA	grays harbor	Pacific	$239,550	$161	1,499
OR	yamhill	Pacific	$459,950	$192	2,380
WA	king	Pacific	$746,045	$398	2,080
CA	lake	Pacific	$269,950	$172	1,552
HI	kauai	Pacific	$1,149,050	$653	1,680
CA	san diego	Pacific	$675,000	$365	1,853
WA	island	Pacific	$424,950	$233	1,805
WA	walla walla	Pacific	$372,764	$166	2,448
WA	king	Pacific	$725,000	$387	2,065
CA	kern	Pacific	$239,950	$129	1,616
OR	lane	Pacific	$399,050	$211	1,930
OR	benton	Pacific	$495,050	$212	2,290
CA	tuolumne	Pacific	$342,550	$198	1,767
CA	ventura	Pacific	$749,500	$376	2,018
WA	clallam	Pacific	$415,050	$201	1,998
WA	chelan	Pacific	$420,050	$197	1,988
WA	pierce	Pacific	$400,050	$197	2,198
CA	san diego	Pacific	$717,500	$405	1,800
CA	lake	Pacific	$279,950	$181	1,577
CA	el dorado	Pacific	$534,050	$260	2,089
WA	franklin	Pacific	$274,390	$138	2,096
CA	madera	Pacific	$335,050	$168	1,956
OR	deschutes	Pacific	$523,521	$245	2,104
CA	marin	Pacific	$1,383,550	$636	2,151
OR	multnomah	Pacific	$449,300	$248	1,947
AK	anchorage	Pacific	$315,050	$180	1,738
WA	yakima	Pacific	$257,050	$133	1,936
CA	merced	Pacific	$300,661	$175	1,752
CA	butte	Pacific	$304,050	$186	1,646
WA	spokane	Pacific	$299,800	$117	2,180
WA	skagit	Pacific	$492,864	$234	2,057
CA	mendocino	Pacific	$629,950	$305	1,500
WA	king	Pacific	$734,417	$393	2,064
WA	clark	Pacific	$455,500	$194	2,400
CA	contra costa	Pacific	$699,050	$403	2,022
CA	santa clara	Pacific	$1,164,957	$720	1,670
CA	shasta	Pacific	$336,550	$190	1,809
CA	san mateo	Pacific	$1,595,050	$899	1,820
CA	kings	Pacific	$262,479	$149	1,758
OR	marion	Pacific	$387,250	$192	2,064
OR	multnomah	Pacific	$462,550	$267	1,817
CA	tulare	Pacific	$250,050	$136	1,795
WA	grant	Pacific	$287,014	$146	1,811
CA	shasta	Pacific	$319,050	$171	1,786
OR	lane	Pacific	$405,000	$195	2,045
OR	klamath	Pacific	$209,050	$122	1,680
AK	matanuska-susitna	Pacific	$269,420	$155	1,786
OR	benton	Pacific	$483,750	$213	2,109
WA	king	Pacific	$599,525	$298	2,215
CA	madera	Pacific	$299,050	$148	2,002
CA	merced	Pacific	$295,050	$163	1,801
OR	columbia	Pacific	$347,500	$185	1,986
CA	santa clara	Pacific	$1,171,994	$704	1,693
AK	anchorage	Pacific	$344,050	$178	1,848
CA	placer	Pacific	$560,050	$260	2,191
WA	lewis	Pacific	$299,550	$158	1,863
OR	jackson	Pacific	$409,950	$213	1,911
WA	cowlitz	Pacific	$325,050	$174	1,866
OR	josephine	Pacific	$364,550	$188	1,888
WA	grant	Pacific	$235,050	$130	1,805
AK	anchorage	Pacific	$319,500	$179	1,754
CA	contra costa	Pacific	$658,050	$391	1,914
OR	jackson	Pacific	$405,000	$212	1,916
CA	tehama	Pacific	$300,050	$160	1,831
WA	clark	Pacific	$457,045	$209	2,260
CA	sonoma	Pacific	$717,550	$385	1,794
CA	lake	Pacific	$334,550	$196	1,594
CA	tehama	Pacific	$307,500	$172	1,788
HI	hawaii	Pacific	$472,050	$323	1,487
WA	whitman	Pacific	$249,800	$118	2,085
OR	columbia	Pacific	$341,550	$172	2,023
WA	benton	Pacific	$374,050	$170	2,229
CA	madera	Pacific	$329,050	$168	1,941
WA	skagit	Pacific	$405,050	$203	2,033
WA	snohomish	Pacific	$450,050	$218	2,087
CA	santa cruz	Pacific	$940,550	$558	1,654
CA	butte	Pacific	$315,050	$191	1,650
CA	san mateo	Pacific	$1,648,550	$907	1,859
OR	yamhill	Pacific	$474,950	$212	2,265
AK	fairbanks north star	Pacific	$229,950	$138	1,667
CA	sonoma	Pacific	$791,550	$448	1,769
OR	umatilla	Pacific	$237,550	$130	1,876
OR	lane	Pacific	$375,050	$198	1,928
OR	marion	Pacific	$366,864	$188	1,964
CA	sacramento	Pacific	$424,550	$240	1,714
CA	yolo	Pacific	$539,050	$280	1,935
CA	kern	Pacific	$245,050	$135	1,610
AK	matanuska-susitna	Pacific	$280,049	$159	1,850
CA	santa cruz	Pacific	$895,050	$542	1,644
WA	clark	Pacific	$451,500	$203	2,245
CA	orange	Pacific	$894,550	$446	2,000
WA	skagit	Pacific	$375,050	$201	1,943
WA	king	Pacific	$740,000	$367	2,180
CA	mendocino	Pacific	$649,050	$299	1,570
CA	nevada	Pacific	$533,907	$261	2,221
WA	snohomish	Pacific	$450,025	$230	2,018
CA	san luis obispo	Pacific	$745,050	$375	1,919
WA	pierce	Pacific	$450,000	$207	2,242
CA	alameda	Pacific	$817,805	$543	1,502
OR	washington	Pacific	$500,000	$225	2,335
OR	benton	Pacific	$469,050	$206	2,209
OR	jackson	Pacific	$412,500	$195	1,969
OR	marion	Pacific	$399,000	$180	2,129
OR	klamath	Pacific	$249,500	$128	1,782
CA	contra costa	Pacific	$619,050	$341	1,998
WA	yakima	Pacific	$327,050	$159	2,067
OR	yamhill	Pacific	$459,950	$203	2,308
WA	cowlitz	Pacific	$290,800	$150	2,008
CA	marin	Pacific	$1,599,050	$695	2,394
WA	franklin	Pacific	$297,500	$156	2,092
CA	madera	Pacific	$322,550	$167	1,915
WA	whatcom	Pacific	$415,000	$215	1,903
OR	umatilla	Pacific	$198,050	$118	1,722
WA	snohomish	Pacific	$462,525	$230	2,048
CA	santa barbara	Pacific	$1,013,907	$450	1,984
CA	humboldt	Pacific	$379,500	$239	1,573
WA	franklin	Pacific	$268,574	$136	2,080
WA	whitman	Pacific	$250,050	$116	2,100
CA	napa	Pacific	$1,012,050	$535	2,028
OR	multnomah	Pacific	$454,525	$240	1,990
OR	clackamas	Pacific	$549,975	$217	2,588
CA	lake	Pacific	$289,494	$186	1,494
CA	stanislaus	Pacific	$320,000	$179	1,797
WA	franklin	Pacific	$307,850	$154	2,120
OR	coos	Pacific	$314,550	$172	1,812
OR	polk	Pacific	$364,950	$190	1,950
WA	skagit	Pacific	$479,950	$233	2,069
OR	douglas	Pacific	$262,000	$141	1,826
OR	benton	Pacific	$410,050	$193	2,054
OR	multnomah	Pacific	$469,500	$262	1,903
CA	sacramento	Pacific	$379,050	$220	1,686
CA	marin	Pacific	$1,575,050	$702	2,264
WA	skagit	Pacific	$465,050	$235	2,038
CA	madera	Pacific	$327,550	$166	1,980
HI	honolulu	Pacific	$690,050	$519	1,268
OR	marion	Pacific	$368,050	$188	1,959
WA	chelan	Pacific	$436,250	$204	1,973
WA	franklin	Pacific	$261,304	$134	2,187
WA	cowlitz	Pacific	$250,050	$141	1,800
OR	josephine	Pacific	$359,950	$194	1,815
WA	kitsap	Pacific	$432,550	$205	2,121
CA	lake	Pacific	$334,050	$198	1,668
OR	douglas	Pacific	$311,550	$166	1,853
WA	grant	Pacific	$226,200	$126	1,801
AK	matanuska-susitna	Pacific	$290,000	$162	1,820
OR	marion	Pacific	$369,050	$174	2,076
OR	benton	Pacific	$472,550	$201	2,174
WA	grays harbor	Pacific	$219,950	$148	1,517
WA	whitman	Pacific	$279,950	$133	2,170
CA	san mateo	Pacific	$1,620,050	$883	1,930
OR	josephine	Pacific	$362,907	$194	1,802
CA	solano	Pacific	$473,590	$268	1,785
OR	douglas	Pacific	$299,050	$160	1,893
CA	mendocino	Pacific	$575,050	$277	1,600
WA	grays harbor	Pacific	$234,750	$150	1,495
CA	kings	Pacific	$257,500	$143	1,798
OR	deschutes	Pacific	$495,050	$236	2,084
CA	santa cruz	Pacific	$895,050	$547	1,605
CA	tehama	Pacific	$299,950	$169	1,769
WA	chelan	Pacific	$458,050	$234	1,872
CA	yuba	Pacific	$299,000	$170	1,804
CA	tulare	Pacific	$280,000	$151	1,816
CA	yolo	Pacific	$465,050	$252	1,867
CA	los angeles	Pacific	$711,518	$433	1,745
CA	placer	Pacific	$579,479	$262	2,248
CA	san luis obispo	Pacific	$749,550	$372	1,942
CA	san mateo	Pacific	$1,419,913	$778	1,829
CA	san francisco	Pacific	$1,235,050	$883	1,290
CA	stanislaus	Pacific	$313,550	$177	1,770
HI	hawaii	Pacific	$504,550	$349	1,528
HI	kauai	Pacific	$891,550	$579	1,563
WA	clallam	Pacific	$399,525	$202	1,961
WA	whitman	Pacific	$319,500	$139	2,363
CA	monterey	Pacific	$1,000,050	$528	2,156
CA	tuolumne	Pacific	$353,050	$199	1,856
WA	island	Pacific	$430,050	$214	2,042
CA	ventura	Pacific	$769,550	$369	2,118
CA	santa clara	Pacific	$1,295,050	$752	1,740
OR	washington	Pacific	$525,050	$226	2,386
OR	marion	Pacific	$395,050	$179	2,164
CA	sutter	Pacific	$334,050	$179	1,900
OR	jackson	Pacific	$414,764	$209	1,901
OR	polk	Pacific	$360,050	$188	1,984
WA	king	Pacific	$645,050	$325	2,130
OR	clackamas	Pacific	$528,236	$228	2,430
WA	pierce	Pacific	$417,525	$200	2,196
AK	matanuska-susitna	Pacific	$279,325	$155	1,872
CA	san bernardino	Pacific	$350,049	$196	1,863
WA	whatcom	Pacific	$394,050	$201	1,884
CA	santa cruz	Pacific	$899,050	$538	1,661
OR	umatilla	Pacific	$232,300	$127	1,800
WA	franklin	Pacific	$318,450	$176	1,931
CA	san diego	Pacific	$721,621	$392	1,868
CA	tuolumne	Pacific	$349,500	$198	1,794
CA	madera	Pacific	$329,050	$167	2,017
WA	franklin	Pacific	$300,750	$157	2,010
CA	tuolumne	Pacific	$347,050	$198	1,798
OR	polk	Pacific	$365,050	$183	1,962
CA	tulare	Pacific	$261,500	$138	1,826
OR	polk	Pacific	$363,998	$172	2,098
CA	sutter	Pacific	$324,950	$174	1,830
CA	santa clara	Pacific	$1,099,050	$620	1,810
WA	island	Pacific	$477,500	$247	1,873
CA	santa cruz	Pacific	$842,050	$519	1,671
WA	king	Pacific	$737,025	$395	2,068
OR	washington	Pacific	$509,800	$228	2,288
OR	lincoln	Pacific	$422,907	$226	1,876
CA	yuba	Pacific	$294,750	$164	1,819
CA	san mateo	Pacific	$1,514,744	$886	1,820
WA	pierce	Pacific	$365,048	$178	2,148
WA	benton	Pacific	$332,300	$157	2,190
WA	franklin	Pacific	$297,500	$153	2,039
CA	sonoma	Pacific	$791,525	$458	1,723
WA	grays harbor	Pacific	$245,050	$171	1,477
WA	mason	Pacific	$242,812	$158	1,594
AK	anchorage	Pacific	$325,050	$180	1,775
CA	sacramento	Pacific	$392,500	$231	1,684
OR	benton	Pacific	$450,050	$205	2,215
CA	contra costa	Pacific	$629,025	$386	1,871
WA	lewis	Pacific	$250,050	$143	1,760
OR	multnomah	Pacific	$475,050	$264	1,916
OR	deschutes	Pacific	$511,379	$249	2,104
CA	san joaquin	Pacific	$380,050	$203	1,891
HI	hawaii	Pacific	$477,050	$324	1,520
WA	yakima	Pacific	$239,500	$121	1,955
CA	kings	Pacific	$265,050	$149	1,808
CA	san mateo	Pacific	$1,643,048	$919	1,876
WA	clallam	Pacific	$332,000	$181	1,847
OR	lincoln	Pacific	$387,050	$210	1,882
CA	alameda	Pacific	$842,050	$535	1,550
WA	cowlitz	Pacific	$304,500	$145	2,189
OR	benton	Pacific	$400,050	$193	2,027
WA	clallam	Pacific	$315,050	$175	1,840
CA	contra costa	Pacific	$587,050	$324	1,866
HI	hawaii	Pacific	$474,050	$328	1,523
CA	ventura	Pacific	$698,050	$368	1,903
CA	ventura	Pacific	$775,050	$368	2,136
HI	honolulu	Pacific	$696,550	$515	1,324
WA	clark	Pacific	$458,550	$207	2,258
CA	sutter	Pacific	$299,444	$152	1,978
OR	washington	Pacific	$499,950	$233	2,171
CA	lake	Pacific	$302,500	$190	1,584
WA	whitman	Pacific	$204,500	$104	1,982
OR	lane	Pacific	$346,550	$183	1,978
OR	polk	Pacific	$384,545	$179	2,216
HI	honolulu	Pacific	$689,550	$549	1,185
CA	napa	Pacific	$899,500	$463	2,047
WA	thurston	Pacific	$389,050	$181	2,186
OR	deschutes	Pacific	$473,282	$230	2,061
OR	multnomah	Pacific	$467,050	$260	1,883
CA	san bernardino	Pacific	$371,993	$216	1,806
OR	clackamas	Pacific	$549,050	$215	2,611
CA	ventura	Pacific	$750,050	$373	2,056
CA	el dorado	Pacific	$535,050	$266	2,006
AK	matanuska-susitna	Pacific	$284,500	$156	1,881
CA	santa barbara	Pacific	$974,550	$428	1,942
CA	tehama	Pacific	$332,500	$177	1,755
WA	cowlitz	Pacific	$259,500	$129	1,895
OR	multnomah	Pacific	$479,050	$250	2,043
OR	umatilla	Pacific	$249,436	$139	1,846
CA	stanislaus	Pacific	$340,050	$201	1,714
WA	kitsap	Pacific	$407,550	$204	2,100
WA	walla walla	Pacific	$275,050	$146	2,118
CA	monterey	Pacific	$1,097,336	$555	2,119
CA	san joaquin	Pacific	$377,550	$196	1,898
OR	columbia	Pacific	$354,444	$170	2,090
CA	tulare	Pacific	$269,950	$147	1,766
CA	lake	Pacific	$269,050	$170	1,558
CA	placer	Pacific	$549,950	$245	2,200
OR	columbia	Pacific	$349,050	$186	1,951
CA	merced	Pacific	$306,100	$174	1,765
CA	shasta	Pacific	$318,950	$181	1,748
CA	mendocino	Pacific	$645,050	$309	1,560
WA	grays harbor	Pacific	$219,950	$152	1,496
CA	shasta	Pacific	$323,907	$187	1,813
WA	franklin	Pacific	$305,000	$144	2,152
WA	thurston	Pacific	$336,550	$156	2,137
WA	whitman	Pacific	$263,050	$127	1,836
WA	island	Pacific	$480,314	$250	1,988
WA	whitman	Pacific	$250,050	$128	1,886
CA	san francisco	Pacific	$1,339,550	$944	1,322
CA	marin	Pacific	$1,650,050	$715	2,395
CA	stanislaus	Pacific	$334,444	$183	1,854
CA	napa	Pacific	$1,014,550	$548	2,041
OR	benton	Pacific	$524,050	$210	2,296
CA	butte	Pacific	$287,845	$171	1,710
CA	merced	Pacific	$299,585	$169	1,778
CA	alameda	Pacific	$799,050	$487	1,629
CA	ventura	Pacific	$754,050	$383	2,030
OR	clackamas	Pacific	$519,500	$223	2,400
CA	monterey	Pacific	$897,050	$507	1,848
WA	grant	Pacific	$243,750	$127	1,840
WA	chelan	Pacific	$385,050	$194	1,953
CA	san luis obispo	Pacific	$719,050	$370	1,870
WA	franklin	Pacific	$299,750	$145	2,110
WA	mason	Pacific	$295,000	$176	1,716
WA	grays harbor	Pacific	$248,479	$169	1,494
CA	yuba	Pacific	$325,050	$173	1,884
OR	washington	Pacific	$499,950	$215	2,485
CA	sacramento	Pacific	$426,500	$240	1,734
OR	deschutes	Pacific	$467,500	$225	2,155
CA	santa barbara	Pacific	$1,395,050	$562	2,172
CA	solano	Pacific	$458,050	$268	1,689
WA	franklin	Pacific	$284,000	$139	2,227
CA	santa cruz	Pacific	$938,550	$566	1,685
CA	los angeles	Pacific	$675,050	$422	1,700
CA	el dorado	Pacific	$560,800	$247	2,239
CA	alameda	Pacific	$849,994	$537	1,567
WA	mason	Pacific	$340,050	$192	1,764
AK	anchorage	Pacific	$345,550	$181	1,824
WA	king	Pacific	$649,975	$323	2,180
WA	whatcom	Pacific	$450,050	$237	1,884
CA	san joaquin	Pacific	$430,050	$226	1,920
WA	grays harbor	Pacific	$190,050	$134	1,478
OR	washington	Pacific	$491,300	$216	2,414
CA	san joaquin	Pacific	$410,193	$218	1,873
OR	polk	Pacific	$350,050	$161	2,167
WA	clark	Pacific	$450,050	$201	2,262
CA	contra costa	Pacific	$622,550	$364	1,920
OR	douglas	Pacific	$339,950	$169	1,940
CA	monterey	Pacific	$850,000	$502	1,811
WA	chelan	Pacific	$419,050	$231	1,877
HI	hawaii	Pacific	$514,550	$344	1,535
WA	whitman	Pacific	$274,050	$134	1,862
OR	clackamas	Pacific	$549,525	$225	2,474
AK	fairbanks north star	Pacific	$199,050	$131	1,534
WA	grant	Pacific	$245,050	$130	1,818
OR	coos	Pacific	$280,045	$167	1,752
OR	multnomah	Pacific	$449,050	$248	1,952
WA	lewis	Pacific	$253,950	$143	1,760
WA	skagit	Pacific	$461,050	$234	1,994
OR	lincoln	Pacific	$393,050	$211	1,920
OR	deschutes	Pacific	$496,300	$235	2,092
CA	humboldt	Pacific	$379,500	$219	1,650
CA	tuolumne	Pacific	$319,050	$183	1,768
WA	grant	Pacific	$249,950	$142	1,800
OR	douglas	Pacific	$310,050	$168	1,855
CA	kern	Pacific	$265,050	$140	1,691
WA	thurston	Pacific	$349,950	$166	2,131
OR	jackson	Pacific	$400,050	$192	2,001
WA	yakima	Pacific	$281,046	$150	1,922
CA	napa	Pacific	$874,550	$447	2,009
OR	lincoln	Pacific	$375,050	$208	1,844
OR	polk	Pacific	$365,050	$188	2,000
CA	tulare	Pacific	$268,050	$147	1,759
CA	el dorado	Pacific	$568,550	$274	2,085
CA	santa cruz	Pacific	$900,000	$520	1,848
AK	fairbanks north star	Pacific	$224,950	$137	1,608
CA	orange	Pacific	$875,050	$420	2,065
CA	madera	Pacific	$324,950	$162	1,979
WA	king	Pacific	$679,050	$361	2,000
WA	clark	Pacific	$459,450	$211	2,260
OR	columbia	Pacific	$348,350	$161	2,087
WA	chelan	Pacific	$409,500	$227	1,814
CA	tuolumne	Pacific	$317,500	$184	1,777
OR	linn	Pacific	$283,950	$156	1,809
WA	kitsap	Pacific	$375,050	$188	2,073
CA	butte	Pacific	$356,433	$217	1,696
WA	chelan	Pacific	$450,050	$229	1,940
CA	tehama	Pacific	$297,050	$161	1,800
WA	clark	Pacific	$449,993	$205	2,233
WA	yakima	Pacific	$289,950	$144	1,936
CA	santa clara	Pacific	$915,025	$554	1,764
OR	deschutes	Pacific	$449,050	$221	2,052
CA	merced	Pacific	$289,374	$163	1,760
WA	chelan	Pacific	$447,050	$209	1,964
OR	washington	Pacific	$484,550	$214	2,360
CA	stanislaus	Pacific	$359,950	$198	1,866
OR	washington	Pacific	$498,991	$231	2,182
CA	humboldt	Pacific	$374,300	$229	1,530
OR	multnomah	Pacific	$462,479	$258	1,869
CA	madera	Pacific	$325,050	$165	1,999
OR	umatilla	Pacific	$199,050	$120	1,800
CA	placer	Pacific	$569,697	$252	2,283
CA	los angeles	Pacific	$697,050	$419	1,790
CA	san mateo	Pacific	$1,390,050	$798	1,750
AK	anchorage	Pacific	$339,050	$180	1,788
CA	orange	Pacific	$885,000	$420	2,108
OR	linn	Pacific	$309,950	$163	1,904
CA	san luis obispo	Pacific	$699,050	$369	1,867
WA	chelan	Pacific	$445,050	$230	1,941
WA	king	Pacific	$699,525	$382	1,990
OR	linn	Pacific	$339,950	$187	1,840
AK	matanuska-susitna	Pacific	$299,050	$162	1,876
CA	sonoma	Pacific	$779,050	$446	1,736
WA	clallam	Pacific	$391,025	$199	1,990
CA	napa	Pacific	$979,050	$560	1,986
AK	anchorage	Pacific	$342,500	$182	1,849
OR	multnomah	Pacific	$460,575	$269	1,819
CA	solano	Pacific	$460,000	$268	1,742
CA	butte	Pacific	$329,050	$192	1,706
CA	sonoma	Pacific	$783,050	$425	1,840
CA	placer	Pacific	$580,049	$262	2,262
CA	san mateo	Pacific	$1,388,050	$783	1,780
HI	hawaii	Pacific	$440,479	$302	1,515
WA	king	Pacific	$709,550	$362	2,132
OR	coos	Pacific	$294,550	$165	1,830
CA	santa barbara	Pacific	$1,125,050	$484	2,049
AK	matanuska-susitna	Pacific	$271,550	$153	1,792
OR	deschutes	Pacific	$494,050	$234	2,074
OR	klamath	Pacific	$199,550	$122	1,615
WA	walla walla	Pacific	$384,550	$170	2,376
CA	riverside	Pacific	$444,000	$214	2,142
WA	kitsap	Pacific	$482,550	$216	2,269
WA	clallam	Pacific	$399,050	$200	2,022
CA	sonoma	Pacific	$714,050	$418	1,694
CA	san diego	Pacific	$649,500	$344	1,918
OR	jackson	Pacific	$400,050	$207	1,863
CA	lake	Pacific	$323,050	$194	1,586
CA	los angeles	Pacific	$699,000	$414	1,787
CA	san diego	Pacific	$699,050	$385	1,860
WA	whatcom	Pacific	$398,950	$212	1,883
OR	klamath	Pacific	$225,050	$126	1,736
OR	josephine	Pacific	$376,800	$196	1,892
CA	sutter	Pacific	$339,050	$175	1,968
OR	lane	Pacific	$360,000	$180	1,980
CA	imperial	Pacific	$257,050	$144	1,726
WA	chelan	Pacific	$479,050	$231	1,945
CA	imperial	Pacific	$269,500	$147	1,773
CA	mendocino	Pacific	$644,950	$293	1,560
OR	coos	Pacific	$259,550	$150	1,826
WA	cowlitz	Pacific	$294,550	$153	2,021
CA	tuolumne	Pacific	$329,050	$187	1,776
WA	grays harbor	Pacific	$247,050	$166	1,510
AK	matanuska-susitna	Pacific	$295,550	$161	1,860
WA	mason	Pacific	$238,700	$156	1,643
CA	fresno	Pacific	$327,600	$174	1,868
WA	king	Pacific	$742,550	$368	2,208
CA	sacramento	Pacific	$379,550	$220	1,667
CA	kern	Pacific	$250,025	$134	1,673
OR	deschutes	Pacific	$425,045	$211	2,048
CA	sacramento	Pacific	$429,950	$239	1,749
CA	el dorado	Pacific	$599,050	$247	2,368
WA	clallam	Pacific	$312,550	$167	1,854
CA	el dorado	Pacific	$604,500	$246	2,318
WA	benton	Pacific	$335,050	$149	2,207
CA	solano	Pacific	$449,050	$248	1,840
CA	yolo	Pacific	$528,550	$282	1,889
WA	clallam	Pacific	$428,121	$212	2,012
CA	humboldt	Pacific	$378,407	$232	1,556
CA	tehama	Pacific	$289,500	$159	1,792
HI	kauai	Pacific	$986,050	$604	1,646
CA	san luis obispo	Pacific	$759,050	$370	1,986
WA	benton	Pacific	$310,050	$142	2,206
HI	honolulu	Pacific	$699,050	$540	1,217
AK	fairbanks north star	Pacific	$205,000	$133	1,540
CA	san bernardino	Pacific	$319,050	$174	1,728
CA	sacramento	Pacific	$407,500	$235	1,685
OR	linn	Pacific	$347,500	$184	1,839
OR	benton	Pacific	$469,050	$218	2,094
OR	linn	Pacific	$349,500	$178	1,865
HI	honolulu	Pacific	$734,050	$523	1,322
WA	grant	Pacific	$261,550	$142	1,811
WA	grays harbor	Pacific	$223,300	$151	1,491
CA	tuolumne	Pacific	$325,050	$185	1,744
WA	lewis	Pacific	$300,000	$160	1,838
CA	tehama	Pacific	$279,950	$160	1,799
WA	skagit	Pacific	$445,000	$231	1,923
CA	napa	Pacific	$933,550	$510	1,988
CA	tulare	Pacific	$269,050	$147	1,768
OR	josephine	Pacific	$350,050	$194	1,774
CA	kings	Pacific	$270,050	$150	1,754
HI	kauai	Pacific	$1,090,050	$645	1,687
OR	clackamas	Pacific	$539,550	$229	2,413
CA	yolo	Pacific	$498,050	$260	1,980
WA	king	Pacific	$692,494	$331	2,208
OR	yamhill	Pacific	$450,000	$205	2,324
CA	santa clara	Pacific	$997,525	$602	1,763
CA	san luis obispo	Pacific	$759,050	$370	1,998
WA	mason	Pacific	$240,050	$152	1,572
CA	yolo	Pacific	$512,550	$274	1,809
CA	kings	Pacific	$239,550	$137	1,672
CA	san diego	Pacific	$699,994	$381	1,916
AK	fairbanks north star	Pacific	$199,500	$132	1,545
CA	humboldt	Pacific	$384,050	$232	1,588
HI	hawaii	Pacific	$475,000	$342	1,541
CA	imperial	Pacific	$263,050	$139	1,811
CA	mendocino	Pacific	$627,500	$300	1,552
CA	tuolumne	Pacific	$350,050	$199	1,862
CA	fresno	Pacific	$330,000	$174	1,893
CA	san mateo	Pacific	$1,588,550	$899	1,894
WA	snohomish	Pacific	$457,045	$228	2,046
WA	mason	Pacific	$296,050	$167	1,796
CA	yuba	Pacific	$339,050	$177	1,870
CA	san francisco	Pacific	$1,287,550	$961	1,216
OR	lane	Pacific	$382,550	$206	1,872
WA	whitman	Pacific	$310,000	$142	2,194
OR	umatilla	Pacific	$193,575	$119	1,712
OR	polk	Pacific	$331,545	$159	2,040
CA	kern	Pacific	$256,000	$137	1,648
CA	monterey	Pacific	$900,049	$477	2,000
OR	clackamas