Forum Discussion

HebeHorsley's avatar
HebeHorsley
Copper Contributor
Sep 05, 2019

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

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 

No RepliesBe the first to reply

Resources