Question:

Recession

Metro Area Resistance Affordability Score

Tucson 10 7 70.7

Fort Worth 10 7 68.5

San Antonio 6 8 65.5

Richmond 8 6 63.6

Indianapolis 4 8 62.5

Philly 0 10 61.9

Atlanta 2 6 60.7

Phoenix 4 5 60.3

Cincinnati 2 7 57.0

Miami 6 5 56.5

Hartford 0 7 56.2

Birmingham 0 8 55.7

San Diego 8 2 54.6

Raleigh 2 7 50.9

Oklahoma City 1 6 49.6

Orange County 4 2 49.1

Denver 4 4 48.6

Los Angeles 0 7 45.7

Detroit 0 5 44.3

New Orleans 0 5 41.2

a. Develop an estimate regression equation that can be used to predict the score given the recession resistance rating. At .05 level of significance, test for a significance relationship.

b. Did the estimate regression equation developed in part a) provide a good fit to the data ?explain