summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <ohallot@collabora.co.uk>2016-02-12 14:41:48 -0200
committerDavid Tardon <dtardon@redhat.com>2016-02-16 08:33:34 +0000
commit8259390d2d978d37dc73e8e2cb0f1fcd0299afdf (patch)
tree6ecb04de47063c296910af9c1ef1f3bfef644c05
parente53a0d788c6a34d9375e33adc2e9946e2348ad23 (diff)
tdf#95281 Help page for the SKEWP function
Write help page for SKEWP spreadsheet function Change-Id: Ib7fc372bc2be4c55663a6ab58f488aa204631d20 Reviewed-on: https://gerrit.libreoffice.org/22322 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
-rw-r--r--AllLangHelp_scalc.mk1
-rw-r--r--source/text/scalc/01/04060185.xhp4
-rw-r--r--source/text/scalc/01/func_skewp.xhp53
3 files changed, 58 insertions, 0 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 2d8f35a61..bf50e991b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -215,6 +215,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_numbervalue \
helpcontent2/source/text/scalc/01/func_now \
helpcontent2/source/text/scalc/01/func_second \
+ helpcontent2/source/text/scalc/01/func_skewp \
helpcontent2/source/text/scalc/01/func_sumifs \
helpcontent2/source/text/scalc/01/func_time \
helpcontent2/source/text/scalc/01/func_timevalue \
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 856665d05..7926cbf2a 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -106,6 +106,10 @@
<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="U" oldref="18">
<item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph>
</section>
+<section id="skewp">
+ <paragraph id="hd_id72921349523046" role="heading" level="2" localize="false" xml-lang="en-US">
+ <embed href="text/scalc/01/func_skewp.xhp#skewp_function"/></paragraph>
+</section>
<section id="forecast">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149051"><bookmark_value>regression lines;FORECAST function</bookmark_value>
<bookmark_value>extrapolations</bookmark_value>
diff --git a/source/text/scalc/01/func_skewp.xhp b/source/text/scalc/01/func_skewp.xhp
new file mode 100644
index 000000000..8f2a83366
--- /dev/null
+++ b/source/text/scalc/01/func_skewp.xhp
@@ -0,0 +1,53 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+-->
+
+<meta>
+ <topic id="textscalc01func_skewpxml">
+ <title id="tit" xml-lang="en-US">SKEWP function</title>
+ <filename>text/scalc/01/func_skewp.xhp</filename>
+ </topic>
+</meta>
+<body>
+<section id="skewp_function">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SKEWP" id="bm_id1102201617042146" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id1102201617201921">
+ <bookmark_value>skewness;population</bookmark_value>
+ <bookmark_value>SKEWP function</bookmark_value>
+</bookmark>
+<paragraph id="hd_id456845684568" role="heading" level="2" xml-lang="en-US"><variable id="skewp_head"><link href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></paragraph>
+<paragraph id="par_id1102201617001848" role="paragraph" xml-lang="en-US"><ahelp hid=".">Calculates the skewness of a distribution using the population of a random variable.</ahelp></paragraph>
+<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+<paragraph id="par_id27421466710275" role="code" xml-lang="en-US">SKEWP(Number1; Number2;..., Number30)</paragraph>
+<paragraph id="par_id242131304318587" role="paragraph" xml-lang="en-US"><emph>Number1, Number2, ..., Number30</emph> are up to 30 numerical values or ranges.</paragraph>
+<paragraph id="par_id242131304315587" role="paragraph" xml-lang="en-US">Calculates the skewness of a distribution using the population, i.e. the possible outcomes, of a random variable. The sequence shall contain three numbers at least.</paragraph>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
+<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+<paragraph id="par_id1102201617001888" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(2;3;1;6;8;5)</item> returns 0.2828158928
+</paragraph>
+<paragraph id="par_id1102201618185378" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(A1:A6)</item> returns 0.2828158928, when the range A1:A6 contains {2;3;1;6;8;5}</paragraph>
+<paragraph id="par_id1102201618185326" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(Number1;Number2)</item> returns zero allways, if Number1 and Number2 results in two numbers.</paragraph>
+<paragraph id="par_id1102201618188326" role="paragraph" xml-lang="en-US"><item type="literal">SKEWP(Number1)</item> returns Err:502 (Invalid argument) if Number1 results in one number, because SKEWP cannot be calculated with one value.
+</paragraph>
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060185.xhp#skew">SKEW</link></paragraph>
+</section>
+</body>
+</helpdocument> \ No newline at end of file