Page 1 of 1

GS-Calc 16.8 has been released

PostPosted: Sun Dec 03, 2017 7:22 pm
by citadel5
Changes in this version:

  • A number of new pivot table function have been added:
    • geometric and harmonic means,
    • variances and standard deviations,
    • counting specific numbers,
    • counting strings based on regular expressions,
    • kurtosis,
    • skewness,
    • most frequently occurring numbers and strings.
    To maximize performance, (most of) the pivot functions can make use
    of up to 64 processor cores.

  • Added optional chi-square tests for generated pivot tables.
    Sample screen:
    https://citadel5.com/upd_screens/gsc16.8/gsc16.8_scr1.png
    (Hints: tables must specify the "Grand total" column and row; if there are not any column fields, the expected test chi2 values are assumed to be uniformly distributed.)

  • Sort ranges and keys can be saved and re-used easily.

  • In the IF() functions now only one of the two conditional parameters is evaluated. Previously both were calculated so in this update IF() functions will be proportionally faster.

  • The chitest() function now returns P(X > c^2) instead of the P(X < c^2). The "Settings > Legacy Compatibility" option enables preserving the previous behavior.