How to manage your process using statistical Excel Tools
What you'll learn
- Quality control and production management using Excel & Statistical Analysis and Processes.
- Process Maps/ Statistical Process Charts
- Basic statistical analysis
- Hypothesis testing
- Quality Control
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.
•Process maps : •Flowchart
•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
•Statistical hypothesis tests
•Statistical charts: •I-MR Chart •X-Bar Chart
Who this course is for:
- Engineers and production supervisors in Manufacturing
- Quality assurance personnel
Currently, Professor at a major College & University in Ontario, Canada.
Previous experience includes work at the major Financial Firms in Canada as a Financial Advisor for over 10 years.
Also attained certifications in Project Management and Six Sigma quality improvement. Managed projects in firms in Canada for 5 years to improve efficiency using six sigma tools.
Undertook R&D, quality and operations management in food processing companies for 10 years in international firms.
Qualified with MBA (UK), MSc, PMP
I've been teaching the certification courses for over 10 years. Some courses I provide guidance on:
My expertise is to help you pass the financial courses:
1. Canadian Securities Course CSC,
2. Conduct Practices Handbook CPH,
3. Canadian Insurance Course CIC,
4. Life insurance license LLQP,
5. Investment Funds in Canada IFIC
6. Six Sigma Green Belt certification
7. Project Management (PMP)
8. ASQ QCM/OE Exam
9. Computer skills such as Google, Microsoft, Excel Word, Onedrive etc.
I explain the formulas and math in simple ways. I have been working in the financial industry in insurance, banking, food manufacturing, and investments and thus can provide practical experience also.