I D
× COMMENTARYIN THE NEWSNEWSFRONTSCHEMENTATOR + Show More BUSINESS NEWSTECHNICAL & PRACTICALFEATURE REPORTFACTS AT YOUR FINGERTIPSTECHNOLOGY PROFILEENVIRONMENTAL MANAGEREQUIPMENT & SERVICESFOCUSNEW 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
Improving chemical production processes with IIoT and AI technologies
New filtration technology for highly corrosive media
PTA production: Lowering OPEX without compromising on quality
Sure that zero means zero in your zero-liquid discharge (ZLD) process?
How separation processes profit from Industrial Internet of Things (IIoT) solutions

View More

Live chat by BoldChat