I D
× COMMENTARYCOVER STORYIN THE NEWSNEWSFRONTSCHEMENTATOR + Show More
Chemical Engineering MagazineChementator Briefs
PDH catalyst Last month, Clariant's Catalyst business (Munich, Germany; www.clariant.com)…
BUSINESS NEWSTECHNICAL & PRACTICALFEATURE REPORTFACTS AT YOUR FINGERTIPSTECHNOLOGY PROFILESOLIDS PROCESSINGENGINEERING PRACTICEEQUIPMENT & SERVICESFOCUS
Focus on Pumps
Self-priming, liquid-ring pumps enable hygienic operation The CFS AS/ASH Series…
NEW PRODUCTS + Show More

Comment PDF Automation & Control

Using Spreadsheets As Curve Fitting Tools

By B.J. du Plessis, University of Pretoria |

    Spreadsheets have been around almost as long as personal computers. While early versions were clumsy and limited in scope, today’s spreadsheet programs can do almost anything the user wants them to do. These broadened capabilities are made easier through the use of internal (built-in) functions, add-in programs and the use of macro programming. In this article, we explore how spreadsheets can help determine coefficients of an equation from experimental data, without complex or expensive software. Curve fitting, commonly used in engineering, is a technique used to describe experimental data as a mathematical equation in the form y = f(x) where x is the independent variable (controlled by the experimenter) and y is the dependent variable (measured). The better the fit of the equation, the more accurately the function will describe the experimental data. The introduction of personal computers into laboratories greatly reduced the time and effort required to analyze data. Fitting data with simple linear functions by using linear regression equations is a fairly straightforward process. Most spreadsheets can do this with add-in programs or even with built-in functions. Fitting data to more complex, non-linear equations…
Related Content

Chemical Engineering publishes FREE eletters that bring our original content to our readers in an easily accessible email format about once a week.
Subscribe Now
Quadruple Sensor Lifetime with a Retractable Housing
Minimizing Explosion Risk Where Other Solutions Cannot
Minimizing Corrosion with Fast, Robust Gas Analysis
Lower Measurement Point Costs with Automatic pH Sensor Cleaning
Reduce the Risk of Corrosion in Fertilizer Production

View More

Live chat by BoldChat