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. Introduction To Fundamentally Weighted ...
    Mutual Funds & ETFs

    Introduction To Fundamentally Weighted ...

  2. Regression Basics For Business Analysis
    Investing Basics

    Regression Basics For Business Analysis

  3. How To Create A Modern Fixed-Income ...
    Investing Basics

    How To Create A Modern Fixed-Income ...

  4. Calculating The Equity Risk Premium
    Options & Futures

    Calculating The Equity Risk Premium

comments powered by Disqus
Hot Definitions
  1. Due Diligence - DD

    1. An investigation or audit of a potential investment. Due diligence serves to confirm all material facts in regards to ...
  2. Certificate Of Deposit - CD

    A savings certificate entitling the bearer to receive interest. A CD bears a maturity date, a specified fixed interest rate ...
  3. Days Sales Of Inventory - DSI

    A financial measure of a company's performance that gives investors an idea of how long it takes a company to turn its inventory ...
  4. Accounts Payable - AP

    An accounting entry that represents an entity's obligation to pay off a short-term debt to its creditors. The accounts payable ...
  5. Ratio Analysis

    Quantitative analysis of information contained in a company’s financial statements. Ratio analysis is based on line items ...
  6. Days Payable Outstanding - DPO

    A company's average payable period. Calculated as: ending accounts payable / (cost of sales/number of days).
Trading Center