金属铜作为一种十分重要的资源在世界经济发展的过程中发挥着越来越重要的作用。金属铜被广泛地运用在建筑、装饰、电线电缆制造等方面。期铜价格不仅对企业投资决策很重要，而且对矿业权评估来说也是一个很重要的参数。文章以期铜每年的中间价格作为历史数据，根据散点图，运用对多项式拟合方法对其价格进行预测。分别用excel的添加趋势线法和变量替换法这两种方法，基于同一数据，进行了非线性拟合，综合评判后，认为第一种方法较优。%Copper as an important resource in the process of development of the world economy is playing an more and more important role. Copper is widely used in construction, decoration, electric wire and cable manufacturing etc. Copper price is important not only for enterprise decisions, but also for mining right evaluation. This paper takes the annual medium prices of the copper as historical data, uses the polynomial fitting method to estimate the price based on the scatter plot diagram. Based on the same data, it uses respectively the excel add a trend line method and the variable substitution method for a nonlinear fitting, the first approach is preferred after an integrated appraisal.
展开▼
