KNOWLEDGEBASE - ARTICLE #2135

# How many rows/columns can Prism analyze with ANOVA and nested t test and nested ANOVA?

Very few people do ANOVA with huge data sets, but here we list the limits of Prism 8 for ANOVA, nested t test, and nested ANOVA.

The limits here are for 32-bit Windows. If you use Prism 8 on a Mac (which is 64-bit)  or on 64-bit Windows, the limits are 8 times higher for mixed-effects models and 2.828 (sqrt(8)) times higher for GLM.

Note that GLM refers to the general linear model, which is a more general term for ANOVA (as opposed to fitting a mixed model).

1) One-way ANOVA

1.1) One-way ordinary ANOVA

Prism can handle any table you can enter.

1.2) One-way RM ANOVA

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of columns) > 23,169
- Mixed-effects model: (number of rows) * (number of points) > 268,435,456

2) Two-way ANOVA

2.1) Two-way ordinary ANOVA

Prism cannot analyze tables where: (number of rows) + (number of columns) + (number of rows) * (number of columns) > 23,169

2.2) Each column represents a different time point, so matched values are spread across a row

Prism cannot analyze tables where:
- GLM: (number of columns) + (number of rows) * (number of columns) + (number of rows) * (number of subcolumns) > 23,169
- Mixed-effects model: (number of rows) * (number of subcolumns) * (number of points) > 268,435,456

2.3) Each row represents a different time point, so matched values are stacked into subcolumns

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of rows) * (number of columns) + (number of columns) * (number of subcolumns) > 23,169
- Mixed-effects model: (number of columns) * (number of subcolumns) * (number of points) > 268,435,456

2.4) Repeated measures by both factors

Prism cannot analyze tables where:
- GLM: (number of rows) * (number of columns) + ((number of rows) + (number of columns)) * (number of subcolumns) > 23,169
- Mixed-effects model: ((number of rows) + (number of columns) + 1) * (number of subcolumns) * (number of points) > 268,435,456

3) Three-way ANOVA

3.1) Three-way ordinary ANOVA

Prism cannot analyze tables where: (number of rows) > 5,792

3.2) Values on the same row in columns A and C (and B and D) represent a set of matched or repeated values

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of rows) * (number of subcolumns) > 11,584
- Mixed-effects model: (number of rows) * (number of subcolumns) * (number of points) > 134,217,728

3.3) Values on the same row in columns A and B (and C and D) represent a set of matched or repeated values

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of rows) * (number of subcolumns) > 11,584
- Mixed-effects model: (number of rows) * (number of subcolumns) * (number of points) > 134,217,728

3.4) Values stacked in subcolumns represent a set of matched or repeated values

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of subcolumns) > 5,793
- Mixed-effects model: (number of rows) * (number of subcolumns) * (number of points) > 67,108,864

3.5) Values on the same row in columns A, B, C and D represent a set of matched or repeated values

Prism cannot analyze tables where:
- GLM: (number of rows) + 3 * (number of rows) * (number of subcolumns) > 23,169
- Mixed-effects model: (number of rows) * (number of subcolumns) * (number of points) > 53,687,091

3.6) Values on the same row in columns A and C (and B and D) and values stacked in subcolumns represent a set of matched or repeated values

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of subcolumns) + (number of rows) * (number of subcolumns) > 11,585
- Mixed-effects model: ((number of rows) + 3) * (number of subcolumns) * (number of points) > 134,217,728

3.7) Values on the same row in columns A and B (and C and D) and values stacked in subcolumns represent a set of matched or repeated values

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of subcolumns) + (number of rows) * (number of subcolumns) > 11,585
- Mixed-effects model: ((number of rows) + 3) * (number of subcolumns) * (number of points) > 134,217,728

3.8) Repeated measures by all three factors

Prism cannot analyze tables where:
- GLM: (number of rows) + (number of subcolumns) + 3 * (number of rows) * (number of subcolumns) > 23,169
- Mixed-effects model: (5 * (number of rows) + 9) * (number of subcolumns) * (number of points) > 268,435,456

4) Nested t test / Nested one-way ANOVA

Prism cannot analyze tables where: (number of columns) * (number of subcolumns) * (number of points) > 268,435,456

## Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.