Home / Statistical Tools / Analysis Tools / Summarystats / Options
Options¶
The Options tab in the Summary Statistics dialog lets you choose which statistics, confidence intervals, normality tests, percentiles, and charts to include in the output. All statistics are enabled by default.
General Statistics¶
These checkboxes control which descriptive statistics appear in the output table. All are enabled by default.
Count¶
The number of observations. When using a frequency column, this is the sum of all frequencies (the expanded N), not the number of rows.
Sum¶
The total of all values in the column.
Mean¶
The arithmetic average of all values.
Median¶
The middle value when all observations are sorted (50th percentile).
Mode¶
The most frequently occurring value. If multiple values share the highest frequency, all are reported (multimodal).
Min¶
The smallest value in the dataset.
Max¶
The largest value in the dataset.
Skewness¶
A measure of distribution asymmetry. Values near zero indicate a symmetric distribution. Positive values indicate a right-skewed distribution (tail extends to the right). Negative values indicate a left-skewed distribution.
Kurtosis¶
A measure of distribution tailedness. Higher values indicate heavier tails and a sharper peak compared to a normal distribution.
Standard Deviation (Population)¶
The population standard deviation, calculated using N in the denominator. Use this when your data represents the entire population.
Standard Deviation (Sample)¶
The sample standard deviation, calculated using N-1 in the denominator. Use this when your data is a sample from a larger population. Requires at least 2 observations.
Variance (Population)¶
The square of the population standard deviation.
Variance (Sample)¶
The square of the sample standard deviation. Requires at least 2 observations.
Confidence Intervals for Mean¶
Confidence intervals provide a range within which the true population mean is likely to fall at a given confidence level.
90% CI for Mean¶
Displays lower and upper bounds for a 90% confidence interval around the mean.
95% CI for Mean¶
Displays lower and upper bounds for a 95% confidence interval around the mean. This is the most commonly used confidence level.
99% CI for Mean¶
Displays lower and upper bounds for a 99% confidence interval around the mean.
Custom CI for Mean¶
Enter a custom confidence level as a decimal between 0 and 1 (e.g., 0.975 for a 97.5% confidence interval). Displays lower and upper bounds at the specified level.
Confidence Intervals for Standard Deviation¶
Confidence intervals provide a range within which the true population standard deviation is likely to fall.
90% CI for Sigma¶
Displays lower and upper bounds for a 90% confidence interval around the standard deviation.
95% CI for Sigma¶
Displays lower and upper bounds for a 95% confidence interval around the standard deviation.
99% CI for Sigma¶
Displays lower and upper bounds for a 99% confidence interval around the standard deviation.
Custom CI for Sigma¶
Enter a custom confidence level as a decimal between 0 and 1. Displays lower and upper bounds at the specified level.
Test for Normality¶
Tests whether your data follows a normal distribution. Select one test or None to skip normality testing. The test statistic and p-value are displayed in the output table. A small p-value (typically < 0.05) suggests the data does not follow a normal distribution.
| Test | Description |
|---|---|
| Anderson-Darling | Emphasizes the tails of the distribution. Reports the A² statistic and p-value. This is the default test. |
| Shapiro-Wilk | Best for small to moderate sample sizes. Reports the W statistic and p-value. |
| Kolmogorov-Smirnov | Uses Lilliefors correction. Reports the D statistic and p-value. P-values are bounded between 0.001 and 0.20. |
| None | Skip normality testing. |
Percentiles¶
Standard Percentiles¶
Six common percentiles available as checkboxes:
- 1st Percentile
- 5th Percentile
- 10th Percentile
- 90th Percentile
- 95th Percentile
- 99th Percentile
Custom Percentiles¶
Up to four custom percentiles. Enter each as a decimal between 0 and 1 (e.g., 0.25 for the 25th percentile, 0.75 for the 75th percentile).
Charts¶
Show Box Plot¶
When checked, displays a box plot alongside the statistics table. The box plot shows the median, quartiles, whiskers, and any outliers for each data column.
Show Dot Plot¶
When checked, displays a dot plot alongside the statistics table. The dot plot shows individual data points, making it easy to see clusters, gaps, and distribution shape.