Putting Data In and Getting Results Out

Importing/Exporting Data

Data sets can be imported from a table using the Import Data design choice, or by creating a Blank Spreadsheet design and using copy and paste. Make sure that each factor’s levels and ranges match the existing data set.

Designs can be exported from Stat-Ease to tab delimited text files. These files can be edited to enter responses and then re-imported.

The design files created by Stat-Ease are XML formatted text files. These files can be directly edited. Several scripting languages and Excel® can correctly parse XML files.

The export/import and XML features are most often used with automated experiment equipment.

Analyzing historical data (data mining)

Data gathered without a designed experiment can be evaluated and analyzed using Stat-Ease.

Use the evaluation node to explore the aliasing structure, correlation of the factors and the fraction of design space on the graphs tab. If everything looks okay, continue with the analysis.

Follow this link to our free webinar on the subject of analyzing historical data for some details about the things that can go wrong with historical data analysis.

View alias structure for pre-existing design

Working with existing data sets can be tricky. If it proves difficult to get useful analysis or warning messages about aliased terms appear, click on the Evaluation node on the left side of the screen.

Stat-Ease recommends evaluating the two-factor interaction (2FI) order first as this is where most of the important model terms will come from. Click the Results tab. If it shows no aliasing, then go back to the model tab and increase the order. Repeat until aliased terms appear (if any) to determine the capability of the design.

Fitting more than one model to a response

If it is necessary to compare two models for the same data, use the Analysis [+] button to create a second analysis for the response. A different model can be fit to the response and the analyses compared at each step.


All reports and graphs can be exported to Microsoft Office® programs Word® and PowerPoint®. Select the section of the report or click on the graph that is to be exported, right-click, and select the export method.

Make sure to click on a cell containing text or select the whole report (ctrl + a) to export every section. For graphs just make sure to click on the graph before exporting.

The annotation on the Evaluation and ANOVA is not exported via the journal. Annotation can be copied and pasted separately.

If Word is already open, the exported object will be inserted at the cursor position. If exporting to PowerPoint® a new slide will be added to the presentation. If the selected program is not open, a new document will be created.

If multiple sections of a report are exported they will be in separate tables and/or on separate pages as necessary to maintain a readable font size.