Compute Summary StatisticsΒΆ

Colectica can generate descriptive statistics and store this summary information directly in the open standards-based metadata. Supported statistics include:

  • Total row count

  • Valid

  • Invalid

  • Category frequencies

  • Mean

  • Minimum

  • Maximum

  • Standard deviation

  • Variance

  • Skewness

  • Kurtosis

Optionally, the following statistics can also be calculated. These statistics may take more time and require more memory for larger datasets.

  • Median

  • Quartiles

To calculate summary statistics for your dataset, follow these steps.

  1. Navigate to a dataset.

    ../../../../_images/browse-data.png

  2. On the ribbon, click Calculate Summary Statistics.

    ../../../../_images/calculate-summary-statistics-button.png

  3. If appropriate, select whether to calculate unweighted and/or weighted statistics.

  4. Colectica will automatically calculate summary statistics for each variable in your dataset.

  5. When complete, select a variable to view its summary statistics in the details pane.

    ../../../../_images/calculate-summary-statistics-done.png

Note

SAS can optionally keep deleted rows in a sas7bdat file. Rows that are marked deleted are imported by the import command when creating summary statistics.