Statistical quality control with MS Excel

Focused View

Sumit Dwivedi

5:45:03

262 View

1. Introduction

1. Introduction to Course.mp4

01:48

2. Introduction to Quality.mp4

15:36

3. Introduction to Quality Control.mp4

05:38

4. Introduction to Statistical Quality Control.mp4

07:17

2. Demonstration of central tendency and dispersion using MS Excel

1. What is central tendency and dispersion.mp4

24:16

2. Demonstration of central tendency using MS Excel.mp4

06:51

3. Demonstration of dispersion using MS Excel.mp4

06:03

3. Demonstration of the variation of data using MS Excel

1. Variation in age of students by Histogram using MS Excel.mp4

10:31

2. Variation in age of students by stem and leaf plot.mp4

17:19

3. Variation in age of students by box plot using MS Excel.mp4

21:43

4. Demonstration of Central Limit Theorem (CLT) using MS excel

1. What is Central limit theorem.mp4

09:12

2. What is Normal distribution.mp4

15:43

3. Construction of Normal distribution using MS Excel.mp4

07:05

4. Distribution through single dice values.mp4

05:27

5. Distribution through double dice values.mp4

05:04

6. Distribution through five dice values.mp4

04:25

5. Construction of Control Charts using MS Excel

1. Variables and Attributes.mp4

05:18

2. Classification of Control Charts.mp4

07:50

3. Construction of Mean Chart using MS Excel.mp4

09:30

4. Construction of Range Chart using MS Excel.mp4

03:26

5. Construction of p-chart using MS Excel.mp4

05:38

6. Construction of np-chart using MS Excel.mp4

08:05

7. Construction of c-chart using MS Excel.mp4

03:41

6. Examining process capability of a process using MS Excel

1. What is Process Capability.mp4

13:31

2. What is process capability ratio and process capability index.mp4

19:09

3. Process Capability Analysis using MS excel.mp4

25:53

4. Percentage of defective products produced using Z score.mp4

16:45

7. Designing the Sampling Plans

1. Introduction to Larson Nomogram.mp4

09:13

2. Designing Single Sampling Plan (SSP) using Larson Nomogram.mp4

31:17

3. Designing Double Sampling Plan based on Military Standard 105E (MIL STD 105E).mp4

21:49

Description

Quality Control, MS Excel, Experimental Analysis, Useful for Quality Engineers.

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 SQC tools

Who is this for?

Anyone can take this course.

What You Need to Know?

No prior knowledge is required. You will learn everything you need to know.

Basic mathematics.

More details

Description
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 basic understanding of MS excel in the field of quality control along with the various tools used to solve the 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 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.
Who this course is for:
Anyone can take this course.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Charts

Sumit Dwivedi

Instructor's Courses

I am currently working as an Assistant Professor at SGSITS, Indore (M.P.). I have more than 4 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.