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.

Author: Mohammed Barakat

Mohammed Barakat is an Excellence Enabler, a Data Scientist, and a Trainer who holds several certifications. He is a Consultant Engineer in Industrial Engineering (JCE), a Project and Risk Management Professional (PMP, PMI-RMP), and a Six Sigma Black Belt (CSSBB). He is a proficient trainer accredited by Microsoft (MCT) and is also a speaker in national and international professional and business gatherings. He was named a winner of the prestigious ASQ MEA Quality Professionals Award for the year 2018 in Jordan.

One thought on “Creating Pareto Chart in Microsoft Office Excel”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.