Aggregate Function

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. IRR Rule

    A measure for evaluating whether to proceed with a project or ...
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 Truth about Productivity

    Why has labor market productivity slowed sharply around the world in recent years? One of the greatest economic mysteries out there.
  7. Markets

    The (Expected) Market Impact of the 2016 Election

    With primary season upon us, investor attention is beginning to turn to the upcoming U.S. presidential election.
  8. Term

    How Statistical Significance is Determined

    If something is statistically significant, it’s unlikely that it happened by chance.
  9. Economics

    3 Charts All Investors Should See

    Given the abysmal start to the year, the defining question is whether this is another painful but temporary correction, or the start of a bear market.
  10. Investing

    2 Opportunities Amid Today’s Market Volatility

    As you prepare your portfolio for the market volatility ahead this year, here are a few investing ideas to consider.
RELATED FAQS
  1. What is the formula for calculating EBITDA?

    When analyzing financial fitness, corporate accountants and investors alike closely examine a company's financial statements ... Read Full Answer >>
  2. What is the formula for calculating the debt-to-equity ratio?

    Expressed as a percentage, the debt-to-equity ratio shows the proportion of equity and debt a firm is using to finance its ... Read Full Answer >>
  3. How do I calculate the P/E ratio of a company?

    The price-earnings ratio (P/E ratio) is a valuation measure that compares the level of stock prices to the level of corporate ... Read Full Answer >>
  4. How do you calculate return on equity (ROE)?

    Return on equity (ROE) is a ratio that provides investors insight into how efficiently a company (or more specifically, its ... Read Full Answer >>
  5. What is the formula for calculating the current ratio?

    The current ratio is a financial ratio that investors and analysts use to examine the liquidity of a company and its ability ... Read Full Answer >>
  6. What is the formula for calculating weighted average cost of capital (WACC)?

    Weighted average cost of capital (WACC) is the average after-tax cost of a company’s various capital sources, including common ... Read Full Answer >>
Hot Definitions
  1. Short Selling

    Short selling is the sale of a security that is not owned by the seller, or that the seller has borrowed. Short selling is ...
  2. Harry Potter Stock Index

    A collection of stocks from companies related to the "Harry Potter" series franchise. Created by StockPickr, this index seeks ...
  3. Liquidation Margin

    Liquidation margin refers to the value of all of the equity positions in a margin account. If an investor or trader holds ...
  4. Black Swan

    An event or occurrence that deviates beyond what is normally expected of a situation and that would be extremely difficult ...
  5. Inverted Yield Curve

    An interest rate environment in which long-term debt instruments have a lower yield than short-term debt instruments of the ...
  6. Socially Responsible Investment - SRI

    An investment that is considered socially responsible because of the nature of the business the company conducts. Common ...
Trading Center