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. Mean

    The simple mathematical average of a set of two or more numbers. ...
  5. Arithmetic Mean

    A mathematical representation of the typical value of a series ...
  6. Altman Z-Score

    The output of a credit-strength test that gauges a publicly traded ...
RELATED FAQS
  1. What is the prime cost formula?

    The term "prime cost" refers to the direct costs of manufacturing an item. It is calculated by adding the cost of raw materials ... Read Full Answer >>
  2. What is a "linear" exposure in Value at Risk (VaR) calculation?

    A linear exposure in the value-at-risk, or VaR, calculation is represented by positions in stocks, bonds, commodities or ... Read Full Answer >>
  3. How can I create a yield curve in Excel?

    You can create a yield curve in Microsoft Excel if you are given the time to maturities of bonds and their respective yields ... Read Full Answer >>
  4. How do I calculate my effective tax rate using Excel?

    Your effective tax rate can be calculated using Microsoft Excel through a few standard functions and an accurate breakdown ... Read Full Answer >>
  5. What is the criteria for a simple random sample?

    Simple random sampling is the most basic form of sampling and can be a component of more precise, more complex sampling methods. ... Read Full Answer >>
  6. How do I perform a financial analysis using Excel?

    Investors can use Excel to run technical calculations or produce fundamental accounting ratios. Corporations use Excel to ... Read Full Answer >>
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

    The Strong Dollar’s (Real) Toll On Tech Stocks

    A large portion of U.S. technology companies’ sales occur overseas, given the strong international business and consumer demand from many U.S. tech firms.
  7. Fundamental Analysis

    How to Calculate a Coverage Ratio

    In broad terms, the higher the coverage ratio, the better the ability of the enterprise to fulfill its obligations to its lenders.
  8. Fundamental Analysis

    Calculating the Herfindahl-Hirschman Index (HHI)

    The Herfindhal-Hirschman Index, (HHI) is a measure of market concentration and competition among market participants.
  9. Fundamental Analysis

    Calculating Net Interest Margin

    Net interest margin is a metric used to measure the effectiveness of a company’s investment decisions, particularly financial institutions.
  10. Economics

    Why The U.S. Economy Is Ready For Liftoff

    Though the U.S. economy is once again underperforming expectations, as it has for the past five years, the economy is ready for a (Fed) interest rate hike.

You May Also Like

Hot Definitions
  1. Mixed Economic System

    An economic system that features characteristics of both capitalism and socialism.
  2. Net Worth

    The amount by which assets exceed liabilities. Net worth is a concept applicable to individuals and businesses as a key measure ...
  3. Stop-Loss Order

    An order placed with a broker to sell a security when it reaches a certain price. A stop-loss order is designed to limit ...
  4. Covered Call

    An options strategy whereby an investor holds a long position in an asset and writes (sells) call options on that same asset ...
  5. Butterfly Spread

    A neutral option strategy combining bull and bear spreads. Butterfly spreads use four option contracts with the same expiration ...
  6. Unlevered Beta

    A type of metric that compares the risk of an unlevered company to the risk of the market. The unlevered beta is the beta ...
Trading Center