Purchase Solution

Composite Index and Diffusion Index on an Excel spreadsheet

Not what you're looking for?

Ask Custom Question

The following table presents data on three leading indicators for a three-month period. Construct the composite index (with each indicator assigned equal weight) and the diffusion index.
Leading Leading Leading
Month Indicator A Indicator B Indicator C
______________________________________________________________________________
1 100 200 30
2 110 230 27
3 120 240 33

NOTE: The composite index is obtained by calculating the percentage change for each series relative to the base month and then averaging these percentage changes. The percentage change from the first to the second month is 10 for indicator A, 15 for indicator B, and −10 for indicator C. Their simple average (since each indicator is given equal weight) is 5 percent. Taking the first month as the base period with a composite index of 100, we obtain the composite index of 105 for the second month. The diffusion index from month 1 to 2 is 66.7 (=2/3) because two indicators move up and move down.

Attachments
Purchase this Solution
Solution Summary

This solution shows how to use an Excel spreadsheet to calculate the Composite Index and Diffusion Index for three Leading Indicators.

Purchase this Solution
Free BrainMass Quizzes
Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

View More Free Quizzes
Related BrainMass Solutions

  • Leading economic indicators

    Based on revised data, this index increased 0.8 percent in March and remained unchanged in February.

  • Market Efficiency

    The data that is provided is based on actual closing prices for both IBM and for the NYSE composite index (Market Index). IBM announced its quarterly earnings for the quarter ending 9-94 on 10-21-94 (event day = 0).

  • Statistical Analysis of Defective Items

    Items on which the index is based have been carefully chosen to reflect the categories of consumer expenditures. The spreadsheet is provided and is labeled problem 14 chapter 11.

  • Stock Market Index (using Polish stock prices)

    113928 Stock Market Index using stock prices on the Polish stock exchange : Construct two market indexes, one using weights as calculated in the Dow Jones Industrial Average, the other using weights as calculated in the Standard and Poor's Composite

  • Price Index and Inflation Rate

    An excel spreadsheet is determined.

  • Constructing a Diffusion Index

    Best of luck on your assignment and thank you for using BrainMass. Using three month indicator data to find diffusion indices

  • construct a leading economic indicator

    As an experiment, you select these four series: unemployment in the county, a composite index of county stock prices, the County Price Index, and retail sales.

  • Excel - ASIC website, Single Index Model regression

    611650 Excel - ASIC website, Single Index Model regression Now I am working on a financial report problem. But before finish the report, I want to someone to help me to do an Excel for perfecting my work.

  • Forecast, Determining Index & Plot Graph

    Is there a relationship between permeability and carbon content? Hi, please see attached files thanks. Excel spreadsheet shows how to chart and determine an index, with a scatter plot and find relation between.

View More Related Solutions