Benefits of Accelerated Learning of Statistics, Made Easy Using Microsoft Excel :

  • Learners - - learn faster, easier, focused on value-added skills and enjoy the experience.
  • Trainer - - find out how to promote brain-friendly learning, discover new ideas for course design and delivery, and learn how to make learning interesting with high confidence and enthusiasm.
  • Organisation - - cuts training time, saves money, sees improved performance in the workplace, and gains in-depth techniques with application to other learning contexts.

INTRODUCTION

Business operations in the 21st century have access to large amounts of information.  Competent managers & engineers need to scan through large amount available data and information in order to make sound decisions about their business, processes, machines, etc.  Sorting, organizing and analyzing data becomes mere activities unless one is able to gain insights into what the data is revealing and accurately transform it into useful information for taking actions. Statistical methods or techniques were developed for this purpose and is used worldwide for scientific research, and especially for making sound business decisions.  Managers and Engineers need an understanding of statistics for the following four key reasons:

  • To know how to properly present and describe information.
  • To know how to draw conclusions about large populations based only on information obtained from samples.
  • To know how to monitor and improve operational process
  • To know how to obtain reliable forecasts

It has very wide applications in business, especially in the area of Quality Management across all industry.  This statistical learning program will provide you with the crucial foundation, principles and real applications of statistics, and get you up to speed in analyzing your business/operational data in a fast and easy manner.  It helps you to transform those analyzed data into information for crucial business and operational decision-making.  You will be taught to use accurate and proven Statistical techniques from basic to advance level.  This program also leverage on the power of Microsoft Excel application -- to do all the data crunching, tabulation, statistical computations, and graphing – in a fast and easy manner.   These are foundational courses for those embarking on LEAN Six Sigma initiatives and a must for those who are serious about acquiring Statistical techniques and Statistical Process Control (SPC) skills.

PROGRAM METHODOLOGY:
To maximize the learning impact, this course uses the following methods:

  • Real work case studies & small group discussions
  • Statistical Process Control charting simulations
  • Data analysis using MS Excel technique

Program Assessments
For all modules:
 - Level 1 (After-training evaluation) -- feedback questionnaires after the training.
 - Level 2 (Pre- and Post- tests) -- assessments will be conducted by the Instructor during the training.
For Intermediate & Advance Modules:
 - Level 3 (Assignments) – for intermediate and advance level modules, assignments or mini-projects will
                                             be assigned to participants for them to practice what they have learned and
                                             practice it in their workplace.   

WHO SHOULD ATTEND:

  • Operation/QA/Process Managers, Section Heads & Engineers
  • Six Sigma/LEAN Project Team Leaders, Senior Officers/Supervisors who need to make improvements to quality and processes.
  • Business Analysts who need to grasp the statistical techniques used in data analysis.

This Statistical Learning Program consists of four (4) modules that focuses on the essential skills needed to excel in a today’s managerial and engineering position. There are:

     
  M1). Basic Statistics & QC Tools Applications (- 2days/ 16 hours)  
   

OBJECTIVES :
At the end of the course, participants will be able to...

  • Describe the importance of using statistical methods in making decisions and validating results.
  • Describe the types of data; Variables & Attributes Data
  • Describe the Do’s & Don’ts of data collection, data stratification
  • Describe the smart way of using Check Sheets in tabulating data.
  • Use MS Excel to compute Descriptive Statistics computations.
  • Explain Sampling & Sampling Distribution of Means, Normal Distribution
  • Explain the importance of Central Limit Theorem
  • Use MS Excel to construct Histogram fast and accurately.
  • Analyze Histogram patterns and determine whether the process has improved.
  • Use MS Excel to construct Scatter Diagram and determine whether the parameters tested has correlation.
  • Interpret and make accurate quality improvement decisions using statistical techniques learned.

CONTENTS:

1). Introduction:

  • What is statistics?
  • Population & Sample
  • Why learn statistics.
  • Exercise: Are you making the right decision?
  • Statistics is About Using Data in Decision Making.
  • Utilizing statistics in Quality Control and Assurance

2). Descriptive Statistics:

  • Types of Data.
  • Summarizing Data
  • Data Collection & Stratification - - Do’s & Don’ts
  • Presenting your data in Check Sheets
  • QC Tool 1: Choosing suitable type of Check Sheets
  • Exercise: Smart usage of check sheets

3). Measuring Central Tendency & Dispersion:

  • Measuring Central Tendency of Ungroup Data
  • Measuring Dispersion of Ungroup Data
  • Measuring Central Tendency of Grouped Data
  • Measuring Central Tendency of Group Data
  • Descriptive Statistics Formula Review
  • Exercise: Using MS Excel to calculate fast & accurately
  • Exercises & Test

4). Probability, The Basis For Inferential Statistics:

  • Understanding Probability
  • Law of Variation
  • Discrete Probability Distributions
  • Continuous Probability Distribution
  • Normal Distribution and Sampling Distributions
  • Central Limit Theorem
  • Exercise: Quincunx Simulations
  • Probability Formula Review
  • Exercise: Using MS Excel to calculate fast & accurately

5). Applications of QC Tool 2: Histogram

  • Purpose: To analyze distribution of data against specifications
  • Principles and Characteristics of Histogram
  • Exercise: Using MS Excel to construct histogram fast & accurately
  • How to use Histogram successfully.
  • Analysis of Patterns on your Histogram
  • Exercise: How to interpret what the data is telling us?
  • Exercise: Which machine is better?  How do we know we have improved the process?

6). Applications of QC Tool 3: Scatter Diagram

  • Purpose: To study the relationship between different parameters
  • Principles and Characteristics of Scatter Diagram
  • Exercise: Using MS Excel to construct Scatter Diagram
  • How to use Scatter Diagram successfully.
  • Analysis of Patterns on your Scatter Diagram
  • Exercise: What is the correlation between parameters?
  • Exercise: Stratification of scattered patterns

7). Other Exercises

  • Accelerated method of constructing QC Tools using MS Excel templates
  • Hands-on data analysis using MS Excel, stratification and making decisions based on interpretation of data
  • Action plan to improve the process. Tests.
 
       
  M2). Statistical Process Control - Level I (SPC1) (- 2days/ 16 hours)  
   

OBJECTIVES :
At the end of the course, participants will be able to ...

  • Describe the overall basic statistical concepts, principles and methods of “Statistical Process Control (SPC)”

  • Recognize why and how SPC is important in performing Quality Control & Improvements activities.

  • Perform data analysis on statistical models and control charts

  • Select the correct control charts for variable and attribute data, and how to implement it at the workplace.

  • Construct control charts fast & easy using the Microsoft Excel.

  • Analyze control charts and recognize its process trends and patterns.

  • Take positive actions to control operational processes at workplace.

  • To conduct Process Capability study and calculate Cp, Cpk.

CONTENTS:

Introduction:

  • Revision of Basic Statistics:
     - Type of Data, Central tendency & dispersion.
     - Frequency distribution and measurements
     - Histogram and Normal Distribution
     - Significant of Central Limit Theorem

What is Statistical Process Control (SPC)?:

  • Concepts, Principles and Usage of SPC
  • Prevention Vs Detection system
  • Meaning of Process Controlled System
  • Variation: Common Vs Special (Assignable) Causes
  • Process Control and Process Capability

Introduction to Control Charts:

  • Basic principles of control charting
  • Histogram Vs Control Charts
  • Process model simulations
  • What are the Variable control charts?
  • What are the Attribute control charts?
  • Selection of Control Charts: Which charts to use?
  • Control Limits Formula and Accelerated method of constructing control charts.
  • Exercise:  Using MS Excel to construct SPC charts fast & accurately.
  • Interpretation of what the data/pattern reveals.  What is your process telling you?
  • Stratifications and making decisions based on interpretation of data

Control Charts For Variable Data:

  • Usage of  Xbar-R chart
  • Exercise:  Step-by-step how to construct Xbar-R chart
  • Control Limits Vs Specification Limits
  • Formula for Xbar-R chart UCL/LCL
  • In-Control (Common Causes) and Out-Of-Control (Special Causes) patterns.
  • Using Control Stability Criteria
  • Exercise: How to determine out-of-control points?
  • Interpretation of Control Charts Patterns
  • Actions plan for out-of-control points.
  • Construction of X-mR chart.
  • Construction of Xbar-S chart.

Process Capability Study

  • What is Process Capability Study
  • What is the conditions to conduct Process Capability Study?
  • Exercise: Calculation of Cp.
  • Exercise: Calculation of Cpk.
  • How to determine Cp, Cpk values from variable control charts.
  • Step-by-Step how to conduct Process Capability Studies.

Control Charts For Attribute Data:

  • Formula for Attribute charts UCL/LCL
  • Proportion of defective charts (p-chart, np-chart)
  • Exercise:  Step-by-step how to construct p- & np-charts
  • Proportion of defect charts (c-chart, u-chart)
  • Exercise:  Step-by-step how to construct c- & u-charts
  • Interpretation of Attribute charts patterns
  • Determination of Process Capability for Attribute charts.

Practical Procedures

  • Real data case studies.
  • Conducting Process Capability Study exercises
  • Exercises using MS Excel for data analysis.
 
       
 

M3). Intermediate Statistics For Management (- 2days/ 16 hours)

 
   

OBJECTIVES :
At the end of the course, participants will be able to ...

  • Describe the overall fundamental concepts, principles and methods of using Statistics for making sound business decisions.

  • Describe the basic statistical applications for QC Tools: Histogram, Control Charts, and Scatter Diagram.

  • Utilize MS Excel to quickly analyze data, transform it into valuable business acumen and present it.

  • Draw conclusions about large populations based only on information obtained from samples.

  • Perform Hypothesis Testings and make correct judgment.

  • Perform Analysis of Variance (ANOVA) techniques and determine the correct actions to take.

  • Use correlation and Linear Regression analysis to obtain reliable forecasts.

CONTENTS:

Introduction:

  • Revision of Basic Statistics and SPC1:
     - Normal Distribution, Sampling Distribution
     - Analyzing data with Histogram & Scatter Diagram
     - Basic principles and uses of Control Charts
     - Variable & Attribute Control Charts; Which control chart to use?
     - Process Control and Process Capability, Cp, Cpk values.

Drawing Conclusions from Population, Based on Sample Info:

  • Normal Distribution and Sampling Distribution
  • Confident Interval Estimation (CIE) of Mean (sigma known)
  • Confidence Interval Estimation of Mean (sigma unknown)
  • Confidence Interval Estimation for the Proportion
  • Determining Sample Size
  • Exercise: CIE in auditing

Fundamentals of Hypothesis Testings (One-Sample Test):

  • What is and why do Hypothesis Testing
  • Step-by-Step Hypothesis Testing Methodology
  • Exercise: Using MS Excel to compute p-value fast & accurately
  • One-Sample Tests:
     - z-test for Mean (sigma known)
     - t-test for Mean (sigma unknown)
     - z-test for Proportion
  • Exercise: Case studies using MS Excel

Two-Sample Tests with Numerical Data

  • Comparing two independent samples: - t-test for Means
  • F-test for Differences Between Two Variances
  • Comparing Two Related Samples: - t-paired test for Means
  • Exercise: Case studies using MS Excel

Analysis of Variance (ANOVA)

  • What is and why do ANOVA?
  • Completely Randomize Design: One-way ANOVA
  • Two-Factor Factorial Design: Two-way ANOVA
  • Exercise: Case studies using MS Excel

Simple Linear Regression (SLR) Model and Correlation

  • What is and why do SLR?
  • Exercise: Using MS Excel regression modeling
  • Determining the SLR equation.
  • Measures of Variations
  • Assumptions & Pitfalls in Regression.
  • Residual Analysis
  • Inferences about the Slope and Correlation.
  • Estimation of Means and Prediction of Individual Values

Practical Procedures

  • Real data case studies and business scenario analysis.
  • Exercises using MS Excel for data analysis.
 
       
  M4). Statistical Process Control - Level II (SPC2) (- 2days/ 16 hours)  
   

OBJECTIVES :
At the end of the course, participants will be able to...

  • Apply advance Statistical Process Control and its practical applications in business and quality management.

  • Run experiments to optimize and reduce variability with Hypothesis Testings, ANOVA and Normality tests.

  • Use CUSUM and EWMA control charts to detect small shifts in process

  • Construct and use the correct control charts for special considerations and at different stages of the process.

  • Conduct Short-term (STCS) and Long-term Capability Studies (LTCS)

  • Construct and use Deviation from Nominal Value (DNOM) control chart.

  • Calculate Capability Indices for non-normality process.

  • Perform a Gauge Repeatability and Reproducibility (GR&R) technique to establish the correct measurement.

CONTENTS:

Introduction:

  • Revision of Intermediate Statistics and SPC1:
     - Statistical Inferences for optimization and reduced variability:
       Hypothesis Testings - - t-test, z-test, F-test, ANOVA
     - A Process Control System
     - Constructing Variable & Attribute Control Charts.
     - Process Capability Study; Cp, Cpk values.

Further Process Capability Analysis

  • Understanding Cp, Cpk, and Six Sigma state of control.
  • Determining the correct Cp, Cpk for special considerations
  • Exercise: Calculating the Cp, Cpk for one-sided distribution
  • What is Short-Term and Long-Term production runs?
  • Conducting Short-Term Capability Study (STCS)
  • Conducting Long-Term Capability Study (LTCS)
  • Calculating Process Capability Studies: Pp, Ppk values
  • Exercise: STCS & LTCS comparison
  • Exercise: Comparing Cp, Cpk, Pp, Ppk

Special Control Charts For Detecting Small Shift

  • Inability of standard control charts to detect small shift in the process.
  • Cumulative Sum (CUSUM) control chart.
  • Exercise: Using MS Excel to construct CUSUM chart
  • Exponentially Weighted Moving Average (EWMA) control chart
  • Exercise: Using MS Excel to construct EWMA control chart
  • Interpreting CUSUM and EWMA control charts.

Special Considerations Using Modified Control Charts:

  • Short production run processes.
  • Using Deviation from Nominal Value (DNOM) control chart
  • Calculating Capability indices for non-normality processes.
  • Exercise: Special cases using modified control charts
  • Other considerations for Skewed process

Gauge Repeatability & Reproducibility (GR&R)

  • What is Measurement System Analysis (MSA)?
  • Why perform MSA?
  • What is Gauge Repeatability & Reproducibility (GR&R)?
  • Step-by-step how to perform a GR&R.
  • Exercise: Using MS Excel to tabulate GR&R
  • Interpreting GR&R results.
  • Other considerations when performing MSA.

Other Practical Exercises

  • Real data case studies.
  • Conducting Process Capability Study for special considerations
  • Exercises using MS Excel for modified control charts
  • Exercises using MS Excel for GR&R practicals.
 
       
 

Why use MS Excel application in training courses?

  • Readily Available - - Most companies already have MS Excel in their computer, so the tool is readily available for participants to use at work after training.
  • Save Time - - draw critical charts and diagrams at the clicks of a few buttons on the computer keyboard. That's all!
  • Avoid Effort - - your data analysis is already in MS Excel format. Just cut and paste and your charts or reports are ready for a great & professional presentation.
  • Gain Consistency - - over 90% of corporations worldwide uses Microsoft Office. You can share your analysis, reports, charts and graphs with anyone who has MS Excel. Consistency and reliability of your analysis is preserved.
  • Value-Added - - MS Excel can help reduce non value-added tasks (e.g. calculations, graphing, sequencing, executing statistical formulas, etc) to a few simple steps. This will allow learners to spend more training time learning and focusing on value-added tasks (eg. interpretation of data, proactive actions to improve processes). Also makes learning more interesting.
  Contact me to further customize these course for your participants' training needs:
   
 
   
 
   
 
   
  For other training courses, please browse my other webpages at www.mytrainingprovider.com
   
 
Back to Top