How to get polynomial (2nd order) excel trend–line coefficents in matlab?

5 次查看(过去 30 天)
If I use [p,S,mu] = polyfit(X,y,2), the coefficents I get are very different from the ones I find in excel. Should I use another function? How can I get the R squared?
Thank you in advance!

回答(1 个)

Guillaume
Guillaume 2019-8-22
编辑:Guillaume 2019-8-22
As documented, the [p, S, mu] output of polyfit centers and scales the returned polynomial, so it returns a different polynomial than the [p, S] ouput. If you want the same polynomial as Excel, use the [p, S] output.
As for the value that excel gives you, matlab does not give you that straight, but as explained by John here, you can calculate it:
[p, S] = polyfit(X, y, 2) %if you want the same polynomial as excel.
r2 = 1 - (S.normr/norm(y - mean(y)))^2

类别

Help CenterFile Exchange 中查找有关 Polynomials 的更多信息

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by