use solver add-on in excel

Rama Rao Karri Thank you very much

Using origin pro software (rectangular hyperbola function) Langmuir modeling can be easily drawn and its parameters can be automatically obtained.

Md. Aminul Islam Thank you for the reply, but Langmuir model is a homographic function. Then why fit it with hyperbola function?!

add a solver in excel

Using origin software can be draw and obtain the parameters of isotherms models ,

OriginPro allows you to fit experimental data to mathematical models setting a default objetive function. You can actually can type the models (independent and dependent variables) and select the numerical method to solve it. The output gives you the model parameters (with an error interval) and the R2 as a fitting goodness. Solver in Excel is a good first approximation though as Abdelghani Hsini and Rama Rao Karri mentioned.

i think it will be suitable to use:

origin pro

or

kaleidagraph

You can use transformed variables before data fitting in excel

Fatima , how we cab do in origin non linaire pls

If any one can explain me the errer bar ,what the uses?? What résult can found??

Dear Naji

Thank you for the link it helped a lot. Can you please help with how to go about calculating the kinetic models specially the pseudo first order and the pseudo second order? If any one can also contribute it will be of great help

I do agree with David De Haro-Del Rio

Conduct the isotherm experiments for different values of initial concentration (Co). After equilibrium we get equilibrium concentration (Ce), then calculate adsorption capacity at equilibrium (qe). Then plot a graph of Ce on x-axis and Ce/qe on y-axis. From the slope and intercept find the values of model constants (qm and Kl). Then the non-linear form of the equation qe= (qm*Kl*Ce)/(1+Kl*Ce).

In the above equation, take any Ce value, substitute the calculated values of qm and Kl, then calculate the value of qe. Similarly calculate the values of qe for the Ce value. Plot Ce on x-axis and qe on y-axis which will give the non-linear form of Langmuir isotherm. In the plot, show the experimental values of qe by points and the non- linear form of Langmuir isotherm by curve.

First of all, there is no such thing as a non-linear form of Langmiur like equation. It is a hyperbolic function that is non-linear - it was and will remain. Secondly, for usually 5-7 points, a calculator is enough.

https://www.researchgate.net/post/I_want_to_know_what_software_these_images_are_drawn_with

This paper has step by step

http://www.jwsponline.com/uploadpic/Magazine/pp223-237%20JWS-A-13-013.pdf

Here is link

https://youtu.be/wWIZyxrp04I

This video shows how to fit Jovanovic isotherm model nonlinear equation easily using originpro. #aminulcheminnovation #chemcolony #aminulsir #aminulchem https://youtu.be/1w7kNbDabyg