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