%% 一元线性回归
clear all;clc
x=[23.8 27.6 31.6 32.4 33.7 34.9 43.2 52.80 63.80 73.40];
y=[41.4 51.8 61.7 67.9 68.7 77.5 95.9 137.4 155.0 175.0];
figure(1);
plot(x,y,'k-o','MarkerFaceColor','k');grid on;
xlabel('X(职工工资总额)','fontsize',12);
ylabel('Y(商品零售总额)','fontsize',12);
Lxx=sum((x-mean(x)).^2);
Lxy=sum((x-mean(x)).*(y-mean(y)));
b1=Lxy/Lxx;
b0=mean(y)-b1*mean(x);
y1=b1*x+b0;
hold on;
plot(x,y1,'b-o','MarkerFaceColor','b');grid on;
legend('原始数据','一元线性回归模型');
%% 将数据保存为Excel文件
Data=[x',y',y1'];
[m,n]=size(Data);
Data_cell=mat2cell(Data,ones(m,1),ones(n,1));
title={'x','y','y1'};
result=[title;Data_cell];
s = xlswrite('wind.xlsx', result);
下图为matlab编程生成的数据图
下图为matlab编程生成的Excel数据