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
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, […]
Which Excel 2010 chart types to use, and which to avoid
Download Update: VBA and Excel…Part 2
My apologies to anyone in the past two months who tried to download my sample Excel spreadsheet that went along with the article " VBA and Excel for Engineers and Scientists – Part 2". I didn’t notice that there was a problem with the download until a new member emailed me about it (thanks Chris). I believe that it’s working now, if not be sure to email me! By the way, I’ve been out in the field since last week, sorry for the sparse posts.
Download the GeoPrac-VBA2-Examples.xls Spreadsheet (Excel 97-2003 format, but works with 2007 also)