烟草科技Issue(7)：80-82,3.
EXCEL在烤烟收购风险发生曲线拟合中的应用
Application of EXCEL in Fitting of Tobacco Purchasing Risk Occurrence Curve
摘要
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.关键词
烤烟/周收购风险指数/多项式曲线拟合/拟合精度Key words
Tobacco/Purchasing risk index of week/Multinomial curve fitting/Fitting precision分类
轻工纺织引用本文复制引用
李震,邵忠顺,马莹,郭亚利,胡向丹..EXCEL在烤烟收购风险发生曲线拟合中的应用[J].烟草科技,2013,(7):80-82,3.基金项目
黔西南州烟草公司科技项目"基于合作社建设的博弈理论研究——以兴义市为例"(wkhx2011020). （wkhx2011020）
