Working with Aggregate Data: An Excel Macro for Pairwise Comparison Using Z Test for Two Proportions - Open Access Library Journal

OALibJ > Vol.4 No.10, October 2017

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

HTML XML

Download as PDF (Size: 556KB) PP. 1-9

DOI: 10.4236/oalib.1103927 1,390 Downloads 3,443 Views Citations

Author(s)

Victor L. Landry

Affiliation(s)

College of Doctoral Studies, Grand Canyon University, Phoenix, AZ, USA.

ABSTRACT

A Visual Basic for Applications (VBA) Excel macro was created for doing a pairwise, two-sample Z-test of within-column proportions fork 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 extracting 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.

KEYWORDS

Pairwise Comparison, Two-Proportion Z-Test, Aggregated Data, Internet Data, Excel VBA Macro

Share and Cite:

Landry, V. (2017) Working with Aggregate Data: An Excel Macro for Pairwise Comparison Using Z Test for Two Proportions. Open Access Library Journal, 4, 1-9. doi: 10.4236/oalib.1103927.

Journals Menu

Follow SCIRP

	+1 323-425-8868
	customer@scirp.org
	+86 18163351462(WhatsApp)
	1655362766

	Paper Publishing WeChat

Journals Menu

Home

About SCIRP

Service

Policies