• Are there different customization options for each type of graph?

    No. Once a graph is displayed on the screen, regardless of how it was requested or defined, all graph customization options available in STATISTICA can be used to customize it. The customization options available for all graphs include appending new plots to existing graphs and linking and embedding graphs, as well as drawing, fitting, and graph restructuring options. Also, all these options can be used to customize graphs that were saved and later opened for additional editing.

  • Can I add a folder to a workbook?

    By default, when results are automatically added to a workbook, they are included in a folder that identifies from which analysis they originated; however, you can add as many folders (and levels) to a workbook as you want. This allows you to easily organize all of the items in your workbook, including spreadsheets, reports, and non-STATISTICA documents that are placed in the first level of the workbook by default. As with all items you can add to a workbook, folders can be inserted as either a sibling or a child to current workbook items.

    Folders are added to the workbook tree via the Insert Workbook Item dialog. Right-click on the first folder in the workbook tree to display a shortcut menu, and select Insert to display this dialog.

    workbook tree insert

    You can also select Insert from the Workbook menu or press the INSERT key on your keyboard

    When the Insert Workbook Item dialog is displayed, select the Workbook folder option button in the Item group box and As first child in the Placement group. Note that the sibling options in this box are disabled because we are adding an item to the root level of the workbook tree and it cannot have siblings. Click the OK button to add the folder to the workbook tree. Although folders can be added to any part of the workbook tree, this example adds a new folder to the first folder in the tree.

    Note that when the folder is initially added to the tree, its name is selected. You can rename the folder at this time by entering a new name. To rename the folder later, double-click on the name New Folder, and enter a new name.

  • Can I add custom headers or footers to printed output?

    You can create a customized header or footer for a STATISTICA Spreadsheet, Report, Graph, or Workbook that can include information such as the date, time, page number, and name of your company.

    output management header footer

    To create the header or footer for a STATISTICA Spreadsheet, Report, or Graph, select Header/Footer from the View menu and use the options in the Modify Header/Footer dialog to specify the custom header or footer. Note that custom headers and footers for STATISTICA Workbooks are created in the Workbook Page Setup dialog, accessible via the File menu.

  • Can I append output from multiple sessions to the same report?

    To automatically send all results to the same report, select the Single Report (common for all Analyses/Graphs) in the Analyses/Graphs: Output Manager options pane of the Options dialog (accessible by selecting Options from the Tools menu). This automatically generates a report that contains all of the results and graphs created in STATISTICA (from the time the options are specified).

  • Can I automate commonly used procedures or repeat similar tasks in STATISTICA?

    Automation facilities in STATISTICA are available via STATISTICA Visual Basic. When you run an analytic procedure (from the Statistics or Data Mining menus) or create a graph (from the Graphs menu), the Visual Basic code corresponding to all design specifications as well as output options that you select are recorded. To display that code, select Create Macro from the Options button drop-down list (available on any analysis or graph dialog), or click the Create Macro toolbar button, or select the particular analysis or graph from the Tools - Macro - Create Analysis/Graph Macro submenu. The code can later be executed repeatedly or edited by changing options, variables, or data files and optionally adding user interfaces, etc.

    Programs can also be written using the STATISTICA Visual Basic professional development environment featuring a convenient program editor with a powerful debugger (with breakpoints, etc.), an intuitive dialog painter, and many facilities that aid in efficient code building. To display the SVB editor, select New from the File menu to display the Create New Document dialog, and select the Macro tab.

    Note that Master Macros (logs of multiple analyses) and Keyboard Macros (context sensitive recordings of sequences of keystrokes) are also available.

    Also, many procedures and graphs allow you to automatically repeat the same analysis for each of a series of variables (e.g., Design of Experiments uses multiple dependent variables) or each level of a grouping variable (e.g., categorized graphs).

  • Can I change the multi-item display settings in a workbook I have already created without changing the global defaults?

    Yes. With the workbook open, from the Workbook - Multi-Item Display submenu, select Settings to display the Multi-Item Display Settings dialog. Alternatively, you can right-click on a folder in the workbook and select Multi-Item Display - Settings to display the Multi-Item Display Settings dialog. Select the Apply to All Folders check box if you want the changes to apply to all folders currently in your workbook. Otherwise, the changes will apply only to the selected folder. Different folders in a workbook can have different multi-item display settings.

  • Can I combine text, tables, and graphs in one report?

    Yes. You can use STATISTICA Reports to combine text and graphics. Create a new report (using the Create New Document dialog - Report tab, accessed by selecting New from the File menu), and then select the document you want to add to the report, and click the Add to Report toolbar button.

  • Can I copy a set of text labels, numeric values, and descriptions to other variables and files?

    Yes, you can. Click the Copy From button in the Text Labels Editor (see above) to copy to the current variable the text labels, numerical values, and descriptions from other variables or from the case names.

    When you need to copy the text labels, numerical values, and descriptions from one file to another, select Merge from the Data menu to display the Merge Options dialog. On the Text Labels tab, you can concatenate or replace text labels with labels from another file.

  • Can I create a custom header or footer for my report?

    Yes. You can create a customized header or footer for a STATISTICA Report (or any other document) that can include information such as the date, time, or the name and logo of your company. To create a header or footer, select Header/Footer from the View menu. This displays the Modify Header/Footer dialog in which you can select a default header or footer or create a custom header or footer.

  • Can I create a custom list to use for extrapolation?

    Yes. Select Custom Lists in the Options dialog (accessible by selecting Options from the Tools menu) to edit or create custom lists for STATISTICA to use.

    The Custom lists box reports all the custom lists currently available in STATISTICA. To see the entries included in a custom list, select one, and the entries are displayed in the List entries box. To create a new list, select NEW LIST and enter your choice of items for it in the List entries box. Once you have added all the items for the new list, click the Add button and the list is added to those in the Custom lists box. When entering data in spreadsheets, you can enter the first few items in the list, and then use extrapolation to fill in the remaining cases in the spreadsheet (as shown below).

    spreadsheet extrapolation

  • Can I label numeric values?

    Yes, in STATISTICA, each numeric value can have two identities: the actual numeric value (e.g., 1) and a text label (e.g., Male) assigned to it. Note that in addition to text labels for numeric values, STATISTICA also supports text variables.

  • Can I open more than one input data file simultaneously?

    Yes. Moreover, you can simultaneously run different analyses on the same or different data files. To open (and use) more than one input data file simultaneously, open multiple data files and make sure each is specified as an input data file (by selecting Input Spreadsheet from the Data menu) as you start the respective analyses.

    Analyses stay associated with the different data files when you switch between them (using the buttons next to the STATISTICA Start button, above the status bar). Note that you can also perform different analyses on the same or different data files.

    While you can specify any number of spreadsheets as input data files, only one file (per workbook) can be designated as the active input data file.

    spreadsheet input datafile

    This means that if all your spreadsheets are opened within one workbook, only one of them can be used for input data at a time. The active input data spreadsheet is highlighted in the workbook tree with a red square, as shown above.

  • Can I place multiple graphs on one page?

    Several graphs can be printed on one page by linking or embedding them within a blank graph (see above). Although this can be done manually using cut-and-paste (and Snap to Grid), the easiest method is to use either the Multiple Graph Layouts - Wizard or the Multiple Graph Layouts - Templates, which automates placement of multiple graphs on one page.

  • Can I print more than one item from a workbook without printing the entire workbook?

    Yes. When printing from within a workbook, only the currently displayed (active) item is printed when the Print button is clicked, but if the Print dialog is used, multiple selections from the workbook can be printed by using the Selection option in the Print Workbook dialog. Note that STATISTICA supports the standard Windows SHIFT+click and CTRL+click conventions to select ranges and discontinuous lists of items, respectively. Thus to print a range of graphs from a workbook, select the range of graphs, selectPrint from the File menu to display the Print Workbook dialog, select the Selection option button in that dialog, and click the OK button.

  • Can I quickly adjust sizes of all fonts in a graph?

    In STATISTICA, all graph displays and printouts can be continuously scaled. STATISTICA will also automatically adjust the sizes of all fonts, markers, spacing, etc., such that manual adjustments of individual font sizes are rarely necessary.

    You can interactively decrease or increase the size of the selected text or point marker by clicking the Decrease Font or Increase Font buttons (respectively) on the Graph Tools toolbar. Each click of the toolbar button changes the font size (or point marker) by one point (i.e., one click of the Increase Font button will increase the font size or point marker by one point). Note that if you have not selected any text or point markers, clicking these buttons will increase or decrease all text and point markers by one point.

  • Can I rearrange blocks of data or ranges of cases and variables in a data file?

    There are three types of operations that you can use to rearrange blocks of data or ranges of cases and variables in a data file. They each operate differently and can produce different effects.

    • Clipboard-based operations. The standard Clipboard-based operations of cut, copy, and paste (implemented via the standard Clipboard keyboard, toolbar, or menu commands) affect only the contents of blocks of data, rows, or columns. They do not influence the overall size of the data file (e.g., they can empty a column but will not remove the column from the spreadsheet).

    • Global operations. Global operations (accessible from the Vars and Cases spreadsheet toolbar buttons and the spreadsheet Insert menu) are performed on entire rows or columns as "units"; for example, they move or delete entire columns, not only their contents. Hence, the size of the data file increases or decreases when you use these options.

    • Drag-and-drop operations. STATISTICA supports standard (Microsoft Excel-style) drag-and-drop facilities, allowing you to easily perform both Clipboard-style (but without using the Clipboard) and global (if the insert mode is implemented by pressing the SHIFT key) operations.

  • Can I rearrange the workbook tree with drag-and-drop?

    Yes. The STATISTICA Workbook supports an entire range of drag-and-drop features within the workbook tree. Click on an item in the workbook tree, and drag that item to a new location within the tree. In fact, since the drag-and-drop features support parent/child relationships, you can use these features to rearrange large portions of the workbook tree.

    To select the parent node and all of its children, simply click on the parent node (or press CTRL while clicking on the parent node and each of its children). To make discontinuous selections (i.e., select some of the children, but not all of them), hold down the CTRL key while clicking on each item you want to select. You can also make discontinuous selections across nodes using the CTRL key.

    Follow these steps to move a folder (and its contents) to a new location in the workbook tree:

    1. Click on the folder to select it and all of its children.

    2. Right-click on the folder and drag the folder to a new location in the tree.

    3. Release the right mouse button, and a shortcut menu is displayed, giving you options to either copy or move the dragged item. You can place the item before, after, or as a child to the newly selected item in the tree.

  • Can I rename an item in a report?

    Yes. When you add items to a report, they are inserted with generic document names (i.e., spreadsheet). However, you can rename report items (using a variety of Windows standard renaming conventions) so that they are more descriptive. For example, you can click to select an item in the report tree and press F2. Then enter the new name for the item and press ENTER.

  • Can I represent objects in graphs as expandable icons?

    Icons representing documents in Windows Explorer can be dragged across applications and dropped into STATISTICA Graphs. If the source application is OLE-compliant, the document will be displayed in theSTATISTICA Graph.

    If the source application is not OLE-compliant, the document will be represented as an icon, either of the source application (if an association exists in Windows for the document's file extension), or of the Windows Object Packager (if no association exists). These icons function as buttons; double-clicking on an icon will launch the application with which it is associated and open the file represented by the icon.

  • Can I save my reports in HTM format?

    Yes. Select Save As from the File menu to display the Save As dialog. To save the file using an *.htm extension, select HTML Files (*.html, *.htm) from the Save as type option.

    Items in the report are saved as *.png files in the same folder as the HTM file using the following naming convention: reportname_document type_0001.png, reportname_document type_0002.png, etc. You can save graphs as JPG files, instead. To do this, select Options from the Tools menu to display the Options dialog. Select the Reports node, and in the options pane, select the JPEG format option button in the Export HTML images as group box.

  • Can I select (highlight) the entire spreadsheet?

    Following standard spreadsheet conventions, click in the upper-left corner of the spreadsheet (in the Info Box). This shortcut is useful, for example, when you intend to copy the entire file to the Clipboard or reformat the entire spreadsheet. You can also press CTRL+A or select Select All from the spreadsheet Edit menu or shortcut menu (accessed by right-clicking in the Info Box).

    spreadsheet select all

    Note that by clicking twice in the Info Box, you deselect (i.e., select and then deselect) the entire spreadsheet.

  • Can I select discontinuous items in the workbook tree?

    You can select one or more items in the workbook tree using the standard Windows SHIFT+click and CTRL+click conventions to select ranges and discontinuous lists of variables, respectively. Additionally, you can select and deselect tree items using the keyboard navigation keys (e.g., HOME, END, PAGE UP, PAGE DOWN, and arrow keys). You can delete an entire selection by pressing the DELETE key. Press the INSERT key to display the Insert Workbook Item dialog for the currently selected item.

    Note that to select discontinuous items of a particular node, you will need to expand the node (by clicking on the plus sign adjacent to the node).

  • Can I specify a certain number of columns for a multi-item display?

    To set the global default for all future workbooks, from the Tools menu select Options to display the Options dialog, and select DocumentsWorkbooks. In the options pane, you can change the defaults for the number of columns as well as the height and width of the items in the display (see the options in the Multi-Item Display group box).

  • Can I undo editing operations?

    You can undo most operations such as editing, moving, or copying blocks; random fill; recoding or ranking variables; etc. by selecting Undo from the spreadsheet Edit menu or pressing CTRL+Z. Multi-level undo is supported (with 32 buffers), so you can undo up to 32 of the most recent spreadsheet operations.

  • Can I use clipboard functions to rearrange items in the report tree?

    Yes. In addition to using drag-and-drop features to rearrange report items, you can use cut (CTRL+X), copy (CTRL+C), and paste (CTRL+V) functions to move items from one folder to another. To move (cut) a spreadsheet (or other document) in a report, right-click on the spreadsheet and select Cut from the shortcut menu (or press CTRL+X). This action places a copy of the item on the Clipboard while removing it from its current location in the report. To paste the spreadsheet into a new folder in the report, right-click the folder, and select Paste from the shortcut menu. Alternatively, you can press CTRL+V. This action places the spreadsheet (that you had cut to the Clipboard) in the desired folder in the report. Note that the pasted object is placed in the top position in the folder, and can be dragged to another position if desired.

  • Can I use the results of one analysis to perform another analysis?

    Yes. To designate a spreadsheet (i.e., the results from one analysis) as an input spreadsheet, select the spreadsheet (e.g., ensure the spreadsheet has the focus) and select Input spreadsheet from the Data menu. Now you can specify an analysis, and STATISTICA uses the selected spreadsheet as the input spreadsheet. Note that if you switch back to another spreadsheet that has previously been designated as an input spreadsheet, it can still be used for analyses as well.

    While you can specify any number of spreadsheets as input data files, only one file (per workbook) can be designated as the active input data file. This means that if all your spreadsheets are opened within one workbook, only one of them can be used for input data at a time. The active input data spreadsheet is highlighted in the workbook tree with a red square as shown above.

  • Do all printer drivers support rotated fonts?

    Most properly configured printers supported by Windows can handle rotated fonts; however, some printer drivers support some of the advanced printer control features used by STATISTICA only when they are set to a higher resolution (e.g., higher than 300 DPI) and/or when they are set to print fonts as graphics. If you encounter problems (e.g., rotated text is printed as unrotated or "uncovered" text is revealed that should be covered), consult the documentation included with your printer for direction on printing TrueType fonts as graphics or setting your printer to a higher resolution.

  • Do STATISTICA Spreadsheets support split display?

    Yes, they do. Spreadsheets can be split into up to four sections (panes) by dragging the split box (the small rectangular button above the up arrow at the top of the vertical scrollbar or to the left of the left arrow on the horizontal scrollbar). This is useful if you have a large amount of information and you want to review results from different parts of the spreadsheet. When you point to the split box, the pointer changes to Vertical Resize (or Horizontal). To position the split, drag to the desired position.

    spreadsheet 2way split

    You can change the position of the split by dragging the split box (now located between panes) to a new position. Note that vertically split panes scroll together when you scroll vertically; horizontally split panes scroll together when you scroll horizontally.

    spreadsheet 4way split

  • Help doesn't work after I installed Windows Server 2003 SP1 and security updates 896358 and 840315. What can I do?

    This Microsoft Windows security update (MS05-026) was intended to reduce security vulnerabilities in HTML Help. However, it interferes with the Help system for network versions of many applications (including the regular network and concurrent network installations of STATISTICA). Fortunately, Microsoft has also issued instructions on how to correct the problem: Simple solution: Most users can download the file HTMLHelp.reg, just click here to start downloading. This will fix the problem by modifying your Windows registry to allow your PC to access the local intranet. More complex solution: Users with sophisticated security issues should read Microsoft's article that describes this problem in detail and provides solutions for different situations: http://support.microsoft.com/?kbid=896054

  • How are dates represented in STATISTICA Spreadsheets?

    Date values of variables are stored internally in Julian format, that is, as a single integer value that represents the number of days that have passed since January 1, 1900. For example, a date entered and displayed as 1/21/1968 is stored as the Julian date 24858; the (optional) decimals are interpreted as time. Date values stored in this manner can be used in subsequent analyses (e.g., in Survival Analysis in order to calculate survival times, see below) and transformed using arithmetic operations; at the same time, they can be displayed as dates in reports or graphs (e.g., used to label scale values).

    Julian date values can be displayed in the spreadsheet in numeric (Julian) format or in one of several predefined date display formats (e.g., 1/6/64, 6-Jan-64, Jan-1964, 01/06/64, 01/06/1964, 6-Jan).

    spreadsheet variable properties date

  • How are missing data handled in STATISTICA?

    A missing data code is a value that signifies that there is no data for a particular case and variable (displayed as a blank cell in the spreadsheet). A missing data code can be specified separately for each variable.

    To change the code, double-click on a variable name in the spreadsheet to access the Variable specifications dialog for that variable. Alternatively, click the Vars toolbar button and select All Specs from the resulting menu to display the Variable Specifications Editor dialog for all variables. The default Missing Data code in STATISTICA (used when new files are created, new variables are added, or data are imported) depends on the variable type being used.

    Moreover, in each analysis, you can individually adjust the way in which missing data are handled when processing data c (see the MD deletion group in most analysis definition dialogs). Whenever applicable, you have the choice to eliminate them from calculations in a casewise or pairwise manner, substitute them with means, or reconstruct or interpolate them.

  • How can I break, stop, or interrupt the current action?

    The following facilities are available to stop, break, or interrupt the current action (depending on the operation being performed by STATISTICA):

    • Analysis. Click the Cancel button on the Progress bar to interrupt the task in progress.

    • Brushing (in a graph). Deactivate the brushing tool by clicking the Selection Tool  toolbar button.

    • Printing. Interrupt the printing of spreadsheets, graphs, reports, etc., by clicking the Cancelbutton in the Print dialog.

    • STATISTICA Visual Basic. You can interrupt SVB programs in several ways. Click the Pause toolbar button to pause the currently running macro, or click the Reset  toolbar button to stop running (i.e., reset) the current macro. You can also press the ESC key or CTRL+BREAK in order to interrupt the execution of the STATISTICA Visual Basic program.

  • How can I copy a selected part of a STATISTICA Graph?

    There are several copy options:

    • Copying an object. Select a graphic object to be copied by clicking on it (ensure that you are in default pointing mode, i.e., the Selection Tool button on the toolbar has been clicked. Graphic objects are all objects you have created on the screen such as a custom text, a segment of a drawing, or an embedded graph or artwork. When the object is selected, press CTRL+C. Alternatively, you can click the Copy toolbar button.

    • Copying a rectangular section of the graph. Enable the Screen Catcher by pressing ALT+F3, or select Capture Rectangle from the Edit - Screen Catcher submenu. Hold down the left mouse button, and use the mouse pointer to select the area of the graph you want to copy. When you release the mouse button, the selected area will be automatically copied to the Clipboard in the bitmap format (there is no need to click the Copy button). Note that the Screen Catcher can be used to copy any rectangular part of the screen, not only in the graph window from which it was called but any part of the screen (even including parts that belong to other applications).

    • Copying a specific window. The Screen Catcher can also capture a specific window from the screen. To copy a specific window, select Capture Window from the Edit - Screen Catcher submenu, and use the mouse pointer to select the desired window.

  • How can I copy an entire STATISTICA Graph?

    Ensure that the window containing the graph to be copied is active, and then press CTRL+C or click the Copy toolbar button.

    STATISTICA Graphs can be pasted and linked or embedded in other application documents (e.g., word processor documents or spreadsheets) following standard OLE conventions. If STATISTICA Graphs are pasted to OLE-compatible applications, the graphs maintain their relation to STATISTICA and thus can be interactively edited from within the other application or updated when the STATISTICA Graphs change.

    If the STATISTICA Graph copied to the Clipboard has been saved as an *.stg file, you can link it in other application documents (or STATISTICA's own) by selecting Paste Special from the Edit menu.

  • How can I copy/print result summaries?

    Located at the top of some results dialogs is a summary box. This box contains relevant summary information for the type of analysis (e.g., descriptive statistics, design attributes, regression results, etc.). Additionally, two buttons are provided with the summary box: a copy button that is used to copy the summary results to the Clipboard and an expand/collapse button that is used to expand (show) or collapse (don't show) the summary box.

    You can copy a portion of the summary results to the Clipboard by selecting the desired text and clicking the copy button. To copy all of the text, click the copy button without selecting any text. You can then paste the text into a STATISTICA Spreadsheet, Report, Graph, or any word processing document (e.g., Microsoft Notepad or Word) for printing.

    Note that the copied text retains formatting information (such as font, color, etc.).

  • How can I find a particular statistical procedure?

    If you are not certain where to find a particular procedure within STATISTICA, consult the Statistical Advisor by selecting Statistical Advisor from the Help menu. The Statistical Advisor lists a set of questions about the nature of the research problem and the type of your data. Click the link for the most appropriate answer, and the next topic will be displayed, which will either list more questions or list suggestions of the statistical procedures that appear most relevant and where they are located in the STATISTICA application.

    You can also search for topics in the STATISTICA Electronic Manual (Help) using the Index or Search facilities. Help is always available by pressing the F1 key.

  • How can I learn what information is necessary to start an analysis (variables, grouping, codes, options, etc.)?

    Click the Help  button or press the F1 key to display the relevant section of the STATISTICA Electronic Manual containing a comprehensive explanation of all options in the current dialog. However, all analysis definition screens in STATISTICA follow the "self-prompting" dialog conventions: The OK button is never dimmed; whenever you are not sure what to select next, simply click and STATISTICA proceeds to the next logical step and prompts you for specific input if it is necessary.

  • How can I make changes to a graph or spreadsheet in my multi-item display?

    There are two ways to do this. If you make changes to the graph or spreadsheet in your workbook, the changes will be reflected automatically in the display item. You can also double-click on an item in the display to "in-place activate" it, and make changes directly in the multi-item display. When an item is in-place activated and modified, changes to the item will be reflected in the corresponding workbook item it represents.

  • How can I place one STATISTICA Graph into another?

    The easiest way to place one graph into another is to copy a graph displayed in one window (press CTRL+C or click the Copy toolbar button), and then move to the target graph window and paste it there (press CTRL+V or click the Paste toolbar button). The pasted graph will be displayed on the target graph. Now you can move or resize it like any other custom graphic object.

    You can also change the properties of the pasted object by selecting Object Properties from its respective shortcut menu (right-click on an object). You can also edit the embedded object by double-clicking on it (following the standard OLE conventions).

    Graphs and artwork saved as files can also be dynamically linked or statically embedded in the current graph by using the standard OLE facility, accessible by clicking the Graph Tools toolbar Insert Object button or selecting OLE Object from the Insert menu.

  • How can I print text/graphics reports from analyses?

    To print a report, select Print from the File menu (or press CTRL+P) to display the Print Report dialog. Use the options in the Print Range group box to specify what pages to print. To print the entire report, select the All option button. To print a range of pages, select the Pages option button and specify the range using the From and To boxes. To print the selected portion of the report, select the Selection option button. Then, click the OK button to print.

  • How can I suppress the printing of gridlines in spreadsheets?

    To suppress the print of the gridlines in an active spreadsheet, you must make changes in two dialogs. First, change the Style of both the Horizontal and Vertical Data Lines to blank in the Gridlines dialog, accessed by selecting Gridlines from the Spreadsheet View menu. (Note that you can access the Spreadsheet View menu from within a report window or workbook by double-clicking on the spreadsheet. This gives you access to all spreadsheet editing tools.)

    output management gridlines

    Second, clear the Gridline styles and colors check box in the Edit Spreadsheet Layout: Print Filter dialog. (To display this dialog, first select Layout Manager from the Format - Spreadsheet submenu to display theSpreadsheet Layouts dialog. Then on the System tab, select Print Filter and click the Edit button.)

    output management layouts

    Note that clearing this check box causes STATISTICA to print the gridlines using the styles and colors specified in the Gridlines dialog rather than using a default black.

  • How can I undo operations on graph objects?

    A multi-level undo option (available from the Edit menu, or by clicking the Undo toolbar button, or by pressing CTRL+Z) maintains up to 32 buffers (steps), which also include operations on objects.

  • How do I access help for a specific dialog?

    Quick access to the STATISTICA Electronic Manual (Help) is provided via the question mark button at the right side of the caption bar of most dialog boxes.

    Click the question mark button or press F1 to display a Help window containing the description of that dialog. Note that when you highlight a menu command, you can press F1 to display its Help window.

  • How do I add a document from another application to a workbook?

    Documents from other applications (e.g., Excel spreadsheets, Word documents) are added to the tree via the Insert Workbook Item dialog. To display this dialog, select Insert from the Workbook menu. You can also right-click in the tree and select Insert from the workbook tree shortcut menu or press INSERT on your keyboard. The example below adds a new Word document as a child to the new folder created above.

    Right-click on the New Folder and select Insert from the shortcut menu. Note that you can always move or copy the item to a new location later (using drag-and-drop features), so the exact location is not critical. In the Insert Workbook Item dialog, select the From another application option button in the Itemgroup box and the As first child option button in the Placement group box. Then click the OK button to display the Insert Document from Another Application (e.g., Excel, Word, etc.) dialog.

    You can insert either a new document or a previously saved document. For this example, select theCreate New option button and select Microsoft Office Word Document in the Object Type group box. Note that if you do not have Microsoft Word installed on your computer, you can select any appropriate file type from this box. Finally, click the OK button to add the new document to your workbook.

  • How do I add a new STATISTICA document to a workbook?

    In addition to adding current and previously saved STATISTICA documents to a workbook, you can also add new (blank) documents to a workbook, including spreadsheets, reports, and macros. When the new document is added, you must specify where to place the item in the workbook tree (as either a sibling or child to another item in the workbook) and which type of item to create.

    One way to add a new STATISTICA document is to determine an appropriate location in the workbook tree and right-click another item in that location. You can always move or copy the item to a new location later using drag-and-drop features, so the exact location is not critical.

    From the workbook tree shortcut menu, select Insert to display the Insert Workbook Item dialog. Select the STATISTICA Document option button in the Item group box and the tree location (either As last child,As first childAs next sibling, or As prior sibling) option button in the Placement group box. Click the OKbutton to display the Document type dialog.

    workbook document type new

    Use this dialog to create a new document, locate a previously saved document, or select an open document. For this example, select the Create new option button and select a spreadsheet, report, or macro in the Type box. Then, click the OK button to add the new document to your workbook.

  • How do I add a previously saved object to a workbook?

    Previously saved ActiveX documents (e.g., STATISTICA Spreadsheets and Graphs, Excel spreadsheets, Word documents) are added to the tree via the Insert Workbook Item dialog. To display this dialog, select Insert from the Workbook menu. You can also right-click in the workbook tree and select Insert from the shortcut menu or press INSERT on your keyboard. You can add a variety of file types to a workbook, a feature that assists you to easily organize all of the files associated with an analysis. As with all items you can add to a workbook, files can be inserted as a sibling or as a child to current workbook items.

    Follow these steps to add a previously saved file as the next sibling to the first item in the current workbook:

    Select the first item in the current workbook, and then display the Insert Workbook Item dialog by selecting Insert from the Workbook menu. In the Item group box, select either the STATISTICA Document option button or the From another application option button, and in the Placement group, select the As next sibling option button. Click the OK button. If STATISTICA Document was selected, the Document type dialog will be displayed. If From another application was selected, the Insert Document from Another Application dialog will be displayed.

    In either dialog, select the Create from File option button and then click the Browse button to display the Browse dialog, where you can locate the file you want to insert into the workbook.

  • How do I add a saved STATISTICA document to a workbook?

    You can add a saved STATISTICA document to your workbook (e.g., a spreadsheet, graph, report, or macro) by selecting Insert from the Workbook menu or workbook tree shortcut menu.

    For example, to add the Adstudy.sta sample data file to the current workbook, open a workbook and click on any item in the workbook tree. Now, press the INSERT key on your keyboard to display theInsert Workbook Item dialog. (You could also select Insert from the Workbook menu or the workbook tree shortcut menu to display this dialog.)

    In the Insert Workbook Item dialog, select the STATISTICA Document option button in the Item group box and the As next sibling option button in the Placement group box. Click the OK button to display the Document type dialog.

    workbook document type file

    Select the Create from file option button in the Document type dialog, and then click the Browse button to display the Browse dialog. Adstudy.sta is located in the Examples/Datasets subfolder of your STATISTICAinstallation folder. Double-click on the file to enter it into the File box on the Document type dialog (as shown above). Click the OK button to add the file to your workbook.

  • How do I add cases before the first case in the spreadsheet?

    Select Add Cases from the spreadsheet Insert menu. In the Insert after case box of the Add Cases dialog, enter 0, which references the case number. If the case number is 0, it effectively means that you are inserting before the first case.

    spreadsheet add cases

    After you click the OK button, a new case is inserted before the first case of your spreadsheet.

    spreadsheet new case

    Note that the name of the new case is 1. To change this, double-click on the 1 and enter a new name.

  • How do I add the current item to a workbook?

    You can add any STATISTICA object to a workbook including graphs, reports, macros, and spreadsheets. The most direct way to add the current STATISTICA object (i.e., the document that currently has focus) to a workbook is to click the Add to Workbook toolbar button. A list of currently available workbooks is displayed, allowing you to select in which workbook to include the item.

    workbook add

    You can also add the item to a new workbook.

    By default, the item is appended at the end of the workbook tree one level below the root node (i.e., it is not placed as a sibling to any existing items in the workbook). You can relocate the object using the workbook's drag-and-drop facilities.

    You can also add currently open STATISTICA documents to the workbook using the Insert command from either the Workbook menu or the workbook tree shortcut menu. Select Insert to display the Insert Workbook Item dialog, and then select the STATISTICA Document option button in the Item group box. Click the OK button in the Insert Workbook Item dialog to display the Document type dialog.

    workbook document type window

    In this dialog, select the Create from window option button and specify which document to add using the Window box. Click the OK button to add the selected document to your workbook. Note that if you want to add all open STATISTICA documents to your workbook, select the All Windows option button in the Insert Workbook Item dialog, and then click the OK button.

    You can also add currently open ActiveX documents (e.g., Word documents or Excel files) to your workbook using the Clipboard. To add an open Word document, select the entire document (or a portion of it), copy it to the Clipboard (press CTRL+C), and then paste the contents of the Clipboard into the workbook (press CTRL+V or select Paste from the Workbook menu). STATISTICA automatically creates the appropriate type of document in the workbook and includes the contents of the Clipboard in that document.

  • How do I add variables before the first variable in the spreadsheet?

    Select Add Variables from the spreadsheet Insert menu to display the Add Variables dialog. In the After box, enter 0, which references the variable number. If the variable number is 0, it effectively means that you are inserting before the first variable.

    After you click the OK button, a new variable is inserted before the first variable of your spreadsheet.

    spreadsheet new variable

    Note that the name of the new variable is the name specified in the Name box of the Add Variables dialog (in this example, NewVar).

  • How do I add/delete cases (rows of data)?

    The easiest way to add cases to an existing data file is to double-click on the gray area of the spreadsheet. This displays the Add Cases and/or Variables dialog.

    spreadsheet add cases variables

    Specify the number of cases you want to add and click the OK button. The new cases are added to the bottom of the data file.

    You can also select Add Cases from the Insert menu to display the Add Cases dialog, where you can specify the Number of cases to add and where to insert them.

    Also, you can select the appropriate command from Cases menu, accessed by clicking the Cases button on the spreadsheet toolbar.

  • How do I add/delete variables (columns of data)?

    The easiest way to add variables to an existing data file is to double-click on the gray area of the spreadsheet. This will display the Add Cases and/or Variables dialog.

    spreadsheet add cases variables

    Specify the number of variables to add and click the OK button. The new variables are added to the far right of the data file, and the variable specification dialog is displayed where you can specify various options for the new variables, such as NameTypeDisplay format, etc.

    You can also select Add Variables from the Insert menu to display the Add Variables dialog, where you can specify the Number of variables to add, Type, etc.

    Also, you can select the appropriate command (e.g., AddMoveCopyDelete, etc.) from the variables menu, accessed by clicking the Vars button on the spreadsheet toolbar.

  • How do I adjust margins in the reports?

    Use the options in the Print Preview dialog, accessible by selecting Print Preview from the File menu when the report is active or by clicking the Print Preview button on the toolbar.

    report preview

    You can position the desired text on the printed page by adjusting the margins (specify the LeftRight,Top, and Bottom margin widths, or drag the margin lines with the mouse pointer, as shown above). You can also create a header and footer for the document.

  • How do I apply a format?

    Formats can be applied quickly and consistently to segments of data. Once a format has been created, it can be applied to any part (or all) of the data in a spreadsheet.

    To apply an existing format, first select the cell(s) that you want to format in the spreadsheet. Then select Block from the Format menu to display the list of available formats. (Alternatively, right-click on the selected cell(s) and choose Format from the shortcut menu, as displayed below.) Finally, select the name of the format to apply to the selected cells.

    spreadsheet apply format

  • How do I apply a spreadsheet layout?

    You can apply any existing spreadsheet layout to the active spreadsheet. To do this, select Spreadsheetfrom the Format menu to display the list of available spreadsheet layouts. Then, select the name of the spreadsheet layout to apply to the spreadsheet.

  • How do I assign a customized point marker to a case?

    Select a case in the spreadsheet. Next, select Edit Case States from the Data - Cases - Case States submenu, or right-click on the case and select Case States - Edit Case States from the shortcut menu, to display the Case State dialog, which contains options that display palettes of colors and symbols from which to select. Once you have made your selection, click OK.

  • How do I change the date display format?

    Select Date in the Display format group of the Variable specifications dialog (accessible by double-clicking on the variable name in the spreadsheet or by selecting Variable Specs from the Data menu) and choose one of the predefined display formats.

    spreadsheet variable properties date

    Alternatively, you can create a single date variable from two (month, year or day) or three (day, month, year) variables as well as split a single date variable into two or three variables via the Date Operations dialog (accessed by selecting Date Operations from the Data menu).

    spreadsheet date operations numeric

  • How do I change the printer setup?

    Most options for modifying the printing specifications for a given document, including margins and customized headers and footers, can be selected from the Print Preview window. To change the printer setup for a given printer, select Print Setup from the File > menu to display the Print Setup dialog. Then click the Properties button to access the Printer Properties dialog.

  • How do I convert date-values into text labels and vice-versa?

    In some circumstances, it can be useful to create text labels with date information [for example, when using a date variable as a coding variable with codes greater than 32,000. In this case, you can transform the date variable into a variable containing date text labels with numeric equivalents in a range that allows them to be used as codes by all procedures of STATISTICA (i.e., numeric values less than 32,000)]. Use the options on the Text Dates tab of the Date Operations dialog (accessed by selecting Date Operations from the Data menu) to convert dates into codes.

    spreadsheet date operations text

  • How do I copy case states to a variable?

    First, create a new variable. Double-click on the new variable heading to display the Variable specifications dialog. Specify the Type as Integer, specify the variable as a case state variable by selecting the Case State check box, and click OK. Then, select Copy to Variable from the Data - Cases - Case States submenu to display the Select a variable dialog. Select the appropriate variable and click OK. The case states will now be copied directly into the new variable.

  • How do I create a blank graph for a compound graph?

    The quickest way to create a blank graph is to select Blank Graph from the Graphs - Multiple Graph Layouts submenu. You can also select Wizard from the Graphs - Multiple Graph Layouts submenu to display the AutoLayout Wizard - Step 1 dialog. In this dialog, click the Blank button in the Add Graphsgroup box, and then click the OK button to produce a "compound" graph containing one blank graph. You can then add new or existing graph objects (e.g., added text, embedded or linked objects, arrows, freehand drawings, previously saved graphs, etc.) to that blank graph.

    The Wizard (see below) and the Templates commands (on the Graphs - Multiple Graph Layouts submenu) can also be used to design and produce a custom layout. Alternatively, the Snap to Grid facility can be used. The Alignment Grid (accessible from the View menu) and/or the dynamically updated cursor coordinates can be used to aid in the visual placement and alignment of the graph objects in the blank graph.

  • How do I create a new cell/block format?

    A format is a group of formatting options that you can save with an assigned name for future use. Formats can be assigned to numbers as well as text. To create a new format in a spreadsheet, follow these instructions:

    Select Format Manager from the Format - Block submenu to display the Format Manager dialog.

    spreadsheet format manager

    Click the New button to display the Format Name dialog.

    spreadsheet format name

    Enter a name in the Name box, and then click the OK button to display the Edit Format dialog.

    spreadsheet edit format

    This dialog contains four tabs (NumberAlignmentFont, and Border) that are used to specify the formatting components for the new format. Select the desired formatting options for your new format. In the illustration above, the Bold check box has been selected in the Style/Effect group box and the Text Color box has been changed to navy.

    Click the OK button to close the Edit Format dialog. The format that you just created has been added to the list of formats available in the Format Manager dialog and to the Format - Block submenu.

    spreadsheet format manager bold

    You can now apply this format to new selections (see the next section).

  • How do I create a new report?

    To create a new report, select New from the File menu to display the Create New Document dialog. Select the Report tab and specify whether you want to create the report as part of a new Workbook or a stand-alone report. Alternatively, STATISTICA will create a new report for you (and add the active document to it) when you select New Report from the File - Add to Report submenu or from the Add to Report toolbar button.

  • How do I create a new spreadsheet layout?

    A spreadsheet layout is a convenient way to combine sets of formatting options into one collection. This feature can be used to specify and apply different formats for different components of a spreadsheet. Once you have created a spreadsheet layout, it can be applied to any spreadsheet for a consistently formatted appearance. Follow these instructions to create a new spreadsheet layout:

    Select Layout Manager from the Format - Spreadsheet submenu to display the Spreadsheet Layouts dialog.

    spreadsheet layouts

    Click the New button to display the Spreadsheet Layout Name dialog.

    spreadsheet layout name

    Enter a name in the Name box, and then click the OK button to display the Edit Spreadsheet Layout dialog.

    spreadsheet edit layout

    In the Formats group box, a default Format 1 will be displayed. Select the area of the spreadsheet to be affected by Format 1 in the Areas of Spreadsheet affected by format group box. In the above illustration, only the Variable Header check box is selected. Note that you can control the range of variable headers to be affected by Format 1 via the options in the Range of variables group box.

    Next, click the Edit button in the Format group box to display the Edit Format: Format 1 dialog.

    spreadsheet edit format

    Select any formatting options to be associated with Format 1. Above, Comic Sans MS has been chosen as the Font10 for the Size, white for the Text Color, and blue for the Background color. Note that the Preview box is used to view your specified format.

    Click the OK button to accept the settings and return to the Edit Spreadsheet Layout dialog.

    spreadsheet edit layout blue

    To define additional formats for other areas of the spreadsheet, click the New button to display the New FormatFormat 2 dialog, and select any formatting options to be associated with Format 2. In this manner, you can add additional formats to the spreadsheet layout as necessary. In the illustration above, Format 2 (Font  Comic Sans MSSize 10Text Color white, and Background color blue) has been applied to the Case Headers.

    When you are satisfied with the appearance of your spreadsheet layout, which is displayed in the Preview box, click the OK button. The spreadsheet layout that you just created is added to the list of formats available in the Spreadsheet Layouts dialog and on the Format - Spreadsheet submenu.

    spreadsheet layouts headers

    You can now apply this spreadsheet layout to new selections (see the next section).

  • How do I create my own variable properties?

    In the Variable specifications dialog, click the Properties button to display the Variable Properties dialog. In this dialog, click the New Property button to display the New Property dialog, where you can name the new property, and click the OK button to close the dialog and return to the Variable Properties dialog. Specify the value of the new property in the Value field. Click the Remove button to remove the selected property from the variable.

  • How do I define categories for categorized graphs?

    When categorized graphs are requested from output dialogs of specific analytic procedures that involving subsets of data, the graphs will automatically display the subsets that are already defined as part of the current analysis).

    Alternatively, the categorized graphs requested from the Graphs menu offer a variety of methods to specify subsets using one or two grouping variables.

    Specifically, categories can be defined by:

    • Integer Mode: Integer values of grouping variables

    • Categories: Dividing grouping variables into a requested number of equal-length intervals

    • Boundaries: Custom intervals (ranges) of grouping variables, defined by specific interval boundaries

    • Codes: Specific values (i.e., codes) of grouping variables

    • Multiple Subsets: User-defined "multiple-subset" definitions that can be entered as logical case selection conditions of values of all variables in the current data file

    The following graph is a relatively complex example of a two-way categorized graph based on a mixed method of defining the subset graphs. The two-way categorization arranges small graphs like a two-way table (crosstabulation) based on two different criteria of categorization.

    For example, the two rows of graphs represent categories defined based on values of variable Home_2 (cases where Home_2 is less than or equal to 104.624 and cases where it is greater than 104.624). The three columns of graphs represent subsets of cases defined using specific "multiple subset" definitions based on values of variable number 0 (i.e., case numbers) and variable Home_2.

    Following is the 2D Categorized Scatterplots dialog from which the above graph was defined (select Scatterplots from the Graphs - Categorized Graphs menu).

    graph categorized scatterplot

    Specifically, variable Work_1 and Work_2 are plotted in each small graph (as variables X and Y, respectively). The first of the two categorizations (X Categories, or "columns" of graphs) was defined as Multiple Subsets in the Specify Multiple Subsets dialog that is displayed after the Specify Subsets button is clicked.

  • How do I delete items from a workbook?

    Commands for deleting workbook items are available from the Workbook menu, as well as from the workbook tree shortcut menu (accessed by right-clicking in the workbook tree). You can also delete an item by selecting it and pressing the DELETE key on your keyboard. Note that when you delete an item that has children, all of its children will also be deleted.

  • How do I display a specific equation for the fitted function?

    In Graphs menu graphs, the display of the text of the fitted function equations can be requested by selecting either In title or As custom text in the Display fit expression box on the Options 2 tab of the graph specification dialog. Select Off in the Display fit expression box to suppress the display of fit equations.

    Note that these options can be controlled globally (i.e., for all graphs) in the Analyses/Graphs: Display options pane of the Options dialog accessible from the Tools menu.

    In all single plot and non-categorized graphs where only one function is fitted, the text of the equation is displayed in the first available line of the fixed title. Depending on the number of equations to be displayed, also in categorized graphs, the equations can be displayed in the fixed titles of the graph.

    However, if more equations need to be displayed than the number of lines available in the fixed title,STATISTICA will create a custom text object on the graph and place the equations there. Potentially, such lists of equations can be very long (e.g., include 256 equations), and thus the custom text object can be large and partially cover the graph. However, the location of the listing of functions can be adjusted (the list can be moved around and edited like any other custom text object, the font size reduced, etc.).

    graph fit equations

    When the listing of functions is very long, it is recommended to add some space around the graph and place the text object there. You can add space around the graph using either the Graph actual size/scaling toolbar button or the Set graph area toolbar button.

  • How do I edit case names?

    To edit a current case name, double-click on the case name in the spreadsheet. To manage (e.g., change the width, copy from a variable, etc.) case names, right-click on any case name and select Case Names Manager from the Case Name Management submenu to display the Case Names Manager dialog. The Case Names Manager command is also available from the Cases toolbar button and from the Data menu.

    If the current data file contains no case names, you can create them by double-clicking on the case number.

  • How do I edit the contents of a cell without overwriting it?

    Double-click on the cell before you start typing. This action enters the edit mode and positions the cursor within the cell.

    Alternatively, you can follow the "old" spreadsheet convention and press the F2 key, which also enters the edit mode for the currently highlighted cell.

  • How do I enter/edit the assignments between numeric values and text labels?

    Normally, the assignments between text labels and numeric values are handled automatically as you enter or edit data in the spreadsheet. However, in some circumstances, you may want to review, edit, or restructure all assignments of values for a particular variable or copy text/numeric assignments from one variable to another. These operations can be performed in the Text Labels Editor dialog, accessible by selecting Text Labels from the Vars toolbar button menu or by clicking the Text Labels button in the Variable specifications dialog for a particular variable.

    Use the options in the Text Labels Editor dialog to sort the assignments by text labels or numeric values, perform the Fill Down operation (to automatically reassign numeric values to text labels), Copynumeric/text assignments from other variables or from case names, and perform other operations.

  • How do I export a STATISTICA Graph to another application?

    Export via Copy and Paste operations (e.g., the Clipboard). The quickest way to export a graph is to copy it to the Clipboard and then paste it into another application. STATISTICA native, Windows metafile, and bitmap formats are created in the Clipboard and can be used in other applications.

    STATISTICA Graphs can be pasted into other application documents (e.g., word processor documents or spreadsheets) as embedded objects or objects linked to graph files. If STATISTICA Graphs are pasted to other applications via Windows OLE, the graphs are tied to STATISTICA and can be interactively edited from within the other application.

    • Linking STATISTICA Graph files via OLE. STATISTICA Graph files can also be inserted and linked via OLE to other applications.

    • Export to another file format. If the graph to be saved is to be used by an application that does not support OLE or ActiveX, you can choose to save the file as a different file type by selecting the appropriate option from the Save as type option in the Save As dialog.

    • Limitations of Windows Metafile format. Very large (in terms of the number of data points represented) or very complex graphs that can be produced by STATISTICA can exceed the capacity of the Windows metafile graphics format used in the Windows 95 and 98 systems. In those circumstances, use the JPG, PNG, or bitmap representation instead.

  • How do I fit a custom-defined function to data?

    The custom-function plotting facility (see the previous topic) accessible in the Custom Function options pane of the Graph Options dialog plots the requested (custom-defined) functions and overlays them on the existing graph. It does not fit these functions to the data. The most commonly used, predefined functions that can be fitted to the data and smoothing procedures is available in the Plot: Fitting options pane of the Graph Options dialog (e.g., LinearLogarithmicExponentialPolynomialDistance-Weighted least squares, Spline, and others).

    Comprehensive facilities to fit to data (and interactively plot in two or three dimensions) user-defined functions of practically unlimited complexity are provided in the Nonlinear Estimation module.

  • How do I fit a function to data?

    Access the Plot: Fitting options pane of the Graph Options dialog, select the appropriate plot, and click the Add new fit button; then, select the desired type of function or smoothing procedure in the Fit type box. You can adjust the fitting options (e.g., stiffness or optimization settings) and the pattern for the graphical representation of the fit here as well. The pattern can also be adjusted by double-clicking on the fit line or surface in the graph.

  • How do I insert an object into a spreadsheet?

    You can insert either a new or an existing object into a spreadsheet. To do this, select Object from theInsert menu to display the Insert Object dialog.

    To insert a new object, select the Create New option button, select the type of object to be created from the Object Type box, and click the OK button.

    To insert an existing object into the spreadsheet, select the Create from File option button in the Insert Object dialog. Next, click the Browse button to display the Browse dialog, and select the file to be displayed in the spreadsheet.

    Then, click the OK button.

    spreadsheet object

    Double-click on the object to edit it. It will be opened in the application in which it was created.

  • How do I place artwork or other graphs into a STATISTICA Graph?

    The Clipboard-based operations (cut, copy, paste, link, embed) apply to all Windows-compatible artwork and graphs. Linking and embedding operations save graphs and artwork into bitmaps, Windows graphics metafiles, STATISTICA format graph files, and any OLE-compatible objects.

  • How do I place text in a STATISTICA Graph?

    Even large portions of text (e.g., a report several pages long) can be pasted into STATISTICA Graphs using the Clipboard operations mentioned in the previous two topics. Additionally, you can paste a portion of a document into the graph window using the Paste Special command. To edit and customize the text within STATISTICA Graphs, double-click the text to display the Titles/Text dialog (for custom text) or the respective OLE server application (for pasting in text via the Paste Special command).

    Both the Clipboard-based as well as inserting operations listed in the previous topic apply to all Windows compatible graphs and artwork (linking and embedding operations support any OLE-compliant objects).

  • How do I plot a custom-defined function?

    Select Custom Function Plots from either the Graphs - 2D Graphs or the Graphs - 3D XYZ Graphs submenu and specify the function in the respective dialog. Also, you can add a custom function plot to any existing graph: Access the Custom Function options pane of the Graph Options dialog and click the Add new function button. Then, use the options in the Custom Function options pane to specify the equation to be plotted in the 2D or 3D graph.

    In addition to the standard math functions, a variety of functions representing distributions as well as their integrals and inverses are supported and can be plotted (including Beta, binomial, Cauchy, Chi-square, exponential, F, Gamma, geometric, Laplace, logistic, normal, log-normal, Pareto, Poisson, Student's t, and Weibull distributions).

  • How do I print previously saved results?

    There are several options available for printing previously saved results:

    1. You can open each spreadsheet (and/or graph) and print it by selecting Print from the File menu (CTRL+P) as described above.

    2. You can open each spreadsheet (and/or graph), insert them into a report, and print the report. Note that with this method you can add supplementary text and comments to the analysis results.

    3. You can insert all of the spreadsheets and graphs into a workbook and print the entire workbook by selecting Print from the Workbook File menu.

  • How do I print spreadsheets?

    The simplest way to print a spreadsheet is to click the Print button on the toolbar. STATISTICA then sends the current spreadsheet to the printer specified in the Print dialog. No other intermediate option dialogs are displayed. If a block is selected in the spreadsheet, then only that block is sent to the output destination; otherwise, the entire spreadsheet is sent to the output. More options are available when you select Print from the File menu (or CTRL+P) to display the Print dialog, where you can customize various aspects of the printing.

    Automatic Reports. Note that you can keep a complete log of all spreadsheets (and/or graphs) that are displayed on the screen without having to remember to individually transfer them to the Report window or to print them. To do this, select Options from the Tools menu to display the Options dialog. Select Analyses/Graphs: Output Manager in the tree view. In the options pane, adjust the Report Output option to either Send to Multiple Reports (one for each Analysis/Graph or Single Report (common for all Analyses/Graphs). Note that this is a global option (as are all options in the Options dialog), and it will affect all analyses until the option is changed. To make changes for one particular analysis, use the Options button on the analysis or graph definition dialog.

  • How do I rename workbook items?

    Commands for renaming workbook items are available from the Workbook menu as well as from the workbook tree shortcut menu (accessibly by right-clicking in the workbook tree). You can also select a workbook item and press F2.

  • How do I review and edit variable specifications (names, formats, notes, formulas, etc.)?

    To review specifications for a single variable, double-click on a variable name in a spreadsheet to display the Variable specifications dialog ,where you can change the variable name, font format, display format, missing data value, long label, or formula for the current variable.

    spreadsheet variable properties number

    In this dialog, click the Values/Stats button to access descriptive statistics and a listing of sorted numeric values and text labels for the current variable. Click the Text Labels button to display the Text Labels Editor, where you can review and change the assignments between the text and numeric values for the current variable.

    To review specifications for all variables, click the All Specs button to display the Variable Specifications Editor, an editable, combined table of specifications of all variables in the current data file. The table format is convenient when you need to compare or edit specifications of several variables, especially when you need to paste and copy between variables. You can also access this dialog by selecting All Variable Specs from the Data menu

    spreadsheet variable specs editor

  • How do I select an object in a graph?

    To select an object in a graph, click on the object. Once an object has been selected, press the TAB key to navigate from object to object within your graph.

  • How do I select items in the workbook tree?

    You can select one or more items in the workbook tree using the standard Windows SHIFT+click and CTRL+click conventions to select ranges and discontinuous lists of variables, respectively. Additionally, you can select or deselect tree items using the keyboard navigation keys (e.g., HOME, END, PAGE UP, PAGE DOWN, and arrow keys). You can delete an entire selection by pressing the DELETE key. Pressing the INSERT key will display the Insert Workbook Item dialog for the currently selected item.

    Note that only visible items can be selected; therefore, to select the contents of a particular node, you will need to expand the node (by clicking on the plus sign adjacent to the node).

  • How do I specify whether a variable is continuous, categorical, or ordinal?

    Double-click on the variable header to display the Variable specifications dialog, where you can select the measurement type of the variable from a drop down list. Measurement types will map directly to subsequent analyses and graphs, identifying appropriate variables in each case (e.g., variables of typeCategorical will be present within the list of categorical predictors available in a Factorial ANOVA). Note that you can also define a variable as Unspecified, in which case no distinction will be made about the measurement type of the variable. You can also define a variable as Auto, in which case STATISTICA will automatically determine the measurement type of the variable based on the values of the variable.

  • How do I use copy and paste in a workbook?

    In addition to using drag-and-drop features to rearrange workbook items, you can use the Copy and Paste commands. Commands for cutting, copying, and pasting are available from the Workbook menu, the workbook tree shortcut menu, and the Standard toolbar.

  • How is the mouse used in graph applications?

    In addition to the standard Windows mouse conventions for selecting objects, the mouse can be used in many other specialized applications in the graphics window in STATISTICA. The following is a list of representative examples:

    • OLE. Links or embeds foreign document files to STATISTICA documents by dragging them directly from the desktop or Windows Explorer (across application windows) and dropping them onto STATISTICA Graphs.

    • Brushing. Highlights data points in the graph by clicking on them with the brushing tool or selecting them with a Box, Lasso, Cube, or a 2D or 3D Slice.

    • Zoom in and zoom out tools. Zooms in ("magnifies") or zooms out ("shrinks"), respectively, the selected area of the graph.

    • Drawing tools. Adds rectangles, ovals (or circles), polylines, and freehand drawings, arrows, etc. to a graph.

    • Resizing and moving. Resizes (drag on a "black selection square") or moves (drag the entire object) selected graph objects. 

    • Editing polyline objects. Reshapes individual segments of the polyline drawing by dragging on either the object area black selection squares or any of the black selection squares that mark the line segments.

    • Rotating text. You can interactively rotate custom text by selecting it in the graph and then dragging one of the object handles (small black squares) in the desired direction.

    • Controlling the mouse with the keyboard in graphs. You can also emulate the mouse with the keyboard in order to move or resize an object by selecting the object, placing the mouse pointer over the object, and then using the keyboard cursor keys to move or resize the object.

    Note that the mouse pointer will change to match the application in use. Press the ESC key to return the mouse pointer to the default mode. You can also use the mouse pointer to customize the graph.

  • How is the mouse used in other operations?

    Besides the standard Windows SHIFT+click and CTRL+click conventions, you can perform the following actions using the mouse:

    • Drag-and-drop. Provides mouse shortcuts for moving, copying, deleting, inserting, and/or extrapolating a block of values in the spreadsheet.

    user interface mouse drag

    • Increase/decrease column width. Adjusts the spreadsheet column width by dragging the right column border to the desired width. The variable header automatically expands, and the new width of the column is indicated by a dashed line.

    user interface increase decrease mouse column width

    • Split scrolling (in spreadsheets). Splits the spreadsheet (i.e., split scrolling) by dragging the split box (the small rectangle at the top of the vertical scrollbar or to the left of the horizontal scrollbar).

    user interface mouse split scroll

    • Variable speed scrolling. Controls the speed at which you scroll (1 line at a time by moving the cursor a short distance away or one page at a time by moving the cursor further away) when you extend a block outside the spreadsheet.
    • Microscrolls. Enable you to increase or decrease the value in a numeric edit field incrementally, by either the last digit (click the up microscroll, e.g., 1.11, 1.12, 1.13, ...), or the last digit by a factor of 10 (right-click the up microscroll).

    user interface microscrolls

    • Toolbar configuration. Double-click on the space between the buttons of the toolbar to undock the toolbar, allowing you to place it wherever you want. To return the toolbar to a docked setting, double-click in the title bar of the floating toolbar.
    • Reordering items in a list. You can reorder items in a list by selecting one or more items (in a continuous or discontinuous list) and then moving the cursor, which changes to a Vertical Resize, to the desired position.

    user interface reorder list

    Clicking the mouse will then move the highlighted item(s) to the insertion point.

  • How is time represented in STATISTICA Spreadsheets?

    Time values of variables are stored as (optional) decimal values representing the fraction of the day since midnight; for example, 6:00 a.m. is stored as 0.25. Time values stored in this manner can be used in subsequent analyses and transformed using arithmetic operations; at the same time, they can be displayed as times in reports or graphs (e.g., used to label scale values).

    spreadsheet variable properties

    STATISTICA formats the display of time values according to the current settings of the Windows Control Panel.

    spreadsheet regional settings

  • I want to fit a large number of variable distributions to lists of variables. How do I do this?

    Try the STATISTICA Distributions & Simulation module. It has standard (normal, half-normal, log-normal, Weibull) and specialized (Johnson, Gaussian Mixture, Generalized Pareto, Generalized Extreme Value) distributions. STATISTICA automatically ranks the quality of the fit for each selected distribution and variable.

    In addition, the distributions fit to the list of selected variables and the covariance between the selected variables can be saved for deployment. The Distributions & Simulation module uses this deployment information to generate simulated data sets that not only faithfully reproduce the respective distributions, but also the covariances between variables. In short, in addition to facilitating efficient distribution fitting to large numbers of variables, this module enables users to fit general multivariate distributions and simulate from those distributions using simulation techniques such as Latin-Hypercube.

  • I'm new to data mining. Is there a "wizard-like" feature in STATISTICA Data Miner?

    Yes. STATISTICA Data Miner Recipes (DMR) is an easy step-by-step data mining guide with a wizard-like user interface. Novice data miners can quickly clean and analyze data, while advanced users can work more efficiently and have one more option to automate routine tasks. DMR explores the data and makes default decisions for you. You can easily modify these defaults as needed and save them for repeated use.

  • In what formats can I save STATISTICA Graphs?

    STATISTICA Graphs can be saved in the following formats:

    • STATISTICA Graph files (*.stg)
    • Bitmap files (*.bmp)
    • JPEG files (*.jpeg, *.jpg)
    • Portable Network Graphics files (*.png)
    • Windows Metafiles (*.wmf)
    • Enhanced Metafiles (*.emf)
    • PDF files (*.pdf)
    • GIF files (*.gif)
    • TIFF files (*.tif)
  • Is there a way to optimize functions in STATISTICA?

    Yes. The STATISTICA General Optimization module enables you to optimize arbitrary functions of virtually any complexity, using Simplex, Genetic Algorithm, or Grid-Search methods. This module finds the best parameters that control specific processes to achieve optimal results according to user-specified criteria. The function to be optimized can be specified in a simple STATISTICA Visual Basic (SVB) function or a set of formulas. This module can repeatedly invoke other STATISTICA (or R-language) functions in an efficient manner.

  • What are case states?

    Case states are collections of additional case information that can be assigned to individual cases in a spreadsheet.

    You can assign case states in order to customize the appearance of points in graphical displays making it easy to identify influential and interesting points. A wide selection of symbols and colors is available to customize the appearance of selected points. Case states can be assigned in the spreadsheet before a graph is created, as well as interactively in the graph via the Brushing tool. Graphs and spreadsheets are fully linked, so changes made to case states in the graph will propagate back to the spreadsheet and vice versa.

  • What are cases and variables?

    STATISTICA data files are organized into cases and variables. If you are not familiar with this notation, you can think of cases as the equivalent of records in a database management program (or rows of a spreadsheet) and variables as the equivalent of fields (columns of a spreadsheet). Each case consists of a set of values of variables.

    spreadsheet results

  • What are categorized graphs?

    Categorized graphs are created by categorizing data into subsets and then displaying each of these subsets in a separate small component graph arranged in one display. For example, one graph can represent male subjects and another one female subjects, or high blood pressure females, low blood pressure females, high blood pressure males, etc.

    graph categorized graphs

    In STATISTICA, categorized graphs are:

    • Available in many output dialogs (they are automatically generated as part of output from all procedures that analyze groups or subsets of data, e.g., breakdowns, t-tests, ANOVA, discriminant function analysis, nonparametrics, and many others)

    • Accessible as part of the Graphs of Input Data options in the shortcut menus in all spreadsheets

    • Accessible from the Graphs menu where a wide variety of user-defined methods to categorize data are available

  • What are compound graphs?

    Compound graphs are those that contain other graphs. STATISTICA can automatically create compound graphs (e.g., in the Quality Control module where one display contains four different types of graphs, or when you use the Multiple Graph Auto Layout Wizard.

  • What are microscrolls?

    Numerical values in dialogs can be changed by using the microscrolls controls on text boxes. Click the microscrolls to either increment or decrement the last digit. Right-click them to either increment or decrement the next-to-last digit (e.g., clicking the up microscroll increments .15 to .16, then .17, .18, etc., right-clicking the up microscroll increments 0.15 to 0.25, then .35, .45, etc.).

  • What are the applications of STATISTICA Sequence, Association, and Link Analysis?

    STATISTICA Sequence, Association, and Link Analysis (SAL) can be applied to any data set that contains market-basket type data. The market-basket problem assumes there are many products that can be purchased by the customer. Such products can be, for example, supermarket items, different insurance plans, etc. Customers fill their basket with only a fraction of the available items. STATISTICA SAL can use this information to predict what customers will purchase and, hence, help you to boost your sales and meet the supply and demand in your business.

  • What are the different ways in which I can create graphs in STATISTICA?

    Graphs from the Graphs menu contain the most flexible graphing capabilities available in STATISTICA, offering literally thousands of different combinations of options to create the precise graphics that lead to accurate interpretation of data. These commands are also available from the STATISTICA Start button menu (the  button in the lower-left corner of the STATISTICA window).

    categories of STATISTICA graphs

    Following are the general categories of STATISTICA graphs available from the Graphs menu:

    • Menu graphs use data from the current input spreadsheet, taking into account the current case selection and weighting conditions.

    menu graph

    • User-defined graphs are templates of previously saved menu graphs. To create these, click the Add As User-defined Graph to Menu button on the Options 2 tab of any graph creation dialog.
    • Block data graphs use the currently selected (continuous) block of data in the active spreadsheet to specify input data for the graph.

    block data graph

    • Input data graphs process data directly from the current input spreadsheet and take their cues as to which variables to use from the current cursor position.

    input data graph

    Other specialized graphs related to specific analyses (e.g., ANOVA plots of means, Nonlinear Estimation plots of fitted functions, Cluster Analysis tree diagrams) are accessible directly from analysis results dialogs.

    specialized graph

    Note that all STATISTICA Graph types offer the same customization options. Also, any type of graph can be created with STATISTICA Visual Basic.

  • What are ToolTips?

    ToolTips are small "balloon help tips" that are displayed when the mouse pointer is on a toolbar button. ToolTips help you quickly learn the functions of toolbar buttons.

    You can control the display of the ToolTips for graph objects by toggling the Tool Tips on Graph Objects command on the View menu. You can toggle the display of all other types of Tool Tips on the Options tab of the Customize dialog (available by selecting Customize from the Tools menu).

  • What are workbooks?

    The STATISTICA Workbook (*.stw) is a flexible output management facility based on the powerful ActiveX technology. Technically speaking, workbooks are "ActiveX containers" that enable you to manage all STATISTICA documents (e.g., spreadsheets, graphs), as well as all other ActiveX compatible documents such as Microsoft Excel worksheets or Microsoft Word documents. Each workbook contains two panels: an Explorer-style navigation tree on the left and a document viewer on the right. The navigation tree (workbook tree) can be hierarchically split into various nodes allowing you to organize your files in logical groupings (e.g., all analysis outputs, all macros created for a project, etc.). Tabs at the bottom of the document viewer (workbook viewer) are used to easily navigate the children of the currently selected node.

    output management workbook

    Workbooks help to organize sets of output files (e.g., spreadsheets, graphs, reports, macros, non-STATISTICA files, etc.) that have been created or used (e.g., reviewed) during the analysis of a data file.

  • What drag-and-drop facilities are available?

    STATISTICA Spreadsheets support mouse pointer-controlled column width, variable-speed scrolling, split scrolling, and block extension operations.

    They also support standard (Excel-style) drag-and-drop operations such as copy, move, insert, autofill, and clear.

    • Copy. Point to the border of the selection (the mouse pointer changes to an arrow) and then drag the selection to a new location while pressing the CTRL key. Note that when you are dragging the selection, a plus sign is displayed next to the cursor to indicate you are copying the text rather than cutting/moving it (see the cursor in the illustration below).

    spreadsheet copy block

    • Move. Point to the border of the selection (the mouse pointer changes to an arrow) and then drag it to a new location. The selection will be cut from the first location, and copied to the second location.

    spreadsheet move block

    • Insert. Point to the border of the selection (the mouse pointer changes to an arrow), then drag the selection while pressing the SHIFT key. If you point between rows, an insertion bar appears between the rows, and when you release the mouse button, the block is inserted between those two rows [creating new case(s)]. If you point the cursor between columns, an insertion bar appears between the columns, and when you release the mouse button, the block is inserted between those two columns [creating new variable(s)]. Note that if you also press the CTRL key while you are dragging the selection, the block will be copied and inserted instead of cut and inserted; a plus will appear next to the arrow-cursor, as shown in the illustration below.

    spreadsheet insert block

    • Autofill (extrapolate). Point at the lower-right corner of the block displaying the Fill Handle (the small black square located on the lower-right corner of the block). When the mouse pointer changes to a plus sign, drag to the last cell(s) to which you want to extrapolate the data. Numeric values are extrapolated using linear regression; text values are extrapolated following meaningful sequences (e.g., Q1, Q2, Q3, ..., or JAN, FEB, MAR, ...).

    spreadsheet extrapolate block

    • Clear. Drag the block Fill Handle (the small black square located on the lower-right corner of the block) within the selected block. After selecting the block, use your mouse to point at the lower-right corner of the block displaying the Fill Handle. When the mouse pointer changes to a plus sign, drag within the selected block. As you are dragging, the values within the block are dimmed. When you release the left mouse button, the dimmed values are deleted.

    spreadsheet clear block

  • What graphs are available from spreadsheets?

    A variety of graphs is available from the spreadsheet shortcut menu (accessed by right-clicking in any cell or selected block of the spreadsheet). These graphs belong to two broad categories, Graphs of Block Data and Graphs of Input Data, and they produce either summary graphs from rows or columns of the currently highlighted block, or graphs as the original input data identified by the currently selected row and/or column of the spreadsheet (respectively).

    spreadsheet graphs of block data

  • What happens to graphs when the data file changes?

    All Graphs menu graphs can maintain automatic links to the data from which they were created as long as the graph specification dialog is active. Options for auto-updating graphs are available on the Options 1 tab of all graph specification dialogs. Note that if you want a graph to be dynamically updated when the data file changes, it must be placed in a stand-alone window (instead of in a workbook or report).

  • What happens when I drag data outside the range that is being pasted or dropped?

    Text labels. When you copy or move a block in the spreadsheet, the values copied to the Clipboard depend on the display mode of the spreadsheet. If the spreadsheet displays numeric values when the block is copied, only those numeric values are copied to the Clipboard. If the spreadsheet displays text labels when the block is copied, not only are the text labels copied to the Clipboard, but also the corresponding numeric values.

    spreadsheet text labels drag

    In the illustration above, text labels are assigned to numeric values that did not previously have text label equivalents.

    Display formats. When you copy or move a block in a spreadsheet, the display format for that block is also copied. This means that the display format of the copied or moved block overwrites the display format for the block into which it is copied. For example, if you copy a block of currency-formatted values and paste them into a variable that is formatted as percentage, the block remains formatted as currency even though the rest of the values in that variable are formatted as percentage.

    spreadsheet display formats drag

    In the example above, the four currency values copied from Cost are still formatted as currency even though they were pasted into the variable Percent.

  • What is a matrix spreadsheet?

    STATISTICA Matrix Spreadsheet (*.smx) is a spreadsheet file with a strictly defined format that can be used as input in several modules of STATISTICA (e.g., Cluster AnalysisMultidimensional Scaling, and SEPATH). Matrix spreadsheets have to meet the following conditions:

    1. The number of cases (rows) = the number of variables (columns) + 4.

    2. The matrix must be a square matrix and the case names should be the same as the variable names.

    3. The last four cases contain the following case names and information:

    • Means: The mean of each variable is given in this row; this case can be left empty (i.e., do not enter anything in this row) for Similarities and Dissimilarities matrices.

    • Std.Dev.: The standard deviation of each variable is given in this row; this case can be left empty (i.e., do not enter anything in this row) for Similarities and Dissimilarities matrices.

    • No.Cases: This required entry is the number of cases from which the matrix was produced, not the number of cases (rows of data) in this matrix file.

    • Matrix: This required entry represents the type of matrix file; 1 = Correlation, 2 = Similarities, 3 = Dissimilarities, and 4 = Covariance.

  • What is the difference between Rich Text Format (.RTF) and STATISTICA Report (.STR) format?

    RTF (Rich Text Format) is a Microsoft standard method of encoding formatted text and graphics for easy transfer between applications. When reports are saved in Rich Text Format (*.rtf), all file formatting is preserved so that it can be read and interpreted by other RTF-compatible applications (e.g., Microsoft Word).

    The STATISTICA Report format (.str) adheres to RTF conventions; however, saving reports in the default STATISTICA Report format (*.str) ensures that reports will be opened in STATISTICA, giving you complete access to the report tree. In order to open the report in an RTF-compatible application, select Save Asfrom the File menu to save the report as an RTF file. You can then open it in any RTF-compatible application.

  • What is the difference between the file header and a customized header?

    The file header is located immediately above the variable headers at the top of the spreadsheet window. You can use this header to include a summary title or other identification of the data file (or results). Double-click in the header area to edit/enter information.

    A customized header is used when printing spreadsheets (or other STATISTICA documents, e.g., reports, graphs, etc.). This header can include a title, page numbers, time of printing, date, the name of the file, and any custom text you want to include. To create a header, select Header/Footer from the View menu.

    Note that while the file header is associated only with spreadsheets, any printed STATISTICA document can have a customized header.

  • What is the Multiple Graph AutoLayout Wizard?

    The Multiple Graph Auto Layout Wizard can be accessed from the Graphs - Multiple Graph Layouts submenu. The Multiple Graph Auto Layout Wizard assists you in selecting and arranging graphs to be placed on the same page.

    Graphs can be selected from all currently open STATISTICA Graph windows (in all currently open STATISTICA modules) or from graph files previously saved to disk; blank graphs (to be filled or replaced later) can also be used.

  • What is the purpose of a Gage Linearity and Bias Study?

    A Gage Linearity and Bias Study answers the questions "How biased is my gage when compared to a master value?" and "Does the accuracy of my gage change when the size of the parts being measured changes?" These are called Bias and Linearity, respectively.

  • What output management options are available in STATISTICA?

    You can customize the way in which the output is managed in STATISTICA. When you perform an analysis, STATISTICA generates output in the form of spreadsheets and graphs. There are five basic channels to which you can direct all output: workbooks, stand-alone windows, reports, Microsoft Word, and the Web.

    The first four output channels are controlled by the options in the Output Manager (accessible by selecting Output Manager from the File menu, or by selecting Options from the Tools menu to display the Options dialog and selecting Output Manager in the tree view). There are a number of ways to output to the Web, depending on the version of STATISTICA you have. These output channels can be used in many combinations (e.g., a workbook and report simultaneously), and each of the output channels can be customized and organized in a variety of ways.

  • What supplementary information is available with analyses and how can I add it to my reports?

    STATISTICA provides a variety of supplementary information that can be included with graphs or spreadsheets from specific analyses when they are sent to a report. You can specify in the Analyses/Graphs: Output Manager options pane of the Options dialog (select Options from the Tools menu) how much information to include.

    Displaying supplementary information. In the Supplementary detail box, you can select None or any of the commands described below:

    • Brief. Select Brief, the most "economical" output style, to include only the contents of the selected spreadsheets (i.e., no information about the variables or conditions specified for the analyses will be output).

    • Medium. Select the Medium output style to include the contents of the selected spreadsheets as well as the current datafile name, information on Case Selection Conditions and Case Weights (if any were specified), the Output Header, a list of all variables selected for each analysis, and the missing data values for each variable.

    • Long. Select the Long output style (which is more space consuming) to include all information from the Medium format and, additionally, the long variable names (e.g., labels, formulas), reserving one line of output (or more) for each variable.

    • Comprehensive. Select the Comprehensive output style to provide the most comprehensive information on each variable selected for analysis. In addition to all information included in the Long format, it also includes a complete list for each selected variable of all its values that have text label descriptions.

  • When I try to update my license file, nothing happens.

    It is recommended when receiving a new license file to save it to your desktop as “stat.lic.” At that point, the new license file can be applied by clicking Update License File, browsing to the desktop, and applying the license file. If you have Microsoft Windows Vista or Windows 7, you may need to elevate the default level of permissions of STATISTICA by right-clicking on the STATISTICA icon, choosing Run as administrator from the shortcut menu, and then applying the license file.

  • Why do you need different variable types?

    The difference between text and numeric types is straightforward; however, the main reason for having three types of numeric values is the storage efficiency. For most data files, that is not important and, thus, using the default (Double) data type is recommended. However, for very large data files, being able to switch to a 2 (or even 8) times more efficient storage (by using different data types) could make a difference between being able to perform the necessary analysis on a specific computer system.