The lead time Spectral Analysis Chart, or lead time Histogram Chart is a very useful tool for visualizing and analyzing you process lead times. In this post I show you how you can create one in Microsoft Excel 2010.
I’m using the same process data in this example as in the Control Chart example. There should be no problem to have both the Control Chart and the Spectral Analysis Chart in the same document. Step 1 through step 23 are therefore the same in both examples.
Let’s get started.