If you place these values in cells A1A4 then apply the simplest form of calculating geometric standard deviation found on the Wikipedia page you would enter the following as an array formula. Standard deviation in Excel Standard deviation is a measure of how much variance there is in a set of numbers compared to the average mean of the numbers. It is calculated as.
The sample estimate is exp s where s is the standard deviation of the log-transformed data.
The geometric standard error GSE is defined by exponentiating the standard error of the mean of the log-transformed data. The quantity GSD exp s is defined to be the geometric standard deviation. 4 9 1 2 36 1 2 6. The geometric mean is the average rate of return of a set of values calculated with the products of the terms.