Grech Victor
Academic Department of Paediatrics, Mater Dei Hospital, Malta.
Early Hum Dev. 2018 Mar;118:64-66. doi: 10.1016/j.earlhumdev.2018.02.015. Epub 2018 Feb 27.
The calculation of descriptive statistics after data collection provides researchers with an overview of the shape and nature of their datasets, along with basic descriptors, and may help identify true or incorrect outlier values. This exercise should always precede inferential statistics, when possible. This paper provides some pointers for doing so in Microsoft Excel, both statically and dynamically, with Excel's functions, including the calculation of standard deviation and variance and the relevance of the t-distribution.
数据收集后进行描述性统计计算，可为研究人员提供数据集的形状和性质概述以及基本描述符，并有助于识别真实或错误的异常值。只要有可能，这项工作应始终在进行推断统计之前完成。本文提供了一些在Microsoft Excel中进行此项操作的提示，包括使用Excel函数进行静态和动态计算，如标准差和方差的计算以及t分布的相关性。
