LINEST for Polynomial Fit - JDW 2201

This video details a means of generating polynomial curve fits in Excel - a.k.a trendlines - using the built-in LINEST function. It was created for the MECE-102 Engineering Mechanics Laboratory course in Mechanical Engineering at Rochester Institute of Technology.

[@alirezasadeghifar3815]

Thank you! Very helpful!

[@smunwin]

Thanks, very useful.

[@ChemEngPro]

This a great video! Thank you sir!

[@cedarxeda2665]

Thanks can, whats the easiest way to change the slop a bit?

[@franciscopereira2993]

I use commas as a decimal separator so when i do a linest for a 2 degree polinomial it just gives me the matrix of a linear regression, and when i try to this “;” it gives me a value error. Pls help

[@soubac1]

Is this solved? I have the same issue...

[@zeke1750]

@@soubac1 I found a solution! Go to control panel, clock and region, region, additional settings, and in the numbers tab you have to change decimal symbol to ".", and list separator to ","
This solved the issue for me, I hope it helps!