Spreadsheet for Calculating Herfindahl-Hirshman Index (HHI)
Not what you're looking for?
The problem gives this chart:
Competitor
Rank
Market A Market B Market C Market D
1 40 25 10 50
2 30 25 10 25
3 15 10 8 10
4 10 10 8 10
5 5 6 8 2
6 5 8 2
7 5 8 1
8 5 8
9 5 8
10 4 8
11 8
12 8
Totals 100 100 100 100
Calculate the pre-merger HHI measures for each market. How would a merger affect a market's HHI?
Purchase this Solution
Solution Summary
This solution explains the Herfindahl-Hirshman Index (HHI) and gives an Excel spreadsheet that can be used to calculate the HHI for any market, both before and after a merger.
Solution Preview
See the attached file for the calculations.
HHI is a measure of market concentration. You calculate HHI by summing the squares of the market shares. You can express the ...
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.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.
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.
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.