How to get polynomial (2nd order) excel trend–line coefficents in matlab?
3 次查看(过去 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!
0 个评论
回答(1 个)
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
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Polynomials 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!