Exploratory Data Analysis

Lean Six Sigma Green Belt Six Sigma - Analyze
15 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.35
List Price:  €96.21
You save:  €28.86
£55.83
List Price:  £79.77
You save:  £23.93
CA$100.76
List Price:  CA$143.95
You save:  CA$43.19
A$112.23
List Price:  A$160.33
You save:  A$48.10
S$95.14
List Price:  S$135.93
You save:  S$40.78
HK$543.62
List Price:  HK$776.63
You save:  HK$233.01
CHF 63.04
List Price:  CHF 90.06
You save:  CHF 27.02
NOK kr797.48
List Price:  NOK kr1,139.30
You save:  NOK kr341.82
DKK kr502.49
List Price:  DKK kr717.87
You save:  DKK kr215.38
NZ$124.10
List Price:  NZ$177.29
You save:  NZ$53.19
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.18
৳8,361.55
List Price:  ৳11,945.58
You save:  ৳3,584.03
₹5,962.79
List Price:  ₹8,518.63
You save:  ₹2,555.84
RM314.04
List Price:  RM448.65
You save:  RM134.61
₦108,335.42
List Price:  ₦154,771.52
You save:  ₦46,436.10
₨19,495.71
List Price:  ₨27,852.21
You save:  ₨8,356.49
฿2,390.81
List Price:  ฿3,415.60
You save:  ฿1,024.78
₺2,467.44
List Price:  ₺3,525.07
You save:  ₺1,057.62
B$434.14
List Price:  B$620.23
You save:  B$186.09
R1,296.68
List Price:  R1,852.48
You save:  R555.80
Лв131.68
List Price:  Лв188.12
You save:  Лв56.44
₩102,198.93
List Price:  ₩146,004.73
You save:  ₩43,805.79
₪256.56
List Price:  ₪366.53
You save:  ₪109.97
₱4,090.81
List Price:  ₱5,844.26
You save:  ₱1,753.45
¥10,994.99
List Price:  ¥15,707.80
You save:  ¥4,712.81
MX$1,408.98
List Price:  MX$2,012.91
You save:  MX$603.93
QR255.09
List Price:  QR364.43
You save:  QR109.34
P967.82
List Price:  P1,382.66
You save:  P414.84
KSh9,046.20
List Price:  KSh12,923.70
You save:  KSh3,877.50
E£3,562.49
List Price:  E£5,089.49
You save:  E£1,527
ብር8,907.19
List Price:  ብር12,725.10
You save:  ብር3,817.91
Kz63,830.88
List Price:  Kz91,190.88
You save:  Kz27,360
CLP$69,323.69
List Price:  CLP$99,038.09
You save:  CLP$29,714.40
CN¥510.80
List Price:  CN¥729.75
You save:  CN¥218.94
RD$4,245.36
List Price:  RD$6,065.06
You save:  RD$1,819.70
DA9,465.07
List Price:  DA13,522.10
You save:  DA4,057.03
FJ$162.39
List Price:  FJ$232
You save:  FJ$69.60
Q539.11
List Price:  Q770.19
You save:  Q231.08
GY$14,638.77
List Price:  GY$20,913.42
You save:  GY$6,274.65
ISK kr9,772.70
List Price:  ISK kr13,961.60
You save:  ISK kr4,188.90
DH703.98
List Price:  DH1,005.73
You save:  DH301.75
L1,291.33
List Price:  L1,844.84
You save:  L553.50
ден4,143.97
List Price:  ден5,920.21
You save:  ден1,776.24
MOP$559.97
List Price:  MOP$800
You save:  MOP$240.02
N$1,289.45
List Price:  N$1,842.15
You save:  N$552.70
C$2,574.80
List Price:  C$3,678.44
You save:  C$1,103.64
रु9,534.71
List Price:  रु13,621.60
You save:  रु4,086.89
S/260.99
List Price:  S/372.86
You save:  S/111.86
K283.85
List Price:  K405.52
You save:  K121.66
SAR262.91
List Price:  SAR375.60
You save:  SAR112.69
ZK1,936.45
List Price:  ZK2,766.47
You save:  ZK830.02
L335.12
List Price:  L478.77
You save:  L143.64
Kč1,694.03
List Price:  Kč2,420.15
You save:  Kč726.12
Ft27,771.44
List Price:  Ft39,675.18
You save:  Ft11,903.74
SEK kr774.38
List Price:  SEK kr1,106.30
You save:  SEK kr331.92
ARS$71,792.58
List Price:  ARS$102,565.23
You save:  ARS$30,772.64
Bs484.55
List Price:  Bs692.24
You save:  Bs207.69
COP$307,165.41
List Price:  COP$438,826.54
You save:  COP$131,661.12
₡35,530.54
List Price:  ₡50,760.09
You save:  ₡15,229.55
L1,777.33
List Price:  L2,539.15
You save:  L761.82
₲546,250
List Price:  ₲780,390.60
You save:  ₲234,140.59
$U3,115.91
List Price:  $U4,451.49
You save:  $U1,335.58
zł287.82
List Price:  zł411.19
You save:  zł123.37
Already have an account? Log In

Transcript

With lecture 37 we start the Analyze phase of six sigma. In this lecture, we will discuss the introduction of analyze phase, how to create and interpret multivariate studies in respect of positional and temporal variation as well as correlation and regression. Do you recognize this illustration, we had discussed this in one of the lectures of measure face and measure face. We identified the various output characteristics, CD cues and input Characteristics ctps let us have an illustration of what we are going to do in the Analyze phase. As I have told in measure phase, we identify cdp's. Now, in the Analyze phase, we will try to analyze the variation of cdp's and identify two or three root causes.

Let us learn the various tools for identifying the root causes. multivariate study is one of the tools to identify the root cause of variations It is a graphical method to understand the multiple sources of variation in a process by multivariate studies, we study the various sources of variations such as positional variation, cyclical variation, tempo variation, etc. Let me illustrate it for your better understanding. Suppose, we have a manufacturing process that produces cylindrical components for an OEM. Let us take one output from the process and measure its quality characteristics I have taken one cylindrical block and measured the diameter in three different positions from the top from the middle and from the bottom positions, prospectively I don't have to say that these measurements vary at each position, it is obvious to you by now. Now, the positional variation is the variation within different positions of same product.

Further, I have taken two more blocks and taken measurements as you know the measurements vary at different positions as well as the measurements vary from product to product also. Now, the cyclical variation is the variation and measurements among different parts of our shift. Now, if I take the measurements for over a period of time for several number of blocks, it is also going to give me a lot of radiation and the temporal variation is the variation among different parts over a period of time and shifts. Let us learn multi very study in detail By taking an example I have taken one cylindrical block and find out the measurements from top, middle and bottom positions, prospectively the result of measurements are as tabulated. You can see the variations in the measurement at different positions, the positional variation. Similarly, the measurement for part two, Part three and part four respectively in the table by looking at the table could we comment any Think about positional are cyclical variation.

Difficult, isn't it? Let us have a graphical study using multivariate as you can see four columns for four parts and at each column the space for showing d, m and b that are top, middle and bottom respectively. Now, at the left hand side of the graph, plot the measurement scales now plot the individual measurement in part one, the top position measurement Was 0.993 middle position measurement was 0.994 and bottom position measurement was 0.992. Similarly, we can plot all other measurements to what can we commence now, by seeing this graph, we can see the variation between different positions are less the measurement are more clustered and this is the same for all the parts. What about the cyclical variation the variation between Between the parts this variation is significant there are more variations from one part to the other. We can analyze from this graph that the cyclical variation is more significant than the positional variation.

Now, the Six Sigma team could arrange a brainstorming to find out the reason for cyclical variations. Now, let us learn about another major tool in Six Sigma the correlation coefficient and the regression analysis Do you remember this graph that we had discussed in measure phase as part of graphical representation of data? Yes, this is the same scatterplot that we have used to identify the relationship between two variables. During scatterplot we would be able to identify a correlation if it exists, that was fine. But, but could we be able to define the degree of correlation or could we develop a mathematical model based on the correlation Let us review this as I have just Told scatter diagram does not convey the degree of correlation. The correlation studies help you for this purpose by determining whether there exists correlation and measuring the degree of relationships.

Call Pearson's correlation is the most popular method used for this purpose. The correlation coefficient is indicated by R. When we get r is equals to plus one It means a perfect positive correlation. if r is equals to minus one It means Perfect negative correlation where r is equals to zero, it implies no correlation. calculation for correlation are tedious. We can easily find out the correlation by using Excel select a column and type equals to coral, open the bracket, add a one comma added to close the bracket for everyone and era to select the respective columns, where we have stored the set of data. Let us move a step ahead with correlation regression equation provides a mathematical model for the correlation After identifying the relation between two variables, we can use regression equation to predict one variable if other variable is known regression analysis is finding the equation of regression line regression equation is nothing, but the equation of a straight line represented as y is equals to a plus b x, where b is calculated as summation of x y minus n into x bar into y bar divided by summation of x square minus and x bar square.

Do you scale calculation? It was just to give you awareness. This calculation could be easily done with Minitab. Let us see how this is the same file that was used for scatterplot example, double click on the file, then click Start regression fitted line plot fitted line plot window opens now Type in response y box as defect rate, you can also double click instead in the predictor, x box type, soldier temperature. Now click OK Minitab gives the graphical view of fitted plot line and its equation. Now, what you see at the top is the equation that can be used to predict the defect rate for a known value of soldier temperature.

That's all for this lecture. Let us move to another important lecture for hypothesis testing. Thank you

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.