A Methodology for Appropriate Testing When Data is Heterogeneous Using EXCEL

Khanh Nguyen

Abstract


“A Methodology for Appropriate Testing When Data is Heterogeneous (1999)”was originally published and copyrighted in the mid-1990 using Turbo Pascal and a16-bit operating system.  While working on an ergonomic dissertation (Yearout, 1987), the author determined that the perceptual data was determined to be heterogeneous and not normal. Drs. Milliken and Johnson, the authors of Analysis of Messy Data Volume I: Designed Experiments (1989), advised that Satterthwaite’s Approximation with Bonferroni’s Adjustment to correct for pairwise error be used to analyze the heterogeneous data. This technique of applying linear combinations with adjusted degrees of freedom allowed the use of t-Table criteria to make group comparisons without using standard nonparametric techniques.  Thus, data with unequal variances and unequal sample sizes could be analyzed without losing valuable information.  Variances to the 4th power were so large that they could not be reentered into basic calculators.  The solution was to develop an original software package which was written in Turbo Pascal on a 7 ¼ inch disk 16-bit operating system.  Current 64 bit operating systems and more efficient programming languages have made the software obsolete. Using the old system could result in incorrect output or a runtime error.  The purpose of this research was to develop a spreadsheet algorithm with multiple interactive EXCEL worksheets that will efficiently apply Satterthwaite’s Approximation with Bonferroni’s Adjustment to solve the messy data problem.  To ensure that the pedagogy is accurate, the resulting package was successfully test tested in the classroom with academically diverse students.  A comparison between this technique and Microsoft EXCEL worksheets that efficiently apply Satterthwaite’s Approximation with Bonferroni’s Adjustment to solve the messy data problem. A major benefit is that spreadsheet algorithms will continue to be current regardless of evolving operating systems’ status.


Keywords


Heterogeneous Data, Unequal Sample sizes, Satterthwaite’s Approximation with Bonferroni’s Adjustment

Full Text: PDF

Refbacks

  • There are currently no refbacks.