Created by Adam Aizad Ahmad | Published 6/2021
Duration: 1h 47m | 6 sections | 20 lectures | Video: 1280x720, 44 KHz | 865 MB
Genre: eLearning | Language: English + Sub
This course will provide hands on expertise to understand and undertake the following tasks using Excel.
How to become a professional data analyst in quality assurance
Process Maps
Basic statistical analysis
Hypothesis testing
Statistical process charts
ExcelQuality Control
Both Powerpoint slides and excel data analysis are provided in this course. First we will understand the process maps, the purpose of analysis in process maps, and why yield calculations are crucial to understand where rework and scrap is being created. We will then review the basic statistical concepts and use Excel with samples to create histogram boxplot, calculate average and standard deviation. We will understand the types of data. We will undertake the basic hypothesis tests such as T-Test using and Excel add-on for Data Analysis Tool Pak. We will also understand what are the types of process charts and how to create the charts in Excel using formulas or using templates. This course will make you a skilled quality personnel and also help you to manage any process in a better way.
SPC Tools
Process maps : Flowchart
Hidden factory
Yield calculation - IPY and RTY
Quality control basic concepts
Purpose of data collection: Compare a group with a target or Compare a group with each other
Types of data: Continuous data Attribute data Binary Count
Data analysis: Center of distribution Spread of distribution
Types of distribution: Normal distribution Non-normal distribution
Descriptive Data Analysis: Normality Mean, Median, Mode
Histogram
Boxplot
Statistical hypothesis tests
T-Tests
1-sample T-Test
2-sample T-Test
Statistical charts: I-MR Chart X-Bar Chart
Who this course is for:Eeers and production supervisors in ManufacturingQuality assurance personnel
DOWNLOAD
uploadgig.com
rapidgator.net
nitro.download
Feel free to post your Managing Statistical Process Control using Excel Tools Free Download, torrent, subtitles, free download, quality, NFO, Dangerous Managing Statistical Process Control using Excel Tools Torrent Download, free premium downloads movie, game, mp3 download, crack, serial, keygen.