How many metropolitan areas (rows) are included in the total data file?(Whole number)

How many metropolitan areas (rows) are part of the West region?(Whole number)

For metro areas in the Central, what was the average 'median home price' for those cities in 2006?(XXX.X)

Caution: Make sure your method of sorting and computing does not put a 0 in for missing values as this would change your average.

If you wanted to test whether mean home prices are different between two regions (e.g., between Southeast and Central) in 2004, what test would you use?Assume you want to be conservative in your analysis and don't know anything about the prices in a given market.

t test for one mean, mu

t.test for 2 independent samples, assuming equal variances

t test for 2 independent samples, not assuming equal variances

t test for mean difference using dependent samples

When carrying out a t-test for a difference in means for two regions (e.g., between Southeast and Central), which value in the Excel output allows us to conclude whether the means are different?

degrees of freedom

P-value (one-tailed)

P-value (two-tailed)

hypothesized mean difference

Now, perform that test. Is there a statistically significant difference (at the0.05 level) between mean home price in theNortheast and the West regions during 2004?

What p-value do you get for the two-sample (unequal variances) test?(X.XXX)

Flag this Question

Question 710pts

Looking specifically at two states, did home prices for metro areas in South Carolina and Texas differ from one another on average in 2011 (ata= 0.05)?What p-value do you get for the two-sample (unequal variances) test?(X.XXX)

Now, if you wanted to run one test and determine whether mean home prices are different between any of the four regions in 2011, what test would you use?

t-tests for the 6 pairwise comparisons

One-way ANOVA (one factor ANOVA)

Two-way ANOVA (two factor ANOVA

Conduct a one-way ANOVA to see if there are significant differences in mean home price across regions in 2011. What is the P-value? (X.XXX)

Finally, you'd like to run an analysis to determine how home prices are being influenced by both the city and the year in the Mississippi market.You decide to run an ANOVA with both cities and years (2004-2011) as factors.Is mean price differentacross years?What p-value do you get for the year factor?(X.XXX)

Median Selling Prices of Homes in US metro areas (2004-2011) Source: Realtor.org, 2016 McGraw-Hill Data includes state and region designations and figures from the state existing-home sales re The state existing-home sales report includes single-family houses, condos and co-ops. The p Metropolitan Area MSA Area Abilene, TX Akron, OH Albany-Schenectady-Troy, NY Albuquerque, NM Allentown-Bethlehem-Easton, PA-NJ Amarillo, TX Anaheim-Santa Ana, CA (Orange Co.) Appleton, WI Atlanta-Sandy Springs-Marietta, GA Atlantic City, NJ Austin-Round Rock, TX Baltimore-Towson, MD Barnstable Town, MA Baton Rouge, LA Beaumont-Port Arthur, TX Binghamton, NY Birmingham-Hoover, AL Bismarck, ND Bloomington-Normal, IL Boise City-Nampa, ID Boston-Cambridge-Quincy, MA-NH Boulder, CO Bridgeport-Stamford-Norwalk, CT Buffalo-Niagara Falls, NY Burlington-South Burlington, VT Canton-Massillon, OH Cape Coral-Fort Myers, FL Cedar Rapids, IA Champaign-Urbana, IL Charleston-North Charleston, SC Charleston, WV Charlotte-Gastonia-Concord, NC-SC TX OH NY NM PA-NJ TX CA WI GA NJ TX MD MA LA TX NY AL ND IL ID MA-NH CO CT NY VT OH FL IA IL SC WV NC-SC Chattanooga, TN-GA Chicago-Naperville-Joliet, IL Cincinnati-Middletown, OH-KY-IN Cleveland-Elyria-Mentor, OH Colordo Springs, CO Columbia, MO Columbia, SC Columbus, OH Corpus Christi, TX Cumberland, MD-WV Dallas-Fort Worth-Arlington, TX Davenport-Moline-Rock Island, IA-IL Dayton, OH Decatur, AL Decatur, IL Deltona-Daytona Beach-Ormond Beach, FL Denver-Aurora, CO Des Moines, IA Detroit-Warren-Livonia, MI Dover, DE Durham, NC Elmira, NY El Paso, TX Erie, PA Eugene-Springfield, OR Fargo, ND-MN Farmington, NM Fayetteville, NC Florence, SC Ft. Wayne, IN Gainesville, FL Gary-Hammond, IN Glens Falls, NY Grand Rapids, MI Green Bay, WI Greensboro-High Point, NC Greenville, SC Gulfport-Biloxi, MS Hagerstown-Martinsburg, MD-WV Hartford-West Hartford-East Hartford, CT Honolulu, HI TN-GA IL OH-KY-IN OH CO MO SC OH TX MD-WV TX IA-IL OH AL IL FL CO IA MI DE NC NY TX PA OR ND-MN NM NC SC IN FL IN NY MI WI NC SC MS MD-WV CT HI Houston-Baytown-Sugar Land, TX Huntsville, AL Indianapolis, IN Jackson, MS Jacksonville, FL Kankakee-Bradley, IL Kansas City, MO-KS Kennewick-Richland-Pasco, WA Kingston, NY Knoxville, TN Lansing-E.Lansing, MI Las Vegas-Paradise, NV Lexington-Fayette,KY Lincoln, NE Little Rock-N. Little Rock, AR Los Angeles-Long Beach-Santa Ana, CA Louisville, KY-IN Madison, WI Manchester-Nashua, NH Memphis, TN-MS-AR Miami-Fort Lauderdale-Miami Beach, FL Milwaukee-Waukesha-West Allis, WI Minneapolis-St. Paul-Bloomington, MN-WI Mobile, AL Montgomery, AL Nashville-Davidson--Murfreesboro, TN New Haven-Milford, CT New Orleans-Metairie-Kenner, LA New York-Northern New Jersey-Long Island, NY-NJ-PA New York-Wayne-White Plains, NY-NJ Norwich-New London, CT NY: Edison, NJ NY: Nassau-Suffolk, NY NY: Newark-Union, NJ-PA Ocala, FL Oklahoma City, OK Omaha, NE-IA Orlando, FL Palm Bay-Melbourne-Titusville, FL Pensacola-Ferry Pass-Brent, FL Peoria, IL TX AL IN MS FL IL MO-KS WA NY TN MI NV KY NE AR CA KY-IN WI NH TN-MS-AR FL WI MN-WI AL AL TN CT LA NY-NJ-PA NY-NJ CT NJ NY NJ-PA FL OK NE-IA FL FL FL IL Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Phoenix-Mesa-Scottsdale, AZ Pittsburgh, PA Pittsfield, MA Portland-South Portland-Biddeford, ME Portland-Vancouver-Beaverton, OR-WA Providence-New Bedford-Fall River, RI-MA Raleigh-Cary, NC Reading, PA Reno-Sparks, NV Richmond, VA Riverside-San Bernardino-Ontario, CA Rochester, NY Rockford, IL Sacramento--Arden-Arcade--Roseville, CA Saint Louis, MO-IL Salem, OR Salt Lake City, UT San Antonio, TX San Diego-Carlsbad-San Marcos, CA San Francisco-Oakland-Fremont, CA San Jose-Sunnyvale-Santa Clara, CA Sarasota-Bradenton-Venice, FL Seattle-Tacoma-Bellevue, WA Shreveport-Bossier City, LA Sioux Falls, SD South Bend-Mishawaka, IN Spartanburg, SC Spokane, WA Springfield, IL Springfield, MA Springfield, MO Syracuse, NY Tallahassee, FL Tampa-St.Petersburg-Clearwater, FL Toledo, OH Topeka, KS Trenton-Ewing, NJ Tucson, AZ Tulsa, OK Virginia Beach-Norfolk-Newport News, VA-NC PA-NJ-DE-MD AZ PA MA ME OR-WA RI-MA NC PA NV VA CA NY IL CA MO-IL OR UT TX CA CA CA FL WA LA SD IN SC WA IL MA MO NY FL FL OH KS NJ AZ OK VA-NC Washington-Arlington-Alexandria, DC-VA-MD-WV Waterloo/Cedar Falls, IA Wichita, KS Winston-Salem, NC Worcester, MA Yakima, WA York-Hanover, PA Youngstown-Warren-Boardman, OH-PA DC-VA-MD-WV IA KS NC MA WA PA OH-PA ate existing-home sales report. condos and co-ops. The price report reflects sales prices of existing single-family homes by metropolit Primary State Region TX OH NY NM PA TX CA WI GA NJ TX MD MA LA TX NY AL ND IL ID MA CO CT NY VT OH FL IA IL SC WV NC Southeast Central Northeast West Northeast Southeast West Central Southeast Northeast Southeast Northeast Northeast Southeast Southeast Northeast Southeast Central Central West Northeast West Northeast Northeast Northeast Central Southeast Central Central Southeast Southeast Southeast 2004 2005 2006 2007 116.9 161.3 145.4 207.3 97.1 627.3 122.9 156.9 197.9 154.7 217 377.2 127.7 93.5 85.3 146.6 113.8 147.8 120.5 183.5 169.2 243.4 107.1 691.9 129.6 167.2 256.1 163.8 265.3 398.3 146.2 98.5 94.4 157 124.9 159.2 114.6 195.4 184.2 248.1 114.9 709 129.2 171.8 254.8 173.7 279.9 389.5 169.5 112.7 96.9 165.1 134.9 152.2 119.3 198.9 198.5 260.8 118.4 709.5 130 172 269.7 183.7 286.1 384.7 174.4 123 111.2 161.3 152.9 154 389.7 325.3 441.3 95 413.2 348.4 482.4 99 402.2 366.4 473.7 97.9 395.6 376.2 486.6 104 115.2 187.2 129.5 127.2 183.5 111.3 168 102.2 269.2 131.8 137.7 197 118.4 180.9 109.3 268.2 133.8 143 212.4 119.4 190.6 110.3 252.1 136.2 144.1 215.4 122.5 204.3 TN IL OH OH CO MO SC OH TX MD TX IA OH AL IL FL CO IA MI DE NC NY TX PA OR ND NM NC SC IN FL IN NY MI WI NC SC MS MD CT HI Southeast Central Central Central West Central Southeast Central Southeast Northeast Southeast Central Central Southeast Central Southeast West Central Central Northeast Southeast Northeast Southeast Northeast West Central West Southeast Southeast Central Southeast Central Northeast Central Central Southeast Southeast Southeast Northeast Northeast West 125.4 240.1 142.5 136.4 187.6 131.9 264.2 145.9 138.9 205.9 136 273.5 143.2 134.4 218.2 130.9 276.6 140.8 130 217.5 123.4 146.7 112.7 72.7 138.2 107.8 115.8 135 152 125.2 87.4 147.6 117.9 119.7 141.6 148.1 131.8 95.7 149.5 119.7 116.7 146.6 147.4 136.5 109.4 150.9 108.7 115.6 75.5 148.6 239.1 140.8 161 150.1 82.1 192.5 247.1 145.5 163.8 180.4 85.4 205.8 249.5 145.1 151.7 208 83.1 192.3 245.4 149.2 140.3 207.5 78.8 94.7 98.6 164.9 124.2 134.6 77.1 111.8 100 197.6 132.8 155.1 86.8 127.6 101.3 230.6 136.5 172.3 81.6 131.9 98.1 239.6 140.9 191.1 96.6 159 122.6 129.3 132.9 143.3 139.8 135.8 113.9 165.9 231.6 460 102.3 184 129.8 153.1 137.8 154.8 147.8 145.4 131.4 208.7 253.3 590 99.7 213.2 128.1 161.6 134.5 151.3 149.4 152 145.8 223.1 258.1 630 97.1 211.1 134.2 167.6 129.4 150.7 152 153.6 154.5 208.5 263.2 643.5 TX AL IN MS FL IL MO WA NY TN MI NV KY NE AR CA KY WI NH TN FL WI MN AL AL TN CT LA NY NY CT NJ NY NJ FL OK NE FL FL FL IL Southeast Southeast Central Southeast Southeast Central Central West Northeast Southeast Central West Southeast Central Southeast West Southeast Central Northeast Southeast Southeast Central Central Southeast Southeast Southeast Northeast Southeast Northeast Northeast Northeast Northeast Northeast Northeast Southeast Central Central Southeast Southeast Southeast Central 136 143 149.1 152.5 121.7 118.1 150.7 120 150 147.6 216.8 132.2 137.9 266.4 138.7 134.4 108.4 446.4 131.5 200.8 123.8 133.8 175.2 127.1 156.7 154.1 251 143.7 142.2 304.7 146.9 137.2 119 529 135.8 218.3 119.3 147.1 193 131.5 155.8 156.1 252.7 151.2 137.7 317.4 147.8 137.5 127 584.8 137.6 223.2 120.5 139 189.2 134.5 153.3 169.2 258.4 156.4 126.8 297.7 147.5 137.5 129.1 593.6 137.4 226.5 136.2 286.4 197.1 217.4 115.2 116.6 141.2 363.9 215.7 234.8 130.5 133.3 142.3 371.2 220.9 232.3 137 144.2 137.2 365.5 223.4 225.2 136.4 143.8 249.2 137.4 385.9 436.6 231.5 328.1 413.5 375.8 110.1 112.4 131.3 169.6 153.4 131.1 96.3 279.1 159.2 445.2 495.2 255.9 375.5 465.2 416.8 143.5 114.7 136.2 243.6 209.7 162.1 109.3 287.7 173.1 469.3 539.4 264 387.7 474.7 433 165.8 125 138.4 270.4 212 166 112.7 286.5 160.3 469.7 540.3 267.7 380.3 477.2 443.7 164.6 134.9 138 261.3 183.6 165.6 118.6 PA AZ PA MA ME OR RI NC PA NV VA CA NY IL CA MO OR UT TX CA CA CA FL WA LA SD IN SC WA IL MA MO NY FL FL OH KS NJ AZ OK VA Northeast West Northeast Northeast Northeast West Northeast Southeast Northeast Northeast Southeast West Northeast Central West Central West West Southeast West West West Southeast West Southeast Central Central Southeast West Central Northeast Central Northeast Southeast Southeast Central Central Northeast West Central Southeast 185.1 169.4 113.4 192.8 224.8 206.5 276.9 169.9 121.1 284.3 170.7 296.4 106.5 103.6 317 128.7 154.6 158 122.7 551.6 641.7 698.5 255.7 284.6 110.6 129.2 93.6 110.8 128.5 103.3 180.3 114.1 98.4 152.5 159.7 113.5 102.1 234.2 177.3 215.3 247.4 116.1 207.3 246.6 244.9 293.4 194.9 136.6 349.9 201.9 374.2 113.5 118.2 375.9 141 177.7 173.9 133.9 604.3 715.7 744.5 354.2 316.8 124.3 135.8 96.6 121.2 156.4 106.4 201.8 121.1 110.6 167.6 205.3 117.3 105.7 261.1 231.6 230.2 268.2 116.1 212.9 243.8 280.8 289.6 213.8 143.2 347.2 225.5 400.7 114.8 119.3 374.5 148.4 212.9 203 141.7 601.8 752.8 775 334.3 361.2 132.2 138 92.7 126.7 184.1 105.4 209.6 124.8 116.8 177.5 228.9 110 106.1 289.6 244.9 234.9 257.4 120.7 217.4 242.7 295.2 286.5 224.2 154.7 321.4 233.7 379.5 117.9 119.3 342.8 145.4 228.3 232 153.2 588.7 804.8 836.8 310.9 386.9 135.6 144.5 90.7 128.6 193.8 109 211.9 122.6 121.8 179.5 214.9 106.6 111.9 307.1 244.8 163 197.2 216 226.8 DC IA KS NC MA WA PA OH Northeast Central Central Southeast Northeast West Northeast Central 339.8 95.2 103.9 425.8 102.2 108 431 108.9 114.9 430.8 112.8 115.6 275.9 129.9 290.7 133.9 281.7 136.5 274.6 156.5 86 85.6 81.5 78.9 homes by metropolitan statistical area (MSA) 2008 100.5 197.9 192.6 243.6 124.7 533.2 127.4 149.5 253.3 188.6 274.1 341.9 165 127.4 113.7 153.9 155.2 159.8 188.7 361.1 359.6 437.9 105.4 248.8 92.5 152.6 136.5 141.9 206.2 126.9 197.8 2009 2010 2011 93.2 189.1 180.6 223.4 123.8 477.2 115.6 123.5 221.3 187.4 251.2 321 163 132.4 115.7 146.1 156.6 152.8 153.8 332.6 345.5 379.2 113.6 241.8 86.2 87.6 139.7 140.6 192.7 126.8 189.1 112.8 108.9 195.7 178.7 224 124.7 544.7 119 114.8 226.4 193.6 246.1 326 169.6 125.1 110.3 143 163.4 157.9 136.2 357.3 358.1 408.6 121.2 261.2 90.9 88.9 144.7 141.9 200.5 129.1 191 119.2 90.9 193.8 167.9 185.4 128.2 512.5 115.7 98.6 223.2 193.1 230 311.5 163.4 124.2 113.8 139.8 166.9 155.1 115.4 346.2 353.1 390.6 119.2 272 102.9 138.8 143.9 197 129.8 129.1 245.6 131.8 108.5 205.5 146.3 145 139.3 139.1 99.5 145.8 94.2 107 122.6 199.2 125.8 106.8 189.8 146.7 139.2 134.9 134.3 118.3 140.5 110.3 104.1 121.4 191.4 128 114.5 195.5 146.3 142.6 136.4 135.1 100.3 143.8 112.2 103.6 87.4 164.1 219.3 153.2 86.7 124.6 219.9 149.3 86.5 115.6 232.4 150.9 206.2 180.6 87.7 137.5 99.5 224.7 139.1 190.6 197.1 176.9 87.3 132.6 97.9 203.7 140.2 187.5 117.3 92.6 188.6 127.7 161.1 100.9 146.2 145.3 155.7 140.2 185.8 246.2 624 114.5 94 167.6 119.2 153.5 87.4 136.2 132.8 141.4 133.9 157.1 232 596.2 193.3 177.9 101 134.3 107.7 196.3 146.4 178.9 152.5 118.1 97.4 161.6 122.9 147.5 91.5 130.4 129.8 145.3 125 144.4 235.8 607.6 121.4 176.5 122.3 105.1 187.2 150.3 140.6 123.9 134.2 88.8 148.9 109.9 93.3 106.3 87.5 104.8 231.4 151.1 53.8 170.8 103.4 134.3 109.7 148.6 174.4 152.3 114.6 95.4 148.6 120.6 156.2 99.5 134.8 123.8 144.5 104.8 131.3 227.6 597 151.6 153.1 155 111.2 128.7 174.6 130.8 144.3 166.1 242.1 149.1 97.7 220.5 144.3 135.2 129.8 402.1 132.2 226.6 242.8 119.3 285.1 212.3 202 134.2 135.2 114.2 134.9 145.9 129.2 140.7 167.1 208.4 141.4 80.7 142.9 141.4 133.3 131.8 333.9 131.1 212.3 227.1 119.2 211.2 193.4 177.7 127.6 130.2 263.8 160.5 437.9 494.3 236.6 365.2 435.8 417.2 137.5 128.1 135.2 208.9 144.7 155.7 122.1 235.7 160.1 381.4 437.2 211.8 331.9 383.3 366.6 107.4 140.5 133.7 147.4 107 145.7 119.4 123.3 133.2 137.7 116.3 141.6 177.6 213.8 140.9 84.4 138 143.2 133.6 132.5 316.7 134.6 217.7 232 120.2 201.9 205.9 170.6 121 129 153.8 231 159.7 393.7 450 204.7 345.4 387 379.2 87.8 145.7 137.3 134.7 103 141 116.9 155.7 172.8 123.9 135.9 123.6 118.4 133.2 201.2 141 77.5 124.7 138.6 133 129.8 307.7 130.4 213.2 213.5 112.3 181.1 185.2 154.7 103.2 128.2 151.9 223.1 153 378.7 442.6 184.1 313.9 375.9 370.5 80.9 141.6 135.7 124.9 108.5 134.6 119.8 231.4 191.3 215.9 137 214.9 139.2 210.1 115.5 212.6 229.3 280.1 250.6 223.4 155.7 259.1 223.5 234.2 117 117 216.7 133.2 208.8 229.6 152.8 385.6 622 668 240.6 357.2 138.5 142.3 86 127.3 191.2 108 200.6 121.1 120.2 179.9 173 91.2 108 303.2 204.3 136.9 220 186.4 203.5 244.1 218.5 215.4 152.8 193.8 195.5 218 237.3 228.5 217.6 153.3 179.5 188.3 213.7 219.5 217.2 169.7 116.4 108.2 180.5 127.1 183.7 217 149.3 359.5 493.3 530 170.5 306.2 147 139.2 85.2 120.7 175.2 113.9 186.4 114.6 121 150.9 140.7 83.4 108.4 263.7 172.5 130.1 210 179.3 118.9 106.9 183.6 131.1 173.5 206.5 151 385.2 525.3 602.4 164.6 295.7 156.6 143.3 83.1 118.2 172.2 124 190 109.1 125.1 152.8 134.2 81.5 107.2 250.7 156.6 132.3 205 172.3 119.7 92 166.1 121.8 146.2 182.2 152.5 370.3 483.4 570 156.2 285 156.2 141.4 83.6 117 162.3 117.2 181.4 104.7 122.9 143 127.8 75.7 101.5 240.1 134.5 129.7 182.9 143.1 158 343.4 111.5 121.8 308.6 110.6 118.7 237.1 153.3 217.7 155.2 71.7 66.5 325.3 112.1 118.7 134.7 223.3 155.7 158.6 67.2 325.4 112.8 115.6 125.9 209.6 150.4 151.6