Exporting to Excel spreadsheets
When working in Freq it is possible to export the results to Microsoft Excel
spreadsheets.
To export the results, select the attributes of interest and issue the
Export command available in the main toolbar or the
menu.
The Export command creates an Excel document with two spreadsheets: Summary
and Details. The Summary spreadsheet
contains the following information:
-
basic information about the data table: table name, number of rows,
number of attributes, number of exported (shown) attributes, and
target attribute (if defined);
-
basic attribute information: number of missing values, number of
distinct values, modal (most frequent) value, and modal count;
-
attribute statistics: Value set
statistics (Min and max value, median, 1st and 3rd quartile),
mean,
variance,
standard deviation,
skewness, and
kurtosis.
-
WHERE statements, if any filters have been applied.
The Details spreadsheet contains the following elements:
-
levels break-down tables for all of the selected attributes,
including target information, if target has been defined;
-
histogram with the target line, if target has been defined;
-
table of attribute statistics, if the attribute has been set
to Statistics
mode.
The information exported to the spreadsheet reflects the settings applied
to the attribute by the user: