Evaluation of the Microsoft Excel Solver Spreadsheet-Based Program for Nonlinear Expressions of Adsorption Isotherm Models onto Magnetic Nanosorbent

Abstract

The sorption of basic dyes onto magnetic nanosorbent is commonly used as a novel material to combat powdered activated carbon, which is difficult to handle and separate during water and wastewater treatment. This adsorption method is commonly implemented in water and wastewater treatment due to its low cost and high performance. To explore the feasibility of adsorption, six different nonlinear isotherm models were applied and introduced to evaluate the performance and adsorption mechanisms via Microsoft Excel, and they were then compared to those of MATLAB and OriginPro. The Langmuir best provided the sorption of methylene blue adsorbed for a two-parameter isotherm model. The three-parameter model Toth gave a goodness of fit indicating a heterogeneous sorbent surface. Error function analysis found that the Residual Sum of Squares Error, Chi-square, Coefficient of determination, Average Relative Error, Hybrid Fractional Error Function, Marquardt’s Percent Standard Deviation and Root Mean Square Error provided the best overall results. In comparison, it could be concluded that six isotherm models showed the confidence interval that is simply the best fit at all experimental data points provided by the three software tools. All error function results indicated that the Microsoft Excel Solver function spreadsheet method satisfied all the statistic measures to predict the real variance of the probability of experimental data for all six isotherm models of adsorption of basic dye removal. One added benefit of this Microsoft Excel software tool is the built-in function associated with the desired type of application, which designates the desired type of error/statistical functions not mentioned in this research to the adsorbent materials used.

Keywords

• adsorption
• isotherm
• nonlinear
• Microsoft Excel
• MATLAB
• OriginPro