Choose test

Choose one of two tests:

•A one-sample t test compares the mean of a single column of numbers against a hypothetical mean that you provide. It assumes the values were sampled from a Gaussian distribution.

•The nonparametric Wilcoxon signed rank test compares the median of a single column of numbers against a hypothetical median. Don't confuse it with the Wilcoxon matched pairs test which compares two paired or matched groups.

Hypothetical value

Enter the hypothetical value to which you wish to compare the mean (t test) or median (Wilcoxon test). This value is often 0, or 100 (when values are percentages), or 1.0 (when values are ratios).

With the Wilcoxon test, you also need to specify what to do when a data value exactly equals the hypothetical values. Understand the two choices.