Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1f. (3 points) What is the cutoff value for having a high salary? What is the cutoff value for having a low salary? Combined

image text in transcribedimage text in transcribed

1f. (3 points) What is the cutoff value for having a high salary? What is the cutoff value for having a low salary? Combined with the values printed in 1f., what do these values tell you about the distribution of the data? [ ]: print("Cutoff for a high salary:") print("Cutoff for a low salary:") print("These values show that [description of the hypothesized distribution of the data]") Cutoff for a high salary: Cutoff for a low salary: These values show that [description of the hypothesized distribution of the data] 1g. (5 points) Create a histogram visualizing the annual_salary column of df. Adjust the number of bins to an appropriate value. Make sure that all text is readable. Set appropriate labels for the title and x and y axes. Provide a brief interpretation of your visualization. Briefly explain why you chose the number of bins you chose. [ ] : print("As shown in the figure, [description of what is shown in the figure]") print("I chose to use () bins because [reason]") As shown in the figure, [description of what is shown in the figure] I chose to use () bins because [reason] 1h. (2 points) According to a government guideline, an employee's base hourly rate can be calculated by dividing their annual rate by 2087 hours. Assuming that the overtime rate is 1.5 times the base rate, compute the number of overtime hours worked by each employee in the dataset. Store this data in df as a column called overtime_hours. [ ]: 1a. (1 point) Update file_path to read the data into the notebook and examine the output from the head method. [ ] : import pandas as pd [4]: ' file_path = "./data/employee_salaries.csv" df = pd.read_csv(file_path, dtype = {'calendar_year' : str, 'quarter': str}) df = df.drop("objectid", axis=1) print("(rows, columns):", df.shape) df.head() (rows, columns): (344145, 8) 0 calendar_year quarter last_name first_name title department annual_salary ytd_overtime_gross COMMON PLEAS 2016 1 CHILIBERTI ROSEMARY ADM TECHNICIAN III 50543.0 0.0 COURT 1 2016 1 SMITH KARI SENIOR CREW CHIEF MANAGING DIRECTOR'S OFFICE 34842.0 0.0 2 2016 1 BRUMSKILL SANDRA SCHOOL CROSSING GUARD POLICE DEPARTMENT 0.0 0.0 3 2016 1 ALEXANDER KHADEJAH CLERK TEMPORARY- SUMMER-$7.00/HR. COMMON PLEAS COURT 0.0 0.0 4 2016 1 HILL SEAN PROBATION OFFICER 2 COMMON PLEAS COURT 56206.0 0.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Linear Algebra with Applications

Authors: Bernard Kolman, David Hill

9th edition

132296543, 978-0132296540

More Books

Students also viewed these Mathematics questions

Question

How much do/did others trust you in this situation?

Answered: 1 week ago