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 ... 
Arithmetic Mean
A mathematical representation of the typical value of a series ... 
Mean
The simple mathematical average of a set of two or more numbers. ... 
Standard Deviation
1. A measure of the dispersion of a set of data from its mean. ... 
Compound Annual Growth Rate  CAGR
The yearoveryear growth rate of an investment over a specified ...
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. 
Technical Indicators
What is the Ease Of Movement Indicator formula and how is it calculated?
Read about and learn how to calculate the Ease of Movement indicator, created by Richard W. Arms Jr., to help measure the relationship between price and volume. 
Technical Indicators
What is the Exponential Moving Average (EMA) formula and how is the EMA calculated?
Learn the formula for calculating both simple moving averages and exponential moving averages, indicators that are frequently used by traders and analysts. 
Technical Indicators
What is the Double Exponential Moving Average (DEMA) formula and how is it calculated?
Discover the equation for double exponential moving average, or DEMA, and learn how it is calculated for a better understanding of how it works. 
Technical Indicators
What is the OnBalance Volume (OBV) formula and how is it calculated?
Read about the formula and calculation for On Balance Volume, or OBV, which is a technical indicator that shows movements in trading volume. 
Trading Strategies
What is the McGinley Dynamic Indicator formula and how is it calculated?
Discover the McGinley dynamic indicator, which is designed to resolve issues based on the subjective placement and static data of moving averages.