Posts

Showing posts with the label Six Sigma

Value Stream Data Analysis with Excel

Image
  After we have identified what needs to be improved in our value stream we want to look for the root cause of problems. Due to the existence of variation we will need statistical data analysis. Microsoft Excel provides effective data analysis tools we can effectively use to do this.  The steps for value stream improvement are: Map it as it is really happening today in Gemba with a Value Stream Map . Collect process data in the line. To understand the value stream dynamic behavior we will need statistically significant data to enable simulation   Check for stability with Statistical Process Control Know to what extent it is able to meet the customer requirements with Process Capability Perform additional data analysis to get to the root cause Now we will continue our value stream data analysis both for variables and attribute data. Hypothesis Testing A comparison statement is composed of two hypothesis: Null hypothesis                    H0                   Alternative hypothesis