faostat-c.gif (9735 bytes)

FAOSTAT ON-LINE HELP


dline.gif (321 bytes)

5. DATA MANIPULATION FUNCTIONS

Aggregate

This function allows you to create your own aggregates (different from the ones stored in the database and shown on the list boxes).

The following steps are required to perform an aggregation:

- From the list boxes select the Country, Item, Element and Year to define your selection;

- Select the Output Format;

- Select from the "Aggregate" list box the desired aggregation: by Country, by Item or both by Country and Items;

- Submit To Database.

Calculate

This function allows you to perform standard calculations on the selected query results.

The following calculation functions are available:

     Basic Statistics: it provides you with Mean and Standard Deviation

  • Mean
  • Standard Deviation

     Exponential Growth (it is allowed only with more than three observations)

  • 3-Years Average
  • Center Moving Average (3 years)
  • Weighted Average

     Per Capita
     Net Trade
(only for Trade Domain)
     Net Trade Value
(only for Trade Domain)
     Net Trade Quantity
(only for Trade Domain)

 

globi.gif (416 bytes)    FAO HOMEPAGE                       goldbull.gif (1190 bytes)  Previous          goldbull.gif (1190 bytes)  Top of Section