应用Excel进行回归分析教学的探索

On the Application of Excel in the Teaching of Regression Analysis

在高职院校中,高等数学若采用纯理论教学,学生难理解,不爱学,教学效果也不乐观,因此在教学中要有创新,如讲解经济数学中的一元回归分析内容,若引入成本预测回归分析模型,并运用Excel进行成本预测的结果实现,进而在实际操作中传授知识,能够提高学生的学习兴趣和动手能力。

In higher vocational colleges, students tend to find it difficult to learn higher mathematics if "pure theory" teaching method is adopted. Therefore, there should be innovations in the teaching of it. For example, when explaining the content of unitary regression analysis in economic mathematics, if the regression analysis model of cost forecast is introduced and the result of cost forecast is realized by Excel, the knowledge will be imparted in practice, and the students’ learning interest will be increased and the practical ability will be improved.