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

    What's the relationship between r squared and beta?

    Learn about the relationship between R-squared and Beta. Explore how the concepts are related and often used in conjunction with portfolio Alpha.
  7. Fundamental Analysis

    What is the formula for calculating earnings per share (EPS) in Excel?

    Understand the basics of the earnings per share ratio and how this important financial metric is calculated in Excel and used in investment analysis.
  8. Fundamental Analysis

    How do I calculate the debt-to-equity ratio in Excel?

    Understand the basics of the debt to equity ratio, how it is interpreted as a measure of financial stability and how it is calculated in Microsoft Excel.
  9. Economics

    What are some limitations of the consumer price index (CPI)?

    Explore some of the basic limitations of the widely used economic indicator, the consumer price index, or CPI, and examine the criticism of its accuracy.
  10. Fundamental Analysis

    How can I calculate the acid test ratio in Excel?

    Understand how the acid test ratio is used by analysts to determine the financial health of a company and how to calculate this liquidity metric in Excel.

You May Also Like

Hot Definitions
  1. Command Economy

    A system where the government, rather than the free market, determines what goods should be produced, how much should be ...
  2. Prospectus

    A formal legal document, which is required by and filed with the Securities and Exchange Commission, that provides details ...
  3. Treasury Bond - T-Bond

    A marketable, fixed-interest U.S. government debt security with a maturity of more than 10 years. Treasury bonds make interest ...
  4. Weight Of Ice, Snow Or Sleet Insurance

    Financial protection against damage caused to property by winter weather specifically, damage caused if a roof caves in because ...
  5. Weather Insurance

    A type of protection against a financial loss that may be incurred because of rain, snow, storms, wind, fog, undesirable ...
  6. Portfolio Turnover

    A measure of how frequently assets within a fund are bought and sold by the managers. Portfolio turnover is calculated by ...
Trading Center