The American Chamber of Commerce Researchers Association compiles cost-of-living indexes for selected metropolitan areas. Shown here are cost-of-living indexes for 25 different cities on five different items for a recent year. Use the data to develop a regression model to predict the grocery cost-of-living index by the indexes of housing, utilities, transportation, and healthcare. Discuss the results, highlighting both the significant and non-significantpredictors.

Transcribed Image Text:

Grocery City Items Housing Utilities Transportation Healthcare Albany Albuquerque 96.3 105.2 Augusta, GA 96.2 Austin Baltimore Buffalo Colorado 127.4 98.8 115.6 108.3 106.8 107.5 100.9 102.3 97.4 112.8 107.8 102.1 88.8 83.9 114.1 103.1 7. 127.6 94.9 106.0 108.1 100.8 102.4 94.5 Springs Dallas Denver Des Moines El Paso Indianapolis Jacksonville 96 90.496.0 Kansas City Knoxville Los Angeles 103.3 213 Louisville Memphis Miami Minneapolis Mobile Nashville New Orleans 104.0 Oklahom:a 105.4 91.5 108.9 98.9 108.3 106.8 114.3 96.2 110.0 105.9 105.7 104.2 102.7 106.0 102.9 96.0 94.6 99.7 90.9 92.1 97.4 89.8 93.2 93.6 82.3 128.5 88.4 85.5 137.8 107.5 92.2 90.9 87.0 92.4 88.0 75.6 79.4 102.1 102.4 101.1 104.3 106.0 102.8 94.6 99.1 100.3 86.2 123.0 92.8 112.3 125.6 105.2 104.9 95.8 107.7 122.2 103.4 83.4 98.2 98.2 ty Phoenix 96.3 104.6 115.2