

Benefits of Accelerated
Learning of Statistics, Made Easy Using Microsoft Excel :
 Learners   learn faster, easier, focused on valueadded skills and
enjoy the experience.
 Trainer   find out how to promote brainfriendly 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 indepth 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 decisionmaking. 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 (Aftertraining 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 miniprojects 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
 Handson 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 XbarR chart
 Exercise: Stepbystep how to construct XbarR chart
 Control Limits Vs Specification Limits
 Formula for XbarR chart UCL/LCL
 InControl (Common Causes) and OutOfControl (Special Causes) patterns.
 Using Control Stability Criteria
 Exercise: How to determine outofcontrol points?
 Interpretation of Control Charts Patterns
 Actions plan for outofcontrol points.
 Construction of XmR chart.
 Construction of XbarS 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.
 StepbyStep how to conduct Process Capability Studies.
Control Charts For Attribute Data:
 Formula for Attribute charts UCL/LCL
 Proportion of defective charts (pchart, npchart)
 Exercise: Stepbystep how to construct p & npcharts
 Proportion of defect charts (cchart, uchart)
 Exercise: Stepbystep how to construct c & ucharts
 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 (OneSample Test):
 What is and why do Hypothesis Testing
 StepbyStep Hypothesis Testing Methodology
 Exercise: Using MS Excel to compute pvalue fast & accurately
 OneSample Tests:
 ztest for Mean (sigma known)
 ttest for Mean (sigma unknown)
 ztest for Proportion
 Exercise: Case studies using MS Excel
TwoSample Tests with Numerical Data
 Comparing two independent samples:  ttest for Means
 Ftest for Differences Between Two Variances
 Comparing Two Related Samples:  tpaired test for Means
 Exercise: Case studies using MS Excel
Analysis of Variance (ANOVA)
 What is and why do ANOVA?
 Completely Randomize Design: Oneway ANOVA
 TwoFactor Factorial Design: Twoway 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 Shortterm (STCS) and Longterm Capability Studies (LTCS)

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

Calculate Capability Indices for nonnormality 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   ttest, ztest, Ftest, 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 onesided distribution
 What is ShortTerm and LongTerm production runs?
 Conducting ShortTerm Capability Study (STCS)
 Conducting LongTerm 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 nonnormality 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)?
 Stepbystep 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.







