[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] Statistical SUMMARY() function
Leonard Mada: > > Dear list members, > > One of the most used features in spreadsheets is to analyze and > > summarize the data. This is used in academia and businesses alike. ... > > I discussed this issue more fully at: > > http://www.openoffice.org/issues/show_bug.cgi?id=89980 > > > > While Calc (and ODF) has (most) functions implemented as separate > > funcitons, it lacks a unified function to compute all parameters at > > once. MS Excel does come with such a 'Menu'-entry in the advanced > > statistical toolpack. > > > > > > A.) MENU vs FUNCTION > > ==================== > > Excel did implement a menu-command. Unfortunately, IF the data-changes, > > the computed statistics won't change and need to be manually updated. > > The user might not notice that the data has changed. I've added the following text to the draft spec. It does not _REQUIRE_ a menu/command to create a sheet with summary information, but it clearly describes how to do it. Implementations which do it would (I think) meet the _spirit_ of this feature request, and I think by hinting at this functionality (at the front), it's more likely to actually happen. ------------------------------------------------------------------ Added to "What OpenFormula doesn't include": 'a special “summarize data” mechanism that presents many different statistical values of a set of data (e.g., average, minimum, first quartile, median, third quartile, maximum, standard deviation, and mode). If desired, applications may implement such a mechanism using a “wizard” to create a set of (labeled) formulas for each of these statistical values, using the formula language defined here. Such summaries can then be exchanged normally.' --- David A. Wheeler
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]