10 Excel Functions for Data Analysis
April 11, 2024
Article
This course is part of Six Sigma Yellow Belt Specialization
Instructors: David Cook, PhD
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
51,775 already enrolled
Included with
(1,840 reviews)
(1,840 reviews)
Add to your LinkedIn profile
8 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
This course will cover the Measure phase and portions of the Analyze phase of the Six Sigma DMAIC (Define, Measure, Analyze, Improve, and Control) process. You will learn about lean tools for process analysis, failure mode and effects analysis (FMEA), measurement system analysis (MSA) and gauge repeatability and reproducibility (GR&R), and you will be introduced to basic statistics. This course will outline useful measure and analysis phase tools and will give you an overview of statistics as they are related to the Six Sigma process.
The statistics module will provide you with an overview of the concepts and you will be given multiple example problems to see how to apply these concepts. Every module will include readings, discussions, lecture videos, and quizzes to help make sure you understand the material and concepts that are studied. Our applied curriculum is built around the latest handbook The Certified Six Sigma Handbook (2nd edition) and students will develop /learn the fundamentals of Six Sigma. Registration includes online access to course content, projects, and resources but does not include the companion text The Certified Six Sigma Handbook (2nd edition). The companion text is not required to complete the assignments. However, the text is a recognized handbook used by professionals in the field. Also, it is a highly recommended text for those wishing to move forward in Six Sigma and eventually gain certification from professional agencies such as American Society for Quality (ASQ).
Welcome to Six Sigma Tools for Analyze! This is the third course in the Six Sigma Yellow Belt Specialization. Your team of instructors, Dr. Bill Bailey, Dr. David Cook, Dr. Christine Scherrer, and Dr. Gregory Wiles, currently work in the College of Engineering and Engineering Technology at Kennesaw State University. This module will introduce you to Measurement System Analysis (MSA) which is a key component of the Measure phase of the DMAIC process. You will also learn about Gauge Repeatability & Reproducibility (GR&R) and why it is used in the measurement phase.
2 videos1 reading2 assignments
This module will introduce you to the Analysis phase of the DMAIC process. Process analysis helps you to better understand current processes and how they can be improved. You will be introduced to many of the different process analysis tools that are commonly used by Six Sigma experts. Failure Mode and Effects Analysis (FMEA) will also be introduced to help you better understand how to identify process failures.
6 videos2 assignments1 discussion prompt
Root cause analysis is a common problem solving step. Determining the root cause of something is an important aspect of uncovering the causes of a problem. In this module you will review the different tools used in determining root cause including 5-whys, process mapping, force-field analysis, and matrix charts.
6 videos2 assignments1 discussion prompt
In this module you will be diving into the statistical side of Six Sigma. You will begin with learning about the basic distribution types which include normal and binomial. You will then proceed to variation and will learn the difference between common and special cause variation.
7 videos1 reading2 assignments
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Kennesaw State is a Carnegie-designated doctoral research institution (R2), placing it among an elite group of only 6 percent of U.S. colleges. A leader in innovative teaching and learning, KSU is making an impact across the region, the nation and around the world. As the third largest university in the state of Georgia, Kennesaw State has nearly 45,000 students enrolled in over 180 undergraduate, master’s, doctoral degree and certificate programs.
Kennesaw State University
Course
Kennesaw State University
Course
Kennesaw State University
Course
Kennesaw State University
Course
1,840 reviews
78.67%
17.14%
3.03%
0.59%
0.54%
Showing 3 of 1840
Reviewed on Jul 7, 2020
thank you for teaching the basic of six sigma i really enjoyed it, i once again thank all instructors who guided me throughout this course
Reviewed on Nov 21, 2023
Excellent course to develop your Analysis skills. Real-world problem-solving exercises are a great way to develop the skills.
Reviewed on Dec 22, 2020
Excellent course! The practical exercises set was really useful and helped me to grasp a better understanding of data analysis.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Our applied curriculum is built around the latest handbook The Certified Six Sigma Handbook (2nd edition) and students will develop /learn the fundamentals of Six Sigma. Registration includes online access to all course content, projects, and resources. This price does not include the companion text The Certified Six Sigma Handbook (2nd edition).
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.