Module: Editor
Version: 5.1.4 +
Description
The formula 'CumulativeProductMatrix' returns the cumulative product of a matrix over a specified dimension. A cumulative product is the result of multiplying the numbers from left to right or from top to bottom. The function 'CumulativeProductMatrix' creates a new matrix with the same amount of rows and columns as the matrix used for the input, but with the cumulative product.
Parameters
Matrix: the matrix you want to take the cumulative product from.
Dimension: the dimension to accumulate. 1 means downwards (over rows), 2 means rightwards (over columns).
Example
Description
In the following example the formula 'CumulativeProductMatrix' is used to take the cumulative product of a matrix over dimension 2 (over columns).
Values parameters
Matrix:
| Column1 | Column2 | Column3 | Column4 |
|---|
| 2 |
4 |
6 |
8 |
| 3 |
5 |
7 |
9 |
Dimension: 2
Result
Matrix:
| Column1 | Column2 | Column3 | Column4 |
|---|
| 2 |
8 |
48 |
384 |
| 3 |
15 |
105 |
945 |
The result is a matrix with the cumulative product in the last column.
Related Topics
- Cumulative : The formula 'Cumulative' returns a cumulative matrix over a specified dimension.
Feedback
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.