Descriptive

This tool provides automatic calculation of three types of tables and ranking graphs.

The first table describes the number of cases, percentage (%), crude rate (CR) and its confidence interval, age standardized rate (ASR) as user-defined reference population and its confidence interval, truncated ASR rate (TR), cumulative rate (CumulR), cumulative risk (CRisk) and the ratio between men and women or vice versa (only in case both data, men and women is included in data file). Both rates may be truncated or accumulated for the age groups that are more interesting for the user study.

The second table describes the number of cases per age group.

The third table describes the age specific rate per age group.

Each type of table is returned for each sex introduced in the data file. Each table presents the indicators for each group existing in the data file.

The indicator to be represented in the ranking graph is chosen by the user between number of cases, CR, ASR , TR or CumulR. Various indicators can be selected.

Methodology (PDF)

Files must be ASCII type, ";" separated and unquoted values (i.e: ".txt" or ".csv" files).
Variables included in these files must be in the following order:

Data file (click here to view an example):
a) sex: 1=Male ; 2=Female ; 0=Both sexes.It is not necessary to include all the categories.
b) age.group: ID number of the age group. Age group must be matched with that from the age group file (defined below).
c) year: Year or reference year (in case of period).
d) group: Name of the groups to study. For example, when studying cancer sites it could be "Bladder", "Pancreas", "All sites", ... Or when studying a pathology by geographical areas, it could be "Italy", "France", "Spain", etc.
e) cases: Number of cases in each group.
f) population: Population at risk corresponding to each group.

Age group file. Age groups must be consecutive (clik here to view an example):
a) age.group.id: ID number of the age group.
b) min.age.group: Minimun age group.
c) max.age.group: Maximum value of the age group. If it has no maximum value, e.g. 85+, should be entered as "NA".

Weights file (click here to view an example):
a) age.group: ID number of the age group. Age group must be matched with that from the age group file (defined below).
b) W: Weights of the reference population (must sum 1).
Note: You can rename the W column to your preference. 

NOTE: This process could take a few minutes!

Warning: file size must be less than 10MB.

Data file:

Age groups file:

Weights file: