← Back to branch summary

~ubuntu-branches/ubuntu/quantal/gnumeric/quantal

~ubuntu-branches/ubuntu/quantal/gnumeric/quantal

« back to all changes in this revision

Viewing changes to plugins/fn-stat/functions.c

Committer: Bazaar Package Importer
Author(s): Gauvain Pocentek
Date: 2009-06-22 13:37:20 UTC
mfrom: (1.1.20 upstream) (2.1.3 sid)
Revision ID: james.westby@ubuntu.com-20090622133720-rtdazsiz2lx5q8l7

Tags: 1.9.9-1ubuntu1

* Merge from debian unstable, remaining changes:
  - Promoted gnumeric-doc to Recommends in gnumeric package for help to be
    installed automatically
  - gnumeric-gtk is a transitional package
  - gnumeric conflicts with gnumeric-gtk << 1.8.3-3ubuntu1
  - call initltool-update in po*
  - remove psiconv support (psiconv is in universe):
    o debian/control: remove B-D on libpsiconv-dev
    o debian/rules: don't pass --with-psiconv to ./configure
    o debian/gnumeric-plugins-extra.install: don't install the psiconv
      plugin

files added:
plugins/excel/xls-read-pivot.c

plugins/excel/xls-write-pivot.c

plugins/excel/xlsx-write-pivot.c

src/dialogs/chi-squared.glade

src/dialogs/data-slicer.glade

src/dialogs/dialog-analysis-tool-chi-squared.c

src/dialogs/dialog-data-slicer.c

src/gnm-cell-combo.c

src/gnm-cell-combo.h

src/gnm-command-impl.h

src/gnm-commands-slicer.c

src/gnm-commands-slicer.h

src/gnm-data-cache-source.c

src/gnm-data-cache-source.h

src/gnm-sheet-slicer-combo.c

src/gnm-sheet-slicer-combo.h

src/gnm-sheet-slicer.c

src/gnm-sheet-slicer.h

src/go-data-cache-field-impl.h

src/go-data-cache-field.c

src/go-data-cache-field.h

src/go-data-cache-impl.h

src/go-data-cache-source.c

src/go-data-cache-source.h

src/go-data-cache.c

src/go-data-cache.h

src/go-data-slicer-field-impl.h

src/go-data-slicer-field.c

src/go-data-slicer-field.h

src/go-data-slicer-impl.h

src/go-data-slicer.c

src/go-data-slicer.h

src/go-val.c

src/go-val.h

src/goffice-data.h

src/sheet-utils.c

src/sheet-utils.h

src/tools/analysis-anova.c

src/tools/analysis-anova.h

src/tools/analysis-chi-squared.c

src/tools/analysis-chi-squared.h

src/widgets/gnm-sheet-slicer-combo-foo-view.c

src/widgets/gnm-sheet-slicer-combo-foo-view.h

files removed:
plugins/excel/ms-pivot.c

plugins/excel/ms-pivot.h

src/str.c

src/str.h

files modified:
BUGS

ChangeLog

NEWS

component/gnumeric.c

configure

configure.in

debian/changelog

debian/control

doc/C/ChangeLog

doc/ChangeLog

gnumeric.spec

plugins/applix/ChangeLog

plugins/applix/applix-read.c

plugins/applix/applix-write.c

plugins/applix/boot.c

plugins/corba/ChangeLog

plugins/corba/corba-application.c

plugins/corba/corba-workbook.c

plugins/derivatives/ChangeLog

plugins/derivatives/options.c

plugins/dif/ChangeLog

plugins/dif/dif.c

plugins/excel/ChangeLog

plugins/excel/Makefile.am

plugins/excel/Makefile.in

plugins/excel/biff-types.h

plugins/excel/boot.c

plugins/excel/excel-xml-read.c

plugins/excel/excel.h

plugins/excel/ms-biff.c

plugins/excel/ms-chart.c

plugins/excel/ms-excel-read.c

plugins/excel/ms-excel-read.h

plugins/excel/ms-excel-util.c

plugins/excel/ms-excel-write.c

plugins/excel/ms-excel-write.h

plugins/excel/ms-formula-read.c

plugins/excel/ms-formula-write.c

plugins/excel/ms-obj.c

plugins/excel/plugin.xml.in

plugins/excel/xlsx-read-pivot.c

plugins/excel/xlsx-read.c

plugins/excel/xlsx-utils.c

plugins/excel/xlsx-utils.h

plugins/excel/xlsx-write.c

plugins/fn-complex/ChangeLog

plugins/fn-complex/functions.c

plugins/fn-database/ChangeLog

plugins/fn-database/functions.c

plugins/fn-date/ChangeLog

plugins/fn-date/functions.c

plugins/fn-eng/ChangeLog

plugins/fn-eng/functions.c

plugins/fn-erlang/ChangeLog

plugins/fn-erlang/functions.c

plugins/fn-financial/ChangeLog

plugins/fn-financial/functions.c

plugins/fn-info/ChangeLog

plugins/fn-info/functions.c

plugins/fn-logical/ChangeLog

plugins/fn-logical/functions.c

plugins/fn-lookup/ChangeLog

plugins/fn-lookup/functions.c

plugins/fn-math/ChangeLog

plugins/fn-math/functions.c

plugins/fn-math/plugin.xml.in

plugins/fn-r/ChangeLog

plugins/fn-r/functions.c

plugins/fn-random/ChangeLog

plugins/fn-random/functions.c

plugins/fn-stat/ChangeLog

plugins/fn-stat/functions.c

plugins/fn-string/ChangeLog

plugins/fn-string/functions.c

plugins/fn-tsa/ChangeLog

plugins/fn-tsa/functions.c

plugins/fn-tsa/plugin.xml.in

plugins/gda/ChangeLog

plugins/gda/plugin-gda.c

plugins/gnome-db/ChangeLog

plugins/gnome-glossary/ChangeLog

plugins/html/ChangeLog

plugins/html/boot.c

plugins/html/boot.h

plugins/html/html.c

plugins/html/html.h

plugins/html/html_read.c

plugins/html/latex.c

plugins/html/latex.h

plugins/html/roff.c

plugins/lotus-123/ChangeLog

plugins/lotus-123/boot.c

plugins/mps/ChangeLog

plugins/mps/mps.c

plugins/mps/parser.c

plugins/numtheory/ChangeLog

plugins/numtheory/numtheory.c

plugins/oleo/ChangeLog

plugins/oleo/boot.c

plugins/openoffice/ChangeLog

plugins/openoffice/openoffice-read.c

plugins/openoffice/openoffice-write.c

plugins/openoffice/plugin.xml.in

plugins/paradox/ChangeLog

plugins/paradox/paradox.c

plugins/perl-func/ChangeLog

plugins/perl-loader/ChangeLog

plugins/perl-loader/boot.c

plugins/perl-loader/perl-gnumeric.c

plugins/perl-loader/perl-gnumeric.h

plugins/perl-loader/perl-loader.c

plugins/plan-perfect/ChangeLog

plugins/plan-perfect/pln.c

plugins/plan-perfect/pln.h

plugins/psiconv/ChangeLog

plugins/psiconv/boot.c

plugins/psiconv/psiconv-plugin.h

plugins/psiconv/psiconv-read.c

plugins/py-func/ChangeLog

plugins/python-loader/ChangeLog

plugins/python-loader/boot.c

plugins/python-loader/gnm-py-interpreter.c

plugins/python-loader/gnm-python.c

plugins/python-loader/py-command-line.c

plugins/python-loader/py-console.c

plugins/python-loader/py-gnumeric.c

plugins/python-loader/py-gnumeric.h

plugins/python-loader/py-interpreter-selector.c

plugins/python-loader/py-interpreter-selector.h

plugins/python-loader/python-loader.c

plugins/qpro/ChangeLog

plugins/qpro/qpro-read.c

plugins/sample_datasource/ChangeLog

plugins/sample_datasource/sample_datasource.c

plugins/sc/ChangeLog

plugins/sc/sc.c

plugins/sylk/ChangeLog

plugins/sylk/sylk-write.c

plugins/sylk/sylk.c

plugins/uihello/ChangeLog

plugins/xbase/ChangeLog

plugins/xbase/boot.c

plugins/xbase/xbase.c

po-functions/ChangeLog

po-functions/POTFILES.in

po-functions/POTFILES.skip

po/ChangeLog

po/POTFILES.in

po/POTFILES.skip

po/es.po

po/he.po

samples/regress.gnumeric

schemas/gnumeric-general.schemas.in

src/GNOME_Gnumeric-gtk.xml.in

src/Makefile.am

src/Makefile.in

src/application.c

src/application.h

src/auto-format.c

src/cell-draw.c

src/cell.c

src/cellspan.h

src/clipboard.c

src/clipboard.h

src/cmd-edit.h

src/collect.c

src/command-context-stderr.c

src/command-context.h

src/commands.c

src/consolidate.c

src/dependent.c

src/dependent.h

src/dialogs/ChangeLog

src/dialogs/Makefile.am

src/dialogs/Makefile.in

src/dialogs/dialog-about.c

src/dialogs/dialog-analysis-tools.c

src/dialogs/dialog-autocorrect.c

src/dialogs/dialog-autoformat.c

src/dialogs/dialog-autosave.c

src/dialogs/dialog-cell-format.c

src/dialogs/dialog-cell-sort.c

src/dialogs/dialog-doc-metadata.c

src/dialogs/dialog-formula-guru.c

src/dialogs/dialog-function-select.c

src/dialogs/dialog-goto-cell.c

src/dialogs/dialog-hyperlink.c

src/dialogs/dialog-plugin-manager.c

src/dialogs/dialog-preferences.c

src/dialogs/dialog-printer-setup.c

src/dialogs/dialog-quit.c

src/dialogs/dialog-recent.c

src/dialogs/dialog-scenarios.c

src/dialogs/dialog-search-replace.c

src/dialogs/dialog-search.c

src/dialogs/dialog-sheet-order.c

src/dialogs/dialog-so-styled.c

src/dialogs/dialog-solver.c

src/dialogs/dialog-stf-csv-page.c

src/dialogs/dialog-stf-export.c

src/dialogs/dialog-stf-main-page.c

src/dialogs/dialog-stf.h

src/dialogs/dialogs.h

src/dialogs/help.h

src/dialogs/search.glade

src/expr-name.c

src/expr-name.h

src/expr.c

src/expr.h

src/file-autoft.c

src/file-autoft.h

src/format-template.c

src/format-template.h

src/func-builtin.c

src/func.c

src/func.h

src/gnm-datetime.c

src/gnm-datetime.h

src/gnm-format.c

src/gnm-format.h

src/gnm-graph-window.c

src/gnm-graph-window.h

src/gnm-pane.c

src/gnm-pane.h

src/gnm-plugin.c

src/gnm-plugin.h

src/gnm-so-filled.c

src/gnm-so-line.c

src/gnm-so-polygon.c

src/gnm-style-impl.h

src/gnumeric-gconf-priv.h

src/gnumeric-gconf.c

src/gnumeric-gconf.h

src/gnumeric-simple-canvas.h

src/gnumeric.h

src/graph.c

src/graph.h

src/gui-clipboard.c

src/gui-file.c

src/gui-file.h

src/gui-util.c

src/gui-util.h

src/gutils.c

src/gutils.h

src/history.c

src/hlink.c

src/hlink.h

src/input-msg.c

src/io-context-gtk.c

src/io-context-gtk.h

src/item-cursor.c

src/item-edit.c

src/libgnumeric.c

src/main-application.c

src/mathfunc.c

src/mathfunc.h

src/mstyle.c

src/mstyle.h

src/number-match.c

src/numbers.h

src/parse-util.c

src/parse-util.h

src/parser.c

src/parser.y

src/print-info.c

src/print-info.h

src/print.c

src/print.h

src/rangefunc.h

src/ranges.c

src/ranges.h

src/regression.h

src/rendered-value.c

src/rendered-value.h

src/search.c

src/search.h

src/selection.c

src/selection.h

src/session.c

src/sheet-autofill.c

src/sheet-control-gui-priv.h

src/sheet-control-gui.c

src/sheet-control-priv.h

src/sheet-control.h

src/sheet-filter-combo.h

src/sheet-filter.c

src/sheet-filter.h

src/sheet-merge.c

src/sheet-object-cell-comment.c

src/sheet-object-graph.c

src/sheet-object-graph.h

src/sheet-object-image.c

src/sheet-object-widget.c

src/sheet-object.c

src/sheet-object.h

src/sheet-style.c

src/sheet-style.h

src/sheet-view.c

src/sheet-view.h

src/sheet.c

src/sheet.h

src/solver.h

src/sort.c

src/sort.h

src/ssconvert.c

src/ssgrep.c

src/ssindex.c

src/sstest.c

src/stf-export.c

src/stf-export.h

src/stf-parse.c

src/stf.c

src/style-border.h

src/style-color.h

src/style-font.h

src/style.c

src/symbol.c

src/test-pango.c

src/tools/ChangeLog

src/tools/Makefile.am

src/tools/Makefile.in

src/tools/analysis-exp-smoothing.c

src/tools/analysis-frequency.c

src/tools/analysis-histogram.c

src/tools/analysis-kaplan-meier.c

src/tools/analysis-kaplan-meier.h

src/tools/analysis-tools.c

src/tools/analysis-tools.h

src/tools/auto-correct.c

src/tools/auto-correct.h

src/tools/dao.c

src/tools/dao.h

src/tools/data-shuffling.c

src/tools/fill-series.c

src/tools/scenarios.c

src/tools/solver/ChangeLog

src/tools/solver/glpk/ChangeLog

src/tools/solver/lp_solve/ChangeLog

src/tools/solver/solver.c

src/validation-combo.h

src/validation.c

src/validation.h

src/value-sheet.c

src/value.c

src/value.h

src/wbc-gtk-actions.c

src/wbc-gtk-edit.c

src/wbc-gtk-impl.h

src/wbc-gtk.c

src/wbc-gtk.h

src/widgets/ChangeLog

src/widgets/Makefile.am

src/widgets/Makefile.in

src/widgets/gnm-cell-combo-foo-view-impl.h

src/widgets/gnm-cell-combo-foo-view.c

src/widgets/gnm-dao.c

src/widgets/gnm-dao.h

src/widgets/gnm-filter-combo-foo-view.c

src/widgets/gnm-format-sel.h

src/widgets/gnm-notebook.c

src/widgets/gnm-validation-combo-foo-view.c

src/widgets/gnumeric-dashed-canvas-line.c

src/widgets/gnumeric-expr-entry.c

src/widgets/gnumeric-expr-entry.h

src/widgets/widget-editable-label.c

src/widgets/widget-font-selector.c

src/widgets/widget-font-selector.h

src/workbook-control-priv.h

src/workbook-control.c

src/workbook-control.h

src/workbook-priv.h

src/workbook-view.c

src/workbook-view.h

src/workbook.c

src/workbook.h

src/xml-io.c

src/xml-io.h

src/xml-sax-read.c

src/xml-sax-write.c

test/ChangeLog

test/t5900-sc.pl

test/t5901-qpro.pl

test/t5902-applix.pl

test/t5903-sylk.pl

tools/ChangeLog

Show diffs side-by-side

added added

removed removed

plugins/fn-stat/functions.c

36

36

#include <expr-impl.h>

37

37

#include <func-builtin.h>

38

38

#include <gnm-i18n.h>

39

#include <goffice/app/go-plugin.h>

39

#include <goffice/goffice.h>

40

40

#include <gnm-plugin.h>

41

41

#include <math.h>

42

42

#include <stdlib.h>

56

56

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain number 11.4, 17.3, 21.3, 25.9, and 40.1.")},

57

57

{ GNM_FUNC_HELP_EXAMPLES, F_("Then VARP(A1:A5) equals 94.112")},

58

58

{ GNM_FUNC_HELP_SEEALSO, ("AVERAGE,DVAR,DVARP,STDEV,VAR")},

59

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Variance") },

60

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Variance.html") },

59

61

{ GNM_FUNC_HELP_END }

60

62

};

61

63

82

84

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.")},

83

85

{ GNM_FUNC_HELP_EXAMPLES, F_("Then VAR(A1:A5) equals 117.64.")},

84

86

{ GNM_FUNC_HELP_SEEALSO, ("VARP,STDEV")},

87

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Variance") },

88

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Variance.html") },

85

89

{ GNM_FUNC_HELP_END }

86

90

};

87

91

110

114

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.")},

111

115

{ GNM_FUNC_HELP_EXAMPLES, F_("Then STDEV(A1:A5) equals 10.84619749.")},

112

116

{ GNM_FUNC_HELP_SEEALSO, ("AVERAGE,DSTDEV,DSTDEVP,STDEVA,STDEVPA,VAR")},

117

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Standard_deviation") },

118

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:StandardDeviation.html") },

113

119

{ GNM_FUNC_HELP_END }

114

120

};

115

121

135

141

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.")},

136

142

{ GNM_FUNC_HELP_EXAMPLES, F_("Then STDEVP(A1:A5) equals 9.701133954.")},

137

143

{ GNM_FUNC_HELP_SEEALSO, ("STDEV,STDEVA,STDEVPA")},

144

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Standard_deviation") },

145

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:StandardDeviation.html") },

138

146

{ GNM_FUNC_HELP_END }

139

147

};

140

148

261

269

"B5 23.2, 25.8, 29.9, 33.5, and 42.7.") },

262

270

{ GNM_FUNC_HELP_EXAMPLES, F_("Then COVAR(A1:A5,B1:B5) equals 65.858.") },

263

271

{ GNM_FUNC_HELP_SEEALSO, "CORREL,FISHER,FISHERINV"},

272

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Covariance") },

273

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Covariance.html") },

264

274

{ GNM_FUNC_HELP_END }

265

275

};

266

276

289

299

"B5 23.2, 25.8, 29.9, 33.5, and 42.7.") },

290

300

{ GNM_FUNC_HELP_EXAMPLES, F_("Then CORREL(A1:A5,B1:B5) equals 0.996124788.") },

291

301

{ GNM_FUNC_HELP_SEEALSO, "COVAR,FISHER,FISHERINV"},

302

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:CorrelationCoefficient.html") },

303

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Covariance.html") },

292

304

{ GNM_FUNC_HELP_END }

293

305

};

294

306

341

353

{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },

342

354

{ GNM_FUNC_HELP_EXAMPLES, F_("NORMSDIST(2) equals 0.977249868.") },

343

355

{ GNM_FUNC_HELP_SEEALSO, "NORMDIST"},

356

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Normal_distribution") },

357

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:NormalDistribution.html") },

344

358

{ GNM_FUNC_HELP_END }

345

359

};

346

360

357

371

/***************************************************************************/

358

372

359

373

static GnmFuncHelp const help_normsinv[] = {

360

{ GNM_FUNC_HELP_NAME, F_("NORMSINV:inverse of the cumulative desnity function of the standard normal distribution")},

374

{ GNM_FUNC_HELP_NAME, F_("NORMSINV:inverse of the cumulative density function of the standard normal distribution")},

361

375

{ GNM_FUNC_HELP_ARG, F_("p:given probability")},

362

376

{ GNM_FUNC_HELP_NOTE, F_("If @{p} < 0 or @{p} > 1 this function returns #NUM! error.")},

363

377

{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },

364

378

{ GNM_FUNC_HELP_EXAMPLES, F_("NORMSINV(0.2) equals -0.841621234.") },

365

379

{ GNM_FUNC_HELP_SEEALSO, "NORMDIST,NORMINV,NORMSDIST,STANDARDIZE,ZTEST"},

380

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Normal_distribution") },

381

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:NormalDistribution.html") },

366

382

{ GNM_FUNC_HELP_END }

367

383

};

368

384

391

407

{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },

392

408

{ GNM_FUNC_HELP_EXAMPLES, F_("LOGNORMDIST(3,1,2) equals 0.519662338.") },

393

409

{ GNM_FUNC_HELP_SEEALSO, "NORMDIST"},

410

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Log-normal_distribution") },

411

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:LogNormalDistribution.html") },

394

412

{ GNM_FUNC_HELP_END }

395

413

};

396

414

418

436

{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },

419

437

{ GNM_FUNC_HELP_EXAMPLES, F_("LOGINV(0.5,2,3) equals 7.389056099.")},

420

438

{ GNM_FUNC_HELP_SEEALSO, ("EXP,LN,LOG,LOG10,LOGNORMDIST")},

439

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Log-normal_distribution") },

440

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:LogNormalDistribution.html") },

421

441

{ GNM_FUNC_HELP_END }

422

442

};

423

443

444

464

{ GNM_FUNC_HELP_NOTE, F_("If @{x} is a non-number this function returns a #VALUE! error.")},

445

465

{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },

446

466

{ GNM_FUNC_HELP_EXAMPLES, F_("FISHERINV(2) equals 0.96402758.") },

447

{ GNM_FUNC_HELP_SEEALSO, "FISHER"},

467

{ GNM_FUNC_HELP_SEEALSO, "FISHER,TANH"},

448

468

{ GNM_FUNC_HELP_END }

449

469

};

450

470

451

471

static GnmValue *

452

472

gnumeric_fisherinv (GnmFuncEvalInfo *ei, GnmValue const * const *argv)

453

473

{

454

gnm_float y = value_get_as_float (argv[0]);

455

456

return value_new_float (gnm_expm1 (2 * y) / (gnm_exp (2 * y) + 1.0));

474

return value_new_float (gnm_tanh (value_get_as_float (argv[0])));

457

475

}

458

476

459

477

/***************************************************************************/

468

486

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 11.4, 25.9, and 40.1.") },

469

487

{ GNM_FUNC_HELP_EXAMPLES, F_("Then MODE(A1:A5) equals 11.4.") },

470

488

{ GNM_FUNC_HELP_SEEALSO, "AVERAGE,MEDIAN"},

489

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Mode_(statistics)") },

490

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Mode.html") },

471

491

{ GNM_FUNC_HELP_END }

472

492

};

473

493

493

513

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },

494

514

{ GNM_FUNC_HELP_EXAMPLES, F_("Then HARMEAN(A1:A5) equals 19.529814427.") },

495

515

{ GNM_FUNC_HELP_SEEALSO, "AVERAGE,GEOMEAN,MEDIAN,MODE,TRIMMEAN"},

516

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Harmonic_mean") },

517

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:HarmonicMean.html") },

496

518

{ GNM_FUNC_HELP_END }

497

519

};

498

520

518

540

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },

519

541

{ GNM_FUNC_HELP_EXAMPLES, F_("Then GEOMEAN(A1:A5) equals 21.279182482.") },

520

542

{ GNM_FUNC_HELP_SEEALSO, "AVERAGE,HARMEAN,MEDIAN,MODE,TRIMMEAN"},

543

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Geometric_mean") },

544

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:GeometricMean.html") },

521

545

{ GNM_FUNC_HELP_END }

522

546

};

523

547

612

636

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },

613

637

{ GNM_FUNC_HELP_EXAMPLES, F_("Then AVERAGE(A1:A5) equals 23.2.")},

614

638

{ GNM_FUNC_HELP_SEEALSO, ("SUM, COUNT")},

639

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Arithmetic_mean") },

640

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:ArithmeticMean.html") },

615

641

{ GNM_FUNC_HELP_END }

616

642

};

617

643

1814

1840

{ GNM_FUNC_HELP_NOTE, F_("If @{x} <= -1 or @{x} >= 1, this function returns a #NUM! error.")},

1815

1841

{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },

1816

1842

{ GNM_FUNC_HELP_EXAMPLES, F_("FISHER(0.332) equals 0.345074339.") },

1817

{ GNM_FUNC_HELP_SEEALSO, "SKEW"},

1843

{ GNM_FUNC_HELP_SEEALSO, "FISHERINV,ATANH"},

1818

1844

{ GNM_FUNC_HELP_END }

1819

1845

};

1820

1846

1831

1857

if (x <= -1.0 || x >= 1.0)

1832

1858

return value_new_error_NUM (ei->pos);

1833

1859

1834

return value_new_float (0.5 * (gnm_log1p (x) - gnm_log1p (-x)));

1860

return value_new_float (gnm_atanh (x));

1835

1861

}

1836

1862

1837

1863

/***************************************************************************/

1922

1948

{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },

1923

1949

{ GNM_FUNC_HELP_EXAMPLES, F_("Then MEDIAN(A1:A5) equals 21.3.") },

1924

1950

{ GNM_FUNC_HELP_SEEALSO, "AVERAGE,COUNT,COUNTA,DAVERAGE,MODE,SSMEDIAN,SUM"},

1951

{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Median") },

1952

{ GNM_FUNC_HELP_EXTREF, F_("wolfram:StatisticalMedian.html") },

1925

1953

{ GNM_FUNC_HELP_END }

1926

1954

};

1927

1955

Older »