An Excel macro for transformed and weighted averaging
暂无分享,去创建一个
An Excel macro is presented for averaging spreadsheet data. The macro has several special features: (1) The data are weighted by the inverse variance of each datum to decrease the contribution-of noisy outliers. (2) There is a provision for a power or a log transform of the data before averaging. The rationale for transforming the data before averaging is discussed (3) The output includes the average value, its standard error, and the reduced chi-square that measures the goodness of fit (4) The standard error is corrected by a heterogeneity factor based on the reduced chi-square The averaging of data is rarely done properly, and the intent of this article is to clarify the issues and provide a tool that allows researchers to improve their averaging techniques.
[1] S. Klein,et al. The simultaneous spatial frequency shift: a dissociation between the detection and perception of gratings. , 1974, Vision research.
[2] P. R. Bevington,et al. Data Reduction and Error Analysis for the Physical Sciences , 1969 .
[3] William H. Press,et al. Numerical recipes , 1990 .
[4] C. F. Stromeyer,et al. On inhibition between spatial frequency channels: Adaptation to complex gratings , 1980, Vision Research.