Working with Aggregate Data: An Excel Macro for Pairwise Comparison Using Z Test for Two Proportions

摘要

A Visual Basic for Applications (VBA) Excel macro was created for doing a pairwise, two-sample Z -test of within-column proportions for k data rows in an Excel spreadsheet. By program iteration, the Z -score for k ( k－ 1)/2 unique, non-repeating and non-duplicated within-column comparisons was generated and the null hypothesis is tested against a two-tailed Z -score critical value. This within-column process is useful for ext racting potential meaning from large aggregate columnar data. The procedure was demonstrated using aggregate internet acquired summary data in the public domain. The VBA macro is provided and it is also available at the author’s website.