House listing Cost per
1
State
County
Region
price
square foot
Square
footage
WA
walla walla
Pacific
$372,764
$166
CA
kern
Pacific
$265,193
$145
HI
hawaii
Pacific
$514,550
$344
1,535 0.20841315
WA
yakima
Pacific
$289,950 $144
1,936 0.93496457
CA
san diego
Pacific
$660,550 $377
1,761 0.5011655
WA
king
Pacific
$725,000
$387
2,065 0.944514
Sample Mean:
random
2,448 0.54402625
1,646 0.23059078
Population Parameter being tested: Mean cost per sqft in the Pacific region
Let you represent the mean cost per sqft in the Pacific Region
Mean cost per sqft based on new advertisement: $280
Claim: Mean cost per sqft in the Pacific region is less than $280
259
CA
san diego
Pacific
$699,050
$385
1,860 0.25684495
Target:
280
OR
deschutes
Pacific
$523,521
$245
2,104 0.58162132
Standard Error:
5.5947
10
CA
madera
Pacific
$318,925
$166
1,911 0.13758312
Test Statistics:
-3.827003968
11
WA
grays harbor Pacific
$190,050 $134
1,478 0.03289499
Degree of Freedom
749
12
HI
maui
Pacific
$957,336
$713
1,397 0.72657779
13
OR
polk
Pacific
$331,545
$159
2,040 0.54474796
14
WA
whitman Pacific
$249,800
$118
2,085 0.92546627
Two Tailed Test
15
WA
lewis
Pacific
$250,025 $145
1,782 0.39636638
16
HI
kauai
Pacific
$912,795
$590
1,559 0.02816046
HO: u = 280
H1:u280
17
CA
san francisco Pacific
$1,299,550 $970
1,275 0.72081662
P-value
18
WA
lewis
Pacific
19
CA
yuba
Pacific
$326,000 $164
$294,750 $164
1,894 0.56022866
0.000140539
Since p-value<0.05 we will reject the null hypothesis
We conclude that average cost sqft in Pacific region is not equal to 280
1,819 0.4691685
20
OR
jackson
Pacific
$403,050 $208
1,884 0.13312496
Left Tailed Test
21
CA
lake
Pacific
$269,950
$172
1,552
0.8559548
HO: u = 280
22
OR
jackson
Pacific
23
CA
ventura
Pacific
24
CA
santa clara
Pacific
25
OR
multnomah
Pacific
$409,950 $213
$769,550 $369
$1,175,050 $705
$489,750 $250
1,911 0.24159055
H1: u <280
2,118 0.46057199
P-value
7.02682E-05
1,630 0.739815
2,064 0.21969879
26
OR
josephine
Pacific
$350,050 $194
1,774 0.6599826
Right Tailed Test
27 WA yakima
Pacific
$257.050 $133
1,936 0.21753971
HO: u=280
28
CA
marin
Pacific
$1,549,950 $634
2,422 0.05062345
H1: u > 280
29
CA
kings
Pacific
$257,500
$143
1,798 0.30103703
P-value
0.999929732
30
CA
tulare
Pacific
$259,950
$146
1,780 0.91591986
31
OR
clackamas Pacific
$529,995
$214
2,644 0.91683514
32
CA
kings
Pacific
$269,950
$152
1,786 0.43789491
Is the p-value less than the level of significance?
33
OR
multnomah Pacific
$473,564
$273
1,839 0.00954185
if yes: then reject the null hypothesis
34
WA
franklin Pacific
$274,390 $138
2,096 0.68062743
if not: then do not reject the null hypothesis
35
OR
umatilla Pacific
$228,050
36
OR
multnomah
Pacific
$123
$460,575 $269
1,872 0.25832217
1,819 0.67779645
37
CA
monterey
Pacific
$900,049 $477
2,000 0.73342747
38
CA
humboldt Pacific
39
CA
marin
Pacific
40
WA
hason
Pacific
41
CA
san mateo
Pacific
42
CA
tulare
Pacific
$379,500 $219
$1,475,050 $656
$295,000 $176
$1,301,950 $787
$269,050 $147
1,650 0.23800037
2,173 0.37011788
1,716 0.10183086
1,735 0.46045575
1,768 0.82645054
43 OR
deschutes Pacific
$496,300
44
OR
josephine Pacific
$235
$377,050 $193
2,092 0.05854893
1,892 0.64513978
---