How to Set Up an Ordinal Variable in Excel. An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd ...

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

To set up data in Excel for a factorial ANOVA, the dataset must be structured so that each row corresponds to an individual observation.