Statistical FAQs

Can I perform a one-way analysis of variance with only summary data in JMP Software?

Computing an Analysis of Variance with Summary Statistics in JMP® Software

In some instances, an experimenter may want to perform an Analysis of Variance (ANOVA), but only the summary statistics are available. Most statistical programs are designed to compute ANOVA models with the full, complete set of data. However, David A. Larson describes a method to generate surrogate data from the summary statistics which can be used to fit the ANOVA of interest(1). That is, if the analysis is comparing k categories, and only the summary statistics (n_i, mean_i,s²_i I= 1, 2, 3, …, k) are available, then data can be generated to perform the desired analysis. Utilizing Larson's ideas, JMP Software can be used to perform this type of analysis. The following is an example demonstrating the appropriate steps taken to fit this ANOVA within JMP.

Suppose all the information available is the summary statistics below:

The first step is to create a JMP data table with the above data (Table 1).

Table 1: The JMP data table.

According to Larson, two new columns will need to be generated. So, create two new columns named "Xi's" and "Xn's" with Formula Column properties. Then, using JMP's Formula Editor, define these formulas:

Once these columns are created, they will need to be “stacked.” From the Tables menu, select Stack and choose the columns “Xi's” and “Xn's” to be stacked, and also, change the name of the stacked column from the default “_Stacked_” to “Y” (Figure 1).

Figure 1: The “Stack” dialog box.

Now, all that is necessary to run the model is an appropriate frequency column. Using the If function (found in the JMP Formula Editor's Conditional list) create one more additional column “Frequency” with the formula as shown below in Figure 2.

Figure 2: The “if” selection and the formula for “Frequency.”

The final data table should appear as shown in Table 2.

Table 2: Final data table.

The surrogate data has been generated, so the ANOVA can now be performed. From the Analyze menu, choose Fit Y by X. Specify “Treatment” as the “X”, “Y” as the “Y”, and “Frequency” as the “Freq” and click OK to run the analysis. The first item seen in the output is a scatterplot of the points. From the Oneway Analysis pulldown menu, choose Means/Anova/t Test to get the resulting output as seen in Figure 3.

Figure 3: ANOVA results.

Oneway ANOVA
Summary of Fit

Std Error uses a pooled estimate of error variance

As you can see, the means are exactly those that were specified in the initial summary statistics. The standard errors given are estimated using a pooled estimate of the error variance. To compare all the results, Table 3 gives the actual data from which the summary data is generated. The results from an analysis of variance using the actual data will match perfectly the output given with the summary statistics.

Table 3: Actual data.

In conclusion, if only the summary statistics are available for an oneway analysis, the method described above can be followed to generate surrogate data in JMP Software to complete the desired analysis of variance.

REFERENCES.

Larson, David A. (1992), “Analysis of Variance With Just Summary Statistics
       as Input,” American Statistician, 46, 151-152.

FAQ # 1604
Last Updated: 2002 Nov 22

Browse JMP FAQs

General FAQs

Statistical FAQs

Support Documents

JMP FAQs

Knowledge Base

System Requirements

Alphabetical List of Features

Known Issues

Contact JMP Support

Report a Problem

Update a Report

support@jmp.com

919.677.8008 (US)

International Support via Worldwide SAS Offices