Answered step by step
Verified Expert Solution
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
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
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