基于Excel回归建模的响应曲面法优化高泥氧化铜矿酸浸工艺
CSTR:
作者:
作者单位:

1.昆明理工大学,云南昆明 650093 ;2.攀枝花学院,四川攀枝花 617000

作者简介:

王普蓉(1982—),陕西富平人,硕士,讲师,博士在读,研究方向为资源综合利用。

通讯作者:

中图分类号:

TF811;TF803.3

基金项目:

四川省科技计划重点项目“攀枝花含钛高炉渣提钛关键技术研究与应用”(2022YFS0458)


Optimization of acid leaching process for high-clay copper oxide ore using response surface methodology based on excel regression modeling
Author:
Affiliation:

1.Kunming University of Science and Technology, Kunming 650093 , China ;2.Panzhihua University, Panzhihua 617000 , China

Fund Project:

  • 摘要
  • |
  • 图/表
  • |
  • 访问统计
  • |
  • 参考文献
  • |
  • 相似文献
  • |
  • 引证文献
  • |
  • 资源附件
  • |
  • 文章评论
    摘要:

    针对单因素工艺试验及Design-Expert软件成本高的问题,本研究以高泥氧化铜矿硫酸浸出为研究对象,采用中心复合设计(CCD)开展20组酸浸试验,以硫酸浓度、液固比和浸出时间为自变量,铜浸出率为响应值,利用Excel建立二次回归模型并进行方差分析及响应曲面最优解求解。结果表明:模型高度显著(F=91.14,R2=0.988);因素对浸出率的影响力排序为硫酸浓度>浸出时间>液固比,硫酸浓度与液固比的交互作用呈显著负面影响;响应曲面最优解求解得到的最优工艺条件为硫酸浓度96.16 g/L、液固比3.26 mL/g、浸出时间4.32 h,预测浸出率83.39%,验证试验获得浸出率84.15%,二者吻合良好,表明模型的预测准确性和优化结果的可靠性。本研究方法以Excel替代专业统计软件,不仅为高泥氧化铜矿的硫酸浸出工艺提供了一种高效的参数优化策略,而且为矿物加工及其他相关领域的工艺优化提供了一种成本效益高、操作简便的解决方案。

    Abstract:

    To address the high cost of single-factor process experiments and Design-Expert software, this study investigates the sulfuric acid leaching of high-clay copper oxide ore. A central composite design (CCD) was employed to conduct 20 sets of acid leaching experiments. With sulfuric acid concentration, liquid-to-solid ratio, and leaching time as independent variables, and copper leaching rate as the response value, a quadratic regression model was established using Excel. Analysis of variance (ANOVA) and response surface optimization were performed to determine the optimal solution. The results show that the model is highly significant (F = 91. 14, R2 = 0. 988). The influence of factors on the leaching rate follows the order: sulfuric acid concentration > leaching time > liquid-to-solid ratio. The interaction between sulfuric acid concentration and liquid-to-solid ratio exhibits a significant negative effect. The optimal process conditions obtained from the response surface optimization are: sulfuric acid concentration of 96. 16 g/L, liquid-to-solid ratio of 3. 26 mL/g, and leaching time of 4. 32 h, with a predicted leaching rate of 83. 39%. A verification experiment yielded a leaching rate of 84. 15%, showing good agreement with the prediction, indicating the predictive accuracy of the model and the reliability of the optimization results. By replacing professional statistical software with Excel, this method not only provides an efficient parameter optimization strategy for the sulfuric acid leaching process of high-clay copper oxide ore but also offers a cost-effective and easy-to-operate solution for process optimization in mineral processing and other related fields.

    参考文献
    相似文献
    引证文献
引用本文

王普蓉,徐国印,戴惠新,等. 基于Excel回归建模的响应曲面法优化高泥氧化铜矿酸浸工艺[J]. 中国有色金属,2026,55(4):96-104.

复制
分享
相关视频

文章指标
  • 点击次数:
  • 下载次数:
  • HTML阅读次数:
  • 引用次数:
历史
  • 收稿日期:2026-02-03
  • 最后修改日期:2026-04-01
  • 录用日期:
  • 在线发布日期: 2026-09-03
  • 出版日期:
文章二维码