本平台为互联网非涉密平台,严禁处理、传输国家秘密或工作秘密

EXCEL在烤烟收购风险发生曲线拟合中的应用

Application of EXCEL in Fitting of Tobacco Purchasing Risk Occurrence Curve

  • 摘要: 为了有效控制烤烟收购风险发生,拓展收购过程管理的方法,利用EXCEL绘制散点图的功能,拟合了烤烟收购风险发生曲线。结果表明:源数据x(收购周数)与y(周收购风险指数)间呈抛物线型结构,收购风险发生曲线拟合目标为二~五次多项式函数模型。其中,三次多项式具有拟合精度较高和计算操作简单易行等特点,适合用于收购风险发生曲线模型的建立。

     

    Abstract: To effectively control the risk in flue-cured tobacco purchasing and extend purchasing process management method, the curve representing tobacco purchasing risk was plotted by the aid of EXCEL. The results showed that the relationship between variables x (purchasing weeks) and y (purchasing risk index of weeks) could be represented by a parabolic curve. Higher degree polynomial curves were tested, it was found that the 3rd-degree polynomial curve was of high fitting precision and simple in calculation, which was more suitable for the establishment of mathematical model of purchasing risk.

     

/

返回文章
返回