Chemical Instrumentation (CHEM471)

One of the assignments for this class required us to make spreadsheets for manually calculating (that is, relying on as few built-in functions as possible) statistics for our experimental values. The below spreadsheets are in Gnumeric format.

My standard deviation worksheet calculates the standard deviation as well as signal-to-noise ratios for a set of values. Simply enter the values in the "Values" column. This spreadsheet is superfluous when using Gnumeric, because Gnumeric uses a correct standard deviation algorithm. Microsoft Excel, on the other hand, appears to use some other standard deviation algorithm that produces numbers that are not the same as manually-calculated values. The numbers it produces are the same until the 7th place or so, which is probably fine for most financial or engineering applications, but with experimental values, can make all the difference.

My linear regression worksheet does a linear regression on a set of abscissa and ordinate values. It gets standard deviation in the slope, y-intercept, and interpolated values as well. It does not get r-values/correlation coefficients, however, but it's something I'll add on a rainy day.