Cost-of-living indices are often used to measure the desirability of living in a particular geographical area. The
Question:
Cost-of-living indices are often used to measure the desirability of living in a particular geographical area. The data in the following table give a composite index and six component indices for several urban areas in the United States.
a. Build a linear model to predict the composite index based on the component indices. Evaluate the model in terms of overall goodness-of-fit. Evaluate the results for each regression parameter: Are the signs appropriate? Are the values different from zero?
b. Can you improve the model in (a) by removing or transforming one or more of the explanatory variables from the regression? If so, compare the advantages and disadvantages of the resulting regression to the one in (a).
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 9780470530672
3rd Edition
Authors: Stephen G. Powell, Kenneth R. Baker