**Answers to Exercises in using Economic Data at
[www.census.gov](http://www.census.gov/)**

**Michigan**

1.  In what industry would you find gambling cruises? *\[Goal: Find the
    NAICS code for a kind of business\]*

    a.  Select "NAICS" in the Business section of
        [www.census.gov](http://www.census.gov/) **[OR]{.underline}**
        use the Industry Statistics Sampler on the Economic Census main
        page

    b.  Enter keyword "gambling" in NAICS search box

    c.  +Gambling cruises are NAICS 713210

2.  When will ZIP Code Statistics from the 2002 Economic Census be
    published? *\[Goal: Use the Economic Census publication schedule\]*

    a.  Select "Economic Census" from the Business section of
        [www.census.gov](http://www.census.gov/)

    b.  Select "Schedule" under "2002 Economic Census Reports"

    c.  ZIP statistics are scheduled to be released 2d quarter of 2006.

3.  What were total sales of used car dealers in Oakland County, MI, in
    2002? (Hint - look at both employers and nonemployers) *\[Goal: Use
    drill-down tables; practice adding employers and nonemployers to
    calculate ALL establishments in an industry for a geographic area\]*

    a.  Employers:

        i.  Select "Economic Census" from the Business section of
            [www.census.gov](http://www.census.gov/)

        ii. Under "Drill-down tables" click the red down arrow next to
            "2002 data by NAICS"

        iii. In "Select a state" box in upper right, select "Michigan",
             click on "Go"

        iv. In "Connecticut counties" box, select "Oakland County", and
            click "Go"

        v.  Click the red down arrow next to NAICS 44-45 Retail trade

        vi. Click the red down arrow next to NAICS 441 Motor vehicle &
            parts dealers

        vii. Note used car sales (by employers, NAICS 44112) of
             \$122,114 (000) in 51 establishments

    b.  Nonemployers:

        i.  Cursor up until you see the "Nonemployers" link in the
            headnote of the table -- it takes you directly to the same
            sector and geographic area in the nonemployer tables

        ii. Note used car sales (by nonemployers, NAICS 44112) of
            \$27,146 (000) in 266 establishments

> Total: \$149,260(000) in 317 establishments

4.  Use American FactFinder to display 2002 figures for gasoline
    stations (NAICS 447) for all counties in Michigan*. \[Goal: Use
    American FactFinder to assemble a customized table from economic
    census data\]*

    a.  Select "American FactFinder" from the left sidebar on
        [www.census.gov](http://www.census.gov/) OR at the bottom of the
        Economic Census main page.

    b.  Select "Data Sets" from the left sidebar.

    c.  Select "1997 & 2002 Economic Censuses" from the tabs across the
        top.

    d.  In the 2002 section, select "Economic-Wide Key Statistics"

    e.  Economic-Wide Key Statistics"

    f.  To select all counties in the state...

        i.  In the "Filter Rows" drop-down menu at the top, select "by
            geography".

        ii. Select geographic type "County".

        iii. Select your state from the drop-down.

        iv. Select "All Counties" and then click "Add"

        v.  In the "Current geography selections" box, select "United
            States" and then "Remove"

        vi. Click "Show Result".

    g.  To show data for gasoline stations

        i.  In the "Filter Rows" drop-down menu select "2002 NAICS"

        ii. Enter "gasoline" in the search box and click "Search" (This
            is an occasion where clicking "Use synonyms" gives us more
            than we want.)

        iii. Highlight "447: Gasoline stations" in the "Select an
             industry" box, and click "Add"

        iv. Click "Show result"

5.  Extra credit: Name the top 3 counties in Michigan in terms of sales
    of gasoline stations. *\[Goal: Use additional customizing features
    of American FactFinder\]*

    a.  From the Results page in exercise 4, Select "sort rows" from the
        "Options" drop-down on the top menu bar,

    b.  Select "Sls, shps, rcpts, rev (\$1,000)" from the "Sort by"
        drop-down, and then click the "Descending" button, and click
        "Update"

> Top 3 counties:.Wayne, Oakland, Macomb

6.  Which state had the highest receipts from legal services in 1997?
    *\[Goal: See the variety of data presented in the Industry
    Statistics Sampler, learn the impact of data withheld to avoid
    disclosure\]*

    a.  Select "Economic Census" in the Business section of
        [www.census.gov](http://www.census.gov/) **[OR]{.underline}** go
        directly to
        [www.census.gov/econ/census02](http://www.census.gov/econ/census02)

    b.  Enter "legal" in Industry Statistics Sampler

    c.  Click on NAICS "5411" (Legal Services)

    d.  Click on the link for "States" in the blue navigation bar near
        the top; go to "Geographic Distribution---Legal services:1997"
        table -- this is already ranked by receipts size. California has
        the highest receipts.

    e.  Note -- further down in this table you see a list of states for
        which Receipts was suppressed -- the total of which is 3.57% of
        the U.S. total receipts. Thus, none of the suppressed states
        could outrank California (with 14.60% of total receipts.)

7.  What is the most recent year for which ZIP Code data are available
    from any OTHER Census Business statistics? *\[Goal: Be aware that
    there are more sources of business statistics than the Economic
    Census, and that they can be found through the "Business page"\]*

    a.  Select "Business" on [www.census.gov](http://www.census.gov/)

    b.  In the "Programs with National and Subnational Data" section,
        you can see that 2002 ZIP statistics are available from the
        County Business Patterns program.