GNOME Bugzilla – Bug 385458
implement histogram as a sheet function
Last modified: 2008-09-16 07:34:44 UTC
The function in the menu Tool > Statistical Analysis > Histogram is very useful when one wants to infer some statistics on a sample set. The problem with this functionnality is that it is static, ie when changing the sample set, the results of the histogram function will not be updated. So my suggestion is to implement this as a sheet function. Another possibility would be to implement a new "histogram" graph type which would make the statistics and display the result in a graph. That would allow the results to be updated automatically. (though we don't have an access to the numerical values in this case)
Quite a few of the statistical tools have alreeady changed so that you can have a choice between a static and a dynamic version of the same tool. The same is planned for the histogram tool (whenever I get to it). This may include a new sheet function but for the other tools it turned out that ww ere able to use combinations of existing functions.
The histogram tool is now "live", i.e. yo have the option (the default) to request formulas to be inserted in the output region that will update automatically. This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
Excellent, thank you very much for your work! Frédéric