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 > Numeric, 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