Methods and formulas for Tally

Select the method or formula of your choice.

Counts

Count is the number of times each unique value occurs.

Cumulative counts (CumCt)

A cumulative count is the cumulative total of all the counts up to that unique value. For example, suppose your data are as follows: 1, 2, 1, 1, 3, 3, 1, 1, 3, 3. The cumulative count of Values 1 and Values 2 is 6, and the cumulative count of all three values is 10.

Unique value Count Cumulative count
1 5 5
2 1 5 + 1 = 6
3 4 5 + 1 + 4 = 10

Cumulative percents (CumPct)

Minitab calculates the cumulative percentage for each unique value.

Formula

For example, the cumulative percentage of Values 1 and Values 2 is 60%, and the cumulative percentage of all three values is 100%.

Unique value Count Cumulative percent
1 5 100 * 5/10 = 50%
2 1 100 * (5 + 1) / 10 = 60%
3 4 100 * (5 + 1 + 4) / 10 = 100%

Percents

Formula

For example, the percentage of Value 1 is 50%.

Unique value Count Percent
1 5 100 * 5/10 = 50%
2 1 100 * 1/10 = 10%
3 4 100 * 4/10 = 40%
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy