基于Excel软件利用矩阵运算模拟多元线性回归模型的应用分析  

Application and Analysis of Multiple Linear Regression Model Based on the Matrix Computing of Excel Software

作　　者：岳秋菊[1] 王丽 张娟[2] YUE Qiuju;WANG Li;ZHANG Juan(School of Information Engineering,Lanzhou City University,Lanzhou Gansu 730070;School of Economics and Management,Lanzhou City University,Lanzhou Gansu 730070)

机构地区：[1]兰州城市学院信息工程学院,甘肃兰州730070 [2]兰州城市学院经济管理学院,甘肃兰州730070

出　　处：《甘肃高师学报》2024年第5期66-70,共5页Journal of Gansu Normal Colleges

基　　金：兰州城市学院本科教学研究与改革重点项目“一流本科课程背景下高等代数选讲课程建设的探索与应用”(2023-jy-07)。

摘　　要：文章基于多元线性回归分析的基本原理,模拟多元线性回归方程的矩阵,研究专业基础课程与专业核心课程的相关性.利用Excel软件中的矩阵函数的运算,对兰州城市学院财务管理专业110名学生的线性代数、概率论与数理统计和财务管理学课程卷面成绩为样本数据进行正态性分析.结果表明,课程成绩服从正态分布,据此建立卷面成绩的多元线性回归预测模型,通过对数据样本的方差分析和对统计量进行检验和统计推断,表明方程拟合度较好,以此帮助师生预测财务管理学课程成绩,针对三门课程预测的线性关系,对教师提出了一些教学建议.Based on the basic principles of multiple linear regression analysis,the matrix form of the multiple linear regression equation is simulated.In order to study the correlation between professional basic courses and professional core courses,the matrix function in Excel software is used to analyze the normality of the test scores of linear algebra,probability theory and mathematical statistics,and financial management of 110 students majoring in financial management in Lanzhou City University.The results show that the course scores obey the normal distribution.Based on this,a multivariate linear regression prediction model for the scores of the volume is established.Through the analysis of variance of the data samples and the test and statistical inference of the statistics,it shows that the equation has a good fitting degree,so as to help teachers and students predict the scores of the financial management course.In view of the linear relationship of the prediction of the three courses,some suggestions are put forward for teachers in the teaching process.

关 键 词：EXCEL软件 多元线性回归模型 预测模型 显著性检验 

分 类 号：O213[理学—概率论与数理统计]