Home

Citation: Liangting Chen, Jianxun Fan, Jinhong Gao, Tianxin Zhang. Applications of diverse data processing software in physical chemistry experiments: a case study on determining acetic acid’s equilibrium constant via conductivity method[J]. University Chemistry, ;2026, 41(6): 457-466. doi: 10.12461/PKU.DXHX202504002 shu

Applications of diverse data processing software in physical chemistry experiments: a case study on determining acetic acid’s equilibrium constant via conductivity method

College of Chemistry and Materials Science, Weinan Normal University, Weinan 714099, Shaanxi Province, China

Corresponding author: Liangting Chen, ltchen@wnu.edu.cn
Received Date: 1 April 2025
Revised Date: 21 July 2025

Physical chemistry experiments typically generate substantial datasets, where manual processing may introduce human errors—an issue effectively addressed by employing data processing software. Currently, multiple software options exist, each offering distinct advantages. This study examines the applications of various computational data processing tools (Excel, Origin, SPSS, MATLAB, and Python) in physical chemistry experiments, with a focus on processing data from the determination of the equilibrium ionization constant of acetic acid as a representative weak electrolyte. The functional characteristics of each software package are systematically compared, particularly regarding their capabilities in data recording, organization, analysis, curve fitting, and visualization. The results demonstrate that for experiments with moderate data volumes, Origin exhibits superior comprehensive performance in both data processing and graphical representation compared to other software, making it particularly suitable for most research tasks.
- Data processing software,
- Physical chemistry experiments,
- Excel,
- Origin,
- SPSS,
- MATLAB,
- Python
1. [1]
2. [2]
3. [3]
  J. Chen, JPCS, 2021, 1992, 022029.
4. [4]
5. [5]
6. [6]
7. [7]
8. [8]
9. [9]
10. [10]
11. [11]
12. [12]
13. [13]
14. [14]
15. [15]
16. [16]
17. [17]
1. [1]
  Zehua Zhao , Xiaoyan An , Jinrong Xu , Ling Yang , Hao Zhao , Zhongyun Wu . Independent Development and Application of Calorimetric Experiment Data Acquisition and Processing Software. University Chemistry, 2025, 40(11): 402-408. doi: 10.12461/PKU.DXHX202505045
2. [2]
  Yan Zhang , Limin Zhou , Xiaoyan Cao , Mutai Bao . Exploring the Application of Artificial Intelligence in Marine-Themed Integrated Physical Chemistry Experiments. University Chemistry, 2025, 40(9): 118-125. doi: 10.12461/PKU.DXHX202503062
3. [3]
  Ying Yang , Yonghan Wu , Zixuan Li , Lu Zhang , Rongqin Lin , Yefan Zhang , Jiquan Liu , Xiaohui Ning , Yan Li , Bin Cui . Visualization Simulation Experiment of Cyclic Voltammetry (CV) Based on Python. University Chemistry, 2025, 40(10): 233-242. doi: 10.12461/PKU.DXHX202412024
4. [4]
  Yanxin Wang , Hongjuan Wang , Yuren Shi , Yunxia Yang . Application of Python for Visualizing in Structural Chemistry Teaching. University Chemistry, 2024, 39(3): 108-117. doi: 10.3866/PKU.DXHX202306005
5. [5]
  Yuejiao Wang , Quanxing Mao , Junshuo Cui , Xiaogeng Feng , Xiaohong Chang , Zhenning Lou , Ying Xiong . 颜色识别式人工智能融入混合碱滴定实验的应用. University Chemistry, 2026, 41(1): 107-113. doi: 10.12461/PKU.DXHX202506020
6. [6]
  Yiying Yang , Rongxiu Zhu , Yuchen Ma , Dongju Zhang . MATLAB-based Visualization of Hydrogen-Like Orbitals and Analysis of Relavant Teaching Problems. University Chemistry, 2025, 40(9): 375-382. doi: 10.12461/PKU.DXHX202411015
7. [7]
  Jinghan Xu , Yang Wang , Donghui Wei . Drawing Cross-Sectional Contour Maps of π Molecular Orbitals. University Chemistry, 2025, 40(3): 23-29. doi: 10.12461/PKU.DXHX202403023
8. [8]
  Youjun Fan , Dandan Cai , Wei Chen , Jianhua Qiu . Exploration and Practice of Ideological and Political Education Reform in Physical Chemistry Experiment. University Chemistry, 2024, 39(4): 119-124. doi: 10.3866/PKU.DXHX202310123
9. [9]
  Wanchun Zhu , Yongmei Liu , Li Wang , Yunshan Bai , Shu'e Song , Xiaokui Wang , Zhongyun Wu , Hong Yuan , Yunchao Li , Fuping Tian , Yuan Chun , Jianrong Zhang , Shuyong Zhang . Suggestions on Operating Specifications of Physical Chemistry Experiment: Measurement and Control of Temperature. University Chemistry, 2025, 40(5): 128-136. doi: 10.12461/PKU.DXHX202503028
10. [10]
  Zhongyun Wu , Li Wang , Xiaokui Wang , Wanchun Zhu , Yuan Chun , Fuping Tian , Yongmei Liu , Yunshan Bai , Hong Yuan , Yufeng Li , Shu'e Song , Jianrong Zhang , Shuyong Zhang . Suggestions on Operating Specifications of Physical Chemistry Experiment: Measurement and Control of Pressure. University Chemistry, 2025, 40(5): 137-147. doi: 10.12461/PKU.DXHX202503027
11. [11]
  Shu'e Song , Xiaokui Wang , Yongmei Liu , Wanchun Zhu , Hong Yuan , Fuping Tian , Yunshan Bai , Yunchao Li , Li Wang , Zhongyun Wu , Yuan Chun , Jianrong Zhang , Shuyong Zhang . Suggestions on Operating Specifications of Physical Chemistry Experiment: Measurement of Viscosity, Density and Optical Properties. University Chemistry, 2025, 40(5): 148-156. doi: 10.12461/PKU.DXHX202503026
12. [12]
  Fuping Tian , Yunshan Bai , Wanchun Zhu , Yufeng Li , Yongmei Liu , Shu'e Song , Hong Yuan , Zhongyun Wu , Li Wang , Xiaokui Wang , Yuan Chun , Jianrong Zhang , Shuyong Zhang . Suggestions on Operating Specifications of Physical Chemistry Experiment: Measurement of Thermal Properties. University Chemistry, 2025, 40(5): 157-164. doi: 10.12461/PKU.DXHX202503054
13. [13]
  Yunchao Li , Hong Yuan , Yuan Chun , Xiaokui Wang , Fuping Tian , Yunshan Bai , Yongmei Liu , Wanchun Zhu , Shu'e Song , Zhongyun Wu , Li Wang , Yufeng Li , Jianrong Zhang , Shuyong Zhang . Suggestions on Operating Specifications of Physical Chemistry Experiment: Measurement of Electrical Properties. University Chemistry, 2025, 40(5): 165-177. doi: 10.12461/PKU.DXHX202503055
14. [14]
  Fuping Tian , Yue Dai , Feifei Huang , Yu Wang , Xinkui Wang , Xuzhen Wang , Wenfeng Jian . 物理化学实验课程思政的建设与实践. University Chemistry, 2025, 40(6): 22-27. doi: 10.12461/PKU.DXHX202408074
15. [15]
  Wanchun Zhu , Bing Zhou , Tengfeng Xie , Jingqi Guan , Xu Zhao . 物理化学综合设计实验教学思考与体会. University Chemistry, 2025, 40(8): 33-37. doi: 10.12461/PKU.DXHX202409139
16. [16]
  Zhusheng Huang , Wei Xue , Yongzheng Chang , Lianhui Wang , Zhimin Luo . Teaching Reform in Physical Chemistry Experiments: Cultivating Students’ Innovation and Practical Skills. University Chemistry, 2025, 40(10): 10-16. doi: 10.12461/PKU.DXHX202411019
17. [17]
  Yaoyue Yang , Weishang Jia , Zhaoxia Ma , Xiaole Jiang , Yajuan Wu . Innovative Teaching Design and Practice of a Blended First-Class Course on “Physical Chemistry Experiment” in Ethnic Universities. University Chemistry, 2025, 40(7): 71-78. doi: 10.12461/PKU.DXHX202409118
18. [18]
  Yujing Chen , Hongqun Ouyang , Dan Zhao , Yanyan Chu , Zhengping Qiao . Recommendations for the Content and Instruction of the Physical Chemistry Experiment “Construction of Ternary Liquid-Liquid Phase Diagrams”. University Chemistry, 2025, 40(7): 359-366. doi: 10.12461/PKU.DXHX202409120
19. [19]
  Yuan Chun , Yongmei Liu , Fuping Tian , Hong Yuan , Shu'e Song , Wanchun Zhu , Yunchao Li , Zhongyun Wu , Xiaokui Wang , Yunshan Bai , Li Wang , Jianrong Zhang , Shuyong Zhang . Suggestions on Operating Specifications of Physical Chemistry Experiment: Measurement of Colloidal and Surface Chemical Properties, Molecular Structure and Properties. University Chemistry, 2025, 40(5): 178-188. doi: 10.12461/PKU.DXHX202503053
20. [20]
  Yongmin Zhang , Shuang Guo , Mingyue Zhu , Menghui Liu , Sinong Li . Design and Improvement of Physicochemical Experiments Based on Problem-Oriented Learning: a Case Study of Liquid Surface Tension Measurement. University Chemistry, 2024, 39(2): 21-27. doi: 10.3866/PKU.DXHX202307026

Get Citation

PDF

XML

Metrics

PDF Downloads(0)
Abstract views(133)
HTML views(33)

通讯作者: 陈斌, bchen63@163.com

1.
沈阳化工大学材料科学与工程学院沈阳 110142

Address：Zhongguancun North First Street 2,100190 Beijing, PR China Tel: +86-010-82449177-888

DownLoad: Full-Size Img PowerPoint

Return