Module: Editor
Version: 5.1.4 +
Description
The formula 'ReverseCumulativeProductMatrix' returns the reverse cumulative product of a matrix over a specified dimension. A reverse cumulative product is the result of multiplying the numbers from right to left or from bottom to top. The function 'ReverseCumulativeProductMatrix' creates a new matrix with the same amount of rows and columns as the matrix used for the input, but with the reverse cumulative product.
Parameters
Matrix: the matrix you want to take the reversecumulative product from.
Dimension: the dimension to accumulate. 1 means upwards (over rows), 2 means leftwards (over columns).
Example
Description
In the following example the formula 'ReverseCumulativeProductMatrix' is used to take the reverse cumulative product of a matrix over dimension 1 (over rows).
Values parameters
Matrix:
| Column1 | Column2 | Column3 |
|---|
| 2 |
5 |
8 |
| 3 |
6 |
9 |
| 4 |
7 |
10 |
Dimension: 1
Result
Matrix:
| Column1 | Column2 | Column3 |
|---|
| 24 |
210 |
720 |
| 12 |
42 |
90 |
| 4 |
7 |
10 |
The result is a matrix with the cumulative product in the top row.
Related Topics
- CumulativeProductMatrix : The formula 'CumulativeProductMatrix' returns the cumulative product of a matrix over a specified dimension.
- 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.