HHI and Beer Competition

Is the beer industry a highly concentrated one?  Would you describe the competition among light beer to be of low concentration? Explain.

Data: statistic_id188723_most-popular-beer-brands-in-the-us-2017-based-on-sales.xlsx

Consider the attached beer sales data. Calculate metrics for market share and industry concentration (HHI). Provide a brief narrative that explains your calculated results. Comment also about the share of named light beers relative to other beers.

Note: Please save and upload your work as a PDF.