Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

Symptoms

When you use "Anova: Two-Factor With Replication" in the Data Analysis tools, 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.

↑ Back to the top

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.

↑ Back to the top

Resolution

Use both column and row labels for your input data range.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB267281, kbprb

↑ Back to the top

Article Info
Article ID : 267281
Revision : 3
Created on : 9/25/2003
Published on : 9/25/2003
Exists online : False
Views : 369