Process Control Project Using Survey Data

For this project, I used REDCap to design surveys to collect data on key process metrics from stakeholders over time. REDCap allowed me to efficiently create electronic surveys, distribute them, and collect numeric responses directly into a database. The surveys gathered data on variables like processing times, defect rates, customer satisfaction levels, etc.

I then transferred the raw survey response data from REDCap into statistical software programs SPSS and for analysis. In this program, I performed statistical process control analysis using various control charts (such as p, np, c, u charts) to examine whether the processes were in statistical control or if there were assignable causes of variation impacting process performance.

The results of the control charting revealed which processes were stable over time and which were experiencing issues needing improvement. I presented my analysis back to the clients, identifying processes that were out of control. I also recommended data-driven actions that could be taken to address any unstable processes and drive improvement.

This project demonstrated how I leveraged data collection tools, statistical software, and process control methods to study operational processes using survey data. It provided insight into process performance and opportunities for enhancement based on rigorous statistical analysis.
Process Control Report
SPSS Output file for Process Control Charts

Covenant Hospital Customer Traffic Analysis

For this project, I analyzed customer traffic data collected over 10 weeks from Covenant Hospital and its 3 outlying clinics. The data included hourly customer arrival counts. Using Excel, I created graphs to illustrate daily and hourly traffic patterns.

A daily graph revealed that Fridays had significantly higher average traffic than other weekdays. An hourly graph showed peaks in arrivals from 11am-1pm and late afternoon. These established useful insights into how resources could be optimized.

I also constructed a control chart in Excel to review the stability of weekly traffic over time. The control chart showed the process was in a state of statistical control. However, it highlighted the need for ongoing monitoring in case external factors impact arrivals in the future.

My analysis report and recommendations to hospital management focused on strategically aligning staffing, scheduling, and communications based on the demand patterns. This included staffing up on Fridays/certain hours and spreading out appointments. The project demonstrated how statistical process control can be applied to service systems to improve operations.
Management Report
Excel Analysis File

• Back to Homepage