Regression Problem
The Excel file MetAreas.xls in Recordsdata and Paperwork incorporates information on 325 metropolitan areas in the US. The file incorporates scores from Locations Rated Almanac about every metropolis on value of dwelling, jobs, training, recreation, crime, and well being care. It additionally incorporates an total desirability rating (Column H) for every metropolis.(a) Use regression to develop a mannequin that relates the general desirability rating (dependent variable) to the opposite scores. Embrace solely variables which have a p worth of .05 or much less. What's the ensuing regression equation?(b) What would the mannequin predict for the general desirability rating for a metropolitan space with the next scores:Price of Dwelling 75Jobs 40Schooling 65Recreation 50Crime 40Healthcare 35