STATISTICA Blogs

To designate a spreadsheet (e.g., the results from an analysis) as an input spreadsheet, select the spreadsheet (i.e., ensure the spreadsheet has the focus) and select Input spreadsheet from the Data menu (classic menus), or select the Data tab and in the Mode group, select the Input check box (ribbon bar). Now you can specify an analysis, and STATISTICA uses the selected spreadsheet as the input spreadsheet. Note that you can switch 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 below.

sb