Not Sure How to Calculate a Transfer Function in DOE?

Follow the steps below using QI Macros

Transfer Function Example

Using the Full Factorial, Fractional Factorial 8-run, and/or Fractional Factorial 16-run DOE templates, you can manually calculate a Transfer Function.

Open the QI Macros Full Factorial DOE template.
Next, copy and paste the following formula into cell V39:

="y=" &N46 & IF(M46>=0,"+","") & M46 & "*" &C46 & IF(M47>=0,"+","") & M47 & "*" &C47 & IF(M49>=0,"+","") & M49 & "*" &C49 & IF(M53>=0,"+","") & ROUND(M53,2) & "*" &C53

Your Transfer Function will then be provided accordingly!

For more information on how to implement the Transfer Function formula in the Fractional Factorial 8-run and/or Fractional Factorial 16-run templates, contact our support team!