Creating Pareto Chart in Microsoft Office Excel

During the Define step of a Six Sigma project the project team needs to identify the problem or the opportunity that the project is intended to solve. Usually, there would be more than one potential problem that can be addressed in a Six Sigma project; however, not all of them would have significant improvement. So, the project team needs to filter out those problems that if resolved will result in huge improvement and positive impact on the bottom line, and this is what Pareto analysis is used for.

Watch this video to know more about using Microsoft Office Excel to create a Pareto chart in a Six Sigma project.