Udemy Certificate 0

How to manage your process using statistical Excel Tools

Name: How to manage your process using statistical Excel Tools
Price: 24.99 USD
Availability: InStock

About this course

This course will provide hands on expertise to understand and undertake the following tasks using Excel. 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

62/100

CourseAsk score

What the provider tells you: 38/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

understand process maps and their significance
perform yield calculations
create and interpret histograms and boxplots
conduct hypothesis tests (including T-Tests) using Excel
analyze types of data and their distributions

Data Analysis #data visualization #excel #hypothesis testing #statistical analysis #quality control #histograms #process mapping #boxplots #yield calculations #SPC tools

$24.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.