ERIC Number: EJ1033278
Record Type: Journal
Publication Date: 2014-Jul
Abstractor: As Provided
Reference Count: 20
Diagnosis of Enzyme Inhibition Using Excel Solver: A Combined Dry and Wet Laboratory Exercise
Dias, Albino A.; Pinto, Paula A.; Fraga, Irene; Bezerra, Rui M. F.
Journal of Chemical Education, v91 n7 p1017-1021 Jul 2014
In enzyme kinetic studies, linear transformations of the Michaelis-Menten equation, such as the Lineweaver-Burk double-reciprocal transformation, present some constraints. The linear transformation distorts the experimental error and the relationship between "x" and "y" axes; consequently, linear regression of transformed data is less accurate when compared with methodologies that use nonlinear regression. However, linear transformations are widely used. Explanations for this are the facility to determine model parameters by hand calculations, and until recently, the use of nonlinear regression was difficult as specialized software was not readily available to most scientists and students. Because utilization of personal computers is widespread, these constraints are no longer applicable. This work describes how to perform nonlinear regression with the Solver supplement of Microsoft Office Excel. It is easy to use and to view the results graphically. The "F"-test was applied to discriminate between models. These methodologies are important in any biochemistry syllabus and can be used to create an active-learning environment where students discriminate between different kinetic models and explore their own experimental results based on several hypotheses.
Descriptors: Science Instruction, Science Laboratories, Kinetics, Regression (Statistics), Computation, Computer Software, Educational Technology, Spreadsheets, Biochemistry, Models, Science Experiments, College Science, Undergraduate Study, Equations (Mathematics)
Division of Chemical Education, Inc and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail: firstname.lastname@example.org; Web site: http://pubs.acs.org/jchemeduc
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education; Postsecondary Education
Authoring Institution: N/A