The Excel file MetAreas.xls in Files and Documents contains data on 325 metropolitan areas in the United States. The file contains ratings from Places Rated Almanac about each city on cost of living jobs education recreation crime and health care. It also contains an overall desirability score (Column H) for each city.(a) Use regression to develop a model that relates the overall desirability score (dependent variable) to the other ratings. Include only variables that have a p value of .05 or less. What is the resulting regression equation?(b) What would the model predict for the overall desirability score for a metropolitan area with the following ratings:Cost of Living 75Jobs 40Education 65Recreation 50Crime 40Healthcare 35
Back