The Analysis of Variance (ANOVA) technique is the most popular statistical technique in behavioral research. The ANOVA technique also comes up often in agricultural, pharmaceutical, and quality control contexts. This article will introduce you to six major steps involved in using this technique by implementing them with a combination of PHP, MySQL, and JpGraph. The result is code and knowledge that you can use to think about and potentially solve your own datamining problems.
The scope of the ANOVA technique can narrow to include only the formal mathematics required to partition the total variance of a data matrix into betweengroup and withingroup variance estimates. Within this narrow construal, one might also include the machinery to test whether the ratio of the between to withingroup variance is significant (i.e., whether there is a treatment effect).
In this article, we will construe the ANOVA technique more broadly to consist of multiple dataanalysis steps to take when conducting an ANOVA analysis. The ANOVA technique here is a methodical approach to analyzing data that issues from a particular type of datagenerating process. The datagenerating process will ideally arise from a blocked and randomized experimental design.
Related Reading 
The prototypical Single Factor ANOVA experiment is a simple comparative experiment. These are experiments that involve applying a treatment to homogeneous experimental units and measuring the responses that occur when administering different levels of the treatment to these experimental units.
The hypothetical study we will discuss in this article examines the effect of anxiety (i.e., the treatment) on test performance (i.e., the response). The study randomly assigned 30 subjects to a lowanxiety, moderateanxiety, or highanxiety treatment condition. The experimenter recorded a test score measurement for each subject. The empirical issue of concern is whether there is an effect of Anxiety Level on Test Score.
The idea for this hypothetical study and the data to analyze originally appeared in the popular textbook by Gene V. Glass & Kenneth D. Hopkins (1995) Statistical Methods in Education and Psychology. The reported results agree with their results. You will also find it useful to consult this textbook for its excellent and comprehensive treatment of the ANOVA technique.
You can use the single factor ANOVA technique to determine whether anxiety significantly influences test scores. The following PHP script implements six major steps in the singlefactor ANOVA technique used to analyze data from our hypothetical test anxiety study. After you have examined the overall flow of the script, proceed to the rest of the article where we examine the tabular and graphical output that each step in this script generates.
<?php
/**
* @package SFA
*
* Script performs single factor ANOVA analysis on test anxiety
* data stored in a database.
*
* @author Paul Meagher, Datavore Productions
* @license PHP v3.0
* @version 0.7
*
* The config.php file defines paths to the root of the PHPMATH
* and JPGRAPH libraries and sets up a global database connection.
*/
require_once "config.php";
require_once PHPMATH ."/SFA/SingleFactorANOVA.php";
$sfa = new SingleFactorANOVA;
// Step 1: Specify and analyze data
$sfa>setTable("TestScores");
$sfa>setTreatment("anxiety");
$sfa>setResponse("score");
$sfa>analyze();
// Step 2: Show raw data
$sfa>showRawData();
// Step 3: Show box plot
$params["figureTitle"] = "Anxiety Study";
$params["xTitle"] = "Anxiety Level";
$params["yTitle"] = "Test Score";
$params["yMin"] = 0;
$params["yMax"] = 100;
$params["yTicks"] = 10;
$sfa>showBoxPlot($params);
// Step 4: Show descriptive statistics
$sfa>showDescriptiveStatistics();
// Step 5: Show single factor ANOVA source table
$sfa>showSourceTable();
// Step 6: Show mean differences.
$sfa>showMeanDifferences();
?>
After we instantiate the SingleFactorAnova
class, we start by
specifying 1) what data table to use, 2) what table field name to use as the
treatment column, and 3) what table field name to use as the response
column:
<?php
// Step 1: Specify and analyze data
$sfa>setTable("TestScores");
$sfa>setTreatment("anxiety");
$sfa>setResponse("score");
$sfa>analyze();
?>
The culmination of the first step is the invocation of the
$this>analyze()
method. This method is the centerpiece of this
SingleFactorANOVA
class and is reproduced below. Note that I am
using the PEAR:DB API to interact with a MySQL database.
<?php
/**
* Compute single factor ANOVA statistics.
*/
function analyze() {
global $db;
$sql = " SELECT $this>treatment, sum($this>response), ";
$sql .= " sum($this>response * $this>response), "
$sql .= " count($this>response) ";
$sql .= " FROM $this>table ";
$sql .= " GROUP BY $this>treatment ";
$result = $db>query($sql);
if (DB::isError($result)) {
die($result>getMessage());
} else {
while ($row = $result>fetchRow()) {
$level = $row[0];
$this>levels[] = $row[0];
$this>sums[$level] = $row[1];
$this>n[$level] = $row[3];
$this>means[$level] =
$this>sums[$level] / $this>n[$level];
$this>ss[$level] =
$row[2]  $this>n[$level] * pow($this>means[$level], 2);
$this>variance[$level] =
$this>ss[$level] / ($this>n[$level]  1);
}
$this>sums["total"] = array_sum($this>sums);
$this>n["total"] = array_sum($this>n);
$this>means["grand"] = $this>sums["total"] / $this>n["total"];
$this>ss["within"] = array_sum($this>ss);
foreach($this>levels as $level) {
$this>effects[$level] =
$this>means[$level]  $this>means["grand"];
$this>ss["between"] +=
$this>n[$level] * pow($this>effects[$level], 2);
}
$this>num_levels = count($this>levels);
$this>df["between"] = $this>num_levels  1;
$this>df["within"] = $this>n["total"]  $this>num_levels;
$this>ms["between"] = $this>ss["between"] / $this>df["between"];
$this>ms["within"] = $this>ss["within"] / $this>df["within"];
$this>f = $this>ms["between"] / $this>ms["within"];
$F = new FDistribution($this>df["between"],
$this>df["within"]);
$this>p = 1  $F>CDF($this>f);
$this>crit = $F>inverseCDF(1  $this>alpha);
}
}
?>
We could have passed a data matrix into the analysis method. Instead I assume that the data resides in a database and use SQL to extract and sort the records that feed into the subsequent analysis code. I made this storage assumption because of my interest in developing a scalable dataanalysis solution.

The bulk of the code involves calculating the value of various instance
variables to use in subsequent reporting steps. Most of these instance
variables are associative arrays with indices such as total
,
between
, and within
. This is because the ANOVA
procedure involves computing the total variance (in our test scores) and
partitioning it into betweengroup (i.e., between treatment levels) and
withingroup (i.e., within a treatment level) variance estimates.
At the end of the analyze
method we evaluate the probability of
the observed F score by first instantiating an FDistribution class with our
degrees of freedom parameters:
$F = new FDistribution($this>df["between"], $this>df["within"]);
To obtain the probability of the obtained F score we subtract 1 minus the value returned by the cumulative distribution function applied to the obtained F score:
$this>p = 1  $F>CDF($this>f);
Finally, we invoke the inverse cumulative distribution function using 1 minus our alpha setting (i.e., 1  0.05) in order set a critical F value that defines the decision criterion we will use to reject the null hypothesis which states that there is no difference between treatmentlevel means.
$thiscrit = $F>inverseCDF(1  $this>alpha);
If our observed F score is visibly greater than the critical F
score, we can conclude that at least one of the means differs significantly
from the others. A p value (i.e., $this>p
) value less than
0.05 (or whatever your null rejection setting is) would also lead you to reject
the null hypothesis.
The formula for decomposing the total sum of squares (first term) into a betweengroups component (second term) and a withingroup component (third term) appears in Figure 1.
Figure 1. Formula for decomposing the sum of squares.
The symbol stands for the grand mean and the symbol stands for the treatment mean.
It is always good to begin your analysis by making sure that you've properly
loaded your data. We can call the showRawData()
method to dump our
testanxiety data table to a web browser.
<?php
/*
* Output contents of database table.
*/
function showRawData() {
global $db;
$data = $db>tableInfo($this>table, DB_TABLEINFO_ORDER);
$columns = array_keys($data["order"]);
$num_columns = count($columns);
?>
<table cellspacing='0' cellpadding='0'>
<tr>
<td>
<table border='1' cellspacing='0' cellpadding='3'>
<?php
print "<tr bgcolor='ffffcc'>";
for ($i=0; $i < $num_columns; $i++) {
print "<td align='center'><b>".$columns[$i]."</b></td>";
}
print "</tr>";
$fields = implode(",", $columns);
$sql = " SELECT $fields FROM $this>table ";
$result = $db>query($sql);
if (DB::isError($result)) {
die( $result>getMessage());
} else {
while ($row = $result>fetchRow()) {
print "<tr>";
foreach( $row as $key=>$value) {
print "<td>$value</td>";
}
print "</tr>";
}
}
?>
</table>
</td>
</tr>
</table>
<?php
}
?>
This code generates as output the table below:
Table 1. Show Raw Data
id  anxiety  score 

1  low  26 
2  low  34 
3  low  46 
4  low  48 
5  low  42 
6  low  49 
7  low  74 
8  low  61 
9  low  51 
10  low  53 
11  moderate  51 
12  moderate  50 
13  moderate  33 
14  moderate  28 
15  moderate  47 
16  moderate  50 
17  moderate  48 
18  moderate  60 
19  moderate  71 
20  moderate  42 
21  high  52 
22  high  64 
23  high  39 
24  high  54 
25  high  58 
26  high  53 
27  high  77 
28  high  56 
29  high  63 
30  high  59 
A tip for data miners: Maybe you already have some data in your databases to
which you can adapt this code. Look for situations where you have an
enum
data type to act as your treatmentlevel field and a
corresponding integer or float column that measures some response associated
with that treatmentlevel.

Early in your analysis you should graph your data so that you are being
guided by proper overall intuitions about your data. A commonly recommended way
to visualize ANOVA data is to use sidebyside box plots for each treatment
level. To generate these box plots we need to compute a fivenumber
summary for each treatment level, consisting of the minimum value, first
quartile, median, third quartile, and maximum value. The
showBoxPlot($params)
method computes these summary values and uses
them to generate the treatmentlevel box plots.
Figure 2 — box plot of test anxiety data
The showBoxPlot($params)
method is actually a wrapper around
JpGraph library methods. The $params
argument allows us to supply
parameter values needed to fine tune JpGraph's output as you can see if you
examine the method source code:
<?php
/**
* The showBoxPlot method is a wrapper for JPGRAPH methods.
* The JpGraph constant defining to the root of the JpGraph
* library is specified in the config.php file.
*
* I only do very basic $params array handling in this method. There
* is a lot of room for improvement in making parameter handling more
* extensive (i.e., so you have more control over aspects of your plot)
* and more intelligent.
*/
function showBoxPlot($params=array()) {
include_once JPGRAPH . "/src/JpGraph.php";
include_once JPGRAPH . "/src/jpgraph_stock.php";
$summary = $this>getFiveNumberSummary();
$yData = array();
foreach($this>levels AS $level) {
// Data must be in the format : q1, q3, min, max, median.
$plot_parts = array("q1","q3","min","max","median");
foreach($plot_parts AS $part) {
$yData[] = $summary[$level][$part];
}
}
$figureTitle = $params["figureTitle"];
$xTitle = $params["xTitle"];
$yTitle = $params["yTitle"];
if(!isset($figureTitle))
$figureTitle = "Figure 1";
if(!isset($xTitle))
$xTitle = "xlevel";
if(!isset($yTitle))
$yTitle = "ylevel";
$plotWidth = 400;
$plotHeight = 300;
$yMin = $params["yMin"];
$yMax = $params["yMax"];
$yTicks = $params["yTicks"];
$yMargin = 35;
$xMargin = 15;
$xLabels = $this>levels;
$graph = new Graph($plotWidth, $plotHeight);
$graph>SetFrame(false);
$graph>SetMarginColor('white');
$graph>title>Set($figureTitle);
$graph>SetScale("textlin", $yMin, $yMax);
$graph>yscale>ticks>Set($yTicks);
$graph>xaxis>SetTickLabels($xLabels);
$graph>xaxis>SetTitle($xTitle,"center");
$graph>xaxis>SetTitleMargin($xMargin);
$graph>yaxis>SetTitle($yTitle, "center");
$graph>yaxis>SetTitleMargin($yMargin);
// Create a new box plot.
$bp = new BoxPlot($yData);
// Indent bars so they don’t start and end at the edge of the plot area.
$bp>SetCenter();
// Width of the bars in pixels.
$bp>SetWidth(25);
// Set bar colors
$bp>SetColor('black','white','black','white');
// Set median colors
$bp>SetMedianColor('black','black');
$graph>Add($bp);
if (isset($params["outputFile"])) {
$outputFile = $params["outputFile"];
$graph_name = "temp/$outputfile";
} else {
$graph_name = "temp/boxplot.png";
}
$graph>Stroke($graph_name);
echo "<img src='$graph_name' vspace='15' alt='$figureTitle'>";
}
?>
Another report that we will want to see early in our analysis is a
descriptive statistics report. The descriptive statistics table comes directly
from the showDescriptiveStatistics()
method.
Table 2. Show Descriptive Statistics
Anxiety Levels  



If we have carefully studied our box plots and descriptive statistics then
the results of our formal analysis of whether a significant mean difference
exists should come as no surprise. Invoking the showSourceTable()
method generated the ANOVA source table below. It reports the amount of
variance attributable to the effect of our treatment (see "Between" row) versus
the amount of variance to chalk up to experimental error (see "Within"
row).
Table 3. Show Source Table
ANOVA Source Table  

 
Critical F(0.05, 2, 27) is 3.35. 
The obtained F value comes from dividing the mean square error attributable
to the treatment ($ms["between"]
) by the mean square error
attributable to experimental error ($ms["within"]
). If this ratio
is sufficiently large then we can reject the null hypothesis that there is no
treatment effect (i.e., H_{0}: u_{1} = u_{2} =
u_{3}). In the example above, the probability p of the observed F value
is 0.15 — higher than the conventional 0.05 cutoff for declaring
statistical significant. Our critical F_{crit} = 3.35 is also larger
than the obtained F. Both of these facts tell us that we cannot reject the null
hypothesis. This could be because there is in fact no effect of anxiety on test
scores. A null finding could occur if we had a poor experimental design that
had so much experimental error that it washed out our treatment effects.
Perhaps we need to use a repeatedmeasures design instead of an independentsamples design to try to remove some individual differences in responding to anxiety.
If our F test tells us that a significant treatment effect exists, then we
would begin performing multiple comparisons among the treatmentlevel means to
isolate the specific, significantmean differences. Because our obtained F was
not significant, there is no need to proceed to the multiple comparison stage.
It is nevertheless worthwhile examining the size of our effects by calling the
showMeanDifferences()
method. This report arranges
treatmentlevel means from lowest to highest and labels the rows and columns
accordingly.
Table 4. Show Mean Differences
Mean Differences  


Many people engage in data mining without much theoretical motivation for making particular treatment comparisons. In such cases, I recommend obtaining a significant F before performing posthoc comparisons. This approach helps keep the TypeI error rate low. When there is a theoretical motivation for believing that a significant difference exists between particular treatment means, then we can bypass the F test and immediately engage in a priori (or planned) approach, such as Dunn or Planned Orthogonal Contrasts methods. These methods can yield significant results (i.e., comparing the highanxiety group to the combined low and mediumanxiety groups) even when our F ratio is not significant. In general, there is no harm done in always checking whether the F test is significant before engaging in posthoc or a priori multiple comparisons.
In this article, we interpreted the singlefactor ANOVA procedure broadly to consist of several steps to undertake when conducting a singlefactor ANOVA analysis. We illustrated these steps using a hypothetical testanxiety study in which we carried out six steps of the procedure in a recommended order — the order commonly prescribed in undergraduate statistics textbooks. We have not exhausted all the required steps in this article. Because our treatment effect was not significant, we did not proceed to further stages of the analysis procedure.
Had our result come out significant, we would have engaged in the multiplecomparison step where we statistically analyze (using multiple T tests) the significant particularmean differences and contrasts. We would also have run several diagnostic tests to determine whether the data met the assumptions of our statistical tests. Finally, we would have begun to construct a theoretical model of how our treatment levels might exert a causal influence on our response variable. The work reported in this article starts us toward a fullfeatured single factor ANOVA package but there is more implementation work to do.
In addition to teaching the basics of the ANOVA procedure, another purpose
of this article was to demonstrate that PHP is viable platform for webbased
statistical computing, especially when combined with MySQL and JpGraph. The
code distribution for this article contains a benchmark.php
script
that you can use to verify that the critical analyze()
method is
very fast — easily crunching 100,000 records in under a half second
(0.448 seconds) on a very modest hardware (1000 MHz processor with 256 RAM). A
recent American Statistician article repeated the standard advice that new
statistics graduates should be proficient in Cbased languages, Fortran, and
Java. You might add PHP to this list, especially if you intend to work in a Web
medium and see a need for online, databasedriven analysis packages.
Paul Meagher is a cognitive scientist whose graduate studies focused on mathematical problem solving.
Return to the PHP DevCenter.
Copyright © 2017 O'Reilly Media, Inc.