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.
Next Up
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

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 ... 
Contagion
The spread of market changes or disturbances from one region ...
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. 
Fundamental Analysis
Using Decision Trees In Finance
A decision tree provides a comprehensive framework to review the alternative scenarios and consequences a decision may lead to. 
Economics
Understanding Tragedy of the Commons
The tragedy of the commons describes an economic problem in which individuals try to reap the greatest benefits from a given resource. 
Fundamental Analysis
Return on Investment (ROI) Vs. Internal Rate of Return (IRR)
Read about the similarities and differences between an investment's internal rate of return (IRR) and its return on investment (ROI). 
Economics
Current Probability of Donald Trump as President
Predict the current odds of a Donald Trump presidency, and understand the factors that have kept him on top and the looming challenges he faces. 
Investing Basics
Understanding the Random Walk Theory
The random walk theory states stock prices are independent of other factors, so their past movements cannot predict their future.
RELATED FAQS

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 >> 
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 >> 
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 >> 
What assumptions are made when conducting a ttest?
The common assumptions made when doing a ttest include those regarding the scale of measurement, random sampling, normality ... Read Full Answer >> 
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 >> 
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 >>