Age and sex table for "Table 1"

Paste a list of ages and sexes and get the first table of a paper: number, mean (SD), median (IQR), range, age groups and sex counts.

Your data does not go to our server. This tool runs in your browser; what you type or open never leaves your device.

This calculator needs JavaScript, because it calculates in your browser and sends nothing. Turn JavaScript on to use it. How it is calculated is explained below.

How it is calculated

Sex is read from M/F, male/female, E/K, erkek/kadın or the Arabic words; anything else is counted as not stated rather than guessed.

The table is calculated in your browser and can be copied into a spreadsheet.

  • SD = √[Σ(x − mean)² / (n − 1)]
  • Quartiles: linear interpolation between ranked values (type 7)

Worked example: Ages 10, 20, 30, 40, 50: mean 30.0 (SD 15.8), median 30.0 (IQR 20.0 – 40.0).

Sources

These calculators support research; they do not replace the advice of a statistician or a clinician.

Questions

What format does the list need?

One participant per line: the age, then the sex, separated by a comma, semicolon or tab. A header line and lines that cannot be read are skipped and counted.

All free tools

WhatsApp Tell the Editor
Submit manuscript Contact