Question: please help 25. Use the data in the Excel file Cost of Living Adjustments to find the best multiple regression model to predict the salary


please help
25. Use the data in the Excel file Cost of Living Adjustments to find the best multiple regression model to predict the salary as a function of the adjusted cost of living rates. What would the comparable salary be for a city with the following adjustments: groceries: 4%; housing: 9%; utilities: 2%; transportation: 1%; and health care: 8%? A Cost of Living Adjustments City Atlanta Austin Boston Charleston Charlotte Chicago O Columbus Dallas 2 DC 3 Denver 4 Detroit 5 Indianapolis Los Angeles 7 Lousiville 3 Minneapolis 9 New Orleans O New York 1 Philadelphia 2 Phoenix 3 Pittsburgh 4 Portland 5 San Diego 5 San Francisco 7 Seattle 8 St. Louis 3 B Comparative Salary Groceries Housing $60,482.00 $57,530.00 $85,904.00 $60,904.00 $58,012.00 $70,000.00 $54,578.00 $58,072.00 $87,892.00 $65,843.00 $57,590.00 $55,120.00 $83,795.00 $55,602.00 $65,060.00 $57,530.00 $136,024.00 $72,048.00 $57,651.00 $59,578.00 $77,349.00 $86,446.00 $105,241.00 $83,253.00 $56,084.00 15% -8% 16% 18% 11% 23% 1% 12% 20% 7% -2% 3% 16% 1% 16% 10% 37% 26% 7% 9% D 25% 18% 38% 33% 14% 25% 13% 141% 22% 5% 73% -1% -4% 214% 64% 15% 4% 168% 2% 43% 24% 479% 72% 21% 21% 108% 187% 304% 133% -9% Source: CNN Money Cost of Living Calculator, December 2015 E Utilities -10% -1% 43% 11% 2% 1% -5% -3% -6% -8% 0% -11% 10% -13% -10% -17% 26% 17% -8% -3% -18% 18% 3% 2% 13% G Transportation Healthcare 6% -1% 11% -7% -2% 18% -6% 1% 13% 1% 6% -6% 29% 5% 10% -5% 30% 10% 2% 14% 19% 27% 26% 21% 1% 5% 6% 33% 10% 6% 2% -1% 5% -3% 11% -1% 1% 13% -8% 8% 1% 19% 3% 1% -1% 15% 15% 22% 24% 4%Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
