Q: Use the dataset posted below to find a multiple regression model to predict the salary as a function of all five of the adjusted cost of living rates. (Solve in Excel) Interpret the slope coefficient for the Housing rate in context. Interpret the adjusted R2 value and the standard error of the estimate value in context. Cost of Living Adjustments City Comparative Salary Groceries Housing Utilities Transportation Healthcare Atlanta $60,482.00 15% 25% -10% 6% 5% Austin $57,530.00 -8% 13% -1% -1% 6% Boston $85,904.00 16% 141% 43% 11% 33% Charleston $60,904.00 18% 22% 11% -7% 10% Charlotte $58,012.00 11% 5% 2% -2% 6% Chicago $70,000.00 23% 73% 1% 18% 2% Columbus $54,578.00 1% -1% -5% -6% -1% Dallas $58,072.00 12% -4% -3% 1% 5% DC $87,892.00 20% 214% -6% 13% -3% Denver $65,843.00 7% 64% -8% 1% 11% Detroit $57,590.00 -2% 15% 0% 6% -1% Indianapolis $55,120.00 3% 4% -11% -6% 1% Los Angeles $83,795.00 16% 168% 10% 29% 13% Lousiville $55,602.00 1% 2% -13% 5% -8% Minneapolis $65,060.00 16% 43% -10% 10% 8% New Orleans $57,530.00 10% 24% -17% -5% 1% New York $136,024.00 37% 479% 26% 30% 19% Philadelphia $72,048.00 26% 72% 17% 10% 3% Phoenix $57,651.00 7% 21% -8% 2% 1% Pittsburgh $59,578.00 9% 21% -3% 14% -1% Portland $77,349.00 25% 108% -18% 19% 15% San Diego $86,446.00 18% 187% 18% 27% 15% San Francisco $105,241.00 38% 304% 3% 26% 22% Seattle $83,253.00 33% 133% 2% 21% 24% St. Louis $56,084.00 14% -9% 13% 1% 4%

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

Q: Use the dataset posted below to find a multiple regression model to predict the salary as a function of all five of the adjusted cost of living rates. (Solve in Excel)

Interpret the slope coefficient for the Housing rate in context.
Interpret the adjusted R² value and the standard error of the estimate value in context.

Cost of Living Adjustments

City	Comparative Salary	Groceries	Housing	Utilities	Transportation	Healthcare
Atlanta	$60,482.00	15%	25%	-10%	6%	5%
Austin	$57,530.00	-8%	13%	-1%	-1%	6%
Boston	$85,904.00	16%	141%	43%	11%	33%
Charleston	$60,904.00	18%	22%	11%	-7%	10%
Charlotte	$58,012.00	11%	5%	2%	-2%	6%
Chicago	$70,000.00	23%	73%	1%	18%	2%
Columbus	$54,578.00	1%	-1%	-5%	-6%	-1%
Dallas	$58,072.00	12%	-4%	-3%	1%	5%
DC	$87,892.00	20%	214%	-6%	13%	-3%
Denver	$65,843.00	7%	64%	-8%	1%	11%
Detroit	$57,590.00	-2%	15%	0%	6%	-1%
Indianapolis	$55,120.00	3%	4%	-11%	-6%	1%
Los Angeles	$83,795.00	16%	168%	10%	29%	13%
Lousiville	$55,602.00	1%	2%	-13%	5%	-8%
Minneapolis	$65,060.00	16%	43%	-10%	10%	8%
New Orleans	$57,530.00	10%	24%	-17%	-5%	1%
New York	$136,024.00	37%	479%	26%	30%	19%
Philadelphia	$72,048.00	26%	72%	17%	10%	3%
Phoenix	$57,651.00	7%	21%	-8%	2%	1%
Pittsburgh	$59,578.00	9%	21%	-3%	14%	-1%
Portland	$77,349.00	25%	108%	-18%	19%	15%
San Diego	$86,446.00	18%	187%	18%	27%	15%
San Francisco	$105,241.00	38%	304%	3%	26%	22%
Seattle	$83,253.00	33%	133%	2%	21%	24%
St. Louis	$56,084.00	14%	-9%	13%	1%	4%

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions