Value Stream Data Analysis with Excel
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