Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Create and upload a histogram of the salary data for the city of Bell, where each bar width is about $25,000 US dollars. Is
1. Create and upload a histogram of the salary data for the city of Bell, where each bar width is about $25,000 US dollars. Is the distribution of the salaries symmetric? Why/Why not? 2. Create a histogram of the salary data for the city of Duarte, where each bar width is about $25,000. Is the distribution of the salaries symmetric? Justify your answer! 3. Can you tell if the mean in each city is larger, smaller, or equal to the median without doing any calculations? How do you know? 4. Create a side -by-side boxplot for the salaries in both cities. What observations do you make? 5. For the city of Duarte, find the mean, median, and standard deviation for the salaries. Round to the nearest dollar. 6. For the city of Bell, find the mean, median, and standard deviation for the salaries. Round to the nearest dollar. 7. Compare the mean salaries of Bell and Duarte public employees. What do you notice? 8. Compare the mean salaries of Bell and Duarte public employees by position titles. What do you notice? 9. Do police office on average get paid well in the city of Bell? What about officers who assume higher ranking positions? Stat >> Summary Stats>> Select Column (Wages_Bell >> Group by (Position_Bell) >>Statistic (Click on Mean)>> Compute! Look at the position of the police officers and the average salary of a police office next to it from the output you obtained in question 8. Make your observations. 10. Compare the average salary of a city council members in both cities. What do you notice? Usually, city council members get paid nominal amount of money for their public service. Use the output you obtained in question 8 to answer this question. 11. Now, look for the city managers salaries in each city and change those salaries to standardized z-scores, meaning find out how many standard deviations away the city manager salary is from the mean? z-score = (city manager salary - mean)/standard deviation. When the z-score is more than 3, we say the data value is very unusual. b) For the city of Bell, how many standard deviations is the city manager salary above the mean? c) For the city of Duarte, how many standard deviations is the city manager salary sbove the mean? d) City managers could make salaries that are three or four times above the mean. Do you get suspicious here about any of the two city managers? Which one? And why
Step 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