How to get polynomial (2nd order) excel trend–line coefficents in matlab?
    6 次查看(过去 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!