Excel LINEST, how to make it into an array function on mac

Copper Contributor

Hi, 

I'm trying to calculate OLS regression on excel but have more than 16 variables so am using LINEST. I can't figure out how to make my basic equation:
=LINEST(A2:A48,B2:B48,FALSE,TRUE)

into an array function on Mac

Can anyone help?

Thanks 

0 Replies