Changes in this version:
- The following (mainly statistical) Excel functions have been added. A part of them already exists (and stays) in GS-Calc but they are using different names.
BINOM.DIST(), COVARIANCE.P(), COVARIANCE.S(), STDEV.P(), STDEV.S(), VAR.P(), VAR.S(), SKEW.P(), CHISQ.DIST(), CHISQ.INV(), CHISQ.TEST(), CHISQ.DIST.RT(), CHISQ.INV.RT(), CONFIDENCE.NORM(), CONFIDENCE.T(), EXPON.DIST(), F.DIST(), F.DIST.RT(), F.INV(), F.INV.RT(), F.TEST(), HYPGEOM.DIST(), POISSON.DIST(), WEIBULL.DIST(), BETA.DIST(), GAMMA(), GAMMALN(), GAMMALN.PRECISE(), GAMMA.DIST(), NORM.DIST(), NORM.INV(), NORM.S.DIST(), NORM.S.INV(), GAUSS(), PHI(), LOGNORM.DIST(), LOGNORM.INV(), T.TEST(), T.DIST(), T.DIST.2T(), T.DIST.RT(), T.INV(), T.INV.RT(), RANK.EQ(), RANK.AVG(), PERCENTILE.EXC(), PERCENTILE.INC(), QUARTILE.EXC(), QUARTILE.INC(), PERCENTRANK.EXC(), PERCENTRANK.INC(), MODE.SNGL(), MODE.MULT(), Z.TEST(), ISO.CEILING(), CEILING.PRECISE(), CEILING.MATH(), FLOOR.PRECISE(), FLOOR.MATH(), ERF.PRECISE(), ERFC.PRECISE(), NETWORKDAYS.INTL(), WORKDAY.INTL() - Some older, previously existed built-in function with optional parameters have been modified not to require the empty parameters if they are optional (e.g. function(1) instead of function(1,)) which could lead to errors if they were directly copied from Excel.
- Updating speed has been increased by 10-15%.
Bug fixes:
- The numerator and denominator degrees of freedom parameters in the fdist() and finv() function calls were in the reverse order.
September 23, 2020 - 17.2.1 Update
- If the “proportional splitters” option was active, window splitters (dimensions) were not saved correctly.