Excel 101: Multiple regression with LINEST

LINEST is one of the go-to functions to use for multiple regression analysis in Excel. Today we are investigating the application of LINEST in detail as well as studying each and every output it provides.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Excel!
Please consider supporting NEDL on Patreon: / nedleducation

[@NEDLeducation]

You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7
Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation

[@ZhaoLance]

Srsly the best video out there that explains the linest function.

[@surendrabarsode8959]

Very clearly explained. Thanks. This tutorial should be made compulsory for all 12th grade students !

[@surendrabarsode8959]

Very clearly explained. Thanks Savva. This tutorial should be made compulsory for all 12th grade students!!

[@NEDLeducation]

Hi Surendra, and thanks for the kind words! Stay tuned for more Excel tutorials in the future!

[@dawny1923]

Awesome job and thank you

[@fultrim]

@NEDLeducation If your X variables are not in columns next to each other you can write it like this C3#:G3#:ZZ3# where C G and ZZ are the columns. It will select the entire dataset in that column and can handle skipped columns.

[@revgro]

Nice explanation. Very useful. Thanks for the video.

[@fabiosanti7153]

This Excel101 series is extremely interesting and helpful!

[@jameshimelic4454]

well done. no fluff. right to the point.

[@wajihchtiba34]

Thank you very much ! finally understood regressions details !

[@logankauffman6562]

Great explanation. Thank you very much!

[@MartaPawecka]

What about the function returning N/A values? What can be done about it?