How to Use Analysis Output as Input for a New Analysis or Graph

In our STATISTICA analysis projects, sometimes it is helpful and interesting to explore the output further. For example, a custom plot can be produced from the predictions of a predictive modeling tool. Another possibility is to create a graph from summary statistics. Many possibilities exist for the need to use output from an analysis tool as input in a new analysis or graphing tool.
Using Output as Input – Workbooks

The default method of managing output is a workbook. A STATISTICA Workbook is a container for objects associated with your analysis. The input data spreadsheet, output spreadsheets and graphs as well as Microsoft Excel worksheets and charts, Microsoft Word documents, and more can be stored within a workbook. The workbook is designed with a tree panel on the left for navigation through the items it contains.

graphical-summary-for-sales

Any spreadsheet in the workbook can be used as input for a new analysis or graph. To use a spreadsheet contained within a workbook as input, the item must be designated as the active input spreadsheet. In the workbook above, the top spreadsheet is the active input spreadsheet, denoted by the red box around the spreadsheet icon in the tree pane.

The last spreadsheet in this workbook is the prediction and residual output from the General Linear Model. Suppose it would be beneficial to use this output as input for a new analysis. Right-click on the spreadsheet icon to be designated as input, and from the shortcut menu, select Use as active input.

use as active input

Then, the output spreadsheet will be shown with a red box around it, indicating it is now the input spreadsheet for new analyses. Any new analysis started now, with this workbook as the active object, will use this output spreadsheet as input. For example, a range plot was created from the prediction output and can be seen in the following image.

input for output

Using Output as Input – Individual Windows

An alternative output management strategy is individual windows. When output is sent to an individual window, with few exceptions, it is stored as an output spreadsheet. Select the specific spreadsheet you want to designate as input, and on the Data tab in the Mode group, select the Input check box to define that spreadsheet as input.

input from data menu

Now when this spreadsheet is the active object, it will be used as input for the analysis.
Using Output as Input – Reports and Word Documents

STATISTICA output must be sent to either a workbook or a standalone window. In addition to this selection, output can also be sent to a STATISTICA Report, Word document, or both. As the output is sent to multiple places with reports and Word document options, the easiest course of action is to use the output from the workbook or individual window as input in a further analysis.

Report. If only the STATISTICA report is available, such as when returning to results from a previous project, the data must be extracted from the report to be used in analysis and graphs. Select the spreadsheet object in the report’s navigation pane that you want to use as input in a new analysis or graph. Right-click the spreadsheet object to display a shortcut menu. From the Extract submenu, select Copy. This option leaves your report intact while also creating a standalone window of the data spreadsheet. Following the instructions above for marking a standalone window spreadsheet as input will make this output data ready to be used as input in an analysis.

output as input report

Word.When output is sent to Word documents, two options exist for how spreadsheet objects are treated: as an editable table or an object. The selection is made via the Options dialog box that governs global options of STATISTICA.

output manager

When the spreadsheet is sent to Word as a table, the data needed for input in a new analysis or graph can be copied and pasted to a STATISTICA spreadsheet. The spreadsheet with pasted results can be used as input.

Conclusion

STATISTICA offers a variety of output management strategies, and each includes methods for the use of that output as input in new analyses. This makes it possible for a customized analysis of data.

Advertisements

About statsoftsa

StatSoft, Inc. was founded in 1984 and is now one of the largest global providers of analytic software worldwide. StatSoft is also the largest manufacturer of enterprise-wide quality control and improvement software systems in the world, and the only company capable of supporting its QC products worldwide, with wholly owned subsidiaries in all major markets (StatSoft has 23 full-service offices, on all continents), and its software is available in more than 10 languages.

Posted on November 5, 2012, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: