Optimization, Design of Experiments Tool and Constraint Satisfaction

You can manually build graphics from the DoE Output Excel file.

This task shows you how to:

See Also
Optimization, Design of Experiments Tool and Constraint Satisfaction

Creating the Effects Graphs

You can create effects graphs.

  1. If not already done, open the DoE output Excel file.
  2. Click the Chart Wizard command.
  3. Select the Line as Chart type and click the NEXT command.
  4. In the Data Range tab:
    Insert the pointer into the Data Range box and select the following highlighted range in the sheet.

    • Check the Columns option in the Series In box.
  5. In the Data Range tab :
    • Do not modify the content of the Series frame.
    • Insert the pointer into the Category (X) axis labels box and select the following highlighted range in the sheet and then click next.
    • Click NEXT.



  6. In the Titles tab:

    • Chart Title = Mean effect of FactorK on OutputN (surrounded by min. and max. effect)

    • Category (X) axis = VALUE of FactorK
    • Value (Y) axis = Average of OutputN (output's unit) responses (surrounded by min. and max. responses)
  7. Leave the other tabs unchanged and click NEXT.
  8. Choose the As Object in : Sheet1 option.
  9. Click FINISH.

Creating the Interactions Graphs

You can create interactions graphs.

  1. If not already done, open the DoE output Excel file.
  2. Click the Chart Wizard command.
  3. Select the Line as Chart type and click NEXT.
  4. In the Data Range tab:
    • Insert the pointer into the Data Range box and select the following highlighted range in the sheet hereunder
    • Check the Columns option in the Series In box



  5. In the Series tab :

    • Do not modify the content of the Series frame

    • Insert the pointer into the Category (X) axis labels box and select the following highlighted range in the sheet hereunder
      • Then click NEXT.



  6. In the Titles tab :

    • Chart Title = Effect of FactorL on OutputN for each value of FactorK (no interaction if curves are parallel)

    • Category (X) axis = VALUE of FactorL. (Y) axis = Average of OutputN (outputs)
  7. Do not modify the other tabs and click NEXT.
  8. Choose the As Object in : Sheet1 option.
  9. Click FINISH.

Creating the Slopes Graphs

You can create slopes graphs.

  1. If not already done, open the DoE output Excel file.
  2. Click the Chart Wizard command.
  3. Select the Line as Chart type and click NEXT.
  4. In the Data Range tab:
    • Insert the pointer into the Data Range box and select the following highlighted range in the sheet hereunder.
    • Check the Columns option in the Series In box.



  5. In the Series tab :
    • Do not modify the content of the Series frame.
      • Insert the pointer into the Category (X) axis labels box and select the following highlighted range in the sheet :


    • Click NEXT.
  6. In the Titles tab :
    • Chart Title = Mean slope of the effect curve of FactorK on OutputN (surrounded by min. and max. slopes).
    • Category (X) axis = Range of study = [value at level i,value at level i+1] of factor FactorK.
    • Value (Y) axis = Slope
  7. Do not modify the other tabs and click NEXT.
  8. Choose the As Object in : Sheet1 option.
  9. Click FINISH.