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 Index Investing

    If you believe the market smiles on those who focus on value, growth or income, this vehicle may be for you.
  2. Investing Basics

    Regression Basics For Business Analysis

    This tool is easy to use and can provide valuable information on financial analysis and forecasting. Find out how.
  3. Investing Basics

    How To Create A Modern Fixed-Income Portfolio

    Exposure to different asset classes is required to generate income, reduce risk and beat inflation. Find out how bonds can help.
  4. Options & Futures

    Calculating The Equity Risk Premium

    See the model in action with real data and evaluate whether its assumptions are valid.
  5. Professionals

    Style Matters In Financial Modeling

    If you're looking to get a job as an analyst, you'll need to know how to work it.
  6. Technical Indicators

    What is the Ease Of Movement Indicator formula and how is it calculated?

    Read about and learn how to calculate the Ease of Movement indicator, created by Richard W. Arms Jr., to help measure the relationship between price and volume.
  7. Technical Indicators

    What is the Exponential Moving Average (EMA) formula and how is the EMA calculated?

    Learn the formula for calculating both simple moving averages and exponential moving averages, indicators that are frequently used by traders and analysts.
  8. Technical Indicators

    What is the Double Exponential Moving Average (DEMA) formula and how is it calculated?

    Discover the equation for double exponential moving average, or DEMA, and learn how it is calculated for a better understanding of how it works.
  9. Technical Indicators

    What is the On-Balance Volume (OBV) formula and how is it calculated?

    Read about the formula and calculation for On Balance Volume, or OBV, which is a technical indicator that shows movements in trading volume.
  10. Trading Strategies

    What is the McGinley Dynamic Indicator formula and how is it calculated?

    Discover the McGinley dynamic indicator, which is designed to resolve issues based on the subjective placement and static data of moving averages.

You May Also Like

Hot Definitions
  1. Risk-Free Rate Of Return

    The theoretical rate of return of an investment with zero risk. The risk-free rate represents the interest an investor would ...
  2. Scarcity

    The basic economic problem that arises because people have unlimited wants but resources are limited. Because of scarcity, ...
  3. Trust Fund

    A trust fund is a fund comprised of a variety of assets intended to provide benefits to an individual or organization. The ...
  4. Christmas Tree

    An options trading strategy that is generally achieved by purchasing one call option and selling two other call options at ...
  5. Christmas Club

    A short-term savings account that usually pays out the full account balance to its account holders once each year, right ...
  6. Boston Snow Indicator

    A market theory that states that a white Christmas in Boston will result in rising stock prices for the following year. For ...
Trading Center