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.
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.
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.
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.
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.
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.
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.
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.