Taguchi Loss Function Calculator in Excel

Drop your data into this easy to use template in QI Macros add-in

taguchi loss function calculator

To calculate Taguchi Loss Function:

  1. Input your data into column A.
  2. Input the target value for the data into cell E2.
  3. Input the cost as the data moves away from the target in cell E3.

That's it. The template makes the calculations and draws the chart for you.

Taguchi Loss Function Template

The Taguchi loss function template is one of many templates in QI Macros add-in for Excel. QI Macros installs on Excel's menu. To access the template, click on QI Macros, then Calculators, then DPMO | Yield | Cp/PPM | OEE.

calculators menu

The template has several worksheets including one for Taguchi Loss.

dpmo template options

Learn More...

Other charts included in QI Macros add-in for Excel