基于SPSS软件的学生成绩相关性研究

A Research on Correlation of Students’Achievements Based on SPSS Software

针对学生部分科目知识点之间关联性较大的问题,运用SPSS软件对云南师范大学物理与电子信息学院2017级物理学专业64名学生的高等数学两学期期末平均成绩、力学期末成绩及理论力学的期末成绩进行正态分布检验及相关性分析。在得到三者满足正态分布且具有较强的相关性的基础上,以学生的高等数学期末平均成绩、力学期末成绩为自变量,理论力学期末成绩为因变量,建立多元线性回归预测方程,得到回归系数R达0.783,方程拟合程度较好;可在已知学生高等数学与力学期末成绩的条件下,初步预测学生理论力学的期末成绩,并针对分析发现的问题,提出几点建议。

In response to the problem of greater relevance between the knowledge points of some subjects of students,the average scores of advanced mathematics for two semesters,the final results of Mechanics and Theoretical Mechanics of 64 students of the 2017 physics major of the School of Physics and Electronic Information of Yunnan Normal University are analyzed using SPSS.The final results of mechanics are tested for normal distribution and correlation analysis.Based on the fact that the three meet the normal distribution and have a strong correlation,based on the average score of advanced mathematics of students and the final grade of mechanics as independent variables and the final grade of theoretical mechanics as the dependent variable,a multiple linear regression prediction equation is established to obtain regression.The coefficient R reaches 0.783,which indicates that the equation fits well;under the condition of knowing the students’final grades in advanced mathematics and mechanics,the students’preliminary grades in theoretical mechanics can be preliminarily predicted,and some suggestions are proposed for the problems found in the analysis.