GNOME Bugzilla – Bug 115177
Even more string issues
Last modified: 2004-12-22 21:47:04 UTC
#: plugins/fn-stat/functions.c:221 msgid "" "@FUNCTION=VAR\n" "@SYNTAX=VAR(b1, b2, ...)\n" "@DESCRIPTION=VAR estimates the variance of a sample of a population. To get " "the true variance of a complete population use @VARP.\n" "\n" -- Should likely not be "@VARP", but "VARP" instead. --- #: plugins/fn-stat/functions.c:878 msgid "" "@FUNCTION=COUNTA\n" "@SYNTAX=COUNTA(b1, b2, ...)\n" "@DESCRIPTION=COUNTA returns the number of arguments passed not including " "empty cells.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "Let us assume that the cells A1, A2, ..., A5 contain numbers and strings " "11.4, \"missing\", \"missing\", 25.9, and 40.1. Then\n" "COUNTA(A1:A5) equals 5.\n" -- The example is wrong; it should return 3. --- #: plugins/fn-stat/functions.c:952 (Also: #: plugins/fn-stat/functions.c:994 msgid "" "@FUNCTION=MIN\n" "@SYNTAX=MIN(b1, b2, ...)\n" "@DESCRIPTION=MIN returns the value of the element of the values passed that " "has the smallest value. With negative numbers considered smaller than " "positive numbers.\n" -- Should be "... the smallest value, with negative numbers ..." for MIN and "... the largest value, with ..." for MAX. --- #: plugins/fn-stat/functions.c:1036 msgid "" "@FUNCTION=SKEW\n" "@SYNTAX=SKEW(n1, n2, ...)\n" "@DESCRIPTION=SKEW returns an unbiased estimate for skewness of a " "distribution.\n" "\n" "Note, that this is only meaningful if the underlying distribution really has " "a third moment. The skewness of a symmetric (e.g., normal) distribution is " "zero.\n" "\n" "* Strings and empty cells are simply ignored.* If less than three numbers " "are given, SKEW returns #DIV/0! error.\n" "* This function is Excel compatible.\n" -- "* If less than three ..." should be on its own line. --- #: plugins/fn-stat/functions.c:1514 (Also: #: plugins/fn-stat/functions.c:1554 msgid "" "@FUNCTION=BETADIST\n" "@SYNTAX=BETADIST(x,alpha,beta[,a,b])\n" "@DESCRIPTION=BETADIST function returns the cumulative beta distribution. @a " "is the optional lower bound of @x and @b is the optional upper bound of @x. " "If @a is not given, BETADIST uses 0.\n" "\n" "* If @b is not given, BETADIST uses 1.\n" "* If @x < @a or @x > @b BETADIST returns #NUM! error.\n" "* If @alpha <= 0 or @beta <= 0, BETADIST returns #NUM! error.\n" "* If @a >= @b BETADIST returns #NUM! error.\n" -- Either the line "If @a is not given ..." should be moved down and prefixed with a star like the others, or the line "If @b is not given ..." should be moved up and concatenated with the "If @a ..." line. --- #: plugins/fn-stat/functions.c:1881 msgid "" "@FUNCTION=BINOMDIST\n" "@SYNTAX=BINOMDIST(n,trials,p,cumulative)\n" "@DESCRIPTION=BINOMDIST function returns the binomial distribution. @n is the " "number of successes, @trials is the total number of independent trials, @p " "is the probability of success in trials, and @cumulative describes whether " "to return the sum of thebinomial function from 0 to @n.\n" -- "the binomial" rather than "thebinomial" "\n" "* If @n or @trials are non-integer they are truncated.\n" "* If @n < 0 or @trials < 0 BINOMDIST returns #NUM! error.\n" "* If @n > trials BINOMDIST returns #NUM! error.\n" "* If @p < 0 or @p > 1 BINOMDIST returns #NUM! error.\n" -- "@trials" rather than "trials" --- #: plugins/fn-stat/functions.c:1967 msgid "" "@FUNCTION=CRITBINOM\n" "@SYNTAX=CRITBINOM(trials,p,alpha)\n" "@DESCRIPTION=CRITBINOM function returns the smallest value for which " "thecumulative is greater than or equal to a given value. @n is the number of " -- "the cumulative" --- #: plugins/fn-stat/functions.c:2289 msgid "" "@FUNCTION=KURT\n" "@SYNTAX=KURT(n1, n2, ...)\n" "@DESCRIPTION=KURT returns an unbiased estimate of the kurtosis of a data " "set.\n" "Note, that this is only meaningful is the underlying distribution really has " -- "... only meaningful if the underlying ..." --- #: plugins/fn-stat/functions.c:2425 msgid "" "@FUNCTION=FISHER\n" "@SYNTAX=FISHER(x)\n" "@DESCRIPTION=FISHER function returns the Fisher transformation at @x.\n" "\n" "* If @x is not-number FISHER returns #VALUE! error.\n" -- "non-number" or "not a number" --- #: plugins/fn-stat/functions.c:3283 msgid "" "@FUNCTION=VARPA\n" "@SYNTAX=VARPA(number1,number2,...)\n" "@DESCRIPTION=VARPA returns the variance based on the entire population. " "Numbers, text and logical values are included in the calculation too. If " "the cell contains text or the argument evaluates to FALSE, it is counted as " "value zero (0). If the argument evaluates to TRUE, it is counted as one " "(1). Note that empty cells are not counted.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "Let us assume that the cells A1, A2, ..., A5 contain numbers and strings " "11.4, 17.3, \"missing\", 25.9, and 40.1. Then\n" "VARPA(A1:A5) equals 182.8904.\n" "\n" "@SEEALSO=VARP,VARP" -- @SEEALSO is wrong; maybe should be "@SEEALSO=VAR,VARA" ? --- #: plugins/fn-stat/functions.c:3899 msgid "" "@FUNCTION=LINEST\n" "@SYNTAX=LINEST(known_y's[,known_x's[,const[,stat]]])\n" "@DESCRIPTION=LINEST function calculates the ``least squares'' line that best " ... "\n" "* If @known_x's is omitted, an array {1, 2, 3, ...} is used.\n" "If @known_y's and @known_x's have unequal number of data points, LINEST " "returns #NUM! error.\n" -- Add a star to the last line above: "* If @known_y's and ..." --- #: plugins/fn-stat/functions.c:4547 msgid "" "@FUNCTION=TREND\n" "@SYNTAX=TREND(known_y's[,known_x's],new_x's])\n" -- Something is wrong with the function prototype - the first ']' is likely superfluous. Or, possibly, perhaps of the form "(known_y's[,known_x's[,new_x's]])", since the docs treat missing known_x and new_x separately. --- #: plugins/fn-stat/functions.c:4659 (Also in: #: plugins/fn-stat/functions.c:4911 ) msgid "" "@FUNCTION=LOGEST\n" "@SYNTAX=LOGEST(known_y's[,known_x's,const,stat])\n" ... "@SEEALSO=LOGEST,GROWTH,TREND" -- Should not refer to itself in the @SEEALSO-section. --- #: plugins/fn-stat/functions.c:5796 msgid "p,mean,stddev" -- The parameter is spelled interchangeably as "stdev" and "stddev" over the whole application. I haven't had the energy to actually mark each and every place. --- #: plugins/fn-stat/functions.c:5799 msgid "x,meean,stdev" -- "mean"
The answer for the COUNTA example was correct 'missing' is not an empty cell! All the other problems have been fixed in cvs.
Reopening due to two outstanding issues: This one was missed: #: plugins/fn-stat/functions.c:5799 msgid "x,meean,stdev" -- "mean" --- #: plugins/fn-stat/functions.c:4549 msgid "" "@FUNCTION=TREND\n" "@SYNTAX=TREND(known_y's[,known_x's,new_x's])\n" ... "* If @known_x's is omitted, an array {1, 2, 3, ...} is used.\n" "* If @new_x's is omitted, it is assumed to be the same as @known_x's.\n" -- The docs imply that you can have @known_x's without @new_x's, but the function prototype contradicts this. Maybe the two lines should say: "* If @known_x's and @new_x's is omitted, an array {1, 2, 3, ...} is used.\n"
Regarding the latter remaining issue: you can have known_x's without new_x's. I believe we used the notation [...] rather than [...[...]] to mean that they are individually optional. I will need to check that.
I was mistaken. I have changed the function prototype and ajusted the `meean'.
I also noticed that TREND in fact has another optional argument that was completely missing fromthe documentation. added