Contents of Learn Six Sigma Statistics using Microsoft Excel
1 INTRODUCTION
2 EXCEL BASICS
2.1 How Instructions will be Delivered.
2.2 Using the Rand and Randbetween.
2.3 Copying and Pasting Formulas
2.4 Defining a Name for a group of cells
2.5 Paste Special – Numbers.
2.6 Using the Index Function.
2.7 Installing the Data Analysis ToolPak
3 BASIC STATISTICS
3.1 Introduction to Basic Statistics
3.2 Types of Data
3.3 Measuring Central position
3.4 Measuring variation
3.5 The Frequency Distribution Plot
3.6 The Normal Distribution
3.7 Descriptive Statistics
3.8 Inferential Statistics
3.9 Central Limit theorem
3.10 First Look at Confidence Intervals
3.11 Degrees of Freedom
3.12 Student’s t Distribution
4 GRAPHICAL ANALYSIS WITH EXCEL
4.1 Introduction to Generating Graphs
4.2 Charting a Single Variable
4.3 Charts for Two Variables
4.4 ERGONOMICS AND FEATURES OF MINITAB.
5 INTRODUCTION TO THE DATA ANALYSIS TOOLPAK
5.1 Introduction to the Data Analysis TookPak
5.2 Descriptive Statistics
5.3 Rank and Percentile
5.4 Histograms from the DA ToolPak
5.5 Sampling
5.6 Random number generation
6 UNDERSTANDING HYPOTHESIS TESTING
6.1 What is Hypothesis Testing.
6.2 Understanding the Procedure
7 TESTING FOR NORMALITY
7.1 Introduction to Testing for Normality
7.2 Checking for Bimodal Distributions
7.3 Test1 Skewness and Kurtosis
7.4 Test2 Fat Pencil Test
7.5 Test3 Chi-
7.6 Summary Table of all The Results.
7.7 Ergonomics and Features of Minitab
8 TESTING 1 GROUP TO A TARGET MEAN
8.1 Introduction to Testing 1 Group to a Target Mean
8.2 Testing 1 Group to a Target Mean
8.3 Power and Sample size for Testing 1 Group to a Target Mean
8.4 Exercises for 1 Group to a Target Mean
8.5 Ergonomics and Features of Minitab
9 TESTING 1 VARIANCE TO A TARGET
9.1 Introduction to Testing 1 Variance to a Target
9.2 Power and Sample Size for a 1 Variance test
9.3 Testing 1 Variance to a Target Examples
9.4 Testing 1 Variance to a Target Exercises
10 PAIRED t TEST
10.1 Introduction to the Paired t Test
10.2 Examples of Paired t Test
10.3 Exercises using the Paired t Test
11 2 VARIANCE TEST
11.1 Introduction to Testing Two Variances using the F Test
11.2 The F Distribution
11.2 Examples and Exercises using the F Test
11.3 Introduction to Testing Two Variances using the Levene’s Test
11.4 Examples and Exercises using the Levene’s Test
11.5 Bonett’s Test in Minitab
12 2 SAMPLE t TEST
12.1 Introduction to Two Sample t Test
12.2 Two Sample t Test for Equal Variance
12.3 Two Sample t Test for Unequal variances
12.4 Features of Minitab
13 SINGLE FACTOR ANOVA 1
13.1 Explanation of Single Factor ANOVA
13.2 Single Factor ANOVA Example
13.3 Single Factor ANOVA Exercises
13.4 Ergonomics and Features of Minitab
14 ANOVA TWO FACTOR WITHOUT REPLICATION
14.1 Explanation of Two Factor ANOVA WO Replication
14.2 Two Factor ANOVA WO Replication Example
14.3 Two Factor ANOVA WO Replication Exercise
15 ANOVA TWO FACTOR WITH REPLICATION
15.1 Explanation of Two Factor ANOVA with Replication
15.2 Two Factor ANOVA with Replication Example
15.3 Two Factor ANOVA with Replication Exercise
15.4 Ergonomics and Features of Minitab
16 SPC
16.1 Introduction to Control Charts
16.2 When should we use Control Charts
16.3 False Alarms
16.4 Subgrouping
16.5 Subgroup Size and Sampling Frequency
16.6 Detection Rules used for special cause variation
16.7 Control Chart Selection for Continuous Data
16.8 Calculating the Control Limits
16.9 I-
16.10 Xbar-
16.11 Xbar-
16.12 Ergonomics and Features of Minitab
17 PROCESS CAPABILITY
17.1 Simple Process Yield Metrics
17.2 Introduction to Process Capability
17.3 Basic Process Capability.
17.4 Z Scores
17.5 Sigma Shift
17.6 Off-
17.7 Within Capability and Overall Capability
17.8 Normality
17.9 Summary of Process Capability
17.10 Overall Process Capability
17.11 Overall Process Capability Exercise
17.12 Process Capability for Subgroups
17.13 Process Capability for Subgroups Exercise
17.14 Ergonomics and Features of Minitab
18 CORRELATION AND SIMPLE REGRESSION
18.1 What’s the Difference?
18.2 Correlation and Covariance
18.3 Simple Regression
18.4 Types of Variance in Simple Regression
18.5 Simple Regression with the ToolPak
18.6 Validating the Regression Model with Residuals
18.7 Calculating Confidence Intervals and Prediction Intervals
18.8 Simple Regression with Non-
18.9 Ergonomics and Features of Minitab
19 MULTIPLE REGRESSION
19.1 Introduction to Multiple Regression
19.2 Multiple Regression Examples and Exercise
19.3 Multicollinearity
19.4 Multiple Regression and Categorical Predictors
19.5 Ergonomics and Features of Minitab
20 MEASUREMENT SYSTEMS
20.1 What is Measurement System Analysis (MSA)
20.2 Why MSA fundamental to DMAIC
20.3 What we Cover
20.4 Types of Measurement Error 1
20.5 Accuracy Errors
20.6 Precision Errors
20.7 A Breakdown of Measurement Errors
20.8 Type 1 Gage Study
20.9 Gage Linearity and Bias Study
20.10 Gage R&R Introduction
20.11 Gage R&R Crossed
20.12 Ergonomics and Features of Minitab
21 DESIGN OF EXPERIMENTS
21.1 Introduction to Design of Experiment
21.2 Design of Experiment as a Process
21.3 Design of Experiment Terminology
21.4 Understanding Design of Experiment Structure
21.5 Sequential Design of Experiment Examples
21.6 Full Factorial Design of Experiment Example
21.7 Sequential Design of Experiment Exercise
21.8Ergonomics and Features of Minitab
22 ERGONOMICS AND FEATURES OF MINITAB
22.1 Introduction
22.2 The Assistant
22.3 Power and Sample Size
22.4 Main Effects and Interactions Plots
22.5 Model Storage
22.6 Response Optimizer
22.7 Residual Plots
22.8 Minitab Help
