Taguchi Loss Function Calculator in Excel
Drop your data into this easy to use template in QI Macros add-in
To calculate Taguchi Loss Function:
- Input your data into column A.
- Input the target value for the data into cell E2.
- 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.
The template has several worksheets including one for Taguchi Loss.