Question: 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 highsalary? 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

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!