Numbers LINEST function array
Hi, what does the array in the LINEST function look like? And can the whole array be displayed with some function (not like the INDEX function which only gives one cell at y,x)
Thanks!
MacBook Pro 13″, macOS 11.2
Hi, what does the array in the LINEST function look like? And can the whole array be displayed with some function (not like the INDEX function which only gives one cell at y,x)
Thanks!
MacBook Pro 13″, macOS 11.2
If you haven't already done so, you might have a look at the lengthy description of the function at:
https://support.apple.com/guide/functions/linest-ffa5a58341/11.0/web/1.0
You can also find this (and information about other functions) via your menu at Help > Formulas and Functions Help.
SG
Numbers LINEST function array