create table testscore (
subject int unsigned not null auto_increment,
age int unsigned not null,
sex enum(‘M’,‘F’),
score int,
primary key(subject)
)ENGINE = InnoDB DEFAULT CHARSET = utf8;
insert into testscore values(null,5,‘M’,5);
insert into testscore values(null,5,‘M’,4);
insert into testscore values(null,5,‘F’,6);
insert into testscore values(null,5,‘F’,7);
insert into testscore values(null,6,‘M’,8);
insert into testscore values(null,6,‘M’,9);
insert into testscore values(null,6,‘F’,4);
insert into testscore values(null,6,‘F’,6);
insert into testscore values(null,7,‘M’,8);
insert into testscore values(null,7,‘M’,6);
insert into testscore values(null,7,‘F’,9);
insert into testscore values(null,7,‘F’,7);
insert into testscore values(null,8,‘M’,9);
insert into testscore values(null,8,‘M’,6);
insert into testscore values(null,8,‘F’,7);
insert
计算线性回归方程和相应系数
最新推荐文章于 2022-12-02 17:21:12 发布
这篇博客介绍了如何在MySQL中计算线性回归方程和相关系数。通过创建一个testscore表并插入数据,然后利用SQL查询计算了年龄(X)和分数(Y)的均值、总和、变量平方和以及乘积和。接着,根据这些统计值计算出回归方程的斜率(b)和截距(a),最后得出线性回归方程Y = bX + a,适用于数据分析和预测。
摘要由CSDN通过智能技术生成