The Application of Excel in Curve Fitting

AI Zi-sheng,ZHANG Chang-qing,SHAN Lian-cheng,WANG Gang,YU Jin-ming
2008-01-01
Abstract: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 log- arithmic 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 curve 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 e- quation 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.
What problem does this paper attempt to address?