EventStats Quick Start

A quick introduction to importing and analysing a CSV file in EventStats.

Importing a CSV Data File

Note: Source CSV files must have less than 256 columns

Click the Import CSV... button which opens the Import CSV File wizard

Click the Open CSV File button and select your data file. EventStats will analyse the first 200 rows and present you with the column structure and a sample of the data file. Pay no attention to date fields interpreted as a string field, conversions will take place during the analysis

You must now modify the Column Definitions to tell EventStats where the data is:

• Record Key: this is the field that uniquely defines every record in the data file.
  • Enter a Y in the Is Key column on the appropriate row.
• Group Name: enter a name that will identify that this column is to be used for your analysis groups or for data filtering.
  • Enter the name directly in the Group column
  • You can specify as many groups as you want
  • The name can be the same as the column name.
  • You must use a different name for each Group column
  • Enter a value here even if you only want to filter by that column
• Date index: enter a numerical value to identify this field as a date field in the Date index column.
  • Odd numbers are start dates, even numbers are end dates.
  • Pair dates together by using consecutive numbers, i.e. 1&2,3&4,5&6 and so on. e.g. If Admission Date is date index: 1, Discharge Date is then naturally date index 2.
  • Multiple pairs of dates can be specified - you can choose which to analyse in the next step.
  • To specify a single date field, just give it the next available odd number & do not allocate the even number to any field.

Only fields that have a group name, a date index or the key field will be imported

Example configuration:

Note: Click on the Field Name or Data Type cells to open a window where you can change the field name, data type and all the other properties listed above.

Finally click the OK button to actually import the CSV file.

Running Analysis

With the data file loaded, you can now filter your data, and specify your analysis parameters.

• Use the column headers in the CSV Source Data grid to filter the source data. Only visible records will be included in the analysis.

In the Analyse Data section:

• Select the From and To dates to analyse a limited range of records. This is highly recommended to prevent extensive processing times
• Pick your chosen interval from the list. Day is the most common choice.
• Choose the date fields to analyse in the Date range field. You will see the date fields you specified during the import process.
• Select the grouping and sub-grouping levels you require. You will be able to view results for all groups or by sub-group values within the group values. (More info in the results section)

Press Run Analysis to process the file and show the first set of results.

Always check the Exception Report to see which source records were excluded from the analysis. Some of the issues encountered in the exception report can be overcome by the analysis settings (more info needed)

The Results

Results Chart

As the screen shot above shows, the chart contains the results line, but also the bivariate regression (best fit) line, the mean, sample standard deviation and margin of error data.