Ishikawa Diagram. Root Cause Analysis (RCA) using Ishikawa/Fishbone Diagrams. 5 Whys Root Cause Analysis Problem Solving Tool--Video Training. Toyota's 8 Step Practical Problem Solving Methodology Overview. What is Six Sigma? Excel Run Chart with Mean and Standard Deviation Lines. Unlike some commercially available statistics packages, Microsoft Excel does not offer a built in capability to draw lines corresponding to statistical values for a series, such as the mean and the mean ± k standard deviations. The example on this page uses the Add a Horizontal Line to a Column or Line Chart: Error Bar Method to add statistical indicators to a simple run chart. This example uses 25 values from a normally distributed population: These values are listed in column B of the worksheet. In D1:F4 of the worksheet, formulas are entered to produce the following values: Cell D1 is blank, while cell E1 has a text label.
This simple formula was entered into cell H1 to get a count of the number of points: A simple run chart was constructed using the data in column B, adding appropriate axis titles. This added series is not useful as a line chart. Excel automatically added secondary axes to the chart and assigned the XY series to them.