Flexible Output Options

When you perform an analysis, STATISTICA generates output in the form of multimedia tables (spreadsheets) and graphs. The Output Manager is used to direct all output to workbooks, reports, stand-alone windows, and/or Microsoft Word documents. STATISTICA Enterprise Server users can output results to the web using STATISTICA Enterprise Server Knowledge Portal.

Each of the STATISTICA output channels has its unique advantages. They can be used in many combinations (e.g., a workbook and report simultaneously) and can be customized in a variety of ways. Also, all output objects (spreadsheets and graphs) placed in each of the output channels can contain other embedded and linked objects and documents, so STATISTICA output can be hierarchically organized in a variety of ways.

The unique advantages of each of the STATISTICA output channels are described in the sections that follow. More comprehensive overviews of each of the document types associated with the respective channels of output can be found in STATISTICA Documents.


Workbooks are the default way of managing output (for more information, see the workbooks section of STATISTICA Documents). Each output document (e.g., a STATISTICA Spreadsheet or Graph, as well as a Microsoft Word or Excel document) is stored as a tab in the workbook.

Documents can be organized into hierarchies of folders or document nodes (by default, one is created for each new analysis) using a tree view, in which individual documents, folders, or entire branches of the tree can be flexibly managed.

Output Workbooks

For example, selections of documents can be extracted (e.g., drag-copied or drag-moved) to the report window or to the application workspace (i.e., the STATISTICA application “background” where they will be displayed in stand-alone windows). Entire branches can be placed into other workbooks in a variety of ways in order to build specific folder organization.

Technically speaking, workbooks are ActiveX document containers (see ActiveX technology). Workbooks are compatible with a variety of foreign file formats (e.g., Microsoft Office documents), which can be easily inserted into workbooks and in-place edited.

User notes and comments in workbooks. Workbooks offer powerful options to efficiently manage even extremely large amounts of output, and they may be the best output handling solution for both novices and advanced users. It might appear that one of their possible drawbacks is that user comments (e.g., notes) and supplementary information cannot be as transparently inserted into the “stream” of the workbook output as they can in traditional, word processor style reports, such as STATISTICA Reports (see the next section). However, note that:

  • All STATISTICA documents can easily be annotated, both (a) directly, by typing text into graphs, tables, and reports, and (b) indirectly, by entering notes into the Comments box of the Document Properties dialog (accessed by selecting Properties from the File menu).
  • Formatted documents with notes and comments (in the form of text files, STATISTICA Report documents, WordPad or word processor documents, etc.) can easily be inserted anywhere in the hierarchical organization of output in workbooks. Moreover, such summary notes or comment documents can be made nodes for groups of subordinate objects to which the note is related to further enhance their organization.


Reports in STATISTICA (more information about reports is available in STATISTICA Documents) offer a more traditional way of handling output where each object (e.g., a STATISTICA Spreadsheet or Graph, or a Microsoft Excel spreadsheet) is displayed sequentially in a word processor style document.

Output ReportsHowever, the technology behind this simple editor offers you very rich functionality. For example, like the workbook, the STATISTICA Report is also an ActiveX container, where each of its objects (not onlySTATISTICA Spreadsheets and Graphs, but also any other ActiveX-compatible documents, e.g., Microsoft Excel spreadsheets) remains active, customizable, and in-place editable. The obvious advantages of this way of handling output (more traditional than the workbook) are the ability to insert notes and comments “in between” the objects as well as its support for the more traditional way of quick scrolling through and reviewing the output to which some users may be accustomed.

The obvious drawback, however, of these traditional reports is the inherent flat structure imposed by their word processor style format, although that is what some users or certain applications may favor.

Stand-Alone Windows

STATISTICA output documents can also be directed to a queue of stand-alone windows; the Queue Length can be controlled in the Output Manager.

Output Stand-Alone Windows Output Stand-Alone Windows

The clear disadvantage of this output mode is its total lack of organization and its natural tendency to clutter the application workspace (some procedures can generate hundreds of tables or graphs with a click of the button).

One of the advantages of this way of handling output is that you can easily custom arrange these objects within the STATISTICA application workspace (e.g., to create multiple, easy to identify “reference documents” to be compared to the new output). However, note that in order to achieve that effect, you do not need to configure the output ahead of time and generate a large number of (mostly unwanted) separate windows that can clutter the workspace. Instead, individual, specific output objects directed to and stored in workbooks and/or reports can easily be dragged out from their respective tree views onto the application workspace as needed.

Microsoft Word

STATISTICA also allows routing output directly to Word via the Office Integration features. When Word is open within STATISTICA, Word toolbars and menus are also available through standard Active X Document interfaces technology. In STATISTICA, you can perform any formatting and editing that Word supports in its application.

When sending spreadsheet analytical results to Word, STATISTICA will take advantage of Word’s table editing facility, and convert the spreadsheet to a table. For multi-page spreadsheets, you can control where to break the rows and columns. These spreadsheets will be broken by columns such as will be allowed without exceeding the page width. All rows for a given set of columns will be rendered before the next set of spreadsheet columns is rendered in the Word document. This solution enables the presentation of spreadsheets in Word that are natively editable in Word, displays the entire contents of the spreadsheet, and prints and paginates correctly.

As with standard STATISTICA Reports, Word documents can store and preserve the record of supplementary information (e.g., selected variables, long names, etc.).

Although Word documents do not provide the navigational tree of a STATISTICA Workbook or Report, the advantages in sending output to Word documents are many. By sending results to a Word document, you have all the word processing features of Word at your finger tips. For example, you can attach templates to create customized documents, add tables of content and indices, track changes, etc.

When inserting a large spreadsheet into a Word document, STATISTICA automatically detects how many variables can fit on each page and partitions the spreadsheet into several Word tables. If the spreadsheet uses case names, those names will be the first column in each table.

Additional benefits of sending results to a Word document include increased printing functionality (e.g., printing to files, manual duplex) and the ability to save results as Web pages.


HTML reports. You may want to post a STATISTICA Report or Workbook on the Internet for others to review. With STATISTICA, you can save reports and workbooks in HTML format. HTML is an acronym for HyperText Markup Language. HTML uses tags to identify elements of the document, such as text or graphics.

STATISTICA Enterprise Server Knowledge Portal. STATISTICA Enterprise Server provides another way to distribute reports – through the Knowledge Portal. The Knowledge Portal enables you to publish STATISTICA documents (spreadsheets, graphs, reports, or workbooks) to the Internet. Users with limited Knowledge Portal permissions can then view those documents. You control who can access these documents by setting permissions on the documents and directories using standard WebSTATISTICA repository tools.


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 July 30, 2013, 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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: