Statistical quality control with MS Excel

in Microsoft Excel

Best Seller

(0 Ratings)

3 Students enrolled

Created by Sumit Dwivedi

English Intermediate

Last Updated

23 Jan 2023

What you'll learn

Understand the Concept of Quality Control

Understand the applications of MS Excel in the field of Quality Control

Experimental understanding of quality problems

Understand live examples to Demonstrate the various SQC tools

Get certificate of completion

Course content

30 Lessons • 5:45 Hr

Introduction

4 Lessons • 0:30 Hr

Introduction to Course

0:01 Hr

Introduction to Quality

0:15 Hr

Introduction to Quality Control

0:05 Hr

Introduction to Statistical Quality Control

0:07 Hr

What is central tendency and dispersion

3 Lessons • 0:37 Hr

Demonstration Of Central Tendency & Dispersion Using MS Excel

0:24 Hr

Demonstration of central tendency using MS Excel

0:06 Hr

Demonstration of dispersion using MS Excel

0:06 Hr

Variation in age of students by stem and leaf plot

3 Lessons • 0:49 Hr

Variation in age of students by Histogram using MS Excel

0:10 Hr

Variation in age of students by stem and leaf plot

0:17 Hr

Variation in age of students by box plot using MS Excel

0:21 Hr

What is Central limit theorem

6 Lessons • 0:46 Hr

What is Central limit theorem?

0:09 Hr

What is Normal distribution

0:15 Hr

Construction of Normal distribution using MS Excel

0:07 Hr

Distribution through single dice values

0:05 Hr

Distribution through double dice values

0:05 Hr

Distribution through five dice values

0:04 Hr

Variables and Attributes

7 Lessons • 0:43 Hr

Construction Of Control Charts Using MS Excel

0:05 Hr

Classification of Control Charts

0:07 Hr

Construction of Mean Chart using MS Excel

0:09 Hr

Construction of Range Chart using MS Excel

0:03 Hr

Construction of p chart using MS Excel

0:05 Hr

Construction of np chart using MS Excel

0:08 Hr

Construction of c chart using MS Excel

0:03 Hr

What is Process Capability

4 Lessons • 1:15 Hr

Examining Process Capability of a Process Using MS Excel

0:13 Hr

What is process capability ratio and process capability index

0:19 Hr

Process Capability Analysis using MS excel

0:25 Hr

Percentage of defective products produced using Z score

0:16 Hr

Introduction to Larson Nomogram

3 Lessons • 1:02 Hr

Designing The Sampling Plans

0:09 Hr

Designing Single Sampling Plan SSP using Larson Nomogram

0:31 Hr

Designing Double Sampling Plan based on Military Standard 105E MIL STD 105E

0:21 Hr

2 more sections

Requirements

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

Basic mathematics.

About this course

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 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.

We’re in the News!

About the instructor

Sumit Dwivedi

EFA User

Sumit Dwivedi

EFA User

0 Reviews
2 Courses

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.

30 Video Lessons

Get instant & lifetime access

This course contains pre-recorded videos that can be watched anytime

30 day money back

Don’t like it, no problems

If for any reason you are not happy with your purchase, simply email us within 30 days of purchase and we will refund you within 24 hours.

Celebrating

200000+

Happy Learners!

Student reviews

Course Rating

Content quality (0)

Instructor skills (0)

Purchase worth (0)

Support quality (0)

Statistical quality control with MS Excel

in Microsoft Excel

Best Seller

(0 Ratings)

3 Students enrolled

Created by Sumit Dwivedi

English Intermediate

Last Updated

23 Jan 2023

₹999.00

₹2,999.00

Get Discount 66.69% off

7 Hours left for this price

₹999.00

₹2,999.00

30 Days money back guarantee

Gift this course

Send this course as a gift to your friends

This Course includes:

5:45 Hours On demand videos

30 Lessons

Full time access

Access on mobile, Tablet and tv

Course specifications

Capacity:

Unlimited

Duration:

5:45 Hours

Files:

Statistical quality control with MS Excel

What you'll learn

Get certificate of completion

Course content

Requirements

About this course

We’re in the News!

About the instructor

Sumit Dwivedi

Sumit Dwivedi

30 Video Lessons

Get instant & lifetime access

30 day money back

Don’t like it, no problems

Celebrating

200000+

Happy Learners!

Student reviews

Statistical quality control with MS Excel

Gift this course

Course specifications

Report course

Share

Buy with points