Operational Excellence – Video’s
Master Business Administration 2020-2021
Shannon Karhof – Grade 8.5
Table of contents
Week 1 video’s ...................................................................................................................................3
Data and Lean Six Sigma .....................................................................................................................3
M1-V7 Installing Minitab 17 ............................................................................................................3
M1-V8 Introduction to Minitab .......................................................................................................3
M1-V9 Loading data into Minitab ....................................................................................................3
Understanding and visualizing data .....................................................................................................4
M2-V1 Numerical and categorical data............................................................................................4
M2-V2 Descriptive analysis .............................................................................................................5
M2-V3 Visualizing numerical data ...................................................................................................7
M2-V4 Visualizing categorical data ..................................................................................................8
M2-V5 Pareto analysis ....................................................................................................................8
M2-V6 Visualizing two variables .................................................................................................... 10
Week 2 video’s - Data and Lean Six Sigma ......................................................................................... 14
M1-V1 Introduction to lean six sigma ............................................................................................ 14
M1-V2 Data and DMAIC ................................................................................................................ 15
M1-V3 Selecting CTQs ................................................................................................................... 16
M1-V4 Units and operational definition ........................................................................................ 18
M1-V5 Sampling............................................................................................................................ 20
M1-V6 Organizing your data ......................................................................................................... 21
Week 3 video’s – Using Probability distributions ............................................................................... 22
M3-V1 Population versus sample .................................................................................................. 22
M3-V2 Estimation and confidence intervals .................................................................................. 22
M3-V3 Normal, Lognormal and Weibull distributions .................................................................... 24
M3-V4 Probability plot .................................................................................................................. 26
M3-V5 Empirical CDF .................................................................................................................... 29
M3-V6 Properties of normal distribution ....................................................................................... 33
Week 4 video’s – Introduction to testing ........................................................................................... 35
M4-V1 Introduction to data analysis ............................................................................................. 35
M4-V2 Hypothesis testing ............................................................................................................. 36
M4-V3 Causality ............................................................................................................................ 39
,Week 5 video’s – Testing: Numerical Y and categorical X ................................................................... 42
M5-V1 Introduction to ANOVA – Step 1 ........................................................................................ 42
M5-V2 ANOVA Analysis – Step 2 ................................................................................................... 45
M5-V3 ANOVA Residual Analysis - Step 3 ...................................................................................... 48
M5-V4 Kruskal-Wallis test ............................................................................................................. 51
M5-V5 Two-sample t-test .............................................................................................................. 54
M5-V6 Test for Equality of Variances ............................................................................................. 57
Week 6 video’s – Testing: Numerical Y and numerical X .................................................................... 60
M6-V1 – Correlation...................................................................................................................... 60
M6-V2 – Introduction to regression .............................................................................................. 61
M6-V3 – Regression analysis ......................................................................................................... 63
M6-V4 – Regression residual analysis ............................................................................................ 66
M6-V5 – Regression prediction interval ......................................................................................... 67
M6-V6 – Quadratic regression....................................................................................................... 70
Week 7 video’s – Testing: Categorical Y............................................................................................. 73
M7-V1 – Chi-square analysis ......................................................................................................... 73
M7-V2 – Logistic regression .......................................................................................................... 76
,Week 1 video’s
Data and Lean Six Sigma
M1-V7 Installing Minitab 17
Onthehub.com
Of 30-day trial → products
M1-V8 Introduction to Minitab
It executes all statistical calculations
It matches with LSS
When?
Applying statistical tools to data
If a column says C1-T → It’s a text variable, or categorical variable. Without a T it is numerical
M1-V9 Loading data into Minitab
M2-V1 Numerical and categorical data
M2-V2 Descriptive statistics
Go to the first tab, select investigation time, then a tab opens for this investigation time
Then copy all into minitab
, Understanding and visualizing data
M2-V1 Numerical and categorical data
Always collect your data in a numeric way, at least, when you have a choice.
Master Business Administration 2020-2021
Shannon Karhof – Grade 8.5
Table of contents
Week 1 video’s ...................................................................................................................................3
Data and Lean Six Sigma .....................................................................................................................3
M1-V7 Installing Minitab 17 ............................................................................................................3
M1-V8 Introduction to Minitab .......................................................................................................3
M1-V9 Loading data into Minitab ....................................................................................................3
Understanding and visualizing data .....................................................................................................4
M2-V1 Numerical and categorical data............................................................................................4
M2-V2 Descriptive analysis .............................................................................................................5
M2-V3 Visualizing numerical data ...................................................................................................7
M2-V4 Visualizing categorical data ..................................................................................................8
M2-V5 Pareto analysis ....................................................................................................................8
M2-V6 Visualizing two variables .................................................................................................... 10
Week 2 video’s - Data and Lean Six Sigma ......................................................................................... 14
M1-V1 Introduction to lean six sigma ............................................................................................ 14
M1-V2 Data and DMAIC ................................................................................................................ 15
M1-V3 Selecting CTQs ................................................................................................................... 16
M1-V4 Units and operational definition ........................................................................................ 18
M1-V5 Sampling............................................................................................................................ 20
M1-V6 Organizing your data ......................................................................................................... 21
Week 3 video’s – Using Probability distributions ............................................................................... 22
M3-V1 Population versus sample .................................................................................................. 22
M3-V2 Estimation and confidence intervals .................................................................................. 22
M3-V3 Normal, Lognormal and Weibull distributions .................................................................... 24
M3-V4 Probability plot .................................................................................................................. 26
M3-V5 Empirical CDF .................................................................................................................... 29
M3-V6 Properties of normal distribution ....................................................................................... 33
Week 4 video’s – Introduction to testing ........................................................................................... 35
M4-V1 Introduction to data analysis ............................................................................................. 35
M4-V2 Hypothesis testing ............................................................................................................. 36
M4-V3 Causality ............................................................................................................................ 39
,Week 5 video’s – Testing: Numerical Y and categorical X ................................................................... 42
M5-V1 Introduction to ANOVA – Step 1 ........................................................................................ 42
M5-V2 ANOVA Analysis – Step 2 ................................................................................................... 45
M5-V3 ANOVA Residual Analysis - Step 3 ...................................................................................... 48
M5-V4 Kruskal-Wallis test ............................................................................................................. 51
M5-V5 Two-sample t-test .............................................................................................................. 54
M5-V6 Test for Equality of Variances ............................................................................................. 57
Week 6 video’s – Testing: Numerical Y and numerical X .................................................................... 60
M6-V1 – Correlation...................................................................................................................... 60
M6-V2 – Introduction to regression .............................................................................................. 61
M6-V3 – Regression analysis ......................................................................................................... 63
M6-V4 – Regression residual analysis ............................................................................................ 66
M6-V5 – Regression prediction interval ......................................................................................... 67
M6-V6 – Quadratic regression....................................................................................................... 70
Week 7 video’s – Testing: Categorical Y............................................................................................. 73
M7-V1 – Chi-square analysis ......................................................................................................... 73
M7-V2 – Logistic regression .......................................................................................................... 76
,Week 1 video’s
Data and Lean Six Sigma
M1-V7 Installing Minitab 17
Onthehub.com
Of 30-day trial → products
M1-V8 Introduction to Minitab
It executes all statistical calculations
It matches with LSS
When?
Applying statistical tools to data
If a column says C1-T → It’s a text variable, or categorical variable. Without a T it is numerical
M1-V9 Loading data into Minitab
M2-V1 Numerical and categorical data
M2-V2 Descriptive statistics
Go to the first tab, select investigation time, then a tab opens for this investigation time
Then copy all into minitab
, Understanding and visualizing data
M2-V1 Numerical and categorical data
Always collect your data in a numeric way, at least, when you have a choice.
