Question: Help please!! I need a help finding number of positiveegative outliers. B D G H K M 61 115% Comparative Salary Housing No. of positive

Help please!!

I need a help finding number of positiveegative outliers.

Help please!! I need a help finding number of

B D G H K M 61 115% Comparative Salary Housing No. of positive outlier No. of negative outlier E F 1 Cost of Living Adjustments Compute the mean and standard deviation of Comparative Salary and Housing in the Cost of Living Adjustments Excel file. 2 1. compute the z-scores for the comparative salaries and housing adjustments 4 2. find the number of positiveegative outliers in these two variables. 5 2 6 Mean $70,703.52 85% 7 Standard deviation $19,304.30 1 Comparative 8 City Salary Housing Utilities Transportation Healthcare 9 Atlanta $60,482.00 25% -10% 6% 5% no Austin $57,530.00 13% -1% -1% 6% 11 Boston $85,904.00 141% 43% 11% % 33% 12 Charleston $60,904.00 22% % 702 -7% 11% 10% 13 Charlotte 2004200 EN 20 5% 20 em $58,012.00 % 2% -2% lu 6% ON 400 14 Chicago $70,000.00 73% 1% 18% 2% 15 Columbus der FA SO 20 $54,578.00 -5% -1% -6% -1% 16 Dallas 201 201 401 -4% EU $58,072.00 -3% 1% 5% 2 loc *100 2440 400 - Dc $87,892.00 214% -6% 13% -3% Ce 120 18 Denver BAO DO 401 64% $65,843.00 -8% 1% 1104 11% E 2008 40 19 Detroit eo $57,590.00 15% 0% 6% 104 6% -1% den 401 20 Indianapolis 4401 4% $55,120.00 -11% -6% 1% 400 21 Los Angeles % 168% 2007 $83,795.00 420 10% 29% 13% 207 22 Lousiville 1202 2% $55,602.00 -13% DO 5% -8% 23 Minneapolis $65 0800 400 $65,060.00 400 43% DO -10% 10% 8% 24 New Orleans 22 420 $57,530.00 502 20 24% $ -17% -5% 1% 25 New York 200 479% 26% $136,024.00 2007 30% 19% 26 Philadelphia $72,048.00 7202 72% 17% 10% 3% 202 27 Phoenix $57,651.00 21% -8% 2% 1% 28 Pittsburgh $59,578.00 21% -3% 14% -1% 29 Portland $77,349.00 108% -18% 19% 15% med 30 San Diego $86,446.00 187% 18% 27% 15% 31 San Francisco $105,241.00 304% 3% 26% 22% 32 Seattle $83,253.00 133% 2% 21% 24% 33 St. Louis $56,084.00 -9% 13% 1% 4% 34 1 Z-Score Comparative Salary Housing -0.53 -0.52 -0.68 -0.62 0.79 0.49 are -0.51 -0.55 -0.66 -0.69 -0.04 -0.10 40 -0.84 -0.75 -0.65 -0.77 0.89 1.12 -0.25 -0.18 -0.68 -0.61 -0.81 -0.70 0.68 0.72 -0.78 -0.72 -0.29 -0.36 -0.68 -0.53 2 3.38 3.42 0.07 -0.11 -0.68 -0.55 -0.58 -0.55 0.34 0.20 0.82 0.88 1.79 1.90 0.65 0.42 -0.76 -0.81

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!