Skip to content
Celeus

Descriptive table (Table 1)

Shown in the app as table_one_full. Part of the method reference, under Descriptive.

When to use

Describe the whole dataset: every variable summarised on its own terms (median [Q1, Q3] or mean (SD), chosen per variable), counts with confidence intervals for proportions, and a missingness row - optionally split by one grouping variable. No hypothesis is tested.

What you provide

  • Group (optional): one categorical column.

Options

Missing data

  • Complete case (listwise deletion)

Multiple comparisons

  • Holm
  • Benjamini-Hochberg (false discovery rate)
  • Bonferroni
  • None (unadjusted)

Other methods under Descriptive:

Worked examples

Celeus's result on a published or illustrative dataset, next to an independent computation and, where one exists, a published value. The data themselves are not reproduced here.

datasets::ToothGrowth

  • Source: Published dataset distributed with an R package
  • Licence: base R (GPL)
  • Reference: Crampton (1947), J. Nutrition 33(5)
QuantityCeleusIndependent computationPublished valueAgrees
Number of observations6060-Yes
Number of variables summarised22-Yes

survey::apiclus1 (api00 with the design columns)

  • Source: Published dataset distributed with an R package
  • Licence: survey (GPL-2 | GPL-3)
  • Reference: Lumley T, "A survey analysis example" (survey package vignette) for the published mean and SE; independent computation with the survey package for the design effect
QuantityCeleusIndependent computationPublished valueAgrees
Weighted mean or proportion, table row 1644.169644.169644.17Yes
Design-based standard error, table row 123.542223.542223.542Yes
Design effect, table row 19.069759.06975-Yes
Number of observations183183-Yes

survey::apiclus1 (ell and meals by school type)

  • Source: Published dataset distributed with an R package
  • Licence: survey (GPL-2 | GPL-3)
  • Reference: Lumley T, "A survey analysis example" (survey package vignette) for the published domain means; independent computation with the survey package
QuantityCeleusIndependent computationPublished valueAgrees
Weighted mean or proportion, table row 1151515Yes
Design-based standard error, table row 15.347075.347075.34706Yes
Design effect, table row 11.859751.85975-Yes
Weighted mean or proportion, table row 229.694429.6944-Yes
Design-based standard error, table row 21.411621.41162-Yes
Design effect, table row 21.009651.00965-Yes
Weighted mean or proportion, table row 322.6822.68-Yes
Design-based standard error, table row 32.952862.95286-Yes
Design effect, table row 31.051921.05192-Yes
Weighted mean or proportion, table row 427.61227.612-Yes
Design-based standard error, table row 42.019312.01931-Yes
Design effect, table row 42.618172.61817-Yes
Weighted mean or proportion, table row 537.571437.5714-Yes
Design-based standard error, table row 55.912265.91226-Yes
Design effect, table row 51.314571.31457-Yes
Weighted mean or proportion, table row 653.090353.0903-Yes
Design-based standard error, table row 67.07047.0704-Yes
Design effect, table row 69.647319.64731-Yes
Weighted mean or proportion, table row 743.0843.08-Yes
Design-based standard error, table row 76.017116.01711-Yes
Design effect, table row 71.693721.69372-Yes
Weighted mean or proportion, table row 850.535550.5355-Yes
Design-based standard error, table row 86.269046.26904-Yes
Design effect, table row 810.142910.1429-Yes

survey::fpc (stratified two-PSU example, the subpopulation x > 4)

  • Source: Published dataset distributed with an R package
  • Licence: survey (GPL-2 | GPL-3)
  • Reference: Lumley T, "Estimates in subpopulations" (survey package vignette) for the published domain mean and SE; independent computation with the survey package
QuantityCeleusIndependent computationPublished valueAgrees
Weighted mean or proportion, table row 16.1956.1956.195Yes
Design-based standard error, table row 10.7555130.7555130.7555Yes
Design effect, table row 10.9669740.966974-Yes

survey::nhanes with the second PSU of stratum 75 removed, leaving one single-PSU stratum (deliberately altered)

  • Source: Illustrative or synthetic example data
  • Licence: survey (GPL-2 | GPL-3)
  • Reference: independent computation with the survey package
QuantityCeleusIndependent computationPublished valueAgrees
Weighted mean or proportion, table row 20.1133320.113332-Yes
Design-based standard error, table row 20.005635440.00563544-Yes

Validation report

References

  1. Wilson, E. B. (1927). Probable inference, the law of succession, and statistical inference. Journal of the American Statistical Association 22: 209-212. doi:10.1080/01621459.1927.10502953 doi:10.1080/01621459.1927.10502953
  2. Newcombe, R. G. (1998). Two-sided confidence intervals for the single proportion: comparison of seven methods. Statistics in Medicine 17: 857-872. doi:10.1002/(SICI)1097-0258(19980430)17:8<857::AID-SIM777>3.0.CO;2-E doi:10.1002/(SICI)1097-0258(19980430)17:8<857::AID-SIM777>3.0.CO;2-E
  3. Shapiro, S. S., Wilk, M. B. (1965). An analysis of variance test for normality (complete samples). Biometrika 52: 591-611. doi:10.1093/biomet/52.3-4.591 doi:10.1093/biomet/52.3-4.591