Scenario You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company's Pacific region salespeople just returned to the office with a newly designed advertisement. The average cost per square foot of home sales based on this advertisement is $280. The salesperson claims that the average cost per square foot in the Pacific region is less than $280. In other words, he claims that the newly designed advertisement would result in higher average cost per square foot in the Pacific Region. He wants you to make sure he can make that statement before approving the use of the advertisement. In order to test his claim, you will generate a random sample of size 750 houses using data for the Pacific region and use this data to perform a hypothesis test. Prompt Generate a sample of size 750 houses using data for the Pacific region. Then, design a hypothesis test and interpret the results using significance level a = .05. You will work with this sample in this assignment.

N O S M P R D H B G House listing Cost per Square State County Region price square foot footage random Population Parameter being tested: Mean cost per sqft in the Pacific region WA walla walla Pacific $372,764 $166 2,448 0.79448407 CA kern Pacific $265,193 $145 1,646 0.07569922 Let you represent the mean cost per sqft in the Pacific Region HI hawaii Pacific $514,550 $344 1,535 0.01804061 Mean cost per saft based on new advertisement: $280 Claim: Mean cost per sqft in the Pacific region is less than $280 WA yakima Pacific $289,950 $144 1,936 0.66222334 CA san diego Pacific $660,550 $377 1,761 0.27754855 Pacific $725,000 $387 2,065 0.54370794 Sample Mean: 259 WA king Target: CA san diego Pacific $699,050 $385 1,860 0.76251076 280 OR deschutes Pacific $523,521 $245 2,104 0.17666567 Standard Error: 5.5947 -3.827003968 10 CA madera Pacific $318,925 $166 1,911 0.8108696 Test Statistics: 11 WA grays harbor Pacific $190,050 $134 1,478 0.18490242 Degree of Freedom 749 12 HI maui Pacific $957,336 $713 1,397 0.51363578 13 OF polk Pacific $331,545 $159 2,040 0.18493423 Two Tailed Test 14 WA whitman Pacific $249,800 $118 2,085 0.18480163 15 WA lewis Pacific $250,025 $145 1,782 0.48825318 HO: u = 280 Pacific $912,795 $590 1,559 0.17715403 H1: u # 280 HI kaua P-value Since p-value 280 150 CA marin Pacific $1,549,950 $634 2,422 0.54425722 CA Pacific $257,500 1,798 0.60817867 0.999929732 kings $143 P-value CA tulare Pacific $259,950 $146 1,780 0.82167346 100 OR clackamas Pacific $529,995 $214 2,644 0.71757027 CA kings Pacific $269,950 $152 1,786 0.24691407 Is the p-value less than the level of significance? 50 OR multnomah Pacific $473,564 $273 1,839 0.35262067 if yes: then reject the null hypothesis WA franklin Pacific $274,390 $138 2,096 0.63993081 if not: then do not reject the null hypothesis OR umatilla Pacific $228,050 $123 1,872 0.15102043 OR multnomah Pacific $460,575 $269 1,819 0.04595168 [$107, $166] ($166, $225] ($225, $284] ($284, $343] ($343, $402] ($402, $461] ($461, $520] ($520, $579] ($579, $638] ($638, $697] ($697, $756] ($756, $815] ($815, $874] ($874, $933] ($933, $992] ($992, $1,051] ($1,051, $1,110] 37 CA monterey Pacific $900,049 $477 2,000 0.1011276 38 CA humboldt Pacific $379,500 $219 1,650 0.35272049 CA marin Pacific $1,475,050 $656 2,173 0.17504097 WA mason Pacific $295,000 $176 1,716 0.54147908 CA san mateo Pacific $1,301,950 $787 1,735 0.81347148 CA tulare Pacific $269,050 $147 1,768 0.06139524 OR deschutes Pacific $496 300 $235 2.092 0.91754055