IDEAS home Printed from https://ideas.repec.org/a/che/ireepp/v10y2011i1p117-127.html
   My bibliography  Save this article

Using Excel to Illustrate Hannah and Kay's Concentration Axioms

Author

Listed:
  • Paul Latreille

    (Swansea University)

  • James Mackley

    (Ofcom)

Abstract

Most courses in industrial economics/industrial organisation cover the measurement of industry concentration. In a classic paper Hannah and Kay (1977) propose a set of desirable criteria against which any of the numerous concentration measures may be judged. We describe how these criteria can be illustrated for students for several of the most popular measures using an Excel spreadsheet and an exercise sheet developed by the authors and freely available from the HEA Economics Network website.

Suggested Citation

  • Paul Latreille & James Mackley, 2011. "Using Excel to Illustrate Hannah and Kay's Concentration Axioms," International Review of Economic Education, Economics Network, University of Bristol, vol. 10(1), pages 117-127.
    • Handle: RePEc:che:ireepp:v:10:y:2011:i:1:p:117-127
    as

    Download full text from publisher

    File URL: https://www.economicsnetwork.ac.uk/iree/v10n1/latreille_mackley.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Saving, Thomas R, 1970. "Concentration Ratios and the Degree of Monopoly," International Economic Review, Department of Economics, University of Pennsylvania and Osaka University Institute of Social and Economic Research Association, vol. 11(1), pages 139-146, February.
    2. Marfels, Christian, 1971. "Absolute and Relative Measures of Concentration Reconsidered," Kyklos, Wiley Blackwell, vol. 24(4), pages 753-766.
    3. Leslie Hannah & J. A. Kay, 1977. "The Measurement of Concentration," Palgrave Macmillan Books, in: Concentration in Modern Industry, chapter 4, pages 41-63, Palgrave Macmillan.
    4. Christian Marfels, 1971. "Absolute And Relative Measures Of Concentration Reconsidered," Kyklos, Wiley Blackwell, vol. 24(4), pages 753-766, November.
    5. Curry, B & George, K D, 1983. "Industrial Concentration: A Survey," Journal of Industrial Economics, Wiley Blackwell, vol. 31(3), pages 203-255, March.
    6. Leslie Hannah & J. A. Kay, 1977. "Concentration in Modern Industry," Palgrave Macmillan Books, Palgrave Macmillan, number 978-1-349-02773-6.
    7. John C. Hause, 1977. "The Measurement of Concentrated Industrial Structure and the Size Distribution of Firms," NBER Chapters, in: Annals of Economic and Social Measurement, Volume 6, number 1, pages 73-107, National Bureau of Economic Research, Inc.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Lis-Gutiérrez, Jenny-Paola, 2013. "Medidas de concentración y estabilidad de mercado. Una aplicación para Excel [Market concentration and market stability measures. An application for Excel]," MPRA Paper 47615, University Library of Munich, Germany.
    2. Petr Svoboda, 2016. "Analysis of Market Concentration in Selected Sectors of Public Procurement," Acta Universitatis Agriculturae et Silviculturae Mendelianae Brunensis, Mendel University Press, vol. 64(3), pages 1073-1082.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Oscar Bajo & Rafael Salas, 2002. "Inequality foundations of concentration measures: An application to the Hannah-Kay indices," Spanish Economic Review, Springer;Spanish Economic Association, vol. 4(4), pages 311-316.
    2. Alexander M. Goulielmos & Giannis Sitzimis, 2012. "Measuring Market Concentration in the Aegean Ferry System," SPOUDAI Journal of Economics and Business, SPOUDAI Journal of Economics and Business, University of Piraeus, vol. 62(1-2), pages 7-27, January -.
    3. Jean-Pascal Simonin, 1980. "Indices de concentration, pouvoir de monopole et variations conjecturales : quelques extensions," Revue Économique, Programme National Persée, vol. 31(1), pages 121-135.
    4. Nelson, Ray D., 1984. "Measures of Diversity: A Comparison," Regional Research Projects >1984: S-180 Annual Meeting, March 25-28, 1984, New Orleans, Louisiana 307233, Regional Research Projects > S-180: An Economic Analysis of Risk Management Strategies for Agricultural Production Firms.
    5. P. Owen & Michael Ryan & Clayton Weatherston, 2007. "Measuring Competitive Balance in Professional Team Sports Using the Herfindahl-Hirschman Index," Review of Industrial Organization, Springer;The Industrial Organization Society, vol. 31(4), pages 289-302, December.
    6. Caswell, Julie A., 1988. "An Alternative Measure Of Aggregate Concentration With An Application To The Agribusiness Sector," Working Papers 115904, Regional Research Project NE-165 Private Strategies, Public Policies, and Food System Performance.
    7. Jenny-Paola Lis-Gutiérrez, 2013. "Medidas de concentración y estabilidad de mercado. Una aplicación para Excel," Estudios Económicos SIC 10901, Superintendencia de Industria y Comercio.
    8. Daniel F. Leach, 1997. "Concentration‐Profits Monopoly Vs. Efficiency Debate: South African Evidence," Contemporary Economic Policy, Western Economic Association International, vol. 15(2), pages 12-23, April.
    9. Bhattacharya, Mita & Bloch, Harry, 2000. "The dynamics of industrial concentration in Australian manufacturing," International Journal of Industrial Organization, Elsevier, vol. 18(8), pages 1181-1199, December.
    10. de Vany, Arthur & Kim, Cassey Lee Hong, 2003. "Stochastic Market Structure: Concentration Measures and Motion Picture Antitrust," Centre on Regulation and Competition (CRC) Working papers 30701, University of Manchester, Institute for Development Policy and Management (IDPM).
    11. Behnaz Heidarzadeh & Mohammad Nabi Shahiki Tash, 2013. "Investigating the Impact of Market Power on Foreign Direct Investment Absorption in Concentrated and Unconcentrated Industries in Iran," International Journal of Financial Economics, Research Academy of Social Sciences, vol. 1(2), pages 67-75.
    12. Domínguez Jurado, José Miguel & Triguero-Ruiz, Francisco & Avila-Cano, Antonio, 2021. "Firm growth in the 21st century: Does the Andalusian economy comply with Gibrat’s Law?," Physica A: Statistical Mechanics and its Applications, Elsevier, vol. 577(C).
    13. Benny Geys & Bruno Heyndels, 2006. "Disentangling The Effects Of Political Fragmentation On Voter Turnout: The Flemish Municipal Elections," Economics and Politics, Wiley Blackwell, vol. 18(3), pages 367-387, November.
    14. Dorian Owen, 2014. "Measurement of competitive balance and uncertainty of outcome," Chapters, in: John Goddard & Peter Sloane (ed.), Handbook on the Economics of Professional Football, chapter 3, pages 41-59, Edward Elgar Publishing.
    15. Dariusz Filip & Tomasz Miziołek, 2019. "Market Concentration in the Polish Investment Fund Industry," Gospodarka Narodowa. The Polish Journal of Economics, Warsaw School of Economics, issue 4, pages 53-78.
    16. Abraham Nunes & Thomas Trappenberg & Martin Alda, 2020. "Measuring heterogeneity in normative models as the effective number of deviation patterns," PLOS ONE, Public Library of Science, vol. 15(11), pages 1-16, November.
    17. Eva M. Sierminska & Jacques Silber, 2020. "The diversity of household assets holdings in the United States in 2007 and 2009: measurement and determinants," Review of Economics of the Household, Springer, vol. 18(3), pages 599-634, September.
    18. Edward Nissan & George Carter, 2011. "The Largest Trans-nationals of Developing Economies," Atlantic Economic Journal, Springer;International Atlantic Economic Society, vol. 39(1), pages 71-83, March.
    19. Nicole Palan, 2010. "Measurement of Specialization – The Choice of Indices," FIW Working Paper series 062, FIW.
    20. Guglielmo D’Amico & Giuseppe Di Biase & Raimondo Manca, 2011. "Immigration Effects On Economic Systems Through Dynamic Inequality Indices," Global Journal of Business Research, The Institute for Business and Finance Research, vol. 5(5), pages 11-25.

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:che:ireepp:v:10:y:2011:i:1:p:117-127. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Martin Poulter (email available below). General contact details of provider: https://www.economicsnetwork.ac.uk/iree .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.