Poisson distribution in phpspreadsheet?

Question

PHP

I ran into a problem how to display the results of the Poisson distribution from the Excel table using "phpspreadsheet"
The getCalutatedValue () method leads to a fatal error and overwrites the Excel file. Please let me know if there is a way to do this? And how to do it? Where to dig?

Answer 1

1. connect the class:

use \PhpOffice\PhpSpreadsheet\Calculation\Statistical;

2. We call the static method:
$poisson = Statistical::POISSON($x,$stat, $bool);
The principle is the same as in excel itself, the POISSON.DIST function (x; average; true / false);
I cannot say for the accuracy of the calculations, I compared this script with the values ​​​​purely in excel, they coincide with good accuracy (4 decimal places). This is more than enough for my purposes.
Again, after searching the Internet, I did not find a single article on this topic, so I will leave it here as a solution, MB will come in handy for someone)))