Partial sums function

To use this function, choose Calc > Calculator.

Calculates the running total for the numbers in a column by storing the sum of the first i rows of the input column in the ith row of another column.

Syntax

PARS (number)

For number, specify the input column.

Example

A sales manager records monthly sales and wants to know when the total annual sales are greater than or equal to the goal of \$1.5 million. The manager enters the expression PARS(C2) and stores the results in C3.

C1-D C2 C3
Month Sales Total
January \$139,300 \$139,300
February \$158,200 \$297,500
March \$168,800 \$466,300
April \$193,000 \$659,300
May \$201,900 \$861,200
June \$179,000 \$1,040,200
July \$197,000 \$1,237,200
August \$188,000 \$1,425,200
September \$209,500 \$1,634,700
October \$213,700 \$1,848,400
November \$185,700 \$2,034,100
December \$200,300 \$2,234,400

Based on the partial sums in C3, the sales manager sees that total annual sales was greater than \$1.5 million in September.

Tip

To have Minitab display the currency symbol and the commas in C3 after using the Calculator, click a cell in the column to activate it. Right-click and choose Format Column, then choose Currency and click OK.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy