The data that is needed from: https://data.world/govex/human-resources-training

4. What a. 79 days

is the average Time-to-Hire for a filled position in this city?

63 days

86 days

42 days

120 days

For which of the departments below are BOTH of the following true: (1) the department has more positions than the average for all departments; and (2) the average Time-to-Hire for the department is above the average Time-to-Hire for the city?

Sheriff's Office

Fire and Rescue Services

Department of Transportation

Department of Police

Department of Public Libraries

For which of the HR Analysts below are ALL of the following true: (1) the analyst has more vacant positions associated with his/her name than the rounded-down average for all analysts; and (2) the Time-to-Hire for the analyst is above the average Time-to-Hire for the city; (3) the analyst is associated with the largest number of currently-vacant positions at the Department of Police?

Charles Moore

Dorothy Thompson

Thomas White

Barbara Davis

James Johnson

Which step in the hiring process takes the longest, on average, and may be the largest constraint?

Between Budgeting and Posting

Between Interview and Offer

Between Posting and Interviewing

Between Offer and Acceptance

Between Acceptance and Security

8. Building on the previous question, for the step in the hiring process which takes the longest, which Hiring Analyst has the highest average time spent completing that step in the process and which department is his/her caseload associated with?

Robert Miller, Department of Transportation

James Johnson, Department of Environmental Protection

Charles Moore, Department of Police

Thomas White, Office of Procurement

Dorothy Thompson, Department of Police

9. Create and use a Bin range which begins at 40 and increases by 10 until you reach 140. Which bin has the highest frequency of cases? Note: Students may have different bin arrangements depending on how the histogram is constructed and which software is used. Regardless of which tool you use, by showing your work, you will retroactively receive credit for the answer that closest mirrors the bin labels in your submitted analysis.

50 Days

60 Days

70 Days

80 Days

90 Days

10. For filled positions, what is the correlation between the Salary and Time-to-Hire?

Low/Weak Positive

Moderate Positive

Low/Weak Negative

Moderate Negative

High/Strong Positive

How do I answer these questions in excel?