Exporting Data to SPSS

SPSS supports file formats that are also available in AcqKnowledge –  Excel and text file.  For unusual circumstances when all of the data are to be imported to SPSS, “File > Save As…” can be used in AcqKnowledge to export data to a non-native format.  Use the “Save as type” pulldown menu to convert to an alternate format.  For larger files, it may be necessary to use text instead of spreadsheet as AcqKnowledge is limited to writing older Excel formats and cannot create spreadsheets with more than 65535 rows.  The number of rows is equal to the number of sample points in each channel, so if data are acquired at 1000 samples per second, AcqKnowledge-generated spreadsheets will only contain slightly more than a minute’s worth of data.

Many of AcqKnowledge‘s automated analysis routines send the results to the Journal or an Excel file. The Excel option is selected in the Preferences dialog for the analysis routine.

The Find Cycle detector can also paste measurement results into a spreadsheet file. The Excel option is accessed under the Output tab in the main Find Cycle dialog box.

Information about the import features of SPSS can be found here.

Export to SPSS for additonal statistics and data mining.