Statistical quality control through MS Excel
Quality Control, MS Excel, Experimental Analysis, Useful for Quality Engineers.
Microsoft,Office Productivity,Excel Charts
Lectures -31
Resources -1
Duration -5.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course is made to share 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 quality control field and 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 it is readily 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 is having a separate quality control department, hence 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 & whisker plots, scatter plots, control charts, Pareto charts, and so on. Hence, MS excel has all these tools mentioned earlier.
Goals
This is the list of concepts you will learn in this course.
- 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 SQC tools
Prerequisites
- No prior knowledge is required. You will learn everything you need to know.
- Basic mathematics.
![Statistical quality control through MS Excel Statistical quality control through MS Excel](https://d3mxt5v3yxgcsr.cloudfront.net/courses/14208/course_14208_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
5 Lectures
-
Introduction to Course 01:48 01:48
-
Introduction to Quality 15:36 15:36
-
Introduction to Quality Control 05:38 05:38
-
Introduction to Statistical Quality Control 07:17 07:17
-
Course Resources
Demonstration of central tendency and dispersion using MS Excel
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Demonstration of the variation of data using MS Excel
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Demonstration of Central Limit Theorem (CLT) using MS excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Construction of Control Charts using MS Excel
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Examining process capability of a process using MS Excel
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Designing the Sampling Plans
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Sumit Dwivedi](https://www.tutorialspoint.com/assets/profiles/594009/profile/200_276147-1692611582.jpg)
Sumit Dwivedi
I am working as an Assistant Professor at SGSITS, Indore (M.P.). I have more than 6 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.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)