HOW Calculation Statistical function LINEST

Topics: Developer Forum
Oct 23, 2014 at 1:05 PM
Edited Oct 23, 2014 at 1:09 PM
Hello
I use the function LINEST but
Me need calculation for example

In excel
=LINEST(A1:A10;B1:B10;1;1)

in php
$a=array(1,...,10);
$b=array(1,....,10);
$n=new PHPExcel_Calculation_Statistical();
$n->LINEST($a,$b,1,1);

its ok

But if we have in excel
=LINEST(A1:A10;B1:C10;1;1)


in php
$a=array(1,...,10);
$b[0]=array(1,....,10);
$b[1]=array(1,....,10);
$b[2]=array(1,....,10);
$n=new PHPExcel_Calculation_Statistical();
$n->LINEST($a,$b,1,1);

don't work

what to do?

excel calculate