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. How do I use the rule of 72 to estimate compounding periods?

    The rule of 72 is best used to estimate compounding periods that are factors of two (2, 4, 12, 200 and so on). This is because ... Read Full Answer >>
  2. How can I use Bollinger Bands® to spot options trading opportunities?

    Traders can use Bollinger Bands in a couple of different types of trading strategies. The most common strategy is using Bollinger ... Read Full Answer >>
  3. How can I run linear and multiple regressions in Excel?

    The first step in running regression analysis in Excel is verifying that your software has the capabilities to perform the ... Read Full Answer >>
  4. How do I calculate the rule of 72 using Matlab?

    In finance, the rule of 72 is a useful shortcut to assess how long it takes an investment to double given its annual growth ... Read Full Answer >>
  5. How do I calculate the standard error using Matlab?

    In statistics, the standard error is the standard deviation of the sampling statistical measure, usually the sample mean. ... Read Full Answer >>
  6. How do I use the rule of 72 to calculate continuous compounding?

    The rule of 72 is a mathematical shortcut used to predict when a population, investment or other growing category will double ... 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. Fundamental Analysis

    Explaining the Monte Carlo Simulation

    Monte Carlo simulation is an analysis done by running a number of different variables through a model in order to determine the different outcomes.
  7. Fundamental Analysis

    Explaining the Empirical Rule

    The empirical rule provides a quick estimate of the spread of data in a normal statistical distribution.
  8. Economics

    Explaining Demographics

    Demographics is the study and categorization of people based on factors such as income level, education, gender, race, age, and employment.
  9. Fundamental Analysis

    Calculating Degree of Financial Leverage

    Degree of financial leverage (DFL) is a metric that measures the sensitivity of a company’s operating income due to changes in its capital structure.
  10. Fundamental Analysis

    Calculating the Present Value of an Annuity

    The present value of an annuity is the current, lump sum value of periodic future payments as calculated using a specific rate.

You May Also Like

Hot Definitions
  1. Multicurrency Note Facility

    A credit facility that finances short- to medium-term Euro notes. Multicurrency note facilities are denominated in many currencies. ...
  2. National Currency

    The currency or legal tender issued by a nation's central bank or monetary authority. The national currency of a nation is ...
  3. Treasury Yield

    The return on investment, expressed as a percentage, on the debt obligations of the U.S. government. Treasuries are considered ...
  4. Bund

    A bond issued by Germany's federal government, or the German word for "bond." Bunds are the German equivalent of U.S. Treasury ...
  5. European Central Bank - ECB

    The central bank responsible for the monetary system of the European Union (EU) and the euro currency. The bank was formed ...
  6. Quantitative Easing

    An unconventional monetary policy in which a central bank purchases private sector financial assets in order to lower interest ...
Trading Center
×

You are using adblocking software

Want access to all of Investopedia? Add us to your “whitelist”
so you'll never miss a feature!