Excel在一元线性回归分析中的应用  

Application of Excel in Unitary Linear Regression Analysis

作　　者：杨雄[1] 曾智[1] YANG Xiong;ZENG Zhi(Loudi Vocational Technical College,Loudi Hunan 417000,China)

机构地区：[1]娄底职业技术学院,湖南娄底417000

出　　处：《保山学院学报》2021年第2期66-73,共8页JOURNAL OF BAOSHAN UNIVERSITY

基　　金：2019年度湖南省职业院校教育教学改革研究项目“人工智能背景下高职院校优质课堂建设研究与实践”(项目编号:ZJGB2019173)。

摘　　要：回归分析有预测和因子分析的作用,但在实际运算中计算量大,随着软件的发展,许多运算过程可以用软件来替代;通过分析一元回归的建立过程,以成本预测为案例,应用Excel对案例进行回归方程的求解,并且对Excel的运行结果中的各参数进行具体解释,以至于能够理解各参数的实际意义,进而可以熟悉应用Excel进行回归分析,并能展开实际预测。Regression analysis has the function of prediction and factor analysis,but it has a large amount of calculation in the actual operation.With the development of software,many operation processes can be replaced by software.This paper first analyzes the establishment process of univariate regression,and then takes the cost prediction as a case,applies Excel to solve the regression equation of the case,and specifically explains the parameters in the operation results of Excel,so that we can understand the practical significance of the parameters,and then we can be familiar with the application of Excel for regression analysis,and can carry out the actual prediction.

关 键 词：成本预测 相关系数 回归分析 EXCEL应用 

分 类 号：O13[理学—数学]