How to manage your process using statistical Excel Tools

How to manage your process using statistical Excel Tools, available at $19.99, has an average rating of 4.67, with 20 lectures, based on 6 reviews, and has 2116 subscribers.

You will learn about Quality control and production management using Excel & Statistical Analysis and Processes. Process Maps/ Statistical Process Charts Basic statistical analysis Hypothesis testing This course is ideal for individuals who are Engineers and production supervisors in Manufacturing or Quality assurance personnel It is particularly useful for Engineers and production supervisors in Manufacturing or Quality assurance personnel.

Enroll now: How to manage your process using statistical Excel Tools

Summary

Title: How to manage your process using statistical Excel Tools

Price: $19.99

Average Rating: 4.67

Number of Lectures: 20

Number of Published Lectures: 20

Number of Curriculum Items: 20

Number of Published Curriculum Objects: 20

Original Price: CA$24.99

Quality Status: approved

Status: Live

What You Will Learn

Quality control and production management using Excel & Statistical Analysis and Processes.
Process Maps/ Statistical Process Charts
Basic statistical analysis
Hypothesis testing

Who Should Attend

Engineers and production supervisors in Manufacturing
Quality assurance personnel

Target Audiences

Engineers and production supervisors in Manufacturing
Quality assurance personnel

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Outline and agenda of the course

Chapter 2: Process Maps and Yield Analysis

Lecture 1: Example process map

Lecture 2: Yield calculation and Hidden factory

Lecture 3: Rolled though put Process Yield Part 1

Lecture 4: Rolled throughput Yield Part 2

Lecture 5: Process Maps Overview

Lecture 6: Creating process charts in Excel

Lecture 7: Creating process flow charts using Excel Shapes

Chapter 3: Basic Statistics Concepts

Lecture 1: Types of data

Lecture 2: Distribution Analysis, Center of distribution or Spread of distribution

Lecture 3: Excel analysis for Distribution

Lecture 4: Histogram analysis and Normal distribution

Lecture 5: Create Histogram and Boxplot in Excel

Chapter 4: Descriptive Analysis

Lecture 1: Purpose of Histogram and Boxplots

Chapter 5: Hypothesis Testing

Lecture 1: One sample T-Test

Lecture 2: How to install Data Analysis ToolPak in Excel and Hypothesis testing concepts

Chapter 6: Statistical process Control Charts

Lecture 1: Types of Process Control Charts : I-MR and X-Bar

Lecture 2: Types of Process Control Charts : C Chart and P Chart

Lecture 3: How to make Control chart in Excel using formulas

Lecture 4: How to make a Process Control Chart (and other Tools) using free Excel template

Instructors

Aizad Adam Ahmad
Professor

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 2 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu