Aggregate Function

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.

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
  1. Aggregate Limit

    A contract provision used in insurance to limit the amount that ...
  2. Aggregate Demand

    The total amount of goods and services demanded in the economy ...
  3. Aggregate Supply

    The total supply of goods and services produced within an economy ...
  4. Aggregation

    1. Used in corporate financial planning, aggregation is a process ...
  5. Monetary Aggregates

    Broad categories measuring the total value of the money supply ...
  6. Consumption Function

    The consumption function is a mathematical formula laid out by ...
Related Articles
  1. Markets

    Explaining Aggregate Supply

    Aggregate supply is the total supply of goods and services an economy produces in a given time period.
  2. Financial Advisor

    Top Problems with Financial Data Aggregation

    A new front in personal finance technology—data aggregation—seeks to make our financial lives easier. But here's why it may be stalling.
  3. Markets

    What's Aggregate Demand?

    Aggregate demand is a macroeconomic term describing the total demand in an economy for all goods and services at any given price level in a given time period.
  4. Markets

    Cost-Push Inflation Versus Demand-Pull Inflation

    Gain a deeper understanding of aggregate supply and demand, forces which raise the price of goods and services.
  5. Financial Advisor

    Advisors: Stay Relevant with Data Aggregation

    Advisors wanting to remain competitive should consider embracing data aggregation tech, which many clients expect. Here's the lowdown on the trend.
  6. Trading

    Advanced Guide To The Bloomberg Terminal: Equity Functions: Monitoring Markets, Trading And Options

    Bloomberg offers numerous functions for monitoring the equity markets (as well as all other markets.) Which function you prefer is largely a matter of personal preference, and will depend on ...
  7. Managing Wealth

    Microsoft Excel Features For The Financially Literate

    Here are some of Excel's functions and features that a financial professional can use to make his or her job more efficient.
  8. Investing

    What's a Market Index?

    A market index combines several stocks to create one aggregate value that’s used to measure a market’s or sector’s performance.
  9. Financial Advisor

    Best Advisor Technology for Understanding Clients

    Advisors can leverage new technology to dramatically improve their workflow and overall profitability over time. Here are four solutions that will help.
  10. Markets

    Cost-Push Inflation Versus Demand-Pull Inflation

    Do you remember how much less you paid for things ten years ago? That’s inflation at work.
RELATED FAQS
  1. What factors cause shifts in aggregate demand?

    Find out how aggregate demand is calculated in macroeconomic models. See what kinds of factors can cause the aggregate demand ... Read Answer >>
  2. How can the federal reserve increase aggregate demand?

    Learn about the Federal Reserve's role in increasing aggregate demand. Fiscal policy tends to be more effective in increasing ... Read Answer >>
  3. How are aggregate demand and GDP related?

    See why aggregate demand and gross domestic product (GDP) are necessarily the same thing according to Keynesian macroeconomic ... Read Answer >>
  4. What's the difference between regular supply and demand and aggregate supply and ...

    Understand how businesses use supply and demand and aggregate supply and demand to forecast economic activity. Learn about ... Read Answer >>
  5. How do changes in aggregate demand affect output?

    Find out why aggregate demand and total output are linked in macroeconomic models, and why economists disagree about the ... Read Answer >>
  6. What is the utility function and how is it calculated?

    Learn what the utility function is in microeconomic theory and how it is calculated based on a functional form that represents ... Read Answer >>
Hot Definitions
  1. Bond Ladder

    A portfolio of fixed-income securities in which each security has a significantly different maturity date. The purpose of ...
  2. Duration

    A measure of the sensitivity of the price (the value of principal) of a fixed-income investment to a change in interest rates. ...
  3. Dove

    An economic policy advisor who promotes monetary policies that involve the maintenance of low interest rates, believing that ...
  4. Cyclical Stock

    An equity security whose price is affected by ups and downs in the overall economy. Cyclical stocks typically relate to companies ...
  5. Front Running

    The unethical practice of a broker trading an equity based on information from the analyst department before his or her clients ...
  6. After-Hours Trading - AHT

    Trading after regular trading hours on the major exchanges. The increasing popularity of electronic communication networks ...
Trading Center