A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet

Computer Methods and Programs in Biomedicine
A M Brown

Abstract

The objective of this present study was to introduce a simple, easily understood method for carrying out non-linear regression analysis based on user input functions. While it is relatively straightforward to fit data with simple functions such as linear or logarithmic functions, fitting data with more complicated non-linear functions is more difficult. Commercial specialist programmes are available that will carry out this analysis, but these programmes are expensive and are not intuitive to learn. An alternative method described here is to use the SOLVER function of the ubiquitous spreadsheet programme Microsoft Excel, which employs an iterative least squares fitting routine to produce the optimal goodness of fit between data and function. The intent of this paper is to lead the reader through an easily understood step-by-step guide to implementing this method, which can be applied to any function in the form y=f(x), and is well suited to fast, reliable analysis of data in all fields of biology.

References

Nov 1, 1992·Analytical Biochemistry·M L Johnson
Dec 1, 1995·Trends in Pharmacological Sciences·W P Bowen, J C Jerman

❮ Previous
Next ❯

Citations

Oct 13, 2010·Pflügers Archiv : European journal of physiology·Asser Nyander PoulsenDan Arne Klaerke
Nov 12, 2005·Biomechanics and Modeling in Mechanobiology·R Wulandana, A M Robertson
Jun 15, 2012·Photosynthesis Research·Phillip A Davis, Roger P Hangarter
Jul 13, 2004·Analytical Biochemistry·Rumin ZhangWilliam Windsor
Jun 10, 2004·Neurochemistry International·Angus M BrownBruce R Ransom
Aug 31, 2011·Langmuir : the ACS Journal of Surfaces and Colloids·Kyungho KangPranav Shrotriya
Feb 6, 2010·Nature Protocols·Gerdi Kemmer, Sandro Keller
Jan 12, 2011·Proceedings of the National Academy of Sciences of the United States of America·Timothy J MerkelJoseph M DeSimone
Jul 3, 2013·The Journal of Biological Chemistry·Alejandro E LerouxR Luise Krauth-Siegel
Feb 25, 2011·Journal of Neurophysiology·Noboru Iwagaki, Gareth B Miles
Sep 17, 2013·PloS One·Niels GrasmeijerHenderik W Frijlink
Sep 14, 2012·International Journal of Nanomedicine·Deborah J GorthB Sonny Bal
Oct 31, 2012·International Journal of Molecular Sciences·Johan O WestmanMohammad J Taherzadeh
Jan 12, 2010·The Review of Scientific Instruments·Bryan S A Tatone, Giovanni Grasselli
Dec 18, 2013·Proceedings of the National Academy of Sciences of the United States of America·Hanna KwonEdward N Baker
Dec 2, 2014·Plant Methods·Wannes VoorendHilde Muylle
Feb 9, 2016·Molecular and Biochemical Parasitology·Blessing MusundaR Luise Krauth-Siegel
Aug 1, 2015·Molecules : a Journal of Synthetic Chemistry and Natural Product Chemistry·Brooke A AndersonPatrick J Hrdlicka
Apr 8, 2003·The Journal of Physiology·Angus M BrownBruce R Ransom
Dec 4, 2015·Analytical and Bioanalytical Chemistry·Helen Louise LundCharles Haynes
May 10, 2005·The Journal of Physiology·G B MilesR M Brownstone
Jun 19, 2012·Journal of Controlled Release : Official Journal of the Controlled Release Society·Timothy J MerkelJoseph M DeSimone
Jul 19, 2011·Computer Methods and Programs in Biomedicine·Ronald J W LambertAngus M Brown
Mar 15, 2011·Computer Methods and Programs in Biomedicine·A Ghanadzadeh GilaniM S Zakerhamidi
Jul 6, 2010·Analytical Biochemistry·Tzu-Chen YenTze-Chein Wun
Aug 10, 2013·Chemical Research in Toxicology·Stephen R Lantz, John E Casida
Feb 5, 2008·Behavioural Processes·Alana E Dulaney, Matthew C Bell
Nov 25, 2014·Cell·Maggie S Y YeungJonas Frisén
Mar 3, 2007·Chembiochem : a European Journal of Chemical Biology·Sandro KellerAlfred Blume
Nov 21, 2012·Biochemistry and Molecular Biology Education : a Bimonthly Publication of the International Union of Biochemistry and Molecular Biology·Michael A HefflerJennifer F Kugel
Jan 13, 2012·The New Phytologist·Clare TrinderDavid Robinson
Apr 5, 2012·Biotechnology and Bioengineering·Jose R VallejosGovind Rao
Mar 23, 2004·Analytical Biochemistry·Jeffrey D Gawronski, David R Benson
Jul 31, 2013·Bulletin of Environmental Contamination and Toxicology·Jennifer M DaleyKen G Drouillard
Nov 28, 2006·Analytical Biochemistry·Jonathan D Parsons

❮ Previous
Next ❯

Related Concepts

Trending Feeds

COVID-19

Coronaviruses encompass a large family of viruses that cause the common cold as well as more serious diseases, such as the ongoing outbreak of coronavirus disease 2019 (COVID-19; formally known as 2019-nCoV). Coronaviruses can spread from animals to humans; symptoms include fever, cough, shortness of breath, and breathing difficulties; in more severe cases, infection can lead to death. This feed covers recent research on COVID-19.

Blastomycosis

Blastomycosis fungal infections spread through inhaling Blastomyces dermatitidis spores. Discover the latest research on blastomycosis fungal infections here.

Nuclear Pore Complex in ALS/FTD

Alterations in nucleocytoplasmic transport, controlled by the nuclear pore complex, may be involved in the pathomechanism underlying multiple neurodegenerative diseases including Amyotrophic Lateral Sclerosis and Frontotemporal Dementia. Here is the latest research on the nuclear pore complex in ALS and FTD.

Applications of Molecular Barcoding

The concept of molecular barcoding is that each original DNA or RNA molecule is attached to a unique sequence barcode. Sequence reads having different barcodes represent different original molecules, while sequence reads having the same barcode are results of PCR duplication from one original molecule. Discover the latest research on molecular barcoding here.

Chronic Fatigue Syndrome

Chronic fatigue syndrome is a disease characterized by unexplained disabling fatigue; the pathology of which is incompletely understood. Discover the latest research on chronic fatigue syndrome here.

Evolution of Pluripotency

Pluripotency refers to the ability of a cell to develop into three primary germ cell layers of the embryo. This feed focuses on the mechanisms that underlie the evolution of pluripotency. Here is the latest research.

Position Effect Variegation

Position Effect Variagation occurs when a gene is inactivated due to its positioning near heterochromatic regions within a chromosome. Discover the latest research on Position Effect Variagation here.

STING Receptor Agonists

Stimulator of IFN genes (STING) are a group of transmembrane proteins that are involved in the induction of type I interferon that is important in the innate immune response. The stimulation of STING has been an active area of research in the treatment of cancer and infectious diseases. Here is the latest research on STING receptor agonists.

Microbicide

Microbicides are products that can be applied to vaginal or rectal mucosal surfaces with the goal of preventing, or at least significantly reducing, the transmission of sexually transmitted infections. Here is the latest research on microbicides.