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. ... 
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. ... 
IRR Rule
A measure for evaluating whether to proceed with a project or ...
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. 
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. 
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. 
Term
How Statistical Significance is Determined
If something is statistically significant, it’s unlikely that it happened by chance. 
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. 
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

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 >> 
What is the formula for calculating the debttoequity ratio?
Expressed as a percentage, the debttoequity ratio shows the proportion of equity and debt a firm is using to finance its ... Read Full Answer >> 
How do I calculate the P/E ratio of a company?
The priceearnings ratio (P/E ratio) is a valuation measure that compares the level of stock prices to the level of corporate ... Read Full Answer >> 
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 >> 
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 >> 
What is the formula for calculating weighted average cost of capital (WACC)?
Weighted average cost of capital (WACC) is the average aftertax cost of a company’s various capital sources, including common ... Read Full Answer >>