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 Supply

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

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

    Broad categories measuring the total value of the money supply ...
  5. Functional Currency

    The primary type of money that a company uses in its business ...
  6. Social Choice Theory

    Individual preferences are aggregated to produce a social welfare ...
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. 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.
  7. 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.
  8. 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.
  9. Investing

    Calculating Net Present Value at Different Points Using Excel

    Calculating the net present value (NPV) of your investment projects using Excel.
  10. Financial Advisor

    Morningstar's New Client Portal: Better with Data

    Morningstar’s new client portal features data aggregation to aid financial advisors in helping clients gain a better view of their financial situation.
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. Put Option

    An option contract giving the owner the right, but not the obligation, to sell a specified amount of an underlying security ...
  2. Frexit

    Frexit – short for "French exit" – is a French spinoff of the term Brexit, which emerged when the United Kingdom voted to ...
  3. AAA

    The highest possible rating assigned to the bonds of an issuer by credit rating agencies. An issuer that is rated AAA has ...
  4. GBP

    The abbreviation for the British pound sterling, the official currency of the United Kingdom, the British Overseas Territories ...
  5. Diversification

    A risk management technique that mixes a wide variety of investments within a portfolio. The rationale behind this technique ...
  6. European Union - EU

    A group of European countries that participates in the world economy as one economic unit and operates under one official ...
Trading Center