Using Excel statistical functions for trend analysis

February 13, 2011 rockman Miscellaneous Comments Off on Using Excel statistical functions for trend analysis
Some messy Data

Some messy Data

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

Articles

VBA and Excel for Engineers and Scientists – Part 2

May 20, 2008 rockman Articles, Software and Spreadsheets 1

In this long awaited second article in the series, I will dive into the meat of the VBA programming language, including code containers, data types, variables, math operators, built-in functions, flow control, and even debugging.. In the end, you should be able to code some fairly complex things including custom worksheet functions that you can use in your spreadsheet just like a regular formula. Also in this article I give you a sample spreadsheet with some useful utilities that you can use right away.

[…]

Key-Lab_Accreditation_Lab_Input_i2
Available Resources

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, […]