Aggregate Function

AAA

DEFINITION of 'Aggregate Function'

A mathematical computation involving a set of values rather than a single value. Aggregate functions are often used in databases and spreadsheets, and include the mean or sum of a set of numbers. The calculation performed by an aggregate function returns a single value from multiple values.

INVESTOPEDIA EXPLAINS 'Aggregate Function'

The use of computers has revolutionized the way that calculations are performed, allowing aggregate functions to produce results very quickly. In addition, aggregate functions can handle ever larger and more complex data sets, which has allowed the construction of aggregate supply and demand functions.

RELATED TERMS
  1. Moving Average - MA

    A widely used indicator in technical analysis that helps smooth ...
  2. Variance

    The spread between numbers in a data set, measuring Variance ...
  3. Arithmetic Mean

    A mathematical representation of the typical value of a series ...
  4. Mean

    The simple mathematical average of a set of two or more numbers. ...
  5. Standard Deviation

    1. A measure of the dispersion of a set of data from its mean. ...
  6. Compound Annual Growth Rate - CAGR

    The year-over-year growth rate of an investment over a specified ...
Related Articles
  1. thinkstock|istock
    Mutual Funds & ETFs

    Introduction To Fundamentally Weighted ...

  2. Investing Basics

    Regression Basics For Business Analysis

  3. Investing Basics

    How To Create A Modern Fixed-Income ...

  4. Options & Futures

    Calculating The Equity Risk Premium

Hot Definitions
  1. Turkey

    Slang for an investment that yields disappointing results or turns out worse than expected. Failed business deals, securities ...
  2. Conduit Issuer

    An organization, usually a government agency, that issues municipal securities to raise capital for revenue-generating projects ...
  3. Financing Entity

    The party in a financing arrangement that provides money, property, or another asset to an intermediate entity or financed ...
  4. Hyperinflation

    Extremely rapid or out of control inflation. There is no precise numerical definition to hyperinflation. Hyperinflation is ...
  5. Gross Rate Of Return

    The total rate of return on an investment before the deduction of any fees or expenses. The gross rate of return is quoted ...
  6. Debit Spread

    Two options with different market prices that an investor trades on the same underlying security. The higher priced option ...
Trading Center