You are currently offline, waiting for your internet to reconnect

XL2000: Error: Anova: Two-Factor With Replication - Each sample must contain the same number of rows.

This article was previously published under Q267281
SYMPTOMS
When you use "Anova: Two-Factor With Replication" in the Data Analysistools, you may receive one of the following error messages:
Anova: Two-Factor With Replication - Each sample must contain the same number of rows.
-or-
Anova: Two-Factor With Replication - Input range should contain two or more blocks of data arranged in rows or columns.
CAUSE
This problem may occur when the input range that you specify does not contain data with the correct layout or labels. Anova: Two-Factor With Replication requires that you include labels for each group and each trial as shown in the More Information section of this article.
RESOLUTION
Use both column and row labels for your input data range.
MORE INFORMATION
The following data could be used to analyze two trials for two groups:

A1 :              B1 : Group 1      C1 : Group 2      A2 : Trial 1      B2 : 75           C2 : 59           A3 :              B3 : 68           C3 : 56           A4 :              B4 : 71           C4 : 61           A5 :              B5 : 75           C5 : 60           A6 : Trial 2      B6 : 66           C6 : 62           A7 :              B7 : 70           C7 : 60           A8 :              B8 : 68           C8 : 59           A9 :              B9 : 68           C9 : 68					
To analyze this data using Anova: Two-Factor With Replication, the input range would include A1:C9 and the number of rows would be 4.
REFERENCES
For more information about the Anova analysis tool, click Microsoft Excel Help on the Help menu, type anova in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
covariance XL2000
Properties

Article ID: 267281 - Last Review: 09/25/2003 12:25:00 - Revision: 3.0

  • Microsoft Excel 2000 Standard Edition
  • kbprb KB267281
Feedback