Difference in Matlab and Excel
显示 更早的评论
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.
KATARI LOKESH
2020-7-13
Hi , sorry
Here I attached the both datas. Please check.
clear all;close all;clc;
Y= [30;36;1;26;10;12;12;34;0;47;1;49;29];
X= [21;21;19;38;50;12;35;5;17;30;46;20;48];
b= regress(Y,X)
%% output b = 0.592136616
Here I attached the both values
in matlab I a getting b= 0.5921 and in excel I am getting X = -0.213
回答（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)
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2020-7-13
2020-7-13
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
