The Excel file MetAreas.xls in Files and Documents contains data on 325 metropolitan areas in the United

profiletutor4helpyou
 (Not rated)
 (Not rated)
Chat
Home>Homework Answsers>Mathematics homework help>Numerical analysis homework help

2. 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 75

Jobs 40

Education 65

Recreation 50

Crime 40

Healthcare 35

  • 11 years ago
Report issue
The Excel file MetAreas.xls in Files and Documents contains data on 325 metropolitan areas in the United
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    metareas.xls
  • attachment
    solution.docx