Statistical quality control with MS Excel

سرفصل های دوره

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

1. Introduction

1. Introduction to Course

2. Introduction to Quality

3. Introduction to Quality Control

4. Introduction to Statistical Quality Control

2. Demonstration of central tendency and dispersion using MS Excel

1. What is central tendency and dispersion

2. Demonstration of central tendency using MS Excel

3. Demonstration of dispersion using MS Excel

3. Demonstration of the variation of data using MS Excel

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

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

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

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

1. What is Central limit theorem

2. What is Normal distribution

3. Construction of Normal distribution using MS Excel

4. Distribution through single dice values

5. Distribution through double dice values

6. Distribution through five dice values

5. Construction of Control Charts using MS Excel

1. Variables and Attributes

2. Classification of Control Charts

3. Construction of Mean Chart using MS Excel

4. Construction of Range Chart using MS Excel

5. Construction of p-chart using MS Excel

6. Construction of np-chart using MS Excel

7. Construction of c-chart using MS Excel

6. Examining process capability of a process using MS Excel

1. What is Process Capability

2. What is process capability ratio and process capability index

3. Process Capability Analysis using MS excel

4. Percentage of defective products produced using Z score

7. Designing the Sampling Plans

1. Introduction to Larson Nomogram

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

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

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training