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

Moving Average  MA
A widely used indicator in technical analysis that helps smooth ... 
Variance
The spread between numbers in a data set, measuring Variance ... 
Standard Deviation
1. A measure of the dispersion of a set of data from its mean. ... 
Mean
The simple mathematical average of a set of two or more numbers. ... 
Arithmetic Mean
A mathematical representation of the typical value of a series ... 
Altman ZScore
The output of a creditstrength test that gauges a publicly traded ...
RELATED FAQS

What is the prime cost formula?
The term "prime cost" refers to the direct costs of manufacturing an item. It is calculated by adding the cost of raw materials ... Read Full Answer >> 
What is a "linear" exposure in Value at Risk (VaR) calculation?
A linear exposure in the valueatrisk, or VaR, calculation is represented by positions in stocks, bonds, commodities or ... Read Full Answer >> 
How can I create a yield curve in Excel?
You can create a yield curve in Microsoft Excel if you are given the time to maturities of bonds and their respective yields ... Read Full Answer >> 
How do I calculate my effective tax rate using Excel?
Your effective tax rate can be calculated using Microsoft Excel through a few standard functions and an accurate breakdown ... Read Full Answer >> 
What is the criteria for a simple random sample?
Simple random sampling is the most basic form of sampling and can be a component of more precise, more complex sampling methods. ... Read Full Answer >> 
How do I perform a financial analysis using Excel?
Investors can use Excel to run technical calculations or produce fundamental accounting ratios. Corporations use Excel to ... Read Full Answer >>
Related Articles

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. 
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. 
Investing Basics
How To Create A Modern FixedIncome Portfolio
Exposure to different asset classes is required to generate income, reduce risk and beat inflation. Find out how bonds can help. 
Options & Futures
Calculating The Equity Risk Premium
See the model in action with real data and evaluate whether its assumptions are valid. 
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. 
Investing
The Strong Dollar’s (Real) Toll On Tech Stocks
A large portion of U.S. technology companies’ sales occur overseas, given the strong international business and consumer demand from many U.S. tech firms. 
Fundamental Analysis
How to Calculate a Coverage Ratio
In broad terms, the higher the coverage ratio, the better the ability of the enterprise to fulfill its obligations to its lenders. 
Fundamental Analysis
Calculating the HerfindahlHirschman Index (HHI)
The HerfindhalHirschman Index, (HHI) is a measure of market concentration and competition among market participants. 
Fundamental Analysis
Calculating Net Interest Margin
Net interest margin is a metric used to measure the effectiveness of a company’s investment decisions, particularly financial institutions. 
Economics
Why The U.S. Economy Is Ready For Liftoff
Though the U.S. economy is once again underperforming expectations, as it has for the past five years, the economy is ready for a (Fed) interest rate hike.