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. Standard Deviation

    1. A measure of the dispersion of a set of data from its mean. ...
  4. Arithmetic Mean

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

    The simple mathematical average of a set of two or more numbers. ...
  6. Compound Annual Growth Rate - CAGR

    The year-over-year growth rate of an investment over a specified ...
RELATED FAQS
  1. No results found.
Related Articles
  1. 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. Investing

    How to Use Stratified Random Sampling

    Stratified random sampling is a technique best used with a sample population easily broken into distinct subgroups. Samples are then taken from each subgroup based on the ratio of the subgroup’s ...
  7. Fundamental Analysis

    Lognormal and Normal Distribution

    When and why do you use lognormal distribution or normal distribution for analyzing securities? Lognormal for stocks, normal for portfolio returns.
  8. Investing Basics

    Using Normal Distribution Formula To Optimize Your Portfolio

    Normal or bell curve distribution can be used in portfolio theory to help portfolio managers maximize return and minimize risk.
  9. Technical Indicators

    The Normal Distribution Table, Explained

    The normal distribution formula is based on two simple parameters - mean and standard deviation
  10. Economics

    Can Investors Trust Official Statistics?

    The official statistics in some countries need to be taken with a grain of salt. Find out why you should be skeptical.

You May Also Like

Hot Definitions
  1. Gordon Growth Model

    A model for determining the intrinsic value of a stock, based on a future series of dividends that grow at a constant rate. ...
  2. Cost Accounting

    A type of accounting process that aims to capture a company's costs of production by assessing the input costs of each step ...
  3. Law Of Supply

    A microeconomic law stating that, all other factors being equal, as the price of a good or service increases, the quantity ...
  4. Investment Grade

    A rating that indicates that a municipal or corporate bond has a relatively low risk of default. Bond rating firms, such ...
  5. Fringe Benefits

    A collection of various benefits provided by an employer, which are exempt from taxation as long as certain conditions are ...
  6. Irrevocable Trust

    A trust that can't be modified or terminated without the permission of the beneficiary. The grantor, having transferred assets ...
Trading Center