A table is a statistical representation of data for a future or commodity over a specified period of time. You can create a table of the Worksheet data you entered in the Configuration window. To table this Worksheet data, select View>Table from the MIMIC menu bar, or select the Table button from the toolbar. MIMIC displays the table in the Table window.

To return to the Configuration window, select the Configuration button from the toolbar.

A table contains a Dates column and then a column of data for each symbol. For example, row 'A' from the Worksheet is the first column of data, row 'B' the second column of data, and so on. A table contains data for the dates indicated in the Date Options pane. At the bottom of a table, MIMIC displays table summary statistics.

In a table, there are certain options, features and settings you can make. These settings can apply to the following:

The options and settings for the current table are set in the Worksheet Options pane. To select options and settings for all future tables, select Options>User Preferences from the menu bar, and then select the Table tab.

For more information on the Table tab, see the section called “Table Tab” in this guide.

To print a table, select File>Print from the MIMIC menu bar, or select the Print button from the toolbar.

Table Options Pane

For a current or active table, you can show summary stats, sort dates ascending, and show dates as columns. By default, the Show Summary Stats option is selected. To activate the other options, click the appropriate check box.

MIMIC includes the following table options in the Table Options pane:

Option	Function/Description
Show Summary Stats	When checked, includes the summary statistics at the bottom of the table results. Summary statistics includes the sum, average, percentages, and standard deviation.
Sort Dates Ascending	When checked, sorts the table data by the oldest date first.
Show Dates As Columns	When checked, table results are landscaped and are formatted so that the column="dates for the values" and the rows="values for a relation".

You can also include seasonal analysis information in your table. For more information on Seasonal Analysis, see the section called “Seasonal Analysis ” in this guide.

Table Summary Statistics

MIMIC includes the following table summary statistics:

Table Statistic	Description
Sum	Indicates the sum total of the values returned in the answers.
Average	Indicates the average of the data for a column.
Average (+)	Indicates the average of all the values in the answers.
Average (-)	Indicates the average of the negative answers to the query.
Percent (+)	Percent positive. Indicates the number, as a percentage of the total number of occurrences, of positive answers to the query
Percent (-)	Percent negative. Indicates the number, as a percentage of the total number of occurrences, of negative answers to the query.
Maximum	Indicates the maximum of all the query answers.
Minimum	Indicates the minimum of all the query answers.
Std Deviation	Measures the mean deviation from the average of the answers. This can be a particularly valuable tool to interpret the answers to the query. For example, if the average return on a query is 3%, but the Standard Deviation on that is 10%, then it indicates a poor signal. It is best to have a standard deviation that is lower than the absolute value of the average value returned in the query.
Zstat	Indicates the Z-score of the results. This measures the goodness of the average.
Variance	This is related to the standard deviation calculation, which is actually the square root of the variance.
Last	Repeats the last value of the column data.

MIMIC does not sort table summary statistics.

Sorting Table Data

By default, MIMIC sorts table data in ascending order, with the oldest date first and the most recent date last. You can easily sort any column in ascending or descending order by clicking on any column heading. MIMIC displays an up-arrow symbol in the column heading you clicked to indicate ascending order, and displays a down-arrow symbol in the column heading you clicked to indicate descending order:

Once you exit the Table window, MIMIC clears your sort order.

Show Dates as Columns

In the Table Options pane, check the check box for Show Dates As Columns and select the Execute Table button. The table results are landscaped and are formatted so that the columns="dates for the values" and the rows="values for a relation".

Usually the columns="values for a relation" and the rows="dates for the values".