A non-linear regression analysis program for describing electrophysiological data with multiple functions using Microsoft Excel

Computer Methods and Programs in Biomedicine
Angus M Brown

Abstract

The objective of this present study was to demonstrate a method for fitting complex electrophysiological data with multiple functions using the SOLVER add-in of the ubiquitous spreadsheet Microsoft Excel. SOLVER minimizes the difference between the sum of the squares of the data to be fit and the function(s) describing the data using an iterative generalized reduced gradient method. While it is a straightforward procedure to fit data with linear functions, and we have previously demonstrated a method of non-linear regression analysis of experimental data based upon a single function, it is more complex to fit data with multiple functions, usually requiring specialized expensive computer software. In this paper we describe an easily understood program for fitting experimentally acquired data, in this case the stimulus-evoked compound action potential from the mouse optic nerve, with multiple Gaussian functions. The program is flexible and can be applied to describe data with a wide variety of user-input functions.

References

Jan 15, 1998·Journal of Cerebral Blood Flow and Metabolism : Official Journal of the International Society of Cerebral Blood Flow and Metabolism·P K Stys
Mar 26, 1999·Computer Methods and Programs in Biomedicine·A M Brown
Apr 27, 2001·Journal of Cerebral Blood Flow and Metabolism : Official Journal of the International Society of Cerebral Blood Flow and Metabolism·A M BrownB R Ransom
Apr 8, 2003·The Journal of Physiology·Angus M BrownBruce R Ransom
May 3, 2003·Computer Methods and Programs in Biomedicine·Angus M Brown
Sep 9, 2005·Journal of Neurophysiology·Lynne AllenAngus M Brown

❮ Previous
Next ❯

Citations

Apr 28, 2010·Anatomical Science International·Emma L JamesAngus M Brown
May 12, 2001·Artificial Intelligence in Medicine·M Spenke
Feb 6, 2010·Nature Protocols·Gerdi Kemmer, Sandro Keller
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
Feb 24, 2010·Computer Methods and Programs in Biomedicine·Yong ZhangShaofei Xie
Jun 17, 2006·Computer Methods and Programs in Biomedicine·Haseeb Ahmad Khan
Jul 14, 2010·Bioresource Technology·Juan J García-MesaErnesto Hontoria
Apr 21, 2012·International Journal of Environmental Health Research·Marco Mesa-FriasAnna M Foss
Jun 19, 2012·Molecular Nutrition & Food Research·Shellen R GoltzMario G Ferruzzi
Jul 1, 2017·Proceedings. Biological Sciences·Bridie J M AllanMark I McCormick
Oct 15, 2010·Biology Letters·So KawaguchiAtsushi Ishimatsu
Aug 28, 2013·Philosophical Transactions of the Royal Society of London. Series B, Biological Sciences·Bayden D RussellNova Mieszkowska
Aug 28, 2013·Philosophical Transactions of the Royal Society of London. Series B, Biological Sciences·Maria ByrneSven Uthicke
Aug 28, 2013·Philosophical Transactions of the Royal Society of London. Series B, Biological Sciences·Piero CalosiMaria-Cristina Gambi
Nov 15, 2013·Proceedings. Biological Sciences·Sue-Ann WatsonPhilip L Munday
Jul 1, 2016·Proceedings. Biological Sciences·Ivan NagelkerkenRobbert C Geertsma
Sep 16, 2014·Journal of Plankton Research·Gemma CrippsKevin Flynn
Nov 19, 2014·The International Journal of Behavioral Nutrition and Physical Activity·Wenhua LuSuojin Wang

❮ 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.

Related Papers

Computer Methods and Programs in Biomedicine
Haseeb Ahmad Khan
Computer Methods and Programs in Biomedicine
Ingolf Meineke, Jürgen Brockmöller
© 2021 Meta ULC. All rights reserved