1. Set up all of the information in Table 11.3 except industry sales in 
an Excel spreadsheet.

2. After the column labels, add a row that indicates the source of your 
data (e. g. Hirschey & Pappas, 1992 Economic Census).

3. After the source row, add a row that inidicates the letter of the column.

4. Go the U. S. Census Bureau:
   http://www.census.gov/
and search for concentration ratio.  Look up the concentration ratios 
in manufacturing.

5. Add 4 columns to your table that show (1) the number of firms in the 
industry, (2) 4 firm and (3) 8 firm concentration ratios, and (4) the 
Herfindahl-Hirschmann Index for those industries listed in Table 11.3.  
(You can get this data from the report on concentration ratios in 
manufacturing from the web.)


6. While you are at the Census Bureau's report on 1992 concentration 
ratios, find an SIC code with a 4 firm market concentration ratios less 
than 10 and locate the name of the industry by searching the web.
(Hint: search for sic lookup.)

7. Open Word and write a report you're your findings.  (Hint: Comment on 
any changes between the 1987 data in your text and the 1992 data that you 
found on the web.  Include definitions of terms, such as 4 firm 
concentration ratio.  Explain how to interpret the concentration ratios 
and their advantages and disadvantages.  (You can find this in your 
textbook.)  Be sure that you include a definition of the 
Herfindahlf-Hirschmann Index.  (You can find this definition by searching 
Alta Vista.) 


Attach your Excel file and your Word file and e-mail them to me as
attachments before 5 p. m., Thursday, April 27, 2000.  Remember that
presentation counts!