Question: Substrate Concentration ( mM ) 4 0 Using MS Excel for non - linear ( MM ) fit is very easy. Enter your x in
Substrate Concentration mM
Using MS Excel for nonlinear MM fit is very easy. Enter your in the column A Enter your y in the column B Estimate your criteria approximately from the graph. Enter calculated y using appropriate formula with the criteria used in the column Set the square of the difference between and values in the column D Calculate the sum of the column D Highlight the cell with that sum. Go into Solver menu. If the Solver is not there, load it up by going into AdIns. Once you've got into the Solver. Set the target cell to minimize by changing cells that have your criteria in Run, it takes about to do it and after OK you get your optimized criteria in the criteria cells. Included is an example of such calculation.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
