Search results
Results from the WOW.Com Content Network
Both the "compatibility" function STDEVP and the "consistency" function STDEV.P in Excel 2010 return the 0.5 population standard deviation for the given set of values. However, numerical inaccuracy still can be shown using this example by extending the existing figure to include 10 15 , whereupon the erroneous standard deviation found by Excel ...
σ g: Geometric standard deviation. This value is determined mathematically by the equation: σ g = D 84.13 /D 50 = D 50 /D 15.87. The value of σ g determines the slope of the least-squares regression curve. α: Relative standard deviation or degree of polydispersity. This value is also determined mathematically.
This allows spreadsheet applications to add new functions, without interfering with current standard functions, future standard functions, or functions defined by other applications. As a result, different applications can add new functions without interfering with others; once a consensus arises about the new function, it can be standardized.
A calibration curve plot showing limit of detection (LOD), limit of quantification (LOQ), dynamic range, and limit of linearity (LOL).. In analytical chemistry, a calibration curve, also known as a standard curve, is a general method for determining the concentration of a substance in an unknown sample by comparing the unknown to a set of standard samples of known concentration. [1]
The Standard addition method, often used in analytical chemistry, quantifies the analyte present in an unknown. This method is useful for analyzing complex samples where a matrix effect interferes with the analyte signal.
A simple Monte Carlo spreadsheet calculation would reveal typical values for the standard deviation (around 105 to 115% of σ). Or, one could subtract the mean of each triplet from the values, and examine the distribution of 300 values. The mean is identically zero, but the standard deviation should be somewhat smaller (around 75 to 85% of σ).
Was one of the big three spreadsheets (the others being Lotus 123 and Excel). EasyOffice EasySpreadsheet – for MS Windows. No longer freeware, this suite aims to be more user friendly than competitors. Framework – for MS Windows. Historical office suite still available and supported. It includes a spreadsheet.
The value of the equilibrium constant for the formation of a 1:1 complex, such as a host-guest species, may be calculated with a dedicated spreadsheet application, Bindfit: [4] In this case step 2 can be performed with a non-iterative procedure and the pre-programmed routine Solver can be used for step 3.