Forwarded On Dec. 6, 2005 

Compute This

(These are some questions from other coaches in other parts of the country).

The NOAA.gov website maintains oceanic information on protecting marine mammals, sea turtles, habitats, statistics, economics, enforcement, etc., collectively listed under Fisheries.  For this assignment, you are to research the NOAA.gov website looking for the annual per capita consumption of fish and shellfish for human food.

Your task is to locate consumption information by countries and regions of the world.  The regions are North America, the Caribbean, Latin America, Europe, the Near East, the Far East, Africa, and Oceania .

Using Excel do the following:
1.  Make a table of countries within region listing the pounds of fish and shellfish consumed.
2.   Insert functions that calculate the total pounds by region, a count of countries per region, and the average number of pounds consumed by the countries listed.
3.   Create a pie chart that demonstrates the percentage of fish and shellfish consumed by each region of the world.  Include a title, labeled axis, and a legend that identifies each region of the world. (Hint - making this chart will be easier if you create a second table consisting of only the total pounds by region.)

Using Word, give short answers to the following questions:

1. What is the method used by this website to calculate per capita consumption?  Describe the method.

2. How much more was the per capita consumption of fish and shellfish in the United States during 2003 than in 2002?

3. What is the difference between per capita consumption and per capita use?