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.

BREAKING DOWN '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. Interest Coverage Ratio

    A debt ratio and profitability ratio used to determine how easily ...
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

    The Problem With Today’s Headline Economic Data

    Headwinds have kept the U.S. growth more moderate than in the past–including leverage levels and an aging population—and the latest GDP revisions prove it.
  7. Economics

    Explaining the Participation Rate

    The participation rate is the percentage of civilians who are either employed or unemployed and looking for a job.
  8. Mutual Funds & ETFs

    ETF Analysis: Guggenheim Enhanced Short Dur

    Find out about the Guggenheim Enhanced Short Duration ETF, and learn detailed information about this fund that focuses on fixed-income securities.
  9. Mutual Funds & ETFs

    ETF Analysis: iShares Morningstar Small-Cap Value

    Find out about the Shares Morningstar Small-Cap Value ETF, and learn detailed information about this exchange-traded fund that focuses on small-cap equities.
  10. Mutual Funds & ETFs

    ETF Analysis: iShares MSCI KLD 400 Social

    Find out about the iShares MSCI KLD 400 Social exchange-traded fund, and learn detailed information about its characteristics, suitability and recommendations.
RELATED FAQS
  1. What is the formula for calculating compound annual growth rate (CAGR) in Excel?

    The compound annual growth rate, or CAGR for short, measures the return on an investment over a certain period of time. Below ... Read Full Answer >>
  2. What is the formula for calculating weighted average cost of capital (WACC) in Excel?

    When analyzing different financing options, companies need to look at how much it will cost to fund operations. There are ... Read Full Answer >>
  3. What assumptions are made when conducting a t-test?

    The common assumptions made when doing a t-test include those regarding the scale of measurement, random sampling, normality ... Read Full Answer >>
  4. What are some of the more common types of regressions investors can use?

    The most common types of regression an investor can use are linear regressions and multiple linear regressions. Regressions ... Read Full Answer >>
  5. What types of assets lower portfolio variance?

    Assets that have a negative correlation with each other reduce portfolio variance. Variance is one measure of the volatility ... Read Full Answer >>
  6. When is it better to use systematic over simple random sampling?

    Under simple random sampling, a sample of items is chosen randomly from a population, and each item has an equal probability ... Read Full Answer >>

You May Also Like

Hot Definitions
  1. Financial Crisis

    A situation in which the value of financial institutions or assets drops rapidly. A financial crisis is often associated ...
  2. Election Period

    The period of time during which an investor who owns an extendable or retractable bond must indicate to the issuer whether ...
  3. Shanghai Stock Exchange

    The largest stock exchange in mainland China, the Shanghai Stock Exchange is a nonprofit organization run by the China Securities ...
  4. Dead Cat Bounce

    A temporary recovery from a prolonged decline or bear market, followed by the continuation of the downtrend. A dead cat bounce ...
  5. Bear Market

    A market condition in which the prices of securities are falling, and widespread pessimism causes the negative sentiment ...
  6. Alligator Spread

    An unprofitable spread that occurs as a result of large commissions charged on the transaction, regardless of favorable market ...
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!