Skip to content
No description, website, or topics provided.
Jupyter Notebook R
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
City Time 3.ipynb
Correlation_Analysis.R
README.md

README.md

Predicting Staff Levels for Front line Workers

Objective:

To study the correlation between the average wait time for DOB customers and the leave time of front line workers.

Predict the increase in staffing during busy months (i.e. summer) required to maintain a wait time of ½ hour.

Average wait and total leave steadily increases throughout the year and peaks in June and July:

average wait time and total leave per month

Data and Methods

Data:

  1. 52 weeks of average wait time from QMATIC.

  2. Leave time for each worker from City Time.

  3. Data aggregated to the unit level (work group).

  4. Each group categorized according to job function - Application processing, certificate of occupancy, records.

Methods:

Correlation analysis, linear regression

Software

R, Python, Teableau

Results

Correlation between average wait time and percent hours of leave per group:

correlation analysis results

Regression Analysis

Regression analysis is used to predict the average wait time with increased leave time.

More specifically, when leave increases we want to know the increase in the number of workers required to maintain an average wait time at or below ½ hour.

The dependent variable in our analysis is the average wait time and the independent variable is average hours of leave.

We focus on application processing only (low correlation for records and certificate of occupancy)

Regression results shows that percent leave must be kept to 2.5 hours a week for an average wait time of 30 minutes:

application processing

You can’t perform that action at this time.