In-depth Insights into Utilization of Microsoft Excel Matrix Functions Technique for Adsorption Equilibrium Models

Abstract

Adsorption equilibrium models are commonly utilised to analyse the mechanism of adsorption characteristics in a set system and establish the mass-transfer saturation mechanisms. Previous studies were mainly focused on  the description and utilization of the adsorption equilibrium  models, evaluation of the appropriate quality, estimation of the model’s parameters and practical application of adsorption process in the environmental pollution control systems such as water and wastewater treatment. However, insights into utilization of  Microsoft Excel Matrix Functions Technique for adsorption equilibrium models and their mathematical relations were rarely revealed in the literature. This paper provided step by step techniques required in the utilization of Microsoft Excel Matrix Functions in the determination of adsorption equilibrium parameters. Adsorption equilibrium data were obtained from our previous and published articles. Unknown engineering design parameters in the commonly utilized 2-parameters adsorption equilibrium models were determined using matrix functions and Microsoft Excel Solver in Microsoft Excel. Efficacies of these techniques were evaluated statistically using Analysis of Variance, Coefficient of Determination (CD) and correlation coefficient (R). and compared with experimental adsorption equilibrium. The study revealed that there was no significant difference between the adsorption capacities obtained using the two techniques at a 95 % confidence level. It was concluded that the CD and R between experimental adsorption equilibria, Microsoft Excel Solver and matrix simulated adsorption equilibria were between 0.6916 and 0.9535; 0.0492 and 0.9535; and 0.8318 and 0.9765, and 0.2218 and 0.9765, respectively. The paper established that matrix functions and Microsoft Excel Solver in Microsoft Excel are essential tools in the determination of engineering parameters in adsorption process.