Enter factor levels in the worksheet with make patterned data

You can use Calc > Make Patterned Data > Simple Set of Numbers to enter the level numbers of a factor. Here is an easy way to enter the level numbers for a three-way crossed design with a, b, and c levels of factors A, B, C, with n observations per cell:

Enter the levels for factor A.
1. Choose Calc > Make Patterned Data > Simple Set of Numbers, and press the F3 key to reset defaults.
2. Enter A in Store patterned data in.
3. Enter 1 in From first value. Enter the number of levels in A in To last value.
4. Enter the product of bcn in Number of times to list the sequence.
5. Click OK.
Enter the levels for factor B.
1. Choose Calc > Make Patterned Data > Simple Set of Numbers, and press the F3 key to reset defaults.
2. Enter B in Store patterned data in.
3. Enter 1 in From first value. Enter the number of levels in B in To last value.
4. Enter the number of levels in A in Number of times to list each value. Enter the product of cn in Number of times to list the sequence.
5. Click OK.
Enter the levels for factor C.
1. Choose Calc > Make Patterned Data > Simple Set of Numbers, and press the F3 key to reset defaults.
2. Enter C in Store patterned data in.
3. Enter 1 in From first value. Enter the number of levels in C in To last value.
4. Enter the product of ab in Number of times to list each value. Enter the sample size n in Number of times to list the sequence.
5. Click OK.