Aggregate Function

Posted in Finance, Accounting and Economics Terms, Total Reads: 482
Advertisements

Definition: Aggregate Function

An aggregate function is a mathematical computation comprising a set of values or numbers. Aggregate functions are used profoundly in spreadsheets and databases including financial calculations. It transforms a set of values to a single value such as mean or summation of a set of numbers.


The revolution of computers has allowed aggregate functions to produce results quickly even on a large set of data. The outputs of aggregate functions are essential in various financial calculations.


Examples of aggregate function include

average() : It returns the mean or average of the values provided

sum() : It returns summation of the values provided

 

Advertisements



Looking for Similar Definitions & Concepts, Search Business Concepts


Similar Definitions from same Category: