Utilizing the Chapter 04 Analysis Data Set document, which is linked in the Module Five activity assignment in your course, create a Pareto chart depicting the top 10 states with the longest lengths of stay, and the average length of stay for the remaining 40 states.

IHP 430 Module Five Activity Guidelines

Overview:

The use of statistical process control tools helps address organizational performance in many industries, including Healthcare Information Management. A Pareto chart is a type of analysis tool that helps with ranking causes from most significant to least significant.

For this activity, you will create a Pareto chart using the data provided. As you complete this activity, consider whether these tools could help identify and solve your organizational problem for your final project. For help on how to create a Pareto chart, see this tutorial from Microsoft Office.

Prompt:

Utilizing the Chapter 04 Analysis Data Set document, which is linked in the Module Five activity assignment in your course, create a Pareto chart depicting the top 10 states with the longest lengths of stay, and the average length of stay for the remaining 40 states.

Your chart should contain 11 columns.

In a separate Word document, answer the following questions regarding your Pareto Chart:

 Determine if there is any commonality among the states with long lengths of stay. Explain your conclusion.
 Evaluate the use of statistical process control tools and how they could address organizational performance.
 Identify how these tools could help solve your organizational problem for your final project.

Guidelines for Submission:

Submit the Pareto chart as an Excel document. For the corresponding questions, submit in a Word document with double spacing, 12-point Times New Roman font, and one-inch margins. Use APA format for the reference list and all internal citations.

Last Completed Projects