Grech Victor
Department of Paediatrics, Mater Dei Hospital, Malta.
Early Hum Dev. 2018 Feb;117:104-109. doi: 10.1016/j.earlhumdev.2018.01.003. Epub 2018 Jan 12.
Data analysis at the descriptive stage and the eventual presentation of results requires the tabulation and summarisation of data. This exercise should always precede inferential statistics. Pivot tables and pivot charts are one of Excel's most powerful and underutilised features, with tabulation functions that immensely facilitate descriptive statistics. Pivot tables permit users to dynamically summarise and cross-tabulate data, create tables in several dimensions, offer a range of summary statistics and can be modified interactively with instant outputs. Large and detailed datasets are thereby easily manipulated making pivot tables arguably the best way to explore, summarise and present data from many different angles. This second paper in the WASP series in Early Human Development provides pointers for pivot table manipulation in Excel™.
描述性阶段的数据分析以及最终结果的呈现需要对数据进行制表和汇总。这项工作应始终先于推断性统计。数据透视表和数据透视图是Excel最强大但未得到充分利用的功能之一，其制表功能极大地促进了描述性统计。数据透视表允许用户动态汇总和交叉制表数据、在多个维度创建表格、提供一系列汇总统计信息，并且可以通过即时输出进行交互式修改。由此，大型详细数据集很容易被处理，这使得数据透视表可以说是从许多不同角度探索、汇总和呈现数据的最佳方式。《早期人类发育》中黄蜂系列的第二篇论文提供了在Excel™中操作数据透视表的指南。
