Excel在曲线拟合中的应用

The Application of Excel in Curve Fitting

目的探讨Excel在曲线拟合中的应用。方法通过利用Excel可绘制散点图的功能,了解原始数据自变量X和因变量Y间的线性与非线性关系,并由自变量X和(或)因变量Y的自然对数转换后的散点图的情况,决定采用何种曲线拟合。结果X取自然对数与Y作散点图有直线趋势,拟合对数曲线方程;Y取自然对数与X作散点图有直线趋势,拟合指数曲线方程;X取自然对数与Y取自然对数作散点图有直线趋势,拟合幂函数曲线方程;原始数据X和Y成抛物线关系,拟合抛物线方程。结论Excel拟合曲线回归简单易行。

Objective To explore the application of Excel in curve fitting. Methods At first, the relationship of linear or non-linear between dependent X and independent Y in original data can be distinguished by scatter diagram which can be made through Excel software. The scatter diagram of logarithmic transformation between dependent X and/or independent Y decides which curve to be fitted. Results There was a linear trend between logarithmic X and Y, the equation of logarithmic eurve was able to be fitted, There was a linear trend between logarithmic Y and X, the equation of exponential curve was able to be fitted, There was a linear trend between logarithmic X and logarithmic Y, the equation of power curve can be fitted. There is a parabola pattern between X and Y, the equation of parabola was able to be fitted. Conclusion It is simple and feasible in curve fitting through Excel.