STATISTICA Blogs

Many procedures in STATISTICA automatically mark specific cells or blocks of cells in spreadsheets in order to "highlight" results (e.g., unusually high frequencies in a frequency table, statistically significant correlation coefficients in a correlation matrix, or statistically significant effects in an ANOVA table of all effects). In the following spreadsheet, notice that the correlations between Height (in) and Weight (lb) and between Weight (lb) and Age (yr) are shown in red, indicating significance at p<.05.

 

The default spreadsheet layout for marked cells in STATISTICA uses a red font with a white background. There are options on the Tools tab to edit the format of the marked cells in your spreadsheet. On the Tools tab, click Marked Cells. The drop-down menu contains commands to display marked cells, mark/unmark specific cells, and edit the Marked Cells layout.

 

You can also access these commands by right-clicking on a cell or block of cells in the spreadsheet and selecting Marking Cells from the shortcut menu.

Display. This command controls whether marked cells are displayed in the spreadsheet and is selected by default. Turning off the display will unmark all previously marked cells in a spreadsheet:
 


Edit Marked Cells Layout. Select this command to display the Edit Spreadsheet Layout dialog, which contains options to edit the Marked Cells spreadsheet layout.

 

Select the format that you want to edit, and click the Edit button. The Edit Format dialog is displayed, where you can specify the customizations you want for marking cells in the spreadsheet. Suppose you want cells marked with a bold blue font and yellow background color. Select these options on the Font tab (note that there are also options for formatting numbers, aligning text, and adding borders to the spreadsheet).

Click OK to return to the Edit Spreadsheet Layout dialog where you can view how the marked cells will now be displayed. Click OK in this dialog to apply the new format to any marked cells (the Display command needs to be turned on to see the new format).

 

Edit Printed Marked Cells Layout. This command will display the Edit Spreadsheet Layout dialog, which contains options to edit how the Marked Cells spreadsheet layout is printed. The printed layout can be different than the displayed layout. For example, the default spreadsheet layout for printed marked cells in STATISTICA uses a red italicized font with a white background color, while the default layout for displayed marked cells did not have the font italicized. This can be confirmed looking at a Print Preview of the spreadsheet and seeing how the marked cells will be printed.

Mark/Unmark Selected Cells. These commands can be used to mark cells in a spreadsheet that are not already marked or unmark cells that are marked. You can mark/unmark a single cell or a highlighted block of cells. For example, in our correlation matrix, highlight both correlation cells for Height (in) and Age (yr) (select one of the cells, press the CTRL key on your keyboard, and select the other cell).

 

From the Marked Cells drop-down list, click Mark Selected Cells.

 

You can also highlight marked cells and select Unmark Selected Cells to unmark them.

Redefine Selected Cells. This command will replace the current set of marked cells with the selected cells in the spreadsheet. That is, the Marked Cells spreadsheet layout will be applied to the selected cells AND removed from all unselected cells in the spreadsheet. For example, highlight the diagonal entries (the cells with a value of ‘1’) in the correlation matrix.

 

From the Marked Cells drop-down list, select Redefine Selected Cells. The diagonal entries will now be marked and the previously marked cells are now unmarked.

 

Unmark All. This command will unmark all of the cells in the spreadsheet (i.e., the Marked Cells spreadsheet layout is removed from all cells). This differs from the Display option being turned off in that the Display option toggles the marked cells on and off, whereas Unmark All completely removes marked cells, and cells would need to be marked again to have them displayed in the marked format.