00 Votes

PhpSpreadsheet: Has anyone used or know how to use the linest function?

Question by Guest | 2019-06-26 at 20:01

I need to get the 10 element linest statistics array. I only see the first element, slope. And last element, residual ss.

If I use getActiveSheet()->getCell('A32') the valuse is the slope. If I use getCell('A32')->getCalculatedValue(), I see the residual ss valuse. I have tried toArray, and fromArray, and preselecting a range of cells as you do, when running linest in Excel.

ReplyPositiveNegative

Related Topics

Important Note

Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.

Participate

Ask your own question or write your own article on askingbox.com. That’s how it’s done.