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

How do I use the rule of 72 to estimate compounding periods?
The rule of 72 is best used to estimate compounding periods that are factors of two (2, 4, 12, 200 and so on). This is because ... Read Full Answer >> 
How can I use Bollinger Bands® to spot options trading opportunities?
Traders can use Bollinger Bands in a couple of different types of trading strategies. The most common strategy is using Bollinger ... Read Full Answer >> 
How can I run linear and multiple regressions in Excel?
The first step in running regression analysis in Excel is verifying that your software has the capabilities to perform the ... Read Full Answer >> 
How do I calculate the rule of 72 using Matlab?
In finance, the rule of 72 is a useful shortcut to assess how long it takes an investment to double given its annual growth ... Read Full Answer >> 
How do I calculate the standard error using Matlab?
In statistics, the standard error is the standard deviation of the sampling statistical measure, usually the sample mean. ... Read Full Answer >> 
How do I use the rule of 72 to calculate continuous compounding?
The rule of 72 is a mathematical shortcut used to predict when a population, investment or other growing category will double ... 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. 
Fundamental Analysis
Explaining the Monte Carlo Simulation
Monte Carlo simulation is an analysis done by running a number of different variables through a model in order to determine the different outcomes. 
Fundamental Analysis
Explaining the Empirical Rule
The empirical rule provides a quick estimate of the spread of data in a normal statistical distribution. 
Economics
Explaining Demographics
Demographics is the study and categorization of people based on factors such as income level, education, gender, race, age, and employment. 
Fundamental Analysis
Calculating Degree of Financial Leverage
Degree of financial leverage (DFL) is a metric that measures the sensitivity of a company’s operating income due to changes in its capital structure. 
Fundamental Analysis
Calculating the Present Value of an Annuity
The present value of an annuity is the current, lump sum value of periodic future payments as calculated using a specific rate.