Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-838468%22%20slang%3D%22en-US%22%3EExcel%20LINEST%2C%20how%20to%20make%20it%20into%20an%20array%20function%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-838468%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20calculate%20OLS%20regression%20on%20excel%20but%20have%20more%20than%2016%20variables%20so%20am%20using%20LINEST.%20I%20can't%20figure%20out%20how%20to%20make%20my%20basic%20equation%3A%3CBR%20%2F%3E%3DLINEST(A2%3AA48%2CB2%3AB48%2CFALSE%2CTRUE)%3C%2FP%3E%3CP%3Einto%20an%20array%20function%20on%20Mac%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-838468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
HebeHorsley
Occasional Visitor

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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies