%0 Journal Article
%T Working with Aggregate Data: An Excel Macro for Pairwise Comparison Using Z Test for Two Proportions
%A Victor L. Landry
%J Open Access Library Journal
%V 4
%N 10
%P 1-9
%@ 2333-9721
%D 2017
%I Open Access Library
%R 10.4236/oalib.1103927
%X <div style="text-align:justify;">
	<span style="line-height:1.5;">A Visual Basic for Applications (VBA) Excel macro
was created for doing a pairwise, two-sample </span><i style="line-height:1.5;">Z</i><span style="line-height:1.5;">-test of within-column proportions for</span><i style="line-height:1.5;">k </i><span style="line-height:1.5;">data rows in an Excel spreadsheet. By program iteration, the </span><i style="line-height:1.5;">Z</i><span style="line-height:1.5;">-score for </span><i style="line-height:1.5;">k</i><span style="line-height:1.5;">(</span><i style="line-height:1.5;">kŁ­</i><span style="line-height:1.5;">1)/2</span><i style="line-height:1.5;"> </i><span style="line-height:1.5;">unique,
non-repeating and non-duplicated within-column comparisons was generated and the null hypothesis is tested against a
two-tailed </span><i style="line-height:1.5;">Z</i><span style="line-height:1.5;">-score critical value.
This within-column process is useful for ext</span><span style="line-height:1.5;">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.</span> 
</div>
%K Pairwise Comparison
%K Two-Proportion Z-Test
%K Aggregated Data
%K Internet Data
%K Excel VBA Macro
%U http://www.oalib.com/paper/5290003