2007 Economic Census



2007 Economic Census

Hawai’i Data User Conferences

February 16-18, 2010

Exercise Answers

Exercise 1: In what industry would you find Car Dealers?

Exercise Answer: (Using NAICS Web Page)

➢ Navigate to the NAICS web page by clicking on the NAICS link on the Census Bureau Home page. (naics)

➢ Enter “Car Dealers” in the 2007 NAICS Search box and click the button.

➢ New Car Dealers are classified in NAICS 441110 and Used Car Dealers are classified in NAICS 441120.

Exercise 2: Sign up for NotifyMe for the states and Economic Census sectors you are interested in!

(notifyme)

Exercise 3a: What were the total sales of Automobile dealers (NAICS 4411) in Honolulu County in 2007? (Add sales for both employers and nonemployers

Exercise Answer: (Using the Economy-Wide Key Statistics file in American FactFinder.)

➢ Navigate to American FactFinder by clicking on the American FactFinder link on the Census Bureau Home page. (factfinder.)

➢ Click the “get data” link under Economic Census.

➢ Click the “Economy-Wide Key Statistics” link.

➢ To select “Automobile dealers”

o Place your cursor over the “Filter Rows” menu item and choose “by Industry / 2007 NAICS”.

o Since we know the code for this industry, type “4411” in the Search for an industry box, and click the Search button.

o Select “4411: Automobile dealers” from the list, click the “Add” button, and finally click the “Show Result” button.

o The table displays with data for this industry for the U.S.

➢ To select Honolulu County

o Place your cursor over the “Filter Rows” menu item and choose “by Geography”.

o Choose “County” from the “geographic type” menu, then “Hawai’i” from the “Select a state” menu, then “Honolulu County” from the final “geographic area” menu, and finally click the “Add” button.

o Since we are not interested in data for the U.S., select it from the list at the bottom and click the “Remove” button.

o Finally, click the “Show Result” button.

o The table displays with data for this industry for Honolulu County.

➢ The sales of employer car dealers in Honolulu County were $1,981,770 (in $1,000) and the sales of nonemployer car dealers in Honolulu County were $9,160 (in $1,000), for a TOTAL of $1,990,930

Extra credit: Compare new & used car dealers (NAICS 44111 & 44112) in terms of nonemployer sales

Exercise Answer:

➢ To view the data for these additional 2 NAICS codes

o Place your cursor over the “Filter Rows” menu item and choose “by Industry / 2007 NAICS”.

o Choose “44-45: Retail Trade” from the “Select a sector” menu, then “441: Motor vehicle and parts dealers” from the “sub-sector” menu, then choose 44111 and 44112 from the “industry menu”, and click the “Add” button.

o Finally, click the “Show Result” button.

o The table displays with data for these 3 industries for Honolulu County.

➢ The data for nonemployer “New car dealers” is shown with an “N”, indicating that these data are not available. This is because nonemployer new car dealers are reclassified as used car dealers in the Nonemployer Statistics program.

Exercise 3b: Rank all counties in Hawai’i by the sales of automobile dealers (employers only) After Honolulu County, which county came in second?

Exercise Answer: (Using the Sort tool in AFF on the Economy-Wide Key Statistics file.)

➢ To view the data only for NAICS 4411

o Place your cursor over the “Filter Rows” menu item and choose “by Industry / 2007 NAICS”.

o Choose 44111 and 44112 from the “industry menu” at the bottom, and click the “Remove” button.

o Finally, click the “Show Result” button.

o The table displays with data for just 4411 for Honolulu County.

➢ To select all Hawai’i counties

o Place your cursor over the “Filter Rows” menu item and choose “by Geography”.

o Choose “County” from the “geographic type” menu, then “Hawai’i” from the “Select a state” menu, then select the other 3 counties from the final “geographic area” menu, and finally click the “Add” button.

o Finally, click the “Show Result” button.

o The table displays with data for this industry for all 4 Hawai’i counties.

➢ To rank the counties in sales order

o Place your cursor over the “Options” menu item and choose “Sort Rows”.

o Choose “Sales, shipments,…” from the “Sort by” menu, click the “Descending” radio button, and click the “Update” button.

o The table displays with data for this industry for all 4 Hawai’i counties in descending Sales order.

➢ Hawai’i County was ranked 2nd with $312.6 Million in sales of automobile dealers.

Exercise 4: What is the most recent year for which ZIP Code data are available from any Census business statistics other than the Economic Census?

Exercise Answer: (Using the Business and Industry page.)

➢ Navigate to Business and Industry page by clicking on the Business and Industry link on the Census Bureau Home page. (econ/)

➢ Click the “Data by Geography” tab and then the “ZIP Codes” tab (or the “Compare All” tab.

➢ Data for 2007 are currently available from the ZIP Code Business Patterns program.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download