On Tuesday, July 21, 2009 5:37:01 PM UTC-7, Sandman wrote:
Can the geometric standard deviation of a dataset be calculated using Excel?
I found the function for the geometric mean but have not been able to figure
out how to calculate the GSD.
--
Sandman

One can write a formula in Excel to find geometric standard deviation as illustrated by another respondent but it would be much easier to use an Excel Geometric Standard deviation function like this one http://njsxl.njinstruments.com/excel...-function.html by simply entering the values for data set and have the Excel GEOSTDEV function return the result for geometric standard deviation as shown below

=njsGEOSTDEV( { 2.25, 1.75, 3.25, 1.45, 2.35, 1.5, 1.65, 2.25, 1.35 } )

One may also enter the data set as a reference to a cell range containing the values

=njsGEOSTDEV( A1: I1 )

njsGEOSTDEV is a 3rd party Excel geometric standard deviation function http://njsxl.njinstruments.com/excel...-function.html that is part of njsXL add-in http://njsxl.njinstruments.com/