Generating patterned numeric data

In the Generate Patterned Numeric Data dialog box, specify the type of pattern, the base sequence, and the repetition pattern.

Select the form of data and enter the base sequence

Select the type of pattern to create and then enter the base sequence.

Equally spaced numbers

Select this option to generate a column of evenly spaced numbers, such as 1, 2, 3, 1, 2, 3, or 3, 3, 2, 2, 1, 1. Then complete the following steps to enter the base sequence.

  1. In First number, enter the starting value for the sequence.
  2. In Last number, enter the smallest or largest possible value for the sequence.
  3. In Size of each step, enter the increment or decrement for each step in the sequence. This value must be greater than zero.

Examples of base sequences

First number Last number Size of each step Base sequence
1 8 2 1 3 5 7
7 1 2 7 5 3 1
30 50 5 30 35 40 45 50

Arbitrary set of numbers

Select this option to generate a column of numbers that are not equally spaced, such as 10, 20, 50. Then, in Numbers in the base sequence, enter the numbers to include in the pattern.

Specify the repetition pattern

  1. In Number of times to list each value, enter the number of times that you want each value in the sequence to be consecutively repeated.
  2. In Number of times to list the whole sequence, enter the number of times that you want to repeat the entire sequence.

Examples of repetition patterns

Base sequence Number of times to list each value Number of times to list the whole sequence Output
10 20 3 1 10 10 10 20 20 20
1 7 6 1 3 1 7 6 1 7 6 1 7 6
A Z O 2 2 A A Z Z O O A A Z Z O O
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy