Difference in Matlab and Excel
7 次查看(过去 30 天)
显示 更早的评论
Hi Experts,
I am trying to do linear regression but there is a difference in matlab and excel.
Can i what could be the reason and how to match data?
2 个评论
Image Analyst
2020-7-13
How much of a difference? You forgot to attach your data, forgot to attach your m-file, forgot to attach your Excel script, and forgot to read this link.
回答(1 个)
KSSV
2020-7-13
Excel fits a striaght line to the data.....to get the same value use polyfit of MATLAB.
p = polyfit(X,Y,1) ;
p(1)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!