ArticleNature protocols2010
Nonlinear least-squares data fitting in Excel spreadsheets.
Article in Nature protocols, 2010. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 142 papers, 1 of them a synthesis that pooled it.
What it found
Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.
The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.
The trial behind it
Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.
Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.
Who cites it
142 citing papers in PubMed, 1 synthesis or guideline pooled it.
- An approximation of herd effect due to vaccinating children against seasonal influenza - a potential solution to the incorporation of indirect effects into static models.BMC infectious diseases · 2013Pooled it
- Clicking acylgermanes: modular access to photoinitiators for visible-light photopolymerization.Organic chemistry frontiers : an international journal of organic chemistry · 2026Article
- Antibacterial photoswitchable triazenic ciprofloxacins.Photochemical & photobiological sciences : Official journal of the European Photochemistry Association and the European Society for Photobiology · 2026Article
- Mechanistic insights into redox activity and catalytic determinants of the haloarchaeal flavin-dependent oxidoreductasebioRxiv : the preprint server for biology · 2026Article
- Characterisation of a phylogenetically distinct PL25 family ulvan lyase from a seaweed biomass enriched metagenome.The FEBS journal · 2026Article
- GPA33 forms a distinct diagnostic target class to Claudin 18.2 in oesophageal adenocarcinoma enabling the development of a novel GPA33 antibody-based detection platform.Cellular & molecular biology letters · 2026Article
- Kinetic plasticity of nitrite-oxidizing bacteria containing cytoplasmic nitrite oxidoreductase.The ISME journal · 2026Article
- Article
- CaNature cell biology · 2025Article
- Molecular Identification, Mycelial Growth Kinetics, and Antimicrobial Potential of Newly Isolated Medicinal MushroomJournal of fungi (Basel, Switzerland) · 2025Article
- Directed Evolution in Escherichia coli for Novel Ligand-Binding Regulators: Evolving a Progesterone-Responsive Transcription Factor to Bind Cortisol.Current protocols · 2025Article
- Phase separated condensates of ATRX regulate neural progenitor identity.Nature communications · 2025Article
- A Kinetic Model of Antigen-Dependent IgG Oligomerization and Complement Binding.Small science · 2025Article
- Article
- Article
- Simulation and Analysis of the Loading, Relaxation, and Recovery Behavior of Polyethylene and Its Pipes.Polymers · 2024Article
- Complement activation by IgG subclasses is governed by their ability to oligomerize upon antigen binding.Proceedings of the National Academy of Sciences of the United States of America · 2024Article
- Growth of complete ammonia oxidizers on guanidine.Nature · 2024Article
- Time-resolved fluorescence of tryptophan characterizes membrane perturbation by cyclic lipopeptides.Biophysical journal · 2024Article
- Ion Mobility-Mass Spectrometry Strategies to Elucidate the Anhydrous Structure of Noncovalent Guest/Host Complexes.Analytical chemistry · 2024Article
82 more citing papers are in PubMed but not listed here.
Corrections and comments
PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.
Authors and funding
2 authors.
Funding
No grant is acknowledged in the PubMed record.
Abstract
We describe an intuitive and rapid procedure for analyzing experimental data by nonlinear least-squares fitting (NLSF) in the most widely used spreadsheet program. Experimental data in x/y form and data calculated from a regression equation are inputted and plotted in a Microsoft Excel worksheet, and the sum of squared residuals is computed and minimized using the Solver add-in to obtain the set of parameter values that best describes the experimental data. The confidence of best-fit values is then visualized and assessed in a generally applicable and easily comprehensible way. Every user familiar with the most basic functions of Excel will be able to implement this protocol, without previous experience in data fitting or programming and without additional costs for specialist software. The application of this tool is exemplified using the well-known Michaelis-Menten equation characterizing simple enzyme kinetics. Only slight modifications are required to adapt the protocol to virtually any other kind of dataset or regression equation. The entire protocol takes approximately 1 h.
Indexed as
Identifiers
20134427What OpenQuestion holds
Registered trials
Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.