Entering data : Inserting sequences/series using formulas |

Inserting a sequences of values

mtxSeries(n, x, [step])

Generates a column vector (a one-column matrix) of 'n' subsequent numbers or generic date/time strings.

The 'x' argument specifies the first element of the series. This can be a number or date/time string.

The 'step' argument specifies the value by which the subsequent numbers/dates are incremented. If it's omitted, it's assumed to be 1 for numeric sieries and "P1D" (one day) for date series. The general form of the date/time period is:

[+|-]PnYnMnDTnHnMnS.nnn

For example:

P1Y2M10DT11H5M4S.355 represents a period of 1 year, 2 months, 10 days, 11 hours, 5 minutes, 4 seconds, 355 thousandths.

PT12H7M represents a period of twelve hours and seven minutes

=mtxSeries(5, 1, 0.1) returns {1; 1.1; 1.2; 1.3; 1.4}

=mtxSeries(5, "2005-12-01", "P1D") returns {"2005-12-01"; "2005-12-02"; "2005-12-03"; "2005-12-04"; "2005-12-05"}

=mtxSeries(5, "12:50:00", "PT2M") returns {"12:50:00"; "12:50:02"; "12:50:04"; "12:50:06"; "12:50:08"}

Inserting a random series

mtxRand2(n, [seed1], [seed2], [type], [v1], [v2])

Generates a column vector (a one-column matrix) of random floating point numbers for the specified distribution type.

The 'n' argument specifies the size of the returned vector.

The 'seed1' and 'seed2' arguments determine the starting numbers for the first and the second MLCG generator.
If both those values are omitted, the first call to 'mtxRand2' will always starts from the same hard-coded values of 'seed1' and 'seed2' and subsequent calls will use the previously generated values returning partial series occurring one after another.
If both 'seed1' and 'seed2' are specified, 'mtxRand2' will always be generating one and the same partial series.

To generate two or more independent partial series that do not occur one after another, specify a fixed 'seed1' value and skip the 'seed2' argument.

The 'type' argument specifies the distribution type:

- 0 - uniform (0, 1)
- 1 - normal with the 'v1' mean and the 'v2' standard deviation
- 2 - exponential with the 'v1' mean
- 3 - Poisson with the 'v1' mean
- 4 - Bernouli with the 'v1' probability
- 5 - geometric with the 'v1' probability

If a given distribution type doesn't require the 'v1' and/or 'v2' arguments, they should be omitted.

=mtxRand2(4, 10000, 25000,,,) returns {0.71261246808435; 0.28457538373252; 0.42105025462307; 0.93072516522912}