| Excel在曲线拟合中的应用 |
| |
| 引用本文： | 艾自胜,张长青,单连成,王刚,余金明.Excel在曲线拟合中的应用[J].苏州大学学报(自然科学版),2008,28(5). |
| |
| 作者姓名： | 艾自胜 张长青 单连成 王刚 余金明 |
| |
| 作者单位： | [1]同济大学医学院预防医学教研室,上海200092 [2]上海交通大学附属第六人民医院骨科,上海200233 [3]复旦大学公共卫生学院,上海200032 |
| |
| 摘 要： | 目的探讨Excel在曲线拟合中的应用。方法通过利用Excel可绘制散点图的功能,了解原始数据自变量X和因变量Y间的线性与非线性关系,并由自变量X和（或）因变量Y的自然对数转换后的散点图的情况,决定采用何种曲线拟合。结果X取自然对数与Y作散点图有直线趋势,拟合对数曲线方程;Y取自然对数与X作散点图有直线趋势,拟合指数曲线方程;X取自然对数与Y取自然对数作散点图有直线趋势,拟合幂函数曲线方程;原始数据X和Y成抛物线关系,拟合抛物线方程。结论Excel拟合曲线回归简单易行。
|
| 关 键 词： | Excel 曲线拟合 应用 |
The Application of Excel in Curve Fitting |
| |
| AI Zi-sheng,ZHANG Chang-qing,SHAN Lian-cheng,WANG Cang,YU Jin-ming.The Application of Excel in Curve Fitting[J].Suzhou University Journal of Medical Science,2008,28(5). |
| |
| Authors: | AI Zi-sheng ZHANG Chang-qing SHAN Lian-cheng WANG Cang YU Jin-ming |
| |
| 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, Ther... |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
