Please ensure Javascript is enabled for purposes of website accessibility
Statistical Quality Control With Microsoft Excel
0( 0 REVIEWS )
4 STUDENTS
5h 45m

Learn all the applications of Microsoft Excel in the files of Statistical Quality Control.

Read more.
Course Skill Level
Beginner
Time Estimate
5h 45m

Instructor

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 Course

About 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
4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?