Question: USE EXCEL- use excel use built-in excel solver add in. Please include what goes on the solver (solver inputs) USE EXCEL- use excel use built-in
USE EXCEL- use excel use built-in excel solver add in. Please include what goes on the solver (solver inputs)

USE EXCEL- use excel use built-in excel solver add in. Please include what goes on the solver (solver inputs)
The adsorption process can be used to remove a volatile organic compounds (VOCs) from a gas or liquid mixture. The Langmuir adsorption isotherm (Eq. (3)) describes the equilibrium between adsorbate and adsorbent. qe=1+KLCeqmKLCe Where qe is the mol of component adsorbed in 1 gram of adsorbent and Ce is moles of adsorbate in The table below shows the equilibrium data of the adsorption of a chemical substance on activation carbon (adsorbent) at 80C : Your tasks: (a) Linearize the original model and then use linear regression to estimate the unknown parameters qm and KL in the Eq. (3). (b) Use nonlinear regression to determine the unknown parameters qm and KL using the results of (a) as initial estimates. (c) Visualize (plot experimental data along with the model with parameters from linear regression and the model with parameters from nonlinear regression
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
