Part 1 explore the data listed below A Cr ate a histogram of the salary data for the city of Bell, where each bar width is about 50,000 US dollars You can use technology, such as SALT or Excel or sketch this by hand B Describe the shape this histogram C Without making any calculations, will the mean be larger or smaller than the median Explain why D For the city of Duarte, the median salary is 31,597 00 US dollars, the mean salary is 44,713 88 US dollars, and the standard deviation of the salaries is 36,448 59 US dollars (using the formula for the population standard deviationrecall that the data contains the salaries of all city employees) What is the population median, mean, and standard deviation for the salaries in Bell Here is a webpage that will find the mean and SD quickly and you can copy paste from the excel sheet E Compare the mean salaries of Bell and Duarte, paying attention to the position titles and salaries in the two cities Point out at least 3 interesting things you notice F Which department generally has the best salaries in Bell Part 2 the investigation In general, city managers earn the highest salaries in a city, and are paid well above a typical city employee We want to find how far away the city manager salaries are from the mean for each city Some cities have more variation in salaries than others, so we will compute how far the highest paid salaries are from the mean, and then divide that difference by the standard deviation of the city salaries, in order to make a fair comparison In other words, we are going to calculate how many standard deviations the highest salaries are from their city means G For the city of Bell what is the highest salary and which job is it H For the city of Bell how many standard deviations is the highest salary from the mean Note this is a z score, so use (salary mean salary) SD I For the city of Duarte what is the highest salary and which job is it J For the city of Duarte how many standard deviations is the highest salary from the mean K For context, it's normal to see city manager salaries 4 or even 5 standard deviations away from the mean What do you find curious about this data L Wr te a paragraph of a few sentences that would explain to a non stats person why this outcome was worth publishing in the news cityName department position wages Bell Administration Account Clerk 47973 Bell Administration Account Clerk 48207 Bell Administration Account Clerk 46582 Bell Administration Accounting Manager 104406 Bell Administration Assistant City Manager 562538 Bell Administration Assistant to Food Bank Coordinator 110053 Bell Administration Business Development Coordinator 159033 Bell Administration Business License Officer 15071 Bell Administration City Manager 1171423 Bell Administration Council 111260 Bell Administration Council 112489 Bell Administration Council 110954 Bell Administration Council 112627 Bell Administration Director of Administrative Services 253774 Bell Administration Housing Specialist 87657 Bell Administration Management Analyst 50240 Bell Administration Office Assistant 10148 Bell Administration Recreation Aide 15167 Bell Administration Senior Management Analyst 75183 Bell Administration Senior Management Analyst 84937 Bell Community Services Director of Community Services 184176 Bell Community Services Housing Rehabilitation Technician 64399 Bell Community Services Housing Rehabilitation Technician 64705 Bell Community Services Office Assistant 45695 Bell Community Services Recreation Aide 19656 Bell Community Services Recreation Aide 10033 Bell Community Services Recreation Aide 11093 Bell Community Services Recreation Aide 13035 Bell Community Services Recreation Aide 19448 Bell Community Services Recreation Aide 11927 Bell Community Services Recreation Aide 21416 Bell Community Services Recreation Aide 22467 Bell Community Services Recreation Aide 12854 Bell Community Services Recreation Attendant 13729 Bell Community Services Recreation Attendant 13465 Bell Community Services Recreation Attendant 14316 Bell Community Services Recreation Attendant 13094 Bell Community Services Recreation Attendant 13082 Bell Community Services Recreation Attendant 10146 Bell Community Services Recreation Attendant 12641 Bell Community Services Recreation Attendant 15282 Bell Community Services Recreation Attendant 12927 Bell Community Services Recreation Attendant 12227 Bell Community Services Recreation Leader 26120 Bell Community Services Recreation Leader 18802 Bell Community Services Recreation Programmer 25903 Bell Community Services Recreation Supervisor 55993 Bell Community Services Senior Recreation Supervisor 93683 Bell Community Services Senior Recreation Supervisor 87930 Bell General Services Code Enforcement Officer 44779 Bell General Services Code Enforcement Officer 15304 Bell General Services Code Enforcement Officer 45258 Bell General Services Director of General Services 244849 Bell General Services Parking Enforcement Officer 52598 Bell General Services Parking Enforcement Officer 50308 Bell General Services Senior Code Enforcement Officer 77107 Bell Police Assistant Chief of Police 147821 Bell Police Chief of Police 185809 Bell Police Motor Officer 65153 Bell Police Police Captain 131450 Bell Police Police Captain 131450 Bell Police Police Chief 109163 Bell Police Police Detective 90468 Bell Police Police Detective 104613 Bell Police Police Detective 106880 Bell Police Police Lieutenant 76246 Bell Police Police Motor Officer 102106 Bell Police Police Officer 102663 Bell Police Police Officer 112932 Bell Police Police Officer 99425 Bell Police Police Officer 93771 Bell Police Police Officer 90742 Bell Police Police Officer 85539 Bell Police Police Officer 89660 Bell Police Police Officer 94817 Bell Police Police Officer 87987 Bell Police Police Officer 89733 Bell Police Police Officer 85853 Bell Police Police Officer 39085 Bell Police Police Officer 86515 Bell Police Police Officer 103749 Bell Police Police Officer 97036 Bell Police Police Officer 89964 Bell Police Police Officer 94759 Bell Police Police Officer 77005 Bell Police Police Officer 99299 Bell Police Police Officer 92106 Bell Police Police Officer 96044 Bell Police Police Sergeant 113305 Bell Police Police Sergeant 125539 Bell Police Police Sergeant 113461 Bell Police Police Sergeant 116067 Bell Police Police Sergeant 147544 Bell Police Police Sergeant 116368 Bell Police Police Sergeant 114828 Bell Police Administration Community Services Technician 47887 Bell Police Administration Dispatcher 70413 Bell Police Administration Dispatcher 78902 Bell Police Administration Filing Officer 32500 Bell Police Administration Management Analyst 65834 Bell Police Administration Management Analyst 65949 Bell Police Administration Office Assistant 35314 Bell Police Administration Office Coordinator 60387 Bell Police Administration Police Dispatcher 57931 Bell Police Administration Police Dispatcher 57349 Bell Police Administration Police Dispatcher 67693 Bell Police Administration Police Dispatcher 63398 Bell Public Works Deputy City Engineer 164583 Duarte Administrative Services Accountant 61461 Duarte Administrative Services Accounting Specialist 60032 Duarte Administrative Services Administrative Secretary 53176 Duarte Administrative Services Assistant City Manager 132562 Duarte Administrative Services Bus Driver 15467 Duarte Administrative Services Bus Driver 19342 Duarte Administrative Services Bus Driver 18573 Duarte Administrative Services Bus Driver 18700 Duarte Administrative Services Bus Driver 18176 Duarte Administrative Services Bus Driver 20976 Duarte Administrative Services Bus Driver 19784 Duarte Administrative Services Human Resources Analyst 56400 Duarte Administrative Services Human Resources Manager 77250 Duarte Administrative Services Lead Driver 52948 Duarte Administrative Services Transit Supervisor 82606 Duarte City Council Councilmember 13352 Duarte City Manager's Office Administrative Secretary 44609 Duarte City Manager's Office City Manager 215466 Duarte City Manager's Office Clerk Typist Receptionist 33715 Duarte City Manager's Office Deputy City Manager 98430 Duarte City Manager's Office Promise Fellows 10227 Duarte City Manager's Office Promise Fellows 11452 Duarte City Manager's Office Promise Fellows 16181 Duarte Community Development Administrative Secretary 42114 Duarte Community Development Administrative Secretary 48132 Duarte Community Development Assistant Civil Engineer 72665 Duarte Community Development Assistant Planner 29479 Duarte Community Development City Engineer 20580 Duarte Community Development Director of Community Development 129298 Duarte Community Development Engineering Division Manager 98714 Duarte Community Development Field Services Manager 102490 Duarte Community Development Field Services Supervisor 66878 Duarte Community Development Irrigation Control Technician 53847 Duarte Community Development Planning Intern 13318 Duarte Community Development Redevelopment Coordinator 55845 Duarte Community Development Senior Maintenance Technician 46754 Duarte Community Development Senior Maintenance Technician 58025 Duarte Community Development Senior Maintenance Technician 56148 Duarte Community Development Senior Maintenance Technician Electrician 55597 Duarte Community Development Senior Planner 89107 Duarte Community Development Senior Planner 91391 Duarte Parks Recreation Assistant Boxing Trainer 12127 Duarte Parks Recreation Assistant Boxing Trainer 11858 Duarte Parks Recreation Boxing Trainer 18657 Duarte Parks Recreation Custodian 17875 Duarte Parks Recreation Custodian 21090 Duarte Parks Recreation Custodian 14101 Duarte Parks Recreation Custodian 20063 Duarte Parks Recreation Custodian 14124 Duarte Parks Recreation Custodian 17584 Duarte Parks Recreation Custodian 18117 Duarte Parks Recreation Custodian 20722 Duarte Parks Recreation Custodian 18878 Duarte Parks Recreation Custodian 20014 Duarte Parks Recreation Custodian 20779 Duarte Parks Recreation Custodian 24763 Duarte Parks Recreation Custodian 17633 Duarte Parks Recreation Fee and Charge Instructor 16147 Duarte Parks Recreation Recreation Coordinator 27080 Duarte Parks Recreation Recreation Coordinator 33974 Duarte Parks Recreation Recreation Leader 13918 Duarte Parks Recreation Recreation Leader 11233 Duarte Parks Recreation Recreation Leader 11919 Duarte Parks Recreation Recreation Leader 11214 Duarte Parks Recreation Recreation Superintendent 97147 Duarte Parks Recreation Recreation Supervisor 69113 Duarte Parks Recreation Recreation Supervisor 69030 Duarte Parks Recreation Recreation Supervisor 52885 Duarte Parks Recreation Recreation Supervisor 69817 Duarte Parks Recreation Senior Custodian 45081 Duarte Public Safety Administrative Secretary 53565 Duarte Public Safety Clerk Typist Receptionist 10194 Duarte Public Safety Code Compliance Animal Control Officer 58478 Duarte Public Safety Code Compliance Animal Control Officer 62028 Duarte Public Safety Code Compliance Animal Control Officer 62038 Duarte Public Safety Community Services Officer 16440 Duarte Public Safety Community Services Officer 15567 Duarte Public Safety Community Services Officer 15452 Duarte Public Safety Crime Prevention Specialist 60025 Duarte Public Safety Director of Public Safety Services 125113 https www latimes com local la me bell salary 20100715 story html

The Answer is in the image, click to view ...

Question: Part 1 - explore the data listed below: A. Crate a histogram of the salary data for the city of Bell, where each bar width

Part 1 - explore the data listed below:

A. Cr"ate a histogram of the salary data for the city of Bell, where each bar width is about 50,000 US dollars. You can use technology, such as SALT or Excel or sketch this by hand. B. Describe the shape this histogram. C. Without making any calculations, will the mean be larger or smaller than the median? Explain why. D. For the city of Duarte, the median salary is 31,597.00 US dollars, the mean salary is 44,713.88 US dollars, and the standard deviation of the salaries is 36,448.59 US dollars (using the formula for the population standard deviationrecall that the data contains the salaries of all city employees). What is the population median, mean, and standard deviation for the salaries in Bell? [Here is a webpage that will find the mean and SD quickly and you can copy/paste from the excel sheet.] E. Compare the mean salaries of Bell and Duarte, paying attention to the position titles and salaries in the two cities. Point out at least 3 interesting things you notice. F. Which department generally has the best salaries in Bell? Part 2 - the investigation In general, city managers earn the highest salaries in a city, and are paid well above a typical city employee. We want to find how far away the city manager salaries are from the mean for each city. Some cities have more variation in salaries than others, so we will compute how far the highest paid salaries are from the mean, and then divide that difference by the standard deviation of the city salaries, in order to make a fair comparison. In other words, we are going to calculate how many standard deviations the highest salaries are from their city means. G. For the city of Bell - what is the highest salary and which job is it? H. For the city of Bell - how many standard deviations is the highest salary from the mean? Note: this is a z-score, so use (salary - mean salary)/SD I. For the city of Duarte - what is the highest salary and which job is it? J. For the city of Duarte - how many standard deviations is the highest salary from the mean?

K. For context, it's normal to see city manager salaries 4 or even 5 standard deviations away from the mean. What do you find curious about this data? L. Wr"te a paragraph of a few sentences that would explain to a non-stats-person why this outcome was worth publishing in the news.

cityName	department	position	wages
Bell	Administration	Account Clerk	47973
Bell	Administration	Account Clerk	48207
Bell	Administration	Account Clerk	46582
Bell	Administration	Accounting Manager	104406
Bell	Administration	Assistant City Manager	562538
Bell	Administration	Assistant to Food Bank Coordinator	110053
Bell	Administration	Business Development Coordinator	159033
Bell	Administration	Business License Officer	15071
Bell	Administration	City Manager	1171423
Bell	Administration	Council	111260
Bell	Administration	Council	112489
Bell	Administration	Council	110954
Bell	Administration	Council	112627
Bell	Administration	Director of Administrative Services	253774
Bell	Administration	Housing Specialist	87657
Bell	Administration	Management Analyst	50240
Bell	Administration	Office Assistant	10148
Bell	Administration	Recreation Aide	15167
Bell	Administration	Senior Management Analyst	75183
Bell	Administration	Senior Management Analyst	84937
Bell	Community Services	Director of Community Services	184176
Bell	Community Services	Housing Rehabilitation Technician	64399
Bell	Community Services	Housing Rehabilitation Technician	64705
Bell	Community Services	Office Assistant	45695
Bell	Community Services	Recreation Aide	19656
Bell	Community Services	Recreation Aide	10033
Bell	Community Services	Recreation Aide	11093
Bell	Community Services	Recreation Aide	13035
Bell	Community Services	Recreation Aide	19448
Bell	Community Services	Recreation Aide	11927
Bell	Community Services	Recreation Aide	21416
Bell	Community Services	Recreation Aide	22467
Bell	Community Services	Recreation Aide	12854
Bell	Community Services	Recreation Attendant	13729
Bell	Community Services	Recreation Attendant	13465
Bell	Community Services	Recreation Attendant	14316
Bell	Community Services	Recreation Attendant	13094
Bell	Community Services	Recreation Attendant	13082
Bell	Community Services	Recreation Attendant	10146
Bell	Community Services	Recreation Attendant	12641
Bell	Community Services	Recreation Attendant	15282
Bell	Community Services	Recreation Attendant	12927
Bell	Community Services	Recreation Attendant	12227
Bell	Community Services	Recreation Leader	26120
Bell	Community Services	Recreation Leader	18802
Bell	Community Services	Recreation Programmer	25903
Bell	Community Services	Recreation Supervisor	55993
Bell	Community Services	Senior Recreation Supervisor	93683
Bell	Community Services	Senior Recreation Supervisor	87930
Bell	General Services	Code Enforcement Officer	44779
Bell	General Services	Code Enforcement Officer	15304
Bell	General Services	Code Enforcement Officer	45258
Bell	General Services	Director of General Services	244849
Bell	General Services	Parking Enforcement Officer	52598
Bell	General Services	Parking Enforcement Officer	50308
Bell	General Services	Senior Code Enforcement Officer	77107
Bell	Police	Assistant Chief of Police	147821
Bell	Police	Chief of Police	185809
Bell	Police	Motor Officer	65153
Bell	Police	Police Captain	131450
Bell	Police	Police Captain	131450
Bell	Police	Police Chief	109163
Bell	Police	Police Detective	90468
Bell	Police	Police Detective	104613
Bell	Police	Police Detective	106880
Bell	Police	Police Lieutenant	76246
Bell	Police	Police Motor Officer	102106
Bell	Police	Police Officer	102663
Bell	Police	Police Officer	112932
Bell	Police	Police Officer	99425
Bell	Police	Police Officer	93771
Bell	Police	Police Officer	90742
Bell	Police	Police Officer	85539
Bell	Police	Police Officer	89660
Bell	Police	Police Officer	94817
Bell	Police	Police Officer	87987
Bell	Police	Police Officer	89733
Bell	Police	Police Officer	85853
Bell	Police	Police Officer	39085
Bell	Police	Police Officer	86515
Bell	Police	Police Officer	103749
Bell	Police	Police Officer	97036
Bell	Police	Police Officer	89964
Bell	Police	Police Officer	94759
Bell	Police	Police Officer	77005
Bell	Police	Police Officer	99299
Bell	Police	Police Officer	92106
Bell	Police	Police Officer	96044
Bell	Police	Police Sergeant	113305
Bell	Police	Police Sergeant	125539
Bell	Police	Police Sergeant	113461
Bell	Police	Police Sergeant	116067
Bell	Police	Police Sergeant	147544
Bell	Police	Police Sergeant	116368
Bell	Police	Police Sergeant	114828
Bell	Police Administration	Community Services Technician	47887
Bell	Police Administration	Dispatcher	70413
Bell	Police Administration	Dispatcher	78902
Bell	Police Administration	Filing Officer	32500
Bell	Police Administration	Management Analyst	65834
Bell	Police Administration	Management Analyst	65949
Bell	Police Administration	Office Assistant	35314
Bell	Police Administration	Office Coordinator	60387
Bell	Police Administration	Police Dispatcher	57931
Bell	Police Administration	Police Dispatcher	57349
Bell	Police Administration	Police Dispatcher	67693
Bell	Police Administration	Police Dispatcher	63398
Bell	Public Works	Deputy City Engineer	164583
Duarte	Administrative Services	Accountant	61461
Duarte	Administrative Services	Accounting Specialist	60032
Duarte	Administrative Services	Administrative Secretary	53176
Duarte	Administrative Services	Assistant City Manager	132562
Duarte	Administrative Services	Bus Driver	15467
Duarte	Administrative Services	Bus Driver	19342
Duarte	Administrative Services	Bus Driver	18573
Duarte	Administrative Services	Bus Driver	18700
Duarte	Administrative Services	Bus Driver	18176
Duarte	Administrative Services	Bus Driver	20976
Duarte	Administrative Services	Bus Driver	19784
Duarte	Administrative Services	Human Resources Analyst	56400
Duarte	Administrative Services	Human Resources Manager	77250
Duarte	Administrative Services	Lead Driver	52948
Duarte	Administrative Services	Transit Supervisor	82606
Duarte	City Council	Councilmember	13352
Duarte	City Manager's Office	Administrative Secretary	44609
Duarte	City Manager's Office	City Manager	215466
Duarte	City Manager's Office	Clerk/Typist Receptionist	33715
Duarte	City Manager's Office	Deputy City Manager	98430
Duarte	City Manager's Office	Promise Fellows	10227
Duarte	City Manager's Office	Promise Fellows	11452
Duarte	City Manager's Office	Promise Fellows	16181
Duarte	Community Development	Administrative Secretary	42114
Duarte	Community Development	Administrative Secretary	48132
Duarte	Community Development	Assistant Civil Engineer	72665
Duarte	Community Development	Assistant Planner	29479
Duarte	Community Development	City Engineer	20580
Duarte	Community Development	Director of Community Development	129298
Duarte	Community Development	Engineering Division Manager	98714
Duarte	Community Development	Field Services Manager	102490
Duarte	Community Development	Field Services Supervisor	66878
Duarte	Community Development	Irrigation Control Technician	53847
Duarte	Community Development	Planning Intern	13318
Duarte	Community Development	Redevelopment Coordinator	55845
Duarte	Community Development	Senior Maintenance Technician	46754
Duarte	Community Development	Senior Maintenance Technician	58025
Duarte	Community Development	Senior Maintenance Technician	56148
Duarte	Community Development	Senior Maintenance Technician*Electrician	55597
Duarte	Community Development	Senior Planner	89107
Duarte	Community Development	Senior Planner	91391
Duarte	Parks & Recreation	Assistant Boxing Trainer	12127
Duarte	Parks & Recreation	Assistant Boxing Trainer	11858
Duarte	Parks & Recreation	Boxing Trainer	18657
Duarte	Parks & Recreation	Custodian	17875
Duarte	Parks & Recreation	Custodian	21090
Duarte	Parks & Recreation	Custodian	14101
Duarte	Parks & Recreation	Custodian	20063
Duarte	Parks & Recreation	Custodian	14124
Duarte	Parks & Recreation	Custodian	17584
Duarte	Parks & Recreation	Custodian	18117
Duarte	Parks & Recreation	Custodian	20722
Duarte	Parks & Recreation	Custodian	18878
Duarte	Parks & Recreation	Custodian	20014
Duarte	Parks & Recreation	Custodian	20779
Duarte	Parks & Recreation	Custodian	24763
Duarte	Parks & Recreation	Custodian	17633
Duarte	Parks & Recreation	Fee and Charge Instructor	16147
Duarte	Parks & Recreation	Recreation Coordinator	27080
Duarte	Parks & Recreation	Recreation Coordinator	33974
Duarte	Parks & Recreation	Recreation Leader	13918
Duarte	Parks & Recreation	Recreation Leader	11233
Duarte	Parks & Recreation	Recreation Leader	11919
Duarte	Parks & Recreation	Recreation Leader	11214
Duarte	Parks & Recreation	Recreation Superintendent	97147
Duarte	Parks & Recreation	Recreation Supervisor	69113
Duarte	Parks & Recreation	Recreation Supervisor	69030
Duarte	Parks & Recreation	Recreation Supervisor	52885
Duarte	Parks & Recreation	Recreation Supervisor	69817
Duarte	Parks & Recreation	Senior Custodian	45081
Duarte	Public Safety	Administrative Secretary	53565
Duarte	Public Safety	Clerk Typist/Receptionist	10194
Duarte	Public Safety	Code Compliance/Animal Control Officer	58478
Duarte	Public Safety	Code Compliance/Animal Control Officer	62028
Duarte	Public Safety	Code Compliance/Animal Control Officer	62038
Duarte	Public Safety	Community Services Officer	16440
Duarte	Public Safety	Community Services Officer	15567
Duarte	Public Safety	Community Services Officer	15452
Duarte	Public Safety	Crime Prevention Specialist	60025
Duarte	Public Safety	Director of Public Safety Services	125113

https://www.latimes.com/local/la-me-bell-salary-20100715-story.html

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 Mathematics Questions!

Part 1 - explore the data: A. Cr'ate a histogram of the salary data for the city of Bell, where each bar width is about 50,000 US dollars. I have created a histogram basic on the given data.

2.2 51 Summarizing Data for a Quantitative Variable Exercises Methods 11. Consider the following data. WEB 14 19 24 19 16 20 24 20 file Frequency a. b. SELF test 21 22 24 18 17 23 26 22 23 25 25 19...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

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...

1. Create and upload a histogram of the salary data for the city of Bell, where each bar width is about 50,000 US dollars. (Data for the histogram is at the bottom). a.) Is the distribution of the...

Create and upload a histogram of the salary data for the city of Bell, where each bar width is about 50,000 US dollars. (Submit a file with a maximum size of 1 MB.) Choose File | No file chosen This...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

An Investigation into obesity rates Researchers have been interested in studying the obesity trends worldwide over the past 25 years. In 2014 the World Health Organization (WHO) declared there were....

U Login | UMGC X U Week 4: Dealing with Dist X U Week 1: Introductions and X Chapter 2 Homework X A Chapter 2 Homework - M. X + X CD webassign.net/web/Student/Assignment-Responses/last?dep=30133497 ....

The following information was drawn from the balance sheets of two companies: Required a. Compute the debt to assets ratio to measure the level of financial risk of both companies. b. Compare the two...

Metamorphism occurs at depth. Since geologists cannot see this going on, can they apply the axiom of the present is the key to the past?

Question 4 1 1 . 5 ots Lam Inc had the following inventory records: Date Transaction Mar. 1 Beginning Inventory Mar. 1 0 Purchase Mar. 1 6 Purchase Mar. 2 3 Purchase \ table [ [ \ table [ [ Number of...

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: a. The gross margin is 25% of sales. b. Actual and budgeted sales data: c. Sales are 60% for...