Excel Quality Tools

Statistical Trialplanning DoE

Factorial experiments are currently used mostly for finding problems in complex processes, but can also be used in a preventive way to see early what are the most important process parameters.

A factorial trail is a structured way of experiments with different parameter settings. In addition to the main effects of the individual parameters we will also get the information about their two-and multi-factor interactions. The Design of Experiments file is a help for implementation of a factorial design. All effects are shown graphically and presented in a Pareto chart.

Files for the following tests are included:
   - Complete 2-Factortrial (1 Result)
   - Complete 2-Factortrial (5 Result)
   - Complete 3-Factortrial (1 Result)
   - Complete 3-Factortrial (5 Result)
   - Complete 4-Factortrial (1 Result)
   - Reduced 4-Factortrial (1 Result)
   - Reduced 5-Factortrial II (1 Result)
   - Reduced 6-Factortrial II (1 Result)
   - Reduced 7-Factortrial II (1 Result)

Functional Scope

   - 2-factorial trails up to 7-factorial trails
   - full and reduced experimental plans
   - up to 5 repeating measurements
   - graphical display of the main and interaction effects
   - evaluation with the help of a "Pareto" chart
   - automatic calculation of significant limits

DoE "Traildata" - Sheet

Experimental data and other information to be entered in this data sheet.

DoE "Main effect" - Sheet

Here all the main effects are graphically shown for a better evaluation.

DoE "2-Factor-Combination effect" - Sheet

Here all the 2-factor interaction effects are graphically shown for a better evaluation.

DoE "3-Factor-Combination effect" - Sheet

Here all the 3-factor interaction effects are graphically shown for a better evaluation.

DoE "Paretodiagram" - Sheet

With the help of a "Pareto" diagram, the significant factors separates from the random.

Price

The price for the tool Statistical Trialplanning DoE is 2.000 SEK excl. VAT.

Ordering

To order Excel Quality Tools please use the electronic order form.

The copyright of the Excel files is owned by Q2 Management Development AB. It is impermissible to copy, modify, distribute, promote or sell multiple or single files, unless written permission has been given from Q2 Management Development AB.

The Excel files are designed and developed by Q2 Management Development AB.