Most geoengineers I know are comfortable using Excel’s curve fitting functionality on a Chart. Have you ever found yourself manually copying the coefficients from the resulting equation on the chart into cells to program the equation to do some interpolation or extrapolation? It’s possible to do some of the same things with Excel’s built in statistical formulas as well. This post on the Excel blog Chandoo.org describes some of these functions like SLOPE, INTERCEPT, TREND, LINEST and FORECAST and provides some useful examples. [Source: Chandoo.org. Image: Chandoo.org]
Related Articles
Ensuring consistency in geotechnical laboratory operations
May 30, 2017
rockman
Available Resources
Comments Off on Ensuring consistency in geotechnical laboratory operations
Laboratory accreditation has become a ‘ticket to the game’ and most geotechnical laboratories will have, or are working towards, accreditation. The key thing an accreditation body is looking for is consistency; in workflows, sample handling, […]
VBA and Excel for Engineers and Scientists
April 5, 2007
rockman
Articles, Software and Spreadsheets
Comments Off on VBA and Excel for Engineers and Scientists
Visual Basic for Applications or VBA used in conjunction with Microsoft Excel is a tool that many scientists and engineers have yet to take full advantage of. This article is the first in a series designed to provide you with the basic understanding of how to use VBA and Excel in your practice.
Which Excel 2010 chart types to use, and which to avoid
September 22, 2011
rockman
Available Resources
Comments Off on Which Excel 2010 chart types to use, and which to avoid