Use regression to develop a model that relates the overall

Reference no: EM13472850

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

Reference no: EM13472850

Questions Cloud

Determine the largest of three consecutive odd integers : find the largest of three consecutive odd integers whose sum is 225.the largest of the three integers is

Is it ture or false when similar figures have the same : is it ture or false when similar figures have the same shape because the corresponding angles are

Post a brief explanation of grounded theory methodology : post a brief description of grounded theory methodology study of emdr and adolescent ptsd. explain how data was

Assume your average after taking three quizzes is 76 out of : suppose your average after taking 3 quizzes is 76 out of 100. what must your average be on the next 5 quizzes to

Use regression to develop a model that relates the overall : the excel file metareas.xls in files and documents contains data on 325 metropolitan areas in the united states. the

What is an equation of a line that passes through the point : what is an equation of a line that passes through the point 03 and is perpendicular to the line whose equation is

A university begins year 1 with 80 faculty they hire 4 : a university begins year 1 with 80 faculty. they hire 4 faculty each year. during each year 10 rounded to the nearest

Write an equation to model this situation where xis the : a students grade in a course is the average of 4 test grades and a final exam that is worth twice as much as each test.

A waiter earns a salary of 500per month for working 4hours : a waiter earns a salary of 500per month for working 4hours a day. in may he worked additional hours at 10per hour and

User Account

All Pages