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. Altman Z-Score

    The output of a credit-strength test that gauges a publicly traded ...
RELATED FAQS
  1. 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 >>
  2. What types of assets produce negative portfolio variance?

    Assets that have a negative correlation with each other produce negative portfolio variance. Variance is one measure of the ... Read Full Answer >>
  3. 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 >>
  4. What are some common financial sampling methods?

    There are two areas in finance where sampling is very important: hypothesis testing and auditing. The type of sampling methods ... Read Full Answer >>
  5. How do you calculate the quick ratio?

    There are a few different ways to calculate the quick ratio; each method involves pulling numbers from the financial statements. ... Read Full Answer >>
  6. How do you calculate free cash flow?

    Free cash flow (FCF) is one of many possible estimates of cash flow for a business. The idea is to find out how much money ... 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. Economics

    Explaining the Liquidity Coverage Ratio

    The liquidity coverage ratio requires banks and other financial institutions to hold enough cash and liquid assets on hand to weather market stress.
  7. Fundamental Analysis

    Calculating Valuation

    Valuation is the process of determining what an asset is worth.
  8. Economics

    Will the Selloff in China Hurt the Global Economy?

    Though China is the world’s second largest economy, its volatility in the stock market is unlikely to have an impact on the global or Chinese economy.
  9. Fundamental Analysis

    Understanding Qualitative Analysis

    Qualitative analysis is a general term describing the non-mathematical scrutiny used by investors and managers to make investment and business decisions.
  10. Economics

    Signs The U.S. Recovery Is Solid

    Many market observers lately have been making some pretty pessimistic evaluations of the U.S. economy, declaring that it’s stagnating and soft.

You May Also Like

Hot Definitions
  1. OsMA

    An abbreviation for Oscillator - Moving Average. OsMA is used in technical analysis to represent the variance between an ...
  2. Investopedia

    One of the best-known sources of financial information on the internet. Investopedia is a resource for investors, consumers ...
  3. Unfair Claims Practice

    The improper avoidance of a claim by an insurer or an attempt to reduce the size of the claim. By engaging in unfair claims ...
  4. Killer Bees

    An individual or firm that helps a company fend off a takeover attempt. A killer bee uses defensive strategies to keep an ...
  5. Sin Tax

    A state-sponsored tax that is added to products or services that are seen as vices, such as alcohol, tobacco and gambling. ...
  6. Grandfathered Activities

    Nonbank activities, some of which would normally not be permissible for bank holding companies and foreign banks in the United ...
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!