how to do a TRENDLINE (polyfit?how?)

Question

joo 2012-11-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55071-how-to-do-a-trendline-polyfit-how

采纳的回答： Matt Fig

how can i do a trenline like this in matlab

http://i50.tinypic.com/nprtht.jpg

here is the data

http://www.speedyshare.com/ABueW/aaa.xlsx

thank you very much

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Matt Fig 2012-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55071-how-to-do-a-trendline-polyfit-how#answer_66819

编辑：Matt Fig 2012-11-28

See the help for the POLYFIT function.

I see you edited the question to include (polyfit?how?) but what is the problem? Did you actually read the help for POLYFIT (that I even linked for you!) or do you want everyone else to do all the work for you?

If you have difficulty, why not show where you are stuck?

2 个评论
显示无隐藏无

joo 2012-11-28

i am sorry, when i edited i have not seen your answer. my probl in polyfit isthat i don't get a R2 like excel.

even if i do it in excel and then try thsat results in matlab i don't get a good answer

http://www.speedyshare.com/xGgTF/Nova-pasta.rar

can you help me?

Matt Fig 2012-11-29

在 MATLAB Online 中打开

I downloaded your file and got the exact same results as Excel with MATLAB. I called the data N.

>> X = N(22:end,1);
>> Y = N(22:end,2);
>> [pp,s] = polyfit(X,Y,1)
pp =
     -0.0406    0.8654
s = 
          R: [2x2 double]
         df: 76
      normr: 0.2742
>> r_squared = 1 - s.normr^2 / norm(Y-mean(Y))^2
r_squared =
      0.9719

请先登录，再进行评论。

Answer 2

Image Analyst 2012-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55071-how-to-do-a-trendline-polyfit-how#answer_66832

There is a curve fitting toolbox if you want. It handles non-polynomial functions. Check it out.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2012-11-28

Not sure what you looked at but I saw all kinds of curvy and wavy functions being fitted to data.

joo 2012-11-28

yes, i know. but what i need is the black straight line http://i50.tinypic.com/nprtht.jpg that in excel is a trendline as you can see in the excel file< http://www.speedyshare.com/ABueW/aaa.xlsx>. if you npl,ease could helop i would be very grateful. thank you

请先登录，再进行评论。