Learn all the applications of Microsoft Excel in the files of Statistical Quality Control. Read more.
I am currently working as an Assistant Professor at SGSITS, Indore (M.P.). I have more than 5 years of teaching experience. My field of expertise is Manufacturing Engineering, Material Science, and Statistical Quality Control. I am currently teaching engineering students. I am also involved in various research projects. I am still learning new things daily and keep myself updated.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Anyone can take this course
What you’ll learn:
- Understand the concept of Quality Control
- Experimental understanding of quality problems
- Understand the applications of MS Excel in the field of Quality Control
- Understand live examples to demonstrate the various Statistical Quality Control tools
Requirements:
- No prior knowledge is required. You will learn everything you need to know.
- Basic mathematics
This course is made with the purpose of sharing my knowledge with people around the world. I created this course after gathering my knowledge of the concepts of quality control and its experimental aspects.
In this course, you will learn the basics of MS excel in the field of quality control, along with the various tools used to solve quality problems. This course will help you to apply the concept of quality control in various fields like engineering, medicine, or even daily life practice.
This course focuses on industrial problems and their possible solutions with the simple computer software tool that is MS excel, because this tool is easily available in most industries and educational organizations. This also helps in engaging the students to think and apply the knowledge of quality control in various daily life practices along with the various problems related to quality issues.
Since every organization has a separate quality control department, it also helps in exploring the various tools of quality control in the organization itself. Statistical quality control uses statistical tools like histograms, bar charts, box and whisker plots, scatter plots, control charts, Pareto charts, and so on.
Our Promise to You
By the end of this course, you will have learned how to use Microsoft Excel for statistical quality control.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today!
Course Curriculum
Section 1 - Introduction | |||
Downloadable Course Resources | 00:00:00 | ||
Introduction To Course | 00:00:00 | ||
Introduction To Quality | 00:00:00 | ||
Introduction To Quality Control | 00:00:00 | ||
Introduction To Statistical Quality Control | 00:00:00 | ||
Section 2 - Demonstration Of Central Tendency And Dispersion Using MS Excel | |||
What Is Central Tendency And Dispersion? | 00:00:00 | ||
Demonstration Of Central Tendency Using MS Excel | 00:00:00 | ||
Demonstration Of Dispersion Using Excel | 00:00:00 | ||
Section 3 - Demonstration Of The Variation Of Data Using MS Excel | |||
Variation In Age Of Students By Histogram Using Excel | 00:00:00 | ||
Variation In Age Of Students By Stem And Leaf Plot | 00:00:00 | ||
Variation In Age Of Students By Box Plot Using Excel | 00:00:00 | ||
Section 4 - Demonstration Of Central Limit Theorem (CLT) Using MS Excel | |||
What Is Central Limit Theorem? | 00:00:00 | ||
What Is Normal Distribution? | 00:00:00 | ||
Construction Of Normal Distribution Using Excel | 00:00:00 | ||
Distribution Through Single Dice Values | 00:00:00 | ||
Distribution Through Double Dice Values | 00:00:00 | ||
Distribution Through Five Dice Values | 00:00:00 | ||
Section 5 - Construction Of Control Charts Using MS Excel | |||
Variables And Attributes | 00:00:00 | ||
Classification Of Control Charts | 00:00:00 | ||
Construction Of Mean Chart Using Excel | 00:00:00 | ||
Construction Of Range Chart Using Excel | 00:00:00 | ||
Construction Of P-Chart Using Excel | 00:00:00 | ||
Construction Of Np-Chart Using Excel | 00:00:00 | ||
Construction Of C-Chart Using Excel | 00:00:00 | ||
Section 6 - Examining Process Capability Of A Process Using MS Excel | |||
What Is Process Capability? | 00:00:00 | ||
What Is Process Capability Ratio And Process Capability Index? | 00:00:00 | ||
Process Capability Analysis Using Excel | 00:00:00 | ||
Percentage Of Defective Products Produced Using Z Score | 00:00:00 | ||
Section 7 - Designing The Sampling Plans | |||
Introduction To Larson Nomogram | 00:00:00 | ||
Designing Single Sampling Plan (SSP) Using Larson Nomogram | 00:00:00 | ||
Designing Double Sampling Plan Based On Military Standard 105E (MIL STD 105E) | 00:00:00 |