Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please interpret the results, calculated in the image attached Compute the mean and standard deviation of the data in the Cost of Living Adjustments Excel
Please interpret the results, calculated in the image attached
Compute the mean and standard deviation of the data in the Cost of Living Adjustments Excel file. Then compute the z-scores for the comparative salaries and healthcare and interpret your results Interpretation Cost of Living Adjustments z-scores City Comparative Salary Groceric Housing Utilities Transpo Healthcare Comparative Salary Healthcare Atlanta $60,482.00 15% 25% -10% 6% 5% -0.53 -0.27 Austin $57,530.00 -8% 13% -1% -1% 6% -0.68 -0.17 Boston $85,904.00 16% 141% 43% 11% 33% 0.79 2.65 Charleston $60,904.00 18% 22% 11% -7% 10% -0.51 0.25 Charlotte $58,012.00 11% 5% 2% -2% 6% -0.66 0.17 Chicago $70,000.00 23% 73% 1% 18% 2% -0.04 -0.58 Columbus $54,578.00 1% -1% -5% 6% -1% -0.84 -0.90 Dallas $58,072.00 12% 4% -3% 1% 5% -0.65 -0.27 DC $87,892.00 20% 214% -6% 13% -3% 0.89 -1.11 Denver $65,843.00 7% 64% -8% 1% 11% -0.25 0.36 Detroit $57,590.00 2% 15% 0% 6% -1% -0.68 -0.90 Indianapolis $55, 120.00 3% 4% -11% 6% 1% -0.81 -0.69 Los Angeles $83,795.00 16% 168% 10% 29% 13% 0.68 0.56 Lousiville $55,602.00 1% 2% -13% 5% -8% -0.78 -1.63 Minneapolis $65,060.00 16% 43% -10% 10% 8% -0.29 0.04 New Orleans $57,530.00 10% 24% -17% 5% 1% -0.68 -0.69 New York $136,024.00 37% 479% 26% 30% 19% 3.38 1.19 Philadelphia $72,048.00 26% 72% 17% 10% 3% 0.07 -0.48 Phoenix $57,651.00 7% 21% -8% 2% 1% -0.68 -0.69 Pittsburgh $59,578.00 9% 21% 3% 14% -1% -0.58 -0.90 Portland $77,349.00 25% 108% -18% 19% 15% 0.34 0.77 San Diego $86,446.00 18% 187% 18% 27% 15% 0.82 0.77 San Francisco $105,241.00 38% 304% 3% 26% 22% 1.79 1.50 Seattle $83,253.00 33% 133% 2% 21% 24% 0.65 1.71 St. Louis $56,084.00 14% -9% 13% 1% 4% -0.76 -0.38 Mean $70,703.52 $0.15 $0.85 $0.01 $0.09 $0.08 Standard Deviation 19304.29564 0.11608 1.15323 0.14162 0. 1159 0.09574Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started