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.

  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. Qualitative Analysis

    Securities analysis that uses subjective judgment based on nonquantifiable ...
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. Investing

    What is Descriptive Statistics?

    Descriptive statistics is the term applied to meaningful data analysis.
  7. Fundamental Analysis

    Create a Monte Carlo Simulation Using Excel

    How to apply the Monte Carlo Simulation principles to a game of dice using Microsoft Excel.
  8. Mutual Funds & ETFs

    Top 4 Inverse Equities ETFs

    Explore analysis of some of the most popular inverse and leveraged-inverse ETFs that track equity indexes, and learn about the suitability of these ETFs.
  9. Forex Fundamentals

    How Foreign Exchange Affects Mergers and Acquisitions Deals

    Learn how foreign exchange rates can impact the flows of international merger and acquisition (M&A) transactions, and understand how deals can impact exchange rates.
  10. Mutual Funds & ETFs

    Finding Lower Risk, Higher Return Mutual Funds

    Discover detailed analysis of lower-risk, higher-return balanced mutual funds, and learn about the characteristics of this type of mutual fund.
  1. Is Colombia an emerging market economy?

    Colombia meets the criteria of an emerging market economy. The South American country has a much lower gross domestic product, ... Read Full Answer >>
  2. 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 >>
  3. 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 >>
  4. 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 >>
  5. 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 >>
  6. 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 >>

You May Also Like

Hot Definitions
  1. Gross Profit

    A company's total revenue (equivalent to total sales) minus the cost of goods sold. Gross profit is the profit a company ...
  2. Revenue

    The amount of money that a company actually receives during a specific period, including discounts and deductions for returned ...
  3. Normal Profit

    An economic condition occurring when the difference between a firm’s total revenue and total cost is equal to zero.
  4. Operating Cost

    Expenses associated with the maintenance and administration of a business on a day-to-day basis.
  5. Cost Of Funds

    The interest rate paid by financial institutions for the funds that they deploy in their business. The cost of funds is one ...
  6. Cost Accounting

    A type of accounting process that aims to capture a company's costs of production by assessing the input costs of each step ...
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!