diff options
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/01.po | 3954 |
1 files changed, 2004 insertions, 1950 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po index d38c21a35f1..e0900c38b2b 100644 --- a/source/zh-TW/helpcontent2/source/text/scalc/01.po +++ b/source/zh-TW/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2020-03-13 12:05+0100\n" +"POT-Creation-Date: 2020-04-03 11:46+0200\n" "PO-Revision-Date: 2019-08-09 07:59+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -10060,22 +10060,13 @@ msgctxt "" msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." msgstr "這些引數可能是本身傳回邏輯值的邏輯表示式 (TRUE, 1<5, 2+3=7, B8<10)，或包含邏輯值的陣列 (A1:C3)。" -#. W8DPe +#. 7ALjG #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3159123\n" "help.text" -msgid "AND(LogicalValue1; LogicalValue2 ...LogicalValue30)" -msgstr "AND(LogicalValue1; LogicalValue2 ...LogicalValue30)" - -#. MoFG6 -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" -"par_id3150038\n" -"help.text" -msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE." +msgid "AND(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" msgstr "" #. 3exzA @@ -10321,22 +10312,13 @@ msgctxt "" msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." msgstr "這些引數可能是本身傳回邏輯值的邏輯表示式 (TRUE, 1<5, 2+3=7, B8<10)，或包含邏輯值的陣列 (A1:C3)。" -#. emuWZ +#. rpDNn #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3150468\n" "help.text" -msgid "OR(LogicalValue1; LogicalValue2 ...LogicalValue30)" -msgstr "OR(LogicalValue1; LogicalValue2 ...LogicalValue30)" - -#. PJjmV -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" -"par_id3155819\n" -"help.text" -msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range." +msgid "OR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" msgstr "" #. oFKWj @@ -10474,14 +10456,14 @@ msgctxt "" msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." msgstr "這些引數可能是本身傳回邏輯值的邏輯表示式 (TRUE, 1<5, 2+3=7, B8<10)，或包含邏輯值的陣列 (A1:C3)。" -#. pdqV8 +#. fpCVV #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3150469\n" "help.text" -msgid "XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)" -msgstr "OR(LogicalValue1; LogicalValue2 ...LogicalValue30)" +msgid "XOR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" +msgstr "" #. qpsgo #: 04060105.xhp @@ -12085,23 +12067,14 @@ msgctxt "" msgid "The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers." msgstr "最大公約數是可整除各指定整數的最大正整數。" -#. LEUYK +#. 84G6i #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3154524\n" "help.text" -msgid "GCD(Integer1; Integer2; ...; Integer30)" -msgstr "GCD(Integer1; Integer2; ...; Integer30)" - -#. KF2eB -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3149340\n" -"help.text" -msgid "<emph>Integer1 To 30</emph> are up to 30 integers whose greatest common divisor is to be calculated." -msgstr "<emph>Integer1 到 30</emph> 是指可多達 30 個將計算其最大公約數的整數。" +msgid "GCD(<embedvar href=\"text/scalc/01/ful_func.xhp#integer255_1\" markup=\"keep\"/>)" +msgstr "" #. EeAKi #: 04060106.xhp @@ -12148,24 +12121,15 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_GCD\">The result is the greatest common divisor of a list of numbers.</ahelp>" msgstr "" -#. RcC6R +#. gQ2S4 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3156205\n" "help.text" -msgid "GCD_EXCEL2003(Number(s))" +msgid "GCD_EXCEL2003(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. Gt222 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3145150\n" -"help.text" -msgid "<emph>Number(s)</emph> is a list of up to 30 numbers." -msgstr "<emph>Number(s)</emph> 是指可多達 30 個數字的清單。" - #. wNE9S #: 04060106.xhp msgctxt "" @@ -12202,32 +12166,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_KGV\">Returns the least common multiple of one or more integers.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_KGV\">傳回一個或多個整數的最小公倍數。</ahelp>" -#. WUZq6 +#. BeETS #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3147279\n" "help.text" -msgid "LCM(Integer1; Integer2; ...; Integer30)" -msgstr "LCM(Integer1; Integer2; ...; Integer30)" - -#. Kqqia -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3156348\n" -"help.text" -msgid "<emph>Integer1 to 30</emph> are up to 30 integers whose lowest common multiple is to be calculated." -msgstr "<emph>Integer1 到 30</emph> 是指可多達 30 個將計算其最小公倍數的整數。" +msgid "LCM(<embedvar href=\"text/scalc/01/ful_func.xhp#integer255_1\" markup=\"keep\"/>)" +msgstr "" -#. eAgPR +#. gzLdr #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3154914\n" "help.text" -msgid "If you enter the numbers <item type=\"input\">512</item>;<item type=\"input\">1024</item> and <item type=\"input\">2000</item> in the Integer 1;2 and 3 text boxes, 128000 will be returned as the result." -msgstr "若在 Integer 1、Integer 2 與 Integer 3 文字方塊中，分別輸入數字 <item type=\"input\">512</item>、<item type=\"input\">1024</item> 與 <item type=\"input\">2000</item>，則會傳回結果 128000。" +msgid "If you enter the numbers 512; 1024 and 2000 as Integer 1;2 and 3, then 128000 will be returned." +msgstr "" #. 7vjBB #: 04060106.xhp @@ -12256,24 +12211,15 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_LCM\">The result is the lowest common multiple of a list of numbers.</ahelp>" msgstr "" -#. WnQpb +#. ZVaoq #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3154395\n" "help.text" -msgid "LCM_EXCEL2003(Number(s))" +msgid "LCM_EXCEL2003(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. EmCPA -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3147377\n" -"help.text" -msgid "<emph>Number(s)</emph> is a list of up to 30 numbers." -msgstr "<emph>Number(s)</emph> 是指可多達 30 個數字的清單。" - #. dNCeM #: 04060106.xhp msgctxt "" @@ -13201,23 +13147,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_MULTINOMIAL\">Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp>" msgstr "" -#. KohhD +#. sRmYD #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3155660\n" "help.text" -msgid "MULTINOMIAL(Number(s))" -msgstr "MULTINOMIAL(Number(s))" - -#. RMEsV -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155673\n" -"help.text" -msgid "<emph>Number(s)</emph> is a list of up to 30 numbers." -msgstr "<emph>Number(s)</emph> 是指可多達 30 個數字的清單。" +msgid "MULTINOMIAL(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. YLFwC #: 04060106.xhp @@ -13417,32 +13354,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_PRODUKT\">Multiplies all the numbers given as arguments and returns the product.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_PRODUKT\">將作為引數指定的所有數字相乘並傳回乘積。</ahelp>" -#. uJFjB +#. Lsojw #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3144446\n" "help.text" -msgid "PRODUCT(Number1; Number2; ...; Number30)" -msgstr "PRODUCT(Number1; Number2; ...; Number30)" - -#. tbeYN -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3144460\n" -"help.text" -msgid "<emph>Number1 to 30</emph> are up to 30 arguments whose product is to be calculated." -msgstr "<emph>Number1 到 30</emph> 是指可多達 30 個將計算其乘積的引數。" - -#. Gnz4g -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id1589098\n" -"help.text" -msgid "PRODUCT returns number1 * number2 * number3 * ..." -msgstr "PRODUCT 傳回 number1 * number2 * number3 * ..." +msgid "PRODUCT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. D5DEG #: 04060106.xhp @@ -13471,41 +13390,32 @@ msgctxt "" msgid "SUMSQ" msgstr "SUMSQ" -#. mgr6s +#. XFoEC #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3160368\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_QUADRATESUMME\">If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_QUADRATESUMME\">如果您要計算數字平方的總合 (引數平方的總計)，將這些輸入文字欄位。</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_QUADRATESUMME\">Calculates the sum of the squares of a set of numbers.</ahelp>" +msgstr "" -#. CSJAJ +#. 2gNvN #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3160402\n" "help.text" -msgid "SUMSQ(Number1; Number2; ...; Number30)" -msgstr "SUMSQ(Number1; Number2; ...; Number30)" - -#. 5R44a -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3160415\n" -"help.text" -msgid "<emph>Number1 to 30</emph> are up to 30 arguments the sum of whose squares is to be calculated." -msgstr "<emph>Number1 到 30</emph> 是指可多達 30 個將計算其平方和的引數。" +msgid "SUMSQ(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. QdbZ8 +#. ANvo3 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3160449\n" "help.text" -msgid "If you enter the numbers <item type=\"input\">2</item>; <item type=\"input\">3</item> and <item type=\"input\">4</item> in the Number 1; 2 and 3 text boxes, 29 is returned as the result." -msgstr "若在 Number 1、Number 2 與 Number 3 文字方塊中，分別輸入數字 <item type=\"input\">2</item>、<item type=\"input\">3</item> 與 <item type=\"input\">4</item>，則會傳回結果 29。" +msgid "If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 arguments, 29 is returned as the result." +msgstr "" #. KGako #: 04060106.xhp @@ -14254,31 +14164,22 @@ msgctxt "" msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>" msgstr "" -#. DBrbm +#. 924XA #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3163625\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_SUMME\">Adds all the numbers in a range of cells.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_SUMME\">將某一儲存格範圍中的所有數字相加。</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_SUMME\">Adds a set of numbers.</ahelp>" +msgstr "" -#. zBKBJ +#. NavGZ #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3163656\n" "help.text" -msgid "SUM(Number1; Number2; ...; Number30)" -msgstr "SUM(Number1; Number2; ...; Number30)" - -#. wApie -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163671\n" -"help.text" -msgid "<emph>Number1 to Number30</emph> are up to 30 arguments, either cells or ranges, whose sum is to be calculated." +msgid "SUM(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. fsBfG @@ -17386,32 +17287,32 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUMMENPRODUKT\">Multiplies corresponding elements in the given arrays, and returns the sum of those products.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_SUMMENPRODUKT\">將指定陣列中對應的元素相乘，並傳回乘積的小計。</ahelp>" -#. rBb3u +#. zmqCZ #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3163347\n" "help.text" -msgid "SUMPRODUCT(Array1; Array2; ...; Array30)" +msgid "SUMPRODUCT(Array 1[; Array 2;][...;[Array 255]])" msgstr "" -#. xBpX8 +#. gGK9K #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3163362\n" "help.text" -msgid "<emph>Array1, Array2; ...; Array30</emph> represent arrays whose corresponding elements are to be multiplied." +msgid "<emph>Array 1[; Array 2;][...;[Array 255]]</emph> represent arrays whose corresponding elements are to be multiplied." msgstr "" -#. 6knhd +#. kCud6 #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_idN11B19\n" "help.text" -msgid "At least one array must be part of the argument list. If only one array is given, all array elements are summed." -msgstr "至少一個陣列必須是引數清單的一部分。如果只提供一個陣列，則會總計所有陣列元素。" +msgid "At least one array must be part of the argument list. If only one array is given, all array elements are summed. If more than one array is given, they must all be the same size." +msgstr "" #. DgsMB #: 04060107.xhp @@ -18412,6 +18313,15 @@ msgctxt "" msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518." msgstr "若儲存格 A1 顯示 Err:518，則函式 <item type=\"input\">=ERRORTYPE(A1)</item> 會傳回數字 518。" +#. FWJTB +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"hd_id275141466817507\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_error_type.xhp#error_type_head\"/>" +msgstr "" + #. mtLKD #: 04060109.xhp msgctxt "" @@ -19915,14 +19825,23 @@ msgctxt "" msgid "Two different syntax definitions can be used:" msgstr "可以使用兩種不同的語法定義：" -#. LmQbe +#. V3C9Q #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id1665089\n" "help.text" -msgid "GETPIVOTDATA(TargetField; pivot table; [ Field 1; Item 1; ... ])" -msgstr "GETPIVOTDATA(TargetField; pivot table; [ Field 1; Item 1; ... ])" +msgid "GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field 126; Item 126]])" +msgstr "" + +#. 3kCjF +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"par_id661585662472832\n" +"help.text" +msgid "or" +msgstr "" #. QnCVY #: 04060109.xhp @@ -19942,6 +19861,15 @@ msgctxt "" msgid "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." msgstr "第二個語法假設實際提供兩個參數，其中第一個參數為儲存格或儲存格範圍參照。第一個語法假設所有其他情況。[函式精靈] 顯示第一個語法。" +#. Cwsfn +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"hd_id431585688827982\n" +"help.text" +msgid "First Syntax" +msgstr "" + #. xTLTZ #: 04060109.xhp msgctxt "" @@ -20005,6 +19933,15 @@ msgctxt "" msgid "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below)." msgstr "僅在如果樞紐分析表的小計值使用「auto」函式時 (除非在限制中使用，請見下面的 <item type=\"literal\">第二個語法</item>) 才能使用。" +#. amRc3 +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"hd_id551585688835597\n" +"help.text" +msgid "Second Syntax" +msgstr "" + #. KETgR #: 04060109.xhp msgctxt "" @@ -20581,23 +20518,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERKETTEN\">Combines several text strings into one string.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VERKETTEN\">將數個文字字串合併為一個字串。</ahelp>" -#. fWvjJ +#. DA2oR #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3155954\n" "help.text" -msgid "CONCATENATE(\"Text1\"; ...; \"Text30\")" -msgstr "CONCATENATE(\"Text1\"; ...; \"Text30\")" +msgid "CONCATENATE(<embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/>)" +msgstr "" -#. rrDyG +#. GCUtY #: 04060110.xhp msgctxt "" "04060110.xhp\n" -"par_id3146847\n" +"par_id781585222554150\n" "help.text" -msgid "<emph>Text 1; Text 2; ...</emph> represent up to 30 text passages which are to be combined into one string." -msgstr "<emph>Text 1; Text 2; ...</emph> 表示多達 30 個會合併成一個字串的文字段落。" +msgid "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings or references to cells containing strings." +msgstr "" #. 8Dfcz #: 04060110.xhp @@ -22390,32 +22327,32 @@ msgctxt "" msgid "TEXT" msgstr "TEXT" -#. woEeG +#. hZGtP #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147213\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_TEXT\">Converts a number into text according to a given format.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_TEXT\">依指定的格式將數字轉換成文字。</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_TEXT\">Converts a value into text according to a given format.</ahelp>" +msgstr "" -#. 9xURB +#. YjEZu #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147377\n" "help.text" -msgid "TEXT(Number; Format)" -msgstr "TEXT(number; format)" +msgid "TEXT(Value; Format)" +msgstr "" -#. BpPCe +#. hGrSa #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147389\n" "help.text" -msgid "<emph>Number</emph> is the numerical value to be converted." -msgstr "<emph>Number</emph> 是指要轉換的數字。" +msgid "<emph>Value</emph> is the value (numerical or textual) to be converted." +msgstr "" #. 3GZvU #: 04060110.xhp @@ -22444,6 +22381,15 @@ msgctxt "" msgid "<item type=\"input\">=TEXT(12.34567;\"000.00\")</item> returns the text 012.35" msgstr "<item type=\"input\">=TEXT(12.34567;\"000.00\")</item> 傳回文字 012.35。" +#. iT5uP +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id3674124\n" +"help.text" +msgid "<item type=\"input\">=TEXT(\"xyz\";\"=== @ ===\")</item> returns the text === xyz ===" +msgstr "" + #. yhDcc #: 04060110.xhp msgctxt "" @@ -26134,6 +26080,51 @@ msgctxt "" msgid "<item type=\"input\">=IMARGUMENT(\"3+4j\")</item> returns 0.927295." msgstr "<item type=\"input\">=IMARGUMENT(\"3+4j\")</item> 傳回 0.927295。" +#. TVX4f +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id69271214320055\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos_head\"/>" +msgstr "" + +#. 4HGsN +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id217971417131058\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh_head\"/>" +msgstr "" + +#. H4rBq +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id7625634121212\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcot.xhp#imcot_head\"/>" +msgstr "" + +#. Fev3E +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id2907192866882\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcsc.xhp#imcsc_head\"/>" +msgstr "" + +#. U7uHv +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id2111268313694\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcsch.xhp#imcsch_head\"/>" +msgstr "" + #. y5rLV #: 04060116.xhp msgctxt "" @@ -26431,23 +26422,23 @@ msgctxt "" msgid "IMPRODUCT" msgstr "IMPRODUCT" -#. i6VKG +#. DSBR5 #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3153545\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_IMPRODUCT\">The result is the product of up to 29 complex numbers.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_IMPRODUCT\">結果為多達 29 個複數的乘積。</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_IMPRODUCT\">The result is the product of a set of complex numbers.</ahelp>" +msgstr "" -#. fUcG3 +#. RDe9u #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3149027\n" "help.text" -msgid "IMPRODUCT(\"ComplexNumber\"; \"ComplexNumber1\"; ...)" -msgstr "IMPRODUCT(\"ComplexNumber\"; \"ComplexNumber1\"; ...)" +msgid "IMPRODUCT(<embedvar href=\"text/scalc/01/ful_func.xhp#complex255_1\" markup=\"keep\"/>)" +msgstr "" #. x58Ur #: 04060116.xhp @@ -26503,6 +26494,51 @@ msgctxt "" msgid "<item type=\"input\">=IMREAL(\"1+3j\")</item> returns 1." msgstr "<item type=\"input\">=IMREAL(\"1+3j\")</item> 傳回 1。" +#. 7L6GP +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id882954222038\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsec.xhp#imsec_head\"/>" +msgstr "" + +#. WpR5E +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id25480538323169\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsech.xhp#imsech_head\"/>" +msgstr "" + +#. sWL67 +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id14741462320337\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin_head\"/>" +msgstr "" + +#. bXgFc +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id12978120123414\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsinh.xhp#imsinh_head\"/>" +msgstr "" + +#. ZRj2s +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id186491693515289\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imtan.xhp#imtan_head\"/>" +msgstr "" + #. rAXpY #: 04060116.xhp msgctxt "" @@ -26566,23 +26602,23 @@ msgctxt "" msgid "IMSUM" msgstr "IMSUM" -#. 6pmzk +#. sD27s #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3153215\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_IMSUM\">The result is the sum of up to 29 complex numbers.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_IMSUM\">結果為多達 29 個複數的小計。</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_IMSUM\">The result is the sum of a set of complex numbers.</ahelp>" +msgstr "" -#. 22fTk +#. dY4UY #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3152930\n" "help.text" -msgid "IMSUM(\"ComplexNumber1\"; \"ComplexNumber2\"; ...)" -msgstr "IMSUM(\"ComplexNumber1\"; \"ComplexNumber2\"; ...)" +msgid "IMSUM(<embedvar href=\"text/scalc/01/ful_func.xhp#complex255_1\" markup=\"keep\"/>)" +msgstr "" #. CNtPR #: 04060116.xhp @@ -31165,13 +31201,13 @@ msgctxt "" msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xnpv\" name=\"XNPV\">XNPV</link> function." msgstr "" -#. QXdUJ +#. ZxBQz #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3153321\n" "help.text" -msgid "NPV(Rate; Value1; Value2; ...; Value30)" +msgid "NPV(Rate; <embedvar href=\"text/scalc/01/ful_func.xhp#number254_1\" markup=\"keep\"/>)" msgstr "" #. EEL34 @@ -31183,15 +31219,6 @@ msgctxt "" msgid "<emph>Rate</emph> is the discount rate for a period." msgstr "<emph>Rate</emph> 是指週期的折扣率。" -#. YFAME -#: 04060119.xhp -msgctxt "" -"04060119.xhp\n" -"par_id3150427\n" -"help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are up to 30 values, which represent deposits or withdrawals." -msgstr "" - #. DAypR #: 04060119.xhp msgctxt "" @@ -32686,22 +32713,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ANZAHL\">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored." msgstr "<ahelp hid=\"HID_FUNC_ANZAHL\">計算引數清單中有多少個值。</ahelp> 忽略文字項目。" -#. ENuAv +#. AWuDZ #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3148585\n" "help.text" -msgid "COUNT(Value1; Value2; ...; Value30)" -msgstr "" - -#. ncvRM -#: 04060181.xhp -msgctxt "" -"04060181.xhp\n" -"par_id3155827\n" -"help.text" -msgid "<emph>Value1; Value2, ..., Value30</emph> are 1 to 30 values or ranges representing the values to be counted." +msgid "COUNT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. VBCGA @@ -32749,22 +32767,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ANZAHL2\">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored." msgstr "<ahelp hid=\"HID_FUNC_ANZAHL2\">計算引數清單中數值的個數。</ahelp> 也會計算文字項目，即使它們包含的是長度為 0 的空字串。如果引數是一個陣列或參照，則會略過該陣列或參照內的空儲存格。" -#. EyyFo +#. eEkCJ #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3153111\n" "help.text" -msgid "COUNTA(Value1; Value2; ...; Value30)" -msgstr "" - -#. dZVxR -#: 04060181.xhp -msgctxt "" -"04060181.xhp\n" -"par_id3150001\n" -"help.text" -msgid "<emph>Value1; Value2, ..., Value30</emph> are 1 to 30 arguments representing the values to be counted." +msgid "COUNTA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. QKY5C @@ -37510,22 +37519,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_KURT\">Returns the kurtosis of a data set (at least 4 values required).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_KURT\">傳回資料集的峰態 (至少需要 4 個值)。</ahelp>" -#. rKFxG +#. VpSiM #: 04060183.xhp msgctxt "" "04060183.xhp\n" "par_id3154508\n" "help.text" -msgid "KURT(Number1; Number2; ...; Number30)" +msgid "KURT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. 3g87D +#. qFqj4 #: 04060183.xhp msgctxt "" "04060183.xhp\n" -"par_id3145167\n" +"par_id501585152669900\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges representing a random sample of distribution." +msgid "The parameters should specify at least four values." msgstr "" #. V4wcF @@ -37906,22 +37915,13 @@ msgctxt "" msgid "Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN(\"string\"), still results in an error." msgstr "若沒有任何數值且傳送為儲存格參照的儲存格範圍中未發生任何錯誤，即會傳回 0。MIN() 和 MAX() 會忽略文字儲存格。若沒有任何值 (數值或文字) 且沒有發生任何錯誤，MINA() 和 MAXA() 函式即會傳回 0。將文字字串引數傳送給 MIN() 或 MAX() (例如 MIN(\"string\")) 仍會產生錯誤。" -#. c2Fno +#. gTV5V #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3147340\n" "help.text" -msgid "MAX(Number1; Number2; ...; Number30)" -msgstr "" - -#. 3QEiy -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3149568\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "MAX(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. giyJK @@ -37978,22 +37978,13 @@ msgctxt "" msgid "The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered." msgstr "若沒有任何值 (數值或文字) 且沒有發生任何錯誤，MINA() 和 MAXA() 函式即會傳回 0。" -#. 8wybP +#. X7jxS #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3166431\n" "help.text" -msgid "MAXA(Value1; Value2; ...; Value30)" -msgstr "" - -#. 3DZRe -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150202\n" -"help.text" -msgid "<emph>Value1; Value2;...; Value30</emph> are values or ranges. Text has the value of 0." +msgid "MAXA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. ZxXLp @@ -38041,22 +38032,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MEDIAN\">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_MEDIAN\">傳回一組數字的中位數。在包含奇數值的組中，中位數將是該組數中間的數字，而在包含偶數值的組中，中位數將是組數中間兩個值的平均值。</ahelp>" -#. 6ies7 +#. CGf4S #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3155264\n" "help.text" -msgid "MEDIAN(Number1; Number2; ...; Number30)" -msgstr "" - -#. qugaM -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150109\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference." +msgid "MEDIAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. bDCXJ @@ -38113,22 +38095,13 @@ msgctxt "" msgid "Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN(\"string\"), still results in an error." msgstr "若沒有任何數值且傳送為儲存格參照的儲存格範圍中未發生任何錯誤，即會傳回 0。MIN() 和 MAX() 會忽略文字儲存格。若沒有任何值 (數值或文字) 且沒有發生任何錯誤，MINA() 和 MAXA() 函式即會傳回 0。將文字字串引數傳送給 MIN() 或 MAX() (例如 MIN(\"string\")) 仍會產生錯誤。" -#. ewK5y +#. YtBaP #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3146964\n" "help.text" -msgid "MIN(Number1; Number2; ...; Number30)" -msgstr "" - -#. sUDim -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3153486\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "MIN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. yutoe @@ -38176,22 +38149,13 @@ msgctxt "" msgid "The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered." msgstr "若沒有任何值 (數值或文字) 且沒有發生任何錯誤，MINA() 和 MAXA() 函式即會傳回 0。" -#. cjn64 +#. AG7MH #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3153336\n" "help.text" -msgid "MINA(Value1; Value2; ...; Value30)" -msgstr "" - -#. 3Go2h -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3146098\n" -"help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0." +msgid "MINA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. TrF9C @@ -38239,22 +38203,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MITTELABW\">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set." msgstr "<ahelp hid=\"HID_FUNC_MITTELABW\">傳回其中數的資料點之絕對偏差的平均。</ahelp> 顯示資料集中的擴散。" -#. 9zfs5 +#. sAUCf #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3145636\n" "help.text" -msgid "AVEDEV(Number1; Number2; ...; Number30)" -msgstr "" - -#. qNkLm -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3157871\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference." +msgid "AVEDEV(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. UA5P6 @@ -38293,22 +38248,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MITTELWERT\">Returns the average of the arguments.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_MITTELWERT\">傳回引數的平均值。</ahelp>" -#. LVfcJ +#. K8QCj #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3154679\n" "help.text" -msgid "AVERAGE(Number1; Number2; ...; Number30)" -msgstr "" - -#. brJC4 -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150741\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "AVERAGE(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. AjUyH @@ -38347,32 +38293,41 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MITTELWERTA\">Returns the average of the arguments. The value of a text is 0.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_MITTELWERTA\">傳回引數的平均值。文字的值為 0。</ahelp>" -#. vvXZb +#. opsEb #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3149734\n" "help.text" -msgid "AVERAGEA(Value1; Value2; ...; Value30)" +msgid "AVERAGEA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. kHd3R +#. sxYNi #: 04060184.xhp msgctxt "" "04060184.xhp\n" -"par_id3155260\n" +"par_id3150864\n" +"help.text" +msgid "<item type=\"input\">=AVERAGEA(A1:A50)</item>" +msgstr "<item type=\"input\">=AVERAGEA(A1:A50)</item>" + +#. iLCTX +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id110421803716508\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0." +msgid "<embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>" msgstr "" -#. sxYNi +#. K3rLb #: 04060184.xhp msgctxt "" "04060184.xhp\n" -"par_id3150864\n" +"hd_id5471656631510\n" "help.text" -msgid "<item type=\"input\">=AVERAGEA(A1:A50)</item>" -msgstr "<item type=\"input\">=AVERAGEA(A1:A50)</item>" +msgid "<embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>" +msgstr "" #. hKE9h #: 04060184.xhp @@ -38401,22 +38356,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MODALWERT\">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice." msgstr "<ahelp hid=\"HID_FUNC_MODALWERT\">傳回資料集中的最大共用值。</ahelp> 如果有好幾個值具有相同頻率，則會傳回最小值。值不出現兩次時發生錯誤。" -#. FuKPf +#. DFEQv #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3155950\n" "help.text" -msgid "MODE(Number1; Number2; ...; Number30)" -msgstr "" - -#. UkRWQ -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150337\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "MODE(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. VYNy2 @@ -38455,22 +38401,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MODAL_VALUE_MS\">Returns the most frequently occurring, or repetitive, value in an array or range of data.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice." msgstr "<ahelp hid=\"HID_FUNC_MODALWERT\">傳回資料集中的最大共用值。</ahelp> 如果有好幾個值具有相同頻率，則會傳回最小值。值不出現兩次時發生錯誤。" -#. 6wWnN +#. Y5cCt #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2955950\n" "help.text" -msgid "MODE.SNGL(Number1; Number2; ...; Number30)" -msgstr "" - -#. zJnLw -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id2950337\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "MODE.SNGL(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. BGawC @@ -38518,22 +38455,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MODAL_VALUE_MULTI\">Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.</ahelp>" msgstr "" -#. ApATB +#. zDERD #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2855950\n" "help.text" -msgid "MODE.MULT(Number1; Number2; ...; Number30)" -msgstr "" - -#. cBqq8 -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id2850337\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "MODE.MULT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. nrjtV @@ -40309,22 +40237,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SCHIEFE\">Returns the skewness of a distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_SCHIEFE\">傳回分佈的不對稱。</ahelp>" -#. pAGuG +#. EndQD #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3151191\n" "help.text" -msgid "SKEW(Number1; Number2; ...; Number30)" +msgid "SKEW(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. UdXzQ +#. BmsyE #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3155757\n" +"par_id171585151428396\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." +msgid "The parameters should specify at least three values." msgstr "" #. sBJ47 @@ -40507,32 +40435,32 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABW\">Estimates the standard deviation based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABW\">根據範例估計標準離差。</ahelp>" -#. J44yd +#. 2b5hp #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149946\n" "help.text" -msgid "STDEV(Number1; Number2; ...; Number30)" +msgid "STDEV(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. 8LECi +#. H3V9F #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3157904\n" +"par_id211585163957345\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population." +msgid "The parameters should specify at least two values." msgstr "" -#. EAs58 +#. S754h #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149434\n" "help.text" -msgid "<item type=\"input\">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced." -msgstr "<item type=\"input\">=STDEV(A1:A50)</item> 傳回根據參照資料所估計的標準差。" +msgid "<input>=STDEV(A1:A50)</input> returns the estimated standard deviation based on the data referenced." +msgstr "" #. EaGD7 #: 04060185.xhp @@ -40561,22 +40489,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABWA\">Calculates the standard deviation of an estimation based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWA\">根據範例計算估計的標準離差。</ahelp>" -#. 5HP5n +#. JfwF6 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3147422\n" "help.text" -msgid "STDEVA(Value1; Value2; ...; Value30)" +msgid "STDEVA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. Ai2oZ +#. iK7Ch #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3154547\n" +"par_id981585163977014\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0." +msgid "The parameters should specify at least two values. Text has the value 0." msgstr "" #. mgbPX @@ -40615,22 +40543,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABWN\">Calculates the standard deviation based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWN\">根據總體基數計算標準離差。</ahelp>" -#. CoZTL +#. zoiE5 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3154392\n" "help.text" -msgid "STDEVP(Number1; Number2; ...; Number30)" -msgstr "" - -#. oVXGo -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3155261\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." +msgid "STDEVP(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. ADXhB @@ -40669,22 +40588,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ST_DEV_P_MS\">Calculates the standard deviation based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWN\">根據總體基數計算標準離差。</ahelp>" -#. AeSxQ +#. J5bPQ #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2954392\n" "help.text" -msgid "STDEV.P(Number1; Number2; ...; Number30)" -msgstr "" - -#. mxvZc -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id2955261\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." +msgid "STDEV.P(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. 9PAi8 @@ -40723,22 +40633,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ST_DEV_S\">Calculates the standard deviation based on sample of the population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWN\">根據總體基數計算標準離差。</ahelp>" -#. U7xDq +#. dG9nh #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2854392\n" "help.text" -msgid "STDEV.S(Number1; Number2; ...; Number30)" +msgid "STDEV.S(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. agaSo +#. fPUck #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id2855261\n" +"par_id671585163972431\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population." +msgid "The parameters should specify at least two values." msgstr "" #. 9GmUP @@ -40777,22 +40687,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABWNA\">Calculates the standard deviation based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWNA\">根據總體基數計算標準離差。</ahelp>" -#. RhZBw +#. gqtD3 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3146851\n" "help.text" -msgid "STDEVPA(Value1; Value2; ...; Value30)" +msgid "STDEVPA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. 5yKuZ +#. DL6D2 #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3153109\n" +"par_id961585163990543\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0." +msgid "Text has the value 0." msgstr "" #. avUGE @@ -41272,22 +41182,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUMQUADABW\">Returns the sum of squares of deviations based on a sample mean.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_SUMQUADABW\">傳回根據範例平均值偏差的平方總和。</ahelp>" -#. soLp9 +#. pg3Aq #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3146790\n" "help.text" -msgid "DEVSQ(Number1; Number2; ...; Number30)" -msgstr "" - -#. u7jWS -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3155995\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample." +msgid "DEVSQ(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. tETcx @@ -41947,22 +41848,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZ\">Estimates the variance based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZ\">根據範例估計變異數。</ahelp>" -#. C8m5y +#. NGDxF #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3153054\n" "help.text" -msgid "VAR(Number1 ; Number2; ...; Number30)" +msgid "VAR(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. AUGbB +#. qsPg5 #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3148938\n" +"par_id721585215582420\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population." +msgid "The parameters should specify at least two values." msgstr "" #. 7rJxK @@ -42001,22 +41902,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VAR_S\">Estimates the variance based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZ\">根據範例估計變異數。</ahelp>" -#. BAcfb +#. Y2B8P #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2953054\n" "help.text" -msgid "VAR.S(Number1; Number2; ...; Number30)" +msgid "VAR.S(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. SpFct +#. GGJFX #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id2948938\n" +"par_id891585215590756\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population." +msgid "The parameters should specify at least two values." msgstr "" #. GMEXA @@ -42055,22 +41956,22 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZA\">Estimates a variance based on a sample. The value of text is 0.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZA\">根據範例估計變異數。文字的值為 0。</ahelp>" -#. zpEAh +#. mrEpZ #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149999\n" "help.text" -msgid "VARA(Value1; Value2; ...; Value30)" +msgid "VARA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. 26jmj +#. KSAnB #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3158421\n" +"par_id451585215586628\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0." +msgid "The parameters should specify at least two values." msgstr "" #. 4Prou @@ -42109,22 +42010,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZEN\">Calculates a variance based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZEN\">根據總體基數計算變異數。</ahelp>" -#. p2RDk +#. ArDPU #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3147282\n" "help.text" -msgid "VARP(Number1; Number2; ...; Number30)" -msgstr "" - -#. mDRT9 -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3149793\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." +msgid "VARP(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. PGCgC @@ -42163,22 +42055,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VAR_P_MS\">Calculates a variance based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZEN\">根據總體基數計算變異數。</ahelp>" -#. LTWJn +#. t4tND #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2947282\n" "help.text" -msgid "VAR.P(Number1; Number2; ...; Number30)" -msgstr "" - -#. oB7AH -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id2949793\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." +msgid "VAR.P(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. zF5Ys @@ -42217,22 +42100,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZENA\">Calculates the variance based on the entire population. The value of text is 0.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZENA\">根據總體基數計算變異數。文字的值為 0。</ahelp>" -#. hdFhe +#. cAGPm #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149967\n" "help.text" -msgid "VARPA(Value1; Value2; ...; Value30)" -msgstr "" - -#. wStfk -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3149920\n" -"help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population." +msgid "VARPA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. Fa9Jj @@ -48184,6 +48058,15 @@ msgctxt "" msgid "<link href=\"text/scalc/01/06080000.xhp\" name=\"Recalculate\">Recalculate</link>" msgstr "<link href=\"text/scalc/01/06080000.xhp\" name=\"重新計算\">重新計算</link>" +#. CBCeE +#: 06080000.xhp +msgctxt "" +"06080000.xhp\n" +"par_id951584669541929\n" +"help.text" +msgid "Recalculates formula cells." +msgstr "" + #. tCCr5 #: 06080000.xhp msgctxt "" @@ -48436,14 +48319,14 @@ msgctxt "" msgid "Define Database Range" msgstr "定義資料庫範圍" -#. EgD2t +#. 3F2WA #: 12010000.xhp msgctxt "" "12010000.xhp\n" "hd_id3157909\n" "help.text" -msgid "Define Database Range" -msgstr "定義資料庫範圍" +msgid "<link href=\"text/scalc/01/12010000.xhp\" name=\"Define Database Range\">Define Range</link>" +msgstr "" #. 8zFH5 #: 12010000.xhp @@ -48679,14 +48562,14 @@ msgctxt "" msgid "<bookmark_value>databases; selecting (Calc)</bookmark_value>" msgstr "<bookmark_value>資料庫; 選擇 (Calc)</bookmark_value>" -#. D9fvg +#. LFBZy #: 12020000.xhp msgctxt "" "12020000.xhp\n" "hd_id3145068\n" "help.text" -msgid "Select Database Range" -msgstr "選擇資料庫區域" +msgid "<link href=\"text/scalc/01/12020000.xhp\" name=\"Select Database Range\">Select Range</link>" +msgstr "" #. DjALP #: 12020000.xhp @@ -48724,14 +48607,14 @@ msgctxt "" msgid "Sort" msgstr "排序" -#. uyAAQ +#. 2U5X4 #: 12030000.xhp msgctxt "" "12030000.xhp\n" "hd_id3150275\n" "help.text" -msgid "Sort" -msgstr "排序" +msgid "<link href=\"text/scalc/01/12030000.xhp\" name=\"\">Sort</link>" +msgstr "" #. BHBgn #: 12030000.xhp @@ -49255,14 +49138,14 @@ msgctxt "" msgid "Filter" msgstr "篩選" -#. uzVFC +#. A3xBE #: 12040000.xhp msgctxt "" "12040000.xhp\n" "hd_id3150767\n" "help.text" -msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filter</link>" -msgstr "<link href=\"text/scalc/01/12040000.xhp\" name=\"篩選\">篩選</link>" +msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filters</link>" +msgstr "" #. PgpNB #: 12040000.xhp @@ -49642,14 +49525,14 @@ msgctxt "" msgid "Subtotals" msgstr "小計" -#. QTDg7 +#. zaCLT #: 12050000.xhp msgctxt "" "12050000.xhp\n" "hd_id3153822\n" "help.text" -msgid "Subtotals" -msgstr "小計" +msgid "<variable id=\"subtotalheaderh1\"><link href=\"text/scalc/01/12050000.xhp\" name=\"subtotals\">Subtotals</link></variable>" +msgstr "" #. 2jiYA #: 12050000.xhp @@ -49714,69 +49597,6 @@ msgctxt "" msgid "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/SubTotalGrpPage\">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp>" msgstr "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/SubTotalGrpPage\">最多指定三個小計群組的設定。每個標籤都具有相同的版面配置。</ahelp>" -#. nEYZU -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3148797\n" -"help.text" -msgid "To insert subtotal values into a table:" -msgstr "若要在表格中插入小計值，請：" - -#. vSxgC -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3154908\n" -"help.text" -msgid "Ensure that the columns of the table have labels." -msgstr "確保表格中的欄具有貼標。" - -#. kAjkC -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3153968\n" -"help.text" -msgid "Select the table or the area in the table that you want to calculate subtotals for, and then choose <emph>Data – Subtotals</emph>." -msgstr "選取要進行小計的表格或表格中的區域，然後選擇<emph>[資料] - [小計]</emph>。" - -#. MgpYw -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3161831\n" -"help.text" -msgid "In the <emph>Group By</emph> box, select the column that you want to add the subtotals to." -msgstr "在<emph>[依群組]</emph>方塊中，選取要加入小計的欄。" - -#. j4eTU -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3153188\n" -"help.text" -msgid "In the <emph>Calculate subtotals for</emph> box, select the check boxes for the columns containing the values that you want to subtotal." -msgstr "在<emph>[小計用於]</emph>方塊中，選取包含要進行小計的值之欄的核取方塊。" - -#. KKqre -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3152460\n" -"help.text" -msgid "In the <emph>Use function</emph> box, select the function that you want to use to calculate the subtotals." -msgstr "在<emph>[計算規則]</emph>方塊中，選取要用於進行小計的函式。" - -#. bDaWE -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3154321\n" -"help.text" -msgid "Click <emph>OK</emph>." -msgstr "按一下<emph>[確定]</emph>。" - #. a9Dzb #: 12050100.xhp msgctxt "" @@ -50011,14 +49831,14 @@ msgctxt "" msgid "Multiple Operations" msgstr "多重運算" -#. TeBAd +#. rc8Gi #: 12060000.xhp msgctxt "" "12060000.xhp\n" "hd_id3153381\n" "help.text" -msgid "Multiple Operations" -msgstr "多重運算" +msgid "<link href=\"text/scalc/01/12060000.xhp\" name=\"multiple operations\">Multiple Operations</link>" +msgstr "" #. WJG7J #: 12060000.xhp @@ -50119,14 +49939,14 @@ msgctxt "" msgid "Consolidate" msgstr "合併計算" -#. UM7Jw +#. 4QnDV #: 12070000.xhp msgctxt "" "12070000.xhp\n" "hd_id3148946\n" "help.text" -msgid "Consolidate" -msgstr "合併計算" +msgid "<link href=\"text/scalc/01/12070000.xhp\" name=\"Consolidate\">Consolidate</link>" +msgstr "" #. LGBKi #: 12070000.xhp @@ -53026,14 +52846,14 @@ msgctxt "" msgid "Validity" msgstr "有效" -#. BoEo2 +#. ib9Du #: 12120000.xhp msgctxt "" "12120000.xhp\n" "hd_id3156347\n" "help.text" -msgid "Validity" -msgstr "有效" +msgid "<link href=\"text/scalc/01/12120000.xhp\" name=\"validity\">Validity</link>" +msgstr "" #. EGFSj #: 12120000.xhp @@ -53719,6 +53539,33 @@ msgctxt "" msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)" msgstr "" +#. SGHPh +#: calculate.xhp +msgctxt "" +"calculate.xhp\n" +"tit\n" +"help.text" +msgid "Calculate" +msgstr "" + +#. bgC7w +#: calculate.xhp +msgctxt "" +"calculate.xhp\n" +"hd_id621584668179317\n" +"help.text" +msgid "<link href=\"text/scalc/01/calculate.xhp\" name=\"Calculate\">Calculate</link>" +msgstr "" + +#. CFB7A +#: calculate.xhp +msgctxt "" +"calculate.xhp\n" +"par_id241584668179318\n" +"help.text" +msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>" +msgstr "" + #. AZNrM #: common_func.xhp msgctxt "" @@ -53962,22 +53809,22 @@ msgctxt "" msgid "<bookmark_value>data entry forms;for spreadsheets</bookmark_value> <bookmark_value>data entry forms;insert data in spreadsheets</bookmark_value> <bookmark_value>insert data;data entry forms for spreadsheets</bookmark_value> <bookmark_value>spreadsheet;form for inserting data</bookmark_value>" msgstr "" -#. wAipd +#. wTC98 #: data_form.xhp msgctxt "" "data_form.xhp\n" "hd_id240920171003006302\n" "help.text" -msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Entry Forms for Spreadsheets</link>" +msgid "<link href=\"text/scalc/01/data_form.xhp\">Form</link>" msgstr "" -#. Q7Qbi +#. wrzkB #: data_form.xhp msgctxt "" "data_form.xhp\n" "par_id240920171003293400\n" "help.text" -msgid "<ahelp hid=\".\">Data Entry Form is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide." +msgid "<ahelp hid=\".\"><emph>Data Entry Form</emph> is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide." msgstr "" #. VoVM6 @@ -54340,13 +54187,13 @@ msgctxt "" msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." msgstr "" -#. hHEEK +#. 5DDEz #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" "par_id961527953004850\n" "help.text" -msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion1[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable>" msgstr "" #. d8gmy @@ -54367,6 +54214,15 @@ msgctxt "" msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." msgstr "" +#. XB7By +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id101585468691583\n" +"help.text" +msgid "<emph>Range1</emph> – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied." +msgstr "" + #. 3wJSR #: ex_data_stat_func.xhp msgctxt "" @@ -54934,6 +54790,132 @@ msgctxt "" msgid "The result is presented in the string format and has the character \"i\" or \"j\" as an imaginary unit." msgstr "" +#. 3yZht +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id71584446760037\n" +"help.text" +msgid "<variable id=\"string255_1\">String 1[; String 2][; … ;[String 255]]</variable>" +msgstr "" + +#. aZAJy +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id631556228516997\n" +"help.text" +msgid "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings, references to cells or to cell ranges of strings." +msgstr "" + +#. Gx7GF +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id401584447957914\n" +"help.text" +msgid "<variable id=\"integer255_1\">Integer 1[; Integer 2][; … ;[Integer 255]]</variable>" +msgstr "" + +#. sCxFS +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id1001584395844941\n" +"help.text" +msgid "<emph>Integer 1[; Integer 2][; … ;[Integer 255]]</emph> are integers, references to cells or to cell ranges of integers." +msgstr "" + +#. KJbXQ +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id101584447971004\n" +"help.text" +msgid "<variable id=\"number254_1\">Number 1[; Number 2][; … ;[Number 254]]</variable>" +msgstr "" + +#. JPXDA +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584305947010\n" +"help.text" +msgid "<emph>Number 1[; Number 2][; … ;[Number 254]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgstr "" + +#. y6bDp +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id101584447970004\n" +"help.text" +msgid "<variable id=\"number255_1\">Number 1[; Number 2][; … ;[Number 255]]</variable>" +msgstr "" + +#. BXZo8 +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584395947010\n" +"help.text" +msgid "<emph>Number 1[; Number 2][; … ;[Number 255]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgstr "" + +#. AWCP7 +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id291584447988879\n" +"help.text" +msgid "<variable id=\"logical255_1\">Logical 1[; Logical 2][; … ;[Logical 255]]</variable>" +msgstr "" + +#. CzEmY +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584395957010\n" +"help.text" +msgid "<emph>Logical 1[; Logical 2][; … ;[Logical 255]]</emph> are boolean values, references to cells or to cell ranges of logical values." +msgstr "" + +#. cjCCW +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id91584448008632\n" +"help.text" +msgid "<variable id=\"complex255_1\">Complex 1[; Complex 2][; … ;[Complex 255]]</variable>" +msgstr "" + +#. AfffT +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584335947010\n" +"help.text" +msgid "<emph>Complex 1[; Complex 2][; … ;[Complex 255]]</emph> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form \"x+yi\" or \"x+yj\"." +msgstr "" + +#. SDfoG +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id61584448028298\n" +"help.text" +msgid "<variable id=\"reference255_1\">Reference 1[; Reference 2][; … ;[Reference 255]]</variable>" +msgstr "" + +#. NwpZa +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id431584335947010\n" +"help.text" +msgid "<emph>Reference 1[; Reference 2][; … ;[Reference 255]]</emph> are references to cells." +msgstr "" + #. 8DbP2 #: func_aggregate.xhp msgctxt "" @@ -54979,13 +54961,13 @@ msgctxt "" msgid "AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row." msgstr "" -#. 3XYPK +#. 7VEyN #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id200801176228491\n" "help.text" -msgid "AGGREGATE(Function; Option; Ref1 [; Ref2 [; …]])" +msgid "AGGREGATE(Function; Option; Number 1[; Number 2][; ... ;[Number 253]])" msgstr "" #. Xt2VS @@ -54997,13 +54979,13 @@ msgctxt "" msgid "or" msgstr "" -#. pDFDZ +#. 2nzVY #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id30181907128680\n" "help.text" -msgid "AGGREGATE(Function; Option; Array [; k])" +msgid "AGGREGATE(Function; Option; Array[; k])" msgstr "" #. WPGsi @@ -55303,31 +55285,31 @@ msgctxt "" msgid "Ignore only hidden rows and errors" msgstr "" -#. GyzCp +#. ztEnu #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id220402843321947\n" "help.text" -msgid "<emph>Ref1</emph> – obligatory argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it." +msgid "<emph>Number1</emph> – required argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it." msgstr "" -#. HYjBf +#. wNPAv #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id2309201514193338\n" "help.text" -msgid "<emph>Ref2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value." +msgid "<emph>Number2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value." msgstr "" -#. XGBRq +#. VQD44 #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id99381371214702\n" "help.text" -msgid "<emph>Array</emph> – obligatory argument. The array can be specified by the boundaries of the range, the name of the named range or the column label." +msgid "<emph>Array</emph> – required argument. The array can be specified by the boundaries of the range, the name of the named range or the column label." msgstr "" #. tQG5i @@ -55339,13 +55321,13 @@ msgctxt "" msgid "For using column labels “Automatically find columns and rows labels” function needs to be enabled." msgstr "" -#. 7dDDM +#. FChoZ #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id2209201514174370\n" "help.text" -msgid "<emph>k</emph> – obligatory argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions." +msgid "<emph>k</emph> – required argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions." msgstr "" #. 5M7aG @@ -56158,22 +56140,13 @@ msgctxt "" msgid "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate." msgstr "" -#. Em25Q -#: func_concat.xhp -msgctxt "" -"func_concat.xhp\n" -"par_id911556226813411\n" -"help.text" -msgid "CONCAT( string1[, string2][, …] )" -msgstr "" - -#. suFNR +#. fJEF4 #: func_concat.xhp msgctxt "" "func_concat.xhp\n" -"par_id581556227044166\n" +"par_id911556226813412\n" "help.text" -msgid "<emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains strings to concatenate." +msgid "CONCAT( <embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/> )" msgstr "" #. aTwgH @@ -56230,22 +56203,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" msgstr "" -#. CQxwD +#. xRjyE #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" "par_id27421466710275\n" "help.text" -msgid "COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])" -msgstr "" - -#. fMsMm -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id242131304318587\n" -"help.text" -msgid "<emph>Range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for counting and finding the corresponding criterion." +msgid "COUNTIFS(Range1; Criterion1[; Range2; Criterion2][; ... ; [Range127; Criterion127]])" msgstr "" #. 2BB8K @@ -58570,13 +58534,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">IFS is a multiple IF-function.</ahelp></variable>" msgstr "" -#. pspe6 +#. WxB3F #: func_ifs.xhp msgctxt "" "func_ifs.xhp\n" "par_id271556235333493\n" "help.text" -msgid "IFS( expression1, result1[, expression2, result2][, …] )" +msgid "IFS(expression1; result1[; expression2; result2][; ... ; [expression127; result127]])" msgstr "" #. 3KbKX @@ -61108,30 +61072,48 @@ msgctxt "" msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors.</ahelp>" msgstr "" -#. H2pwA +#. DZTdg #: func_rawsubtract.xhp msgctxt "" "func_rawsubtract.xhp\n" "par_2016112109233\n" "help.text" -msgid "RAWSUBTRACT(Minuend, Subtrahend1, Subtrahend2, ...)" +msgid "RAWSUBTRACT(Minuend; Subtrahend 1[; Subtrahend 2][; … ;[ Subtrahend 254]])" msgstr "" -#. xbWdN +#. 7mBFv #: func_rawsubtract.xhp msgctxt "" "func_rawsubtract.xhp\n" "par_2016112109234\n" "help.text" -msgid "Subtracts the subtrahend(s) from the minuend without eliminating roundoff errors. The function should be called with at least two parameters." +msgid "<emph>Minuend</emph> is a number or a reference to a cell containing a number." msgstr "" -#. fB4Ah +#. nFADC +#: func_rawsubtract.xhp +msgctxt "" +"func_rawsubtract.xhp\n" +"par_id241585352178687\n" +"help.text" +msgid "<emph>Subtrahend 1[; Subtrahend 2][; ... ;[ Subtrahend 254]]</emph> are numbers or references to cells containing numbers." +msgstr "" + +#. 7ciz5 #: func_rawsubtract.xhp msgctxt "" "func_rawsubtract.xhp\n" "par_2016112109235\n" "help.text" +msgid "The function should be called with at least two parameters." +msgstr "" + +#. gwtEM +#: func_rawsubtract.xhp +msgctxt "" +"func_rawsubtract.xhp\n" +"par_2016112109236\n" +"help.text" msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765, 0.9876543210987)</item> returns 6.53921361504217E-14" msgstr "" @@ -61693,31 +61675,22 @@ msgctxt "" msgid "<ahelp hid=\".\">Calculates the skewness of a distribution using the population of a random variable.</ahelp>" msgstr "" -#. w2FMD +#. FCmqL #: func_skewp.xhp msgctxt "" "func_skewp.xhp\n" "par_id27421466710275\n" "help.text" -msgid "SKEWP(Number1; Number2; ...; Number30)" +msgid "SKEWP(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" -#. r6EFM -#: func_skewp.xhp -msgctxt "" -"func_skewp.xhp\n" -"par_id242131304318587\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are up to 30 numerical values or ranges." -msgstr "<emph>Number1, Number2...Number30</emph> 是數值或範圍。" - -#. 2Cw95 +#. Af6Mq #: func_skewp.xhp msgctxt "" "func_skewp.xhp\n" "par_id242131304315587\n" "help.text" -msgid "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." +msgid "The parameters should specify at least three values." msgstr "" #. W8hYu @@ -61981,13 +61954,22 @@ msgctxt "" msgid "<variable id=\"functionswitch\"><ahelp hid=\".\">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.</ahelp></variable>" msgstr "" -#. esoEp +#. tFvZx #: func_switch.xhp msgctxt "" "func_switch.xhp\n" "par_id521556242803283\n" "help.text" -msgid "SWITCH( expression, value1, result1[, value2, result2][, … ][, default_result] )" +msgid "SWITCH(expression; value1; result1[; value2; result2][; ... ; [value127; result127][; default_result]])" +msgstr "" + +#. p8fL8 +#: func_switch.xhp +msgctxt "" +"func_switch.xhp\n" +"par_id111585520651521\n" +"help.text" +msgid "If you choose not to specify a default result, 127 value / result pairs may be entered as parameters. If you choose to include a default result at the end of the list of parameters, then only 126 value / result pairs may be entered." msgstr "" #. nnW4D @@ -62089,13 +62071,13 @@ msgctxt "" msgid "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable>" msgstr "" -#. qZsoF +#. q72j4 #: func_textjoin.xhp msgctxt "" "func_textjoin.xhp\n" "par_id541556228253979\n" "help.text" -msgid "TEXTJOIN( delimiter, skip_empty, string1[, string2][, …] )" +msgid "TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )" msgstr "" #. WaME6 @@ -62116,13 +62098,13 @@ msgctxt "" msgid "<emph>skip_empty</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored." msgstr "" -#. emud3 +#. JoYks #: func_textjoin.xhp msgctxt "" "func_textjoin.xhp\n" "par_id631556228516997\n" "help.text" -msgid "<emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains text to join." +msgid "<emph>String 1[; String 2][; … ;[String 253]]</emph> are strings, references to cells or to cell ranges of strings." msgstr "" #. PDbCp @@ -64510,13 +64492,13 @@ msgctxt "" msgid "Data Statistics in Calc" msgstr "" -#. wekDu +#. VK8em #: statistics.xhp msgctxt "" "statistics.xhp\n" "hd_id1000010\n" "help.text" -msgid "Data Statistics in Calc" +msgid "<link href=\"text/scalc/01/statistics.xhp\" name=\"Data Statistics in Calc\">Statistics</link>" msgstr "" #. iXfGE @@ -64537,2398 +64519,2470 @@ msgctxt "" msgid "To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table." msgstr "" -#. MufZD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"bm_id2764278\n" -"help.text" -msgid "<bookmark_value>Analysis toolpack;sampling</bookmark_value><bookmark_value>sampling;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;sampling</bookmark_value>" -msgstr "" - -#. HBwLS -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000020\n" -"help.text" -msgid "Sampling" -msgstr "" - -#. Tg67b -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000030\n" -"help.text" -msgid "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Create a table with data sampled from another table.</ahelp>" -msgstr "" - -#. omEF9 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000040\n" -"help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Sampling</emph></variable>" -msgstr "" - -#. PBJaF -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000050\n" -"help.text" -msgid "Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis." -msgstr "" - -#. EWdZp -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000060\n" -"help.text" -msgid "Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table." -msgstr "" - -#. SLV5d -#: statistics.xhp +#. CGf5i +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000030\n" -"help.text" -msgid "Sampling Method" -msgstr "" - -#. Hz5r6 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000070\n" -"help.text" -msgid "<emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way." -msgstr "" - -#. xu8WG -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000080\n" -"help.text" -msgid "<emph>Sample size</emph>: Number of lines sampled from the source table." -msgstr "" - -#. JXVvj -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000090\n" -"help.text" -msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>." -msgstr "" - -#. 8P2qJ -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000100\n" -"help.text" -msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling." -msgstr "" - -#. oCAwA -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000110\n" -"help.text" -msgid "The following data will be used as example of source data table for sampling:" -msgstr "" - -#. ig3WX -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000510\n" -"help.text" -msgid "Sampling with a period of 2 will result in the following table:" -msgstr "" - -#. GWdPA -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"bm_id01001\n" -"help.text" -msgid "<bookmark_value>Analysis toolpack;descriptive statistics</bookmark_value><bookmark_value>descriptive statistics;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;descriptive statistics</bookmark_value>" -msgstr "" - -#. AFPzR -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000050\n" -"help.text" -msgid "Descriptive Statistics" -msgstr "" - -#. 268Cs -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000640\n" -"help.text" -msgid "<ahelp hid=\"modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog\">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp>" -msgstr "" - -#. KAFvp -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000650\n" -"help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Descriptive Statistics</emph></variable>" -msgstr "" - -#. kELPD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000660\n" -"help.text" -msgid "The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data." -msgstr "" - -#. Ys6kB -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000670\n" -"help.text" -msgid "For more information on descriptive statistics, refer to the <link href=\"https://en.wikipedia.org/wiki/Descriptive_statistics\" name=\"English Wikipedia: Descriptive statistics\">corresponding Wikipedia article</link>." -msgstr "" - -#. EDqCK -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000680\n" -"help.text" -msgid "The following table displays the results of the descriptive statistics of the sample data above." -msgstr "" - -#. H26q7 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000690\n" -"help.text" -msgid "Column 1" -msgstr "欄" - -#. Xo3Q9 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000700\n" -"help.text" -msgid "Column 2" -msgstr "欄" - -#. 6kGNU -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000710\n" -"help.text" -msgid "Column 3" -msgstr "欄" - -#. Y7mYt -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000720\n" -"help.text" -msgid "Mean" -msgstr "" - -#. JKRLG -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000760\n" -"help.text" -msgid "Standard Error" -msgstr "" - -#. 7Fdbc -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000800\n" -"help.text" -msgid "Mode" -msgstr "其他" - -#. 4qjpU -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000840\n" -"help.text" -msgid "Median" -msgstr "" - -#. wBD4D -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000880\n" -"help.text" -msgid "Variance" -msgstr "" - -#. RoEEt -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000920\n" -"help.text" -msgid "Standard Deviation" -msgstr "" - -#. cWsBq -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000960\n" -"help.text" -msgid "Kurtosis" -msgstr "" - -#. SGK2Y -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001000\n" -"help.text" -msgid "Skewness" -msgstr "" - -#. ye9tA -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001040\n" -"help.text" -msgid "Range" -msgstr "區域" - -#. Y8X9J -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001080\n" -"help.text" -msgid "Minimum" -msgstr "最小值" - -#. KumSv -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001120\n" -"help.text" -msgid "Maximum" -msgstr "最大值" - -#. HFRrE -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001160\n" +"statistics_anova.xhp\n" +"tit\n" "help.text" -msgid "Sum" +msgid "ANOVA" msgstr "" -#. bS8FL -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001200\n" -"help.text" -msgid "Count" -msgstr "Count" - -#. Pxk9L -#: statistics.xhp +#. UAf2Q +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "bm_id02001\n" "help.text" msgid "<bookmark_value>Analysis toolpack;analysis of variance</bookmark_value><bookmark_value>Analysis toolpack;ANOVA</bookmark_value><bookmark_value>analysis of variance;Analysis toolpack</bookmark_value><bookmark_value>ANOVA;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;analysis of variance</bookmark_value><bookmark_value>Data statistics;ANOVA</bookmark_value>" msgstr "" -#. 5KmAN -#: statistics.xhp +#. DLedq +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "hd_id1000060\n" "help.text" -msgid "Analysis of Variance (ANOVA)" +msgid "<variable id=\"anovah1\"><link href=\"text/scalc/01/statistics_anova.xhp\" name=\"Analysis of Variance (ANOVA)\">Analysis of Variance (ANOVA)</link></variable>" msgstr "" -#. GyVwG -#: statistics.xhp +#. oSUDa +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001240\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog\">Produces the analysis of variance (ANOVA) of a given data set</ahelp>" msgstr "" -#. SupiC -#: statistics.xhp +#. w5pw6 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001250\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Analysis of Variance (ANOVA)</emph></variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Analysis of Variance (ANOVA)</menuitem></variable>" msgstr "" -#. MHFxP -#: statistics.xhp +#. r9GGt +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001260\n" "help.text" msgid "ANOVA is the acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This tool produces the analysis of variance of a given data set" msgstr "" -#. v5YoG -#: statistics.xhp +#. fRyBD +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001270\n" "help.text" msgid "For more information on ANOVA, refer to the <link href=\"https://en.wikipedia.org/wiki/ANOVA\" name=\"English Wikipedia: ANOVA\">corresponding Wikipedia article</link>." msgstr "" -#. 6BG9w -#: statistics.xhp +#. Lw9W4 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "hd_id1000070\n" "help.text" msgid "Type" -msgstr "類型" +msgstr "" -#. Lj8jU -#: statistics.xhp +#. t2j8D +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001280\n" "help.text" msgid "Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA." msgstr "" -#. dC3VK -#: statistics.xhp +#. msAwu +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "hd_id1000080\n" "help.text" msgid "Parameters" msgstr "" -#. urnKD -#: statistics.xhp +#. ARzmU +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001290\n" "help.text" msgid "<emph>Alpha</emph>: the level of significance of the test." msgstr "" -#. ThHAU -#: statistics.xhp +#. PyK5A +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001300\n" "help.text" msgid "<emph>Rows per sample</emph>: Define how many rows a sample has." msgstr "" -#. ZN697 -#: statistics.xhp +#. 5yBo2 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001310\n" "help.text" msgid "The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above." msgstr "" -#. TKjsT -#: statistics.xhp +#. 5uDqB +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001320\n" "help.text" msgid "ANOVA - Single Factor" msgstr "" -#. GPUcf -#: statistics.xhp +#. AzFd3 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001330\n" "help.text" msgid "Alpha" msgstr "" -#. jFRS3 -#: statistics.xhp +#. Dvbo3 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001350\n" "help.text" msgid "Groups" -msgstr "群組" +msgstr "" -#. 6JGBA -#: statistics.xhp +#. L6VAY +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001360\n" "help.text" msgid "Count" -msgstr "Count" +msgstr "" -#. AWmMZ -#: statistics.xhp +#. G9fqK +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001370\n" "help.text" msgid "Sum" msgstr "" -#. 3LKBY -#: statistics.xhp +#. n2Ayi +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001380\n" "help.text" msgid "Mean" msgstr "" -#. 5kBZx -#: statistics.xhp +#. CnFDW +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001390\n" "help.text" msgid "Variance" msgstr "" -#. HN9Kg -#: statistics.xhp +#. 2LDkn +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001400\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. S4dmD -#: statistics.xhp +#. p6hJA +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001450\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. Dqm5K -#: statistics.xhp +#. 6jqh4 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001500\n" "help.text" msgid "Column 3" -msgstr "欄" +msgstr "" -#. G7cR5 -#: statistics.xhp +#. d3ASg +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001550\n" "help.text" msgid "Source of Variation" msgstr "" -#. YDAXn -#: statistics.xhp +#. CrpJv +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001560\n" "help.text" msgid "SS" msgstr "" -#. hThUx -#: statistics.xhp +#. 3BARp +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001570\n" "help.text" msgid "df" msgstr "" -#. C5Mqo -#: statistics.xhp +#. YhWBw +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001580\n" "help.text" msgid "MS" msgstr "" -#. EUK48 -#: statistics.xhp +#. KV6Cy +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001590\n" "help.text" msgid "F" msgstr "" -#. SdY8k -#: statistics.xhp +#. QRdrB +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001600\n" "help.text" msgid "P-value" msgstr "" -#. E6QVZ -#: statistics.xhp +#. Vabri +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id841554943563747\n" "help.text" msgid "F-critical" msgstr "" -#. oMeZQ -#: statistics.xhp +#. RR2va +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001610\n" "help.text" msgid "Between Groups" msgstr "" -#. JybQF -#: statistics.xhp +#. vuDTW +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id411554944014360\n" "help.text" msgid "3.340385558" msgstr "" -#. 6bYDS -#: statistics.xhp +#. tpzCU +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001670\n" "help.text" msgid "Within Groups" msgstr "" -#. 6qH4W -#: statistics.xhp +#. Lcu3C +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001710\n" "help.text" msgid "Total" msgstr "" -#. WYXKV -#: statistics.xhp +#. NaUDo +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" +"tit\n" +"help.text" +msgid "Data Correlation in Calc" +msgstr "" + +#. agTA6 +#: statistics_correlation.xhp +msgctxt "" +"statistics_correlation.xhp\n" "bm_id1464278\n" "help.text" msgid "<bookmark_value>Analysis toolpack;correlation</bookmark_value><bookmark_value>correlation;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;correlation</bookmark_value>" msgstr "" -#. qFxEj -#: statistics.xhp +#. GDsXj +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "hd_id1000090\n" "help.text" -msgid "Correlation" +msgid "<variable id=\"correlationh1\"><link href=\"text/scalc/01/statistics_correlation.xhp\" name=\"Correlation\">Correlation</link></variable>" msgstr "" -#. Um82Z -#: statistics.xhp +#. zJrnQ +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001740\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/correlationdialog/CorrelationDialog\">Calculates the correlation of two sets of numeric data.</ahelp>" msgstr "" -#. DtTZA -#: statistics.xhp +#. WK8ke +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001750\n" "help.text" -msgid "<variable id=\"corr01\">Choose <emph>Data - Statistics - Correlation</emph></variable>" +msgid "<variable id=\"corr01\">Choose <menuitem>Data - Statistics - Correlation</menuitem></variable>" msgstr "" -#. nyGfA -#: statistics.xhp +#. 85aLv +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001760\n" "help.text" msgid "The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables." msgstr "" -#. Ahycu -#: statistics.xhp +#. Az6pZ +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001770\n" "help.text" msgid "A correlation coefficient of +1 indicates a perfect positive correlation." msgstr "" -#. 5AEs9 -#: statistics.xhp +#. FtKmy +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001780\n" "help.text" msgid "A correlation coefficient of -1 indicates a perfect negative correlation" msgstr "" -#. uHjNT -#: statistics.xhp +#. rzVxG +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001790\n" "help.text" msgid "For more information on statistical correlation, refer to the <link href=\"https://en.wikipedia.org/wiki/Correlation\" name=\"English Wikipedia: Correlation\">corresponding Wikipedia article</link>." msgstr "" -#. LQP4K -#: statistics.xhp +#. 9LxBc +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001800\n" "help.text" msgid "The following table displays the results of the correlation of the sample data above." msgstr "" -#. bJYwq -#: statistics.xhp +#. GZnGj +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001810\n" "help.text" msgid "Correlations" msgstr "" -#. QAQyB -#: statistics.xhp +#. JMJ4R +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001820\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. CBoxF -#: statistics.xhp +#. EJm3M +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001830\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. WVNev -#: statistics.xhp +#. UjLAb +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001840\n" "help.text" msgid "Column 3" -msgstr "欄" +msgstr "" -#. QUWeh -#: statistics.xhp +#. JiUAt +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001850\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. bGwFq -#: statistics.xhp +#. h5ubU +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001870\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. qAAKN -#: statistics.xhp +#. j3GXA +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001900\n" "help.text" msgid "Column 3" -msgstr "欄" +msgstr "" -#. 9xF7p -#: statistics.xhp +#. SpEzh +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" +"tit\n" +"help.text" +msgid "Data Covariance in Calc" +msgstr "" + +#. FsgEU +#: statistics_covariance.xhp +msgctxt "" +"statistics_covariance.xhp\n" "bm_id2964278\n" "help.text" msgid "<bookmark_value>Analysis toolpack;covariance</bookmark_value><bookmark_value>covariance;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;covariance</bookmark_value>" msgstr "" -#. YjBBG -#: statistics.xhp +#. mELGD +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "hd_id1000100\n" "help.text" -msgid "Covariance" +msgid "<variable id=\"covarianceh1\"><link href=\"text/scalc/01/statistics_covariance.xhp\" name=\"Covariance\">Covariance</link></variable>" msgstr "" -#. sD4Fo -#: statistics.xhp +#. xZ7MH +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001940\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/covariancedialog/CovarianceDialog\">Calculates the covariance of two sets of numeric data.</ahelp>" msgstr "" -#. iCA2j -#: statistics.xhp +#. WgiEU +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001950\n" "help.text" -msgid "<variable id=\"cov01\">Choose <emph>Data - Statistics - Covariance</emph></variable>" +msgid "<variable id=\"cov01\">Choose <menuitem>Data - Statistics - Covariance</menuitem></variable>" msgstr "" -#. ZC5Fs -#: statistics.xhp +#. PrEaV +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001960\n" "help.text" msgid "The covariance is a measure of how much two random variables change together." msgstr "" -#. 8yDuo -#: statistics.xhp +#. mnNLA +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001970\n" "help.text" msgid "For more information on statistical covariance, refer to the <link href=\"https://en.wikipedia.org/wiki/Covariance\" name=\"English Wikipedia: Covariance\">corresponding Wikipedia article</link>." msgstr "" -#. CPE2e -#: statistics.xhp +#. FNxfQ +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001980\n" "help.text" msgid "The following table displays the results of the covariance of the sample data above." msgstr "" -#. wXZ5E -#: statistics.xhp +#. NEWzK +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001990\n" "help.text" msgid "Covariances" msgstr "" -#. YL6nE -#: statistics.xhp +#. onYs5 +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002000\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. cKgoA -#: statistics.xhp +#. sqErz +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002010\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. ZeGD3 -#: statistics.xhp +#. n3e2C +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002020\n" "help.text" msgid "Column 3" -msgstr "欄" +msgstr "" -#. PfqDB -#: statistics.xhp +#. F4E2J +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002030\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. B6YQi -#: statistics.xhp +#. 3d6Ds +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002050\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. N7C2i -#: statistics.xhp +#. GajDs +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002080\n" "help.text" msgid "Column 3" -msgstr "欄" +msgstr "" -#. xGFXz -#: statistics.xhp +#. mc3YQ +#: statistics_descriptive.xhp msgctxt "" -"statistics.xhp\n" +"statistics_descriptive.xhp\n" +"tit\n" +"help.text" +msgid "Descriptive Statistics in Calc" +msgstr "" + +#. H4Cik +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"bm_id01001\n" +"help.text" +msgid "<bookmark_value>Analysis toolpack;descriptive statistics</bookmark_value><bookmark_value>descriptive statistics;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;descriptive statistics</bookmark_value>" +msgstr "" + +#. CWfuc +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"hd_id1000050\n" +"help.text" +msgid "<variable id=\"descriptivestatisticsh1\"><link href=\"text/scalc/01/statistics_descriptive.xhp\" name=\"Descriptive Statistics\">Descriptive Statistics</link></variable>" +msgstr "" + +#. 7XkEb +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000640\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog\">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp>" +msgstr "" + +#. EAywA +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000650\n" +"help.text" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Descriptive Statistics</menuitem></variable>" +msgstr "" + +#. cuUnJ +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000660\n" +"help.text" +msgid "The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data." +msgstr "" + +#. 2bsE3 +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000670\n" +"help.text" +msgid "For more information on descriptive statistics, refer to the <link href=\"https://en.wikipedia.org/wiki/Descriptive_statistics\" name=\"English Wikipedia: Descriptive statistics\">corresponding Wikipedia article</link>." +msgstr "" + +#. VccwM +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000680\n" +"help.text" +msgid "The following table displays the results of the descriptive statistics of the sample data above." +msgstr "" + +#. XC7CC +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000690\n" +"help.text" +msgid "Column 1" +msgstr "" + +#. HY2UN +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000700\n" +"help.text" +msgid "Column 2" +msgstr "" + +#. qTDSp +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000710\n" +"help.text" +msgid "Column 3" +msgstr "" + +#. AjAbs +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000720\n" +"help.text" +msgid "Mean" +msgstr "" + +#. CuH3F +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000760\n" +"help.text" +msgid "Standard Error" +msgstr "" + +#. bU9Yb +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000800\n" +"help.text" +msgid "Mode" +msgstr "" + +#. PH44f +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000840\n" +"help.text" +msgid "Median" +msgstr "" + +#. GKGy8 +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000880\n" +"help.text" +msgid "Variance" +msgstr "" + +#. XBfaP +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000920\n" +"help.text" +msgid "Standard Deviation" +msgstr "" + +#. JqtpV +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000960\n" +"help.text" +msgid "Kurtosis" +msgstr "" + +#. CNLwk +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001000\n" +"help.text" +msgid "Skewness" +msgstr "" + +#. 4dWHz +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001040\n" +"help.text" +msgid "Range" +msgstr "" + +#. XX2DK +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001080\n" +"help.text" +msgid "Minimum" +msgstr "" + +#. LKHuw +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001120\n" +"help.text" +msgid "Maximum" +msgstr "" + +#. FM2fN +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001160\n" +"help.text" +msgid "Sum" +msgstr "" + +#. FZdrB +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001200\n" +"help.text" +msgid "Count" +msgstr "" + +#. gAEBc +#: statistics_exposmooth.xhp +msgctxt "" +"statistics_exposmooth.xhp\n" +"tit\n" +"help.text" +msgid "Exponential Smoothing in Calc" +msgstr "" + +#. cNRQD +#: statistics_exposmooth.xhp +msgctxt "" +"statistics_exposmooth.xhp\n" "bm_id03001\n" "help.text" msgid "<bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value><bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;exponential smoothing</bookmark_value>" msgstr "" -#. pjmjS -#: statistics.xhp +#. CF4hG +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "hd_id1000110\n" "help.text" -msgid "Exponential Smoothing" +msgid "<variable id=\"exponentialsmoothingh1\"><link href=\"text/scalc/01/statistics_exposmooth.xhp\" name=\"Exponential Smoothing\">Exponential Smoothing</link></variable>" msgstr "" -#. HQfdM -#: statistics.xhp +#. ESHYa +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002120\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog\">Results in a smoothed data series</ahelp>" msgstr "" -#. GjYAF -#: statistics.xhp +#. CA94C +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002130\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Exponential Smoothing</emph></variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Exponential Smoothing</menuitem></variable>" msgstr "" -#. 5q76p -#: statistics.xhp +#. M4GPm +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002140\n" "help.text" msgid "Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements." msgstr "" -#. VGPLc -#: statistics.xhp +#. BX9Ci +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002150\n" "help.text" msgid "For more information on exponential smoothing, refer to the <link href=\"https://en.wikipedia.org/wiki/Exponential_smoothing\" name=\"English Wikipedia: Exponential smoothing\">corresponding Wikipedia article</link>." msgstr "" -#. 5HoYB -#: statistics.xhp +#. 2PBvq +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "hd_id1000120\n" "help.text" msgid "Parameters" msgstr "" -#. Kk9Cq -#: statistics.xhp +#. 5FYLV +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002160\n" "help.text" msgid "<emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation." msgstr "" -#. L8SEj -#: statistics.xhp +#. b4y8A +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002170\n" "help.text" msgid "The resulting smoothing is below with smoothing factor as 0.5:" msgstr "" -#. tbXxy -#: statistics.xhp +#. GnSwW +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002180\n" "help.text" msgid "Alpha" msgstr "" -#. HNgFX -#: statistics.xhp +#. ZJzEM +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002200\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. MR6ET -#: statistics.xhp +#. dMdDR +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002210\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. 9PsYD -#: statistics.xhp +#. AXaMM +#: statistics_fourier.xhp msgctxt "" -"statistics.xhp\n" +"statistics_fourier.xhp\n" +"tit\n" +"help.text" +msgid "Fourier Analysis" +msgstr "" + +#. F2ncB +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"bm_id2764278\n" +"help.text" +msgid "<bookmark_value>Analysis toolpack;Fourier analysis</bookmark_value><bookmark_value>Fourier analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Fourier analysis</bookmark_value>" +msgstr "" + +#. EV56D +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"hd_id431561808831965\n" +"help.text" +msgid "<variable id=\"fourieranalysysh1\"><link href=\"text/scalc/01/statistics_fourier.xhp\" name=\"Fourier analysis\">Fourier Analysis</link></variable>" +msgstr "" + +#. EEBRe +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id1001240\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp>" +msgstr "" + +#. sG8zA +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id1000040\n" +"help.text" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Fourier Analysis</menuitem></variable>" +msgstr "" + +#. HpuG9 +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id1001270\n" +"help.text" +msgid "For more information on Fourier analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Fourier_analysis\" name=\"English Wikipedia: Fourier analysis\">corresponding Wikipedia article</link>." +msgstr "" + +#. VArYS +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id301561811172762\n" +"help.text" +msgid "<emph>Input range has label</emph>: Mark when the first row or column of the input array is actually a label and not part of the data analysis." +msgstr "" + +#. Gi5kk +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id741556228390897\n" +"help.text" +msgid "Input Range is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data." +msgstr "" + +#. GqXZr +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"hd_id211561811324208\n" +"help.text" +msgid "Options:" +msgstr "" + +#. 68RRB +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id631556228516997\n" +"help.text" +msgid "<emph>Inverse</emph>: When checked, calculates the inverse Discrete Fourier Transform." +msgstr "" + +#. MH9kg +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id811561732287508\n" +"help.text" +msgid "<emph>Polar</emph>: When checked, the results are in polar coordinates (magnitude, phase)." +msgstr "" + +#. peNbe +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id661561732521977\n" +"help.text" +msgid "<emph>Minimum magnitude for polar form output (in dB)</emph>: used only when output is in polar form. All frequency components with magnitude less than this value in decibels will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed." +msgstr "" + +#. 8pLcW +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id731561827207828\n" +"help.text" +msgid "The source data for this example is the same of the <link href=\"text/scalc/01/func_fourier.xhp\" name=\"Fourier function\">FOURIER function page</link>." +msgstr "" + +#. 4XJPB +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257279817\n" +"help.text" +msgid "Fourier Transform" +msgstr "" + +#. nfhVE +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id29062019125727379\n" +"help.text" +msgid "Fourier Transform" +msgstr "" + +#. G6aEG +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257276510\n" +"help.text" +msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgstr "" + +#. 5L22z +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257273433\n" +"help.text" +msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgstr "" + +#. Vyu9a +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257273688\n" +"help.text" +msgid "<emph>Real</emph>" +msgstr "" + +#. qEshW +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257276202\n" +"help.text" +msgid "<emph>Imaginary</emph>" +msgstr "" + +#. fJ6BG +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id481561825547527\n" +"help.text" +msgid "<emph>Magnitude</emph>" +msgstr "" + +#. XcXJz +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id751561825556834\n" +"help.text" +msgid "<emph>Phase</emph>" +msgstr "" + +#. Yo4ob +#: statistics_movingavg.xhp +msgctxt "" +"statistics_movingavg.xhp\n" +"tit\n" +"help.text" +msgid "Moving Average in Calc" +msgstr "" + +#. pgLeC +#: statistics_movingavg.xhp +msgctxt "" +"statistics_movingavg.xhp\n" "bm_id04001\n" "help.text" msgid "<bookmark_value>Analysis toolpack;moving average</bookmark_value><bookmark_value>moving average;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;moving average</bookmark_value>" msgstr "" -#. sbBFf -#: statistics.xhp +#. XUnST +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "hd_id1000130\n" "help.text" -msgid "Moving Average" +msgid "<variable id=\"movingaverageh1\"><link href=\"text/scalc/01/statistics_movingavg.xhp\" name=\"Moving Average\">Moving Average</link></variable>" msgstr "" -#. yBhLV -#: statistics.xhp +#. ghTMS +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002500\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/movingaveragedialog/MovingAverageDialog\">Calculates the moving average of a time series</ahelp>" msgstr "" -#. sXEAs -#: statistics.xhp +#. yW3BR +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002510\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Moving Average</emph></variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Moving Average</menuitem></variable>" msgstr "" -#. yEGoW -#: statistics.xhp +#. kn7s5 +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002520\n" "help.text" msgid "For more information on the moving average, refer to the <link href=\"https://en.wikipedia.org/wiki/Moving_average\" name=\"English Wikipedia: Moving average\">corresponding Wikipedia article</link>." msgstr "" -#. Si43s -#: statistics.xhp +#. eoQu3 +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "hd_id1000140\n" "help.text" msgid "Parameters" msgstr "" -#. 6LjdG -#: statistics.xhp +#. z4Wmd +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002530\n" "help.text" msgid "<emph>Interval</emph>: The number of samples used in the moving average calculation." msgstr "" -#. CJRXM -#: statistics.xhp +#. ZTYni +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "hd_id1000171\n" "help.text" msgid "Results of the moving average:" msgstr "" -#. GNGxZ -#: statistics.xhp +#. GGAtW +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002540\n" "help.text" msgid "Column 1" -msgstr "欄" +msgstr "" -#. LRwyV -#: statistics.xhp +#. LDUuS +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002550\n" "help.text" msgid "Column 2" -msgstr "欄" +msgstr "" -#. T2NME -#: statistics.xhp +#. bJZmR +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002560\n" "help.text" msgid "#N/A" msgstr "" -#. yftCU -#: statistics.xhp +#. qn2Vi +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002570\n" "help.text" msgid "#N/A" msgstr "" -#. TEysC -#: statistics.xhp +#. bE5BK +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002800\n" "help.text" msgid "#N/A" msgstr "" -#. yrKbW -#: statistics.xhp +#. qTU2p +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002810\n" "help.text" msgid "#N/A" msgstr "" -#. CsQFD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"bm_id05001\n" -"help.text" -msgid "<bookmark_value>Analysis toolpack;t-test</bookmark_value><bookmark_value>Analysis toolpack;paired t-test</bookmark_value><bookmark_value>t-test;Analysis toolpack</bookmark_value><bookmark_value>paired t-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;paired t-test</bookmark_value>" -msgstr "" - -#. SzpeD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000150\n" -"help.text" -msgid "Paired t-test" -msgstr "" - -#. XwyAU -#: statistics.xhp +#. 7EZAg +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002820\n" +"statistics_regression.xhp\n" +"tit\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the paired t-Test of two data samples.</ahelp>" +msgid "Regression Analysis" msgstr "" -#. GGeBc -#: statistics.xhp +#. wDYsU +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002830\n" +"statistics_regression.xhp\n" +"bm_id2764278\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Paired t-test</emph></variable>" +msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value>" msgstr "" -#. Pa56H -#: statistics.xhp +#. UPKr7 +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002840\n" +"statistics_regression.xhp\n" +"hd_id1701201615033510\n" "help.text" -msgid "A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution." +msgid "<variable id=\"regressionanalysish1\"><link href=\"text/scalc/01/statistics_regression.xhp\" name=\"regression analysis\">Regression Analysis</link></variable>" msgstr "" -#. UECyT -#: statistics.xhp +#. NFhSA +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002850\n" +"statistics_regression.xhp\n" +"par_id1001240\n" "help.text" -msgid "For more information on paired t-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/T-test\" name=\"English Wikipedia: T-test\">corresponding Wikipedia article</link>." +msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the regression analysis of a data set</ahelp>" msgstr "" -#. BDZik -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000160\n" -"help.text" -msgid "Data" -msgstr "資料" - -#. gcjsZ -#: statistics.xhp +#. ENJtD +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002860\n" +"statistics_regression.xhp\n" +"par_id1000040\n" "help.text" -msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Regression</menuitem></variable>" msgstr "" -#. YWrFc -#: statistics.xhp +#. zADGk +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002870\n" +"statistics_regression.xhp\n" +"par_id1001270\n" "help.text" -msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgid "For more information on regression analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">corresponding Wikipedia article</link>." msgstr "" -#. JFPu9 -#: statistics.xhp +#. rdATw +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002880\n" +"statistics_regression.xhp\n" +"hd_id1000070\n" "help.text" -msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." +msgid "Output Regression Type" msgstr "" -#. vWS92 -#: statistics.xhp +#. QMDBG +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000170\n" +"statistics_regression.xhp\n" +"par_id1001280\n" "help.text" -msgid "Results for paired t-test:" +msgid "Set the regression type. Three types are available:" msgstr "" -#. L9Vxq -#: statistics.xhp +#. 7Avaz +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002890\n" +"statistics_regression.xhp\n" +"par_id1701201620334364\n" "help.text" -msgid "The following table shows the <emph>paired t-test</emph> for the data series above:" +msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data." msgstr "" -#. KvDmj -#: statistics.xhp +#. B6dex +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002900\n" +"statistics_regression.xhp\n" +"par_id1701201620340168\n" "help.text" -msgid "paired t-test" +msgid "<emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type=\"literal\">y = a.ln(x) + b</item>, where <item type=\"literal\">a</item> is the slope, <item type=\"literal\">b</item> is the intercept and <item type=\"literal\">ln(x)</item> is the natural logarithm of <item type=\"literal\">x</item>, that best fits the data." msgstr "" -#. T9BFU -#: statistics.xhp +#. txgoZ +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002910\n" +"statistics_regression.xhp\n" +"par_id1701201620340139\n" "help.text" -msgid "Alpha" +msgid "<emph>Power regression</emph>: Find a power curve in the form of <item type=\"literal\">y = a.x^b</item>, where <item type=\"literal\">a</item> is the coefficient, <item type=\"literal\">b</item> is the power that best fits the data." msgstr "" -#. LAnve -#: statistics.xhp +#. EtPbr +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002930\n" +"statistics_regression.xhp\n" +"par_id1001310\n" "help.text" -msgid "Hypothesized Mean Difference" +msgid "The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below." msgstr "" -#. 6fWZ5 -#: statistics.xhp +#. iJ7yf +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002950\n" +"statistics_regression.xhp\n" +"par_id1701201618090526\n" "help.text" -msgid "Variable 1" +msgid "Regression" msgstr "" -#. EJLqE -#: statistics.xhp +#. cSAoU +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002960\n" +"statistics_regression.xhp\n" +"par_id1701201618090542\n" "help.text" -msgid "Variable 2" +msgid "Regression Model" msgstr "" -#. MPnR3 -#: statistics.xhp +#. YAGFi +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002970\n" +"statistics_regression.xhp\n" +"par_id1701201618090596\n" "help.text" -msgid "Mean" -msgstr "" +msgid "Linear" +msgstr "直線" -#. xmB6Y -#: statistics.xhp +#. 2zcqS +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003000\n" +"statistics_regression.xhp\n" +"par_id1701201618090586\n" "help.text" -msgid "Variance" +msgid "Logarithmic" msgstr "" -#. j5EJE -#: statistics.xhp +#. QvaFq +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003030\n" +"statistics_regression.xhp\n" +"par_id1701201618090555\n" "help.text" -msgid "Observations" -msgstr "" +msgid "Power" +msgstr "功率" -#. TqdAS -#: statistics.xhp +#. oHBnC +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003060\n" +"statistics_regression.xhp\n" +"par_id1701201618090553\n" "help.text" -msgid "Pearson Correlation" +msgid "R^2" msgstr "" -#. KRXGK -#: statistics.xhp +#. egmFM +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003080\n" +"statistics_regression.xhp\n" +"par_id1701201618090595\n" "help.text" -msgid "Observed Mean Difference" +msgid "Standard Error" msgstr "" -#. XqdB7 -#: statistics.xhp +#. woESA +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003100\n" +"statistics_regression.xhp\n" +"par_id1701201618090563\n" "help.text" -msgid "Variance of the Differences" +msgid "Slope" msgstr "" -#. LvHvG -#: statistics.xhp +#. qfNCA +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003120\n" +"statistics_regression.xhp\n" +"par_id1701201618090642\n" "help.text" -msgid "df" +msgid "Intercept" msgstr "" -#. fCMcg -#: statistics.xhp +#. u47eB +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003140\n" +"statistics_sampling.xhp\n" +"tit\n" "help.text" -msgid "t Stat" +msgid "Data Sampling in Calc" msgstr "" -#. LAg7e -#: statistics.xhp +#. LSf66 +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003160\n" +"statistics_sampling.xhp\n" +"bm_id2764278\n" "help.text" -msgid "P (T<=t) one-tail" +msgid "<bookmark_value>Analysis toolpack;sampling</bookmark_value><bookmark_value>sampling;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;sampling</bookmark_value>" msgstr "" -#. vqE6u -#: statistics.xhp +#. 4SPkL +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003180\n" +"statistics_sampling.xhp\n" +"hd_id1000020\n" "help.text" -msgid "t Critical one-tail" +msgid "<variable id=\"datasamplingh1\"><link href=\"text/scalc/01/statistics_sampling.xhp\" name=\"Sampling\">Sampling</link></variable>" msgstr "" -#. g2gAd -#: statistics.xhp +#. 9XjLD +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003200\n" +"statistics_sampling.xhp\n" +"par_id1000030\n" "help.text" -msgid "P (T<=t) two-tail" +msgid "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Create a table with data sampled from another table.</ahelp>" msgstr "" -#. 9dv9Z -#: statistics.xhp +#. vM6cz +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003220\n" +"statistics_sampling.xhp\n" +"par_id1000040\n" "help.text" -msgid "t Critical two-tail" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Sampling</menuitem></variable>" msgstr "" -#. oA65G -#: statistics.xhp +#. MDjEn +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"bm_id05002\n" +"statistics_sampling.xhp\n" +"par_id1000050\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;F-test</bookmark_value><bookmark_value>F-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;F-test</bookmark_value>" +msgid "Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis." msgstr "" -#. ehPwx -#: statistics.xhp +#. GRbRi +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000180\n" +"statistics_sampling.xhp\n" +"par_id1000060\n" "help.text" -msgid "F-test" +msgid "Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table." msgstr "" -#. brHw9 -#: statistics.xhp +#. DmJMr +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003240\n" +"statistics_sampling.xhp\n" +"hd_id1000030\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the F-Test of two data samples.</ahelp>" +msgid "Sampling Method" msgstr "" -#. pbkFE -#: statistics.xhp +#. zDwkD +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003250\n" +"statistics_sampling.xhp\n" +"par_id1000070\n" "help.text" -msgid "<variable id=\"sam02\">Choose <emph>Data - Statistics - F-test</emph></variable>" +msgid "<emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way." msgstr "" -#. Wjkbb -#: statistics.xhp +#. AAvrF +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003260\n" +"statistics_sampling.xhp\n" +"par_id1000080\n" "help.text" -msgid "A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis." +msgid "<emph>Sample size</emph>: Number of lines sampled from the source table." msgstr "" -#. o8Ex8 -#: statistics.xhp +#. hy48Z +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003270\n" +"statistics_sampling.xhp\n" +"par_id1000090\n" "help.text" -msgid "For more information on F-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/F-test\" name=\"English Wikipedia: F-test\">corresponding Wikipedia article</link>." +msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>." msgstr "" -#. NwkkV -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000190\n" -"help.text" -msgid "Data" -msgstr "資料" - -#. 8yUF7 -#: statistics.xhp +#. i8TDF +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003280\n" +"statistics_sampling.xhp\n" +"par_id1000100\n" "help.text" -msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling." msgstr "" -#. ZRSwx -#: statistics.xhp +#. NjytZ +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003290\n" +"statistics_sampling.xhp\n" +"par_id1000110\n" "help.text" -msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgid "The following data will be used as example of source data table for sampling:" msgstr "" -#. iGCgj -#: statistics.xhp +#. VR7DD +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003300\n" +"statistics_sampling.xhp\n" +"par_id1000510\n" "help.text" -msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." +msgid "Sampling with a period of 2 will result in the following table:" msgstr "" -#. BS5E6 -#: statistics.xhp +#. 7UA8A +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000200\n" +"statistics_test_chisqr.xhp\n" +"tit\n" "help.text" -msgid "Results for F-Test:" +msgid "Chi Square Statistics in Calc" msgstr "" -#. fDAwv -#: statistics.xhp +#. hAnmA +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003310\n" +"statistics_test_chisqr.xhp\n" +"bm_id05004\n" "help.text" -msgid "The following table shows the <emph>F-Test</emph> for the data series above:" +msgid "<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value><bookmark_value>Chi-square test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Chi-square test</bookmark_value>" msgstr "" -#. FTLNF -#: statistics.xhp +#. ECMEg +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003320\n" +"statistics_test_chisqr.xhp\n" +"hd_id1000240\n" "help.text" -msgid "Ftest" +msgid "<variable id=\"chisqtesth1\"><link href=\"text/scalc/01/statistics_test_chisqr.xhp\" name=\"Chi-square test\">Chi-square test</link></variable>" msgstr "" -#. 5abPE -#: statistics.xhp +#. u5MGV +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003330\n" +"statistics_test_chisqr.xhp\n" +"par_id1003641\n" "help.text" -msgid "Alpha" +msgid "<ahelp hid=\"modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog\">Calculates the Chi-square test of a data sample.</ahelp>" msgstr "" -#. PC3Js -#: statistics.xhp +#. pdD2p +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003350\n" +"statistics_test_chisqr.xhp\n" +"par_id1003990\n" "help.text" -msgid "Variable 1" +msgid "<variable id=\"sam02\">Choose <menuitem>Data - Statistics - Chi-square Test</menuitem></variable>" msgstr "" -#. Fxv9b -#: statistics.xhp +#. V4PzH +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003360\n" +"statistics_test_chisqr.xhp\n" +"par_id1004000\n" "help.text" -msgid "Variable 2" +msgid "For more information on chi-square tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Chi-square_test\" name=\"English Wikipedia: Chi-square_test\">corresponding Wikipedia article</link>." msgstr "" -#. igFPM -#: statistics.xhp +#. 46RmG +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003370\n" +"statistics_test_chisqr.xhp\n" +"hd_id1000231\n" "help.text" -msgid "Mean" +msgid "Results for Chi-square Test:" msgstr "" -#. P7Dte -#: statistics.xhp +#. QHuAe +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003400\n" +"statistics_test_chisqr.xhp\n" +"par_id1004030\n" "help.text" -msgid "Variance" +msgid "Test of Independence (Chi-Square)" msgstr "" -#. DDEUW -#: statistics.xhp +#. BzGNg +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003430\n" +"statistics_test_chisqr.xhp\n" +"par_id1004040\n" "help.text" -msgid "Observations" +msgid "Alpha" msgstr "" -#. GCVd2 -#: statistics.xhp +#. CRP8j +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003460\n" +"statistics_test_chisqr.xhp\n" +"par_id1004060\n" "help.text" msgid "df" msgstr "" -#. e3MnX -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1003490\n" -"help.text" -msgid "F" -msgstr "" - -#. 9iAny -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1003510\n" -"help.text" -msgid "P (F<=f) right-tail" -msgstr "" - -#. Ew7mY -#: statistics.xhp +#. rcX5Y +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003530\n" +"statistics_test_chisqr.xhp\n" +"par_id1004080\n" "help.text" -msgid "F Critical right-tail" +msgid "P-value" msgstr "" -#. 6CajG -#: statistics.xhp +#. oF79y +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003550\n" +"statistics_test_chisqr.xhp\n" +"par_id1004100\n" "help.text" -msgid "P (F<=f) left-tail" +msgid "Test Statistic" msgstr "" -#. CTNrD -#: statistics.xhp +#. ykGTD +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003570\n" +"statistics_test_chisqr.xhp\n" +"par_id1004120\n" "help.text" -msgid "F Critical left-tail" +msgid "Critical Value" msgstr "" -#. dPGJc -#: statistics.xhp +#. SeEHX +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003590\n" +"statistics_test_f.xhp\n" +"tit\n" "help.text" -msgid "P two-tail" +msgid "F Test Statistics in Calc" msgstr "" -#. c7cBK -#: statistics.xhp +#. bWFPL +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003610\n" +"statistics_test_f.xhp\n" +"bm_id05002\n" "help.text" -msgid "F Critical two-tail" +msgid "<bookmark_value>Analysis toolpack;F-test</bookmark_value><bookmark_value>F-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;F-test</bookmark_value>" msgstr "" -#. DJhea -#: statistics.xhp +#. gZWPc +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"bm_id05003\n" +"statistics_test_f.xhp\n" +"hd_id1000180\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;Z-test</bookmark_value><bookmark_value>Z-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Z-test</bookmark_value>" +msgid "<variable id=\"ftesth1\"><link href=\"text/scalc/01/statistics_test_f.xhp\" name=\"F-test\">F-test</link></variable>" msgstr "" -#. mP5zB -#: statistics.xhp +#. qHRjW +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000210\n" +"statistics_test_f.xhp\n" +"par_id1003240\n" "help.text" -msgid "Z-test" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the F-Test of two data samples.</ahelp>" msgstr "" -#. VdKxp -#: statistics.xhp +#. ARt6p +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003640\n" +"statistics_test_f.xhp\n" +"par_id1003250\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ztestdialog/ZTestDialog\">Calculates the z-Test of two data samples.</ahelp>" +msgid "<variable id=\"sam02\">Choose <menuitem>Data - Statistics - F-test</menuitem></variable>" msgstr "" -#. FpaeZ -#: statistics.xhp +#. FxKGF +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003650\n" +"statistics_test_f.xhp\n" +"par_id1003260\n" "help.text" -msgid "<variable id=\"sam02\">Choose <emph>Data - Statistics - Z-test</emph></variable>" +msgid "A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis." msgstr "" -#. G2Df9 -#: statistics.xhp +#. EGFSG +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003660\n" +"statistics_test_f.xhp\n" +"par_id1003270\n" "help.text" -msgid "For more information on Z-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Z-test\" name=\"English Wikipedia: Z-test\">corresponding Wikipedia article</link>." +msgid "For more information on F-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/F-test\" name=\"English Wikipedia: F-test\">corresponding Wikipedia article</link>." msgstr "" -#. BcMk3 -#: statistics.xhp +#. GxHaD +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000220\n" +"statistics_test_f.xhp\n" +"hd_id1000190\n" "help.text" msgid "Data" -msgstr "資料" +msgstr "" -#. z9aEs -#: statistics.xhp +#. jtjaQ +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003670\n" +"statistics_test_f.xhp\n" +"par_id1003280\n" "help.text" msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." msgstr "" -#. hAxVY -#: statistics.xhp +#. qzYBv +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003680\n" +"statistics_test_f.xhp\n" +"par_id1003290\n" "help.text" msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." msgstr "" -#. e8JtG -#: statistics.xhp +#. MvvMT +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003690\n" +"statistics_test_f.xhp\n" +"par_id1003300\n" "help.text" msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." msgstr "" -#. R6V7y -#: statistics.xhp +#. Greqo +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000230\n" +"statistics_test_f.xhp\n" +"hd_id1000200\n" "help.text" -msgid "Results for z-Test:" +msgid "Results for F-Test:" msgstr "" -#. D8FiS -#: statistics.xhp +#. XqyMa +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003700\n" +"statistics_test_f.xhp\n" +"par_id1003310\n" "help.text" -msgid "The following table shows the <emph>z-Test</emph> for the data series above:" +msgid "The following table shows the <emph>F-Test</emph> for the data series above:" msgstr "" -#. C8bSD -#: statistics.xhp +#. git3T +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003710\n" +"statistics_test_f.xhp\n" +"par_id1003320\n" "help.text" -msgid "z-test" +msgid "Ftest" msgstr "" -#. MLZyG -#: statistics.xhp +#. WsA4s +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003720\n" +"statistics_test_f.xhp\n" +"par_id1003330\n" "help.text" msgid "Alpha" msgstr "" -#. uaG8z -#: statistics.xhp +#. xj9Se +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003740\n" +"statistics_test_f.xhp\n" +"par_id1003350\n" "help.text" -msgid "Hypothesized Mean Difference" +msgid "Variable 1" msgstr "" -#. z8C94 -#: statistics.xhp +#. p5piv +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003760\n" +"statistics_test_f.xhp\n" +"par_id1003360\n" "help.text" -msgid "Variable 1" +msgid "Variable 2" msgstr "" -#. d8qiE -#: statistics.xhp +#. YA2dy +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003770\n" +"statistics_test_f.xhp\n" +"par_id1003370\n" "help.text" -msgid "Variable 2" +msgid "Mean" msgstr "" -#. Jj28P -#: statistics.xhp +#. 8MXro +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003780\n" +"statistics_test_f.xhp\n" +"par_id1003400\n" "help.text" -msgid "Known Variance" +msgid "Variance" msgstr "" -#. mCBCo -#: statistics.xhp +#. W2J6x +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003810\n" +"statistics_test_f.xhp\n" +"par_id1003430\n" "help.text" -msgid "Mean" +msgid "Observations" msgstr "" -#. AuNuX -#: statistics.xhp +#. DqgMQ +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003840\n" +"statistics_test_f.xhp\n" +"par_id1003460\n" "help.text" -msgid "Observations" +msgid "df" msgstr "" -#. 9Kte4 -#: statistics.xhp +#. BJ3Vi +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003870\n" +"statistics_test_f.xhp\n" +"par_id1003490\n" "help.text" -msgid "Observed Mean Difference" +msgid "F" msgstr "" -#. WXPWw -#: statistics.xhp +#. AasLh +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003890\n" +"statistics_test_f.xhp\n" +"par_id1003510\n" "help.text" -msgid "z" +msgid "P (F<=f) right-tail" msgstr "" -#. NYjYx -#: statistics.xhp +#. FVAJa +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003900\n" +"statistics_test_f.xhp\n" +"par_id1003530\n" "help.text" -msgid "#DIV/0!" +msgid "F Critical right-tail" msgstr "" -#. etDij -#: statistics.xhp +#. zBzCY +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003910\n" +"statistics_test_f.xhp\n" +"par_id1003550\n" "help.text" -msgid "P (Z<=z) one-tail" +msgid "P (F<=f) left-tail" msgstr "" -#. HDtBQ -#: statistics.xhp +#. LA56M +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003920\n" +"statistics_test_f.xhp\n" +"par_id1003570\n" "help.text" -msgid "#DIV/0!" +msgid "F Critical left-tail" msgstr "" -#. keob4 -#: statistics.xhp +#. 9ZNSy +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003930\n" +"statistics_test_f.xhp\n" +"par_id1003590\n" "help.text" -msgid "z Critical one-tail" +msgid "P two-tail" msgstr "" -#. KzE5V -#: statistics.xhp +#. dQ4WA +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003950\n" +"statistics_test_f.xhp\n" +"par_id1003610\n" "help.text" -msgid "P (Z<=z) two-tail" +msgid "F Critical two-tail" msgstr "" -#. TsDyQ -#: statistics.xhp +#. jMBzo +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003960\n" +"statistics_test_t.xhp\n" +"tit\n" "help.text" -msgid "#DIV/0!" +msgid "T Test Statistics in Calc" msgstr "" -#. huD6B -#: statistics.xhp +#. cKb9k +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003970\n" +"statistics_test_t.xhp\n" +"bm_id05001\n" "help.text" -msgid "z Critical two-tail" +msgid "<bookmark_value>Analysis toolpack;t-test</bookmark_value><bookmark_value>Analysis toolpack;paired t-test</bookmark_value><bookmark_value>t-test;Analysis toolpack</bookmark_value><bookmark_value>paired t-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;paired t-test</bookmark_value>" msgstr "" -#. C98ER -#: statistics.xhp +#. QWgi3 +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"bm_id05004\n" +"statistics_test_t.xhp\n" +"hd_id1000150\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value><bookmark_value>Chi-square test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Chi-square test</bookmark_value>" +msgid "<variable id=\"ttesth1\"><link href=\"text/scalc/01/statistics_test_t.xhp\" name=\"Paired t-test\">Paired t-test</link></variable>" msgstr "" -#. hBHDK -#: statistics.xhp +#. TXtGV +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000240\n" +"statistics_test_t.xhp\n" +"par_id1002820\n" "help.text" -msgid "Chi-square test" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the paired t-Test of two data samples.</ahelp>" msgstr "" -#. uJFGU -#: statistics.xhp +#. EVZDy +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003641\n" +"statistics_test_t.xhp\n" +"par_id1002830\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog\">Calculates the Chi-square test of a data sample.</ahelp>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Paired t-test</menuitem></variable>" msgstr "" -#. mkjok -#: statistics.xhp +#. 3ngCe +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003990\n" +"statistics_test_t.xhp\n" +"par_id1002840\n" "help.text" -msgid "<variable id=\"sam02\">Choose <emph>Data - Statistics - Chi-square Test</emph></variable>" +msgid "A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution." msgstr "" -#. AMY4A -#: statistics.xhp +#. NE5Ro +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004000\n" +"statistics_test_t.xhp\n" +"par_id1002850\n" "help.text" -msgid "For more information on chi-square tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Chi-square_test\" name=\"English Wikipedia: Chi-square_test\">corresponding Wikipedia article</link>." +msgid "For more information on paired t-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/T-test\" name=\"English Wikipedia: T-test\">corresponding Wikipedia article</link>." msgstr "" -#. FYnfb -#: statistics.xhp +#. BEkGF +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000231\n" +"statistics_test_t.xhp\n" +"hd_id1000160\n" "help.text" -msgid "Results for Chi-square Test:" +msgid "Data" msgstr "" -#. iRDRE -#: statistics.xhp +#. aU9k6 +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004030\n" +"statistics_test_t.xhp\n" +"par_id1002860\n" "help.text" -msgid "Test of Independence (Chi-Square)" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." msgstr "" -#. he69g -#: statistics.xhp +#. 27zQ4 +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004040\n" +"statistics_test_t.xhp\n" +"par_id1002870\n" "help.text" -msgid "Alpha" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." msgstr "" -#. LuZZQ -#: statistics.xhp +#. 8D2Gp +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004060\n" +"statistics_test_t.xhp\n" +"par_id1002880\n" "help.text" -msgid "df" +msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." msgstr "" -#. AC5p4 -#: statistics.xhp +#. KcmaB +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004080\n" +"statistics_test_t.xhp\n" +"hd_id1000170\n" "help.text" -msgid "P-value" +msgid "Results for paired t-test:" msgstr "" -#. B9dja -#: statistics.xhp +#. egFAr +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004100\n" +"statistics_test_t.xhp\n" +"par_id1002890\n" "help.text" -msgid "Test Statistic" +msgid "The following table shows the <emph>paired t-test</emph> for the data series above:" msgstr "" -#. MnuJ5 -#: statistics.xhp +#. rDVBE +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004120\n" +"statistics_test_t.xhp\n" +"par_id1002900\n" "help.text" -msgid "Critical Value" +msgid "paired t-test" msgstr "" -#. fZBAh -#: statistics.xhp +#. pFrdF +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004140\n" +"statistics_test_t.xhp\n" +"par_id1002910\n" "help.text" -msgid "<link href=\"text/scalc/01/statistics_regression.xhp#regressionanalysis\">Regression Analysis</link>" +msgid "Alpha" msgstr "" -#. AXaMM -#: statistics_fourier.xhp +#. da77D +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"tit\n" +"statistics_test_t.xhp\n" +"par_id1002930\n" "help.text" -msgid "Fourier Analysis" +msgid "Hypothesized Mean Difference" msgstr "" -#. EV56D -#: statistics_fourier.xhp +#. tJarn +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"hd_id431561808831965\n" +"statistics_test_t.xhp\n" +"par_id1002950\n" "help.text" -msgid "<variable id=\"fourieranalysysh1\"><link href=\"text/scalc/01/statistics_fourier.xhp\" name=\"Fourier analysis\">Fourier Analysis</link></variable>" +msgid "Variable 1" msgstr "" -#. EEBRe -#: statistics_fourier.xhp +#. kfGaW +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id1001240\n" +"statistics_test_t.xhp\n" +"par_id1002960\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp>" +msgid "Variable 2" msgstr "" -#. F2ncB -#: statistics_fourier.xhp +#. ttThs +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"bm_id2764278\n" +"statistics_test_t.xhp\n" +"par_id1002970\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;Fourier analysis</bookmark_value><bookmark_value>Fourier analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Fourier analysis</bookmark_value>" +msgid "Mean" msgstr "" -#. se49E -#: statistics_fourier.xhp +#. G7NDq +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id1000040\n" +"statistics_test_t.xhp\n" +"par_id1003000\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Fourier Analysis</emph></variable>" +msgid "Variance" msgstr "" -#. HpuG9 -#: statistics_fourier.xhp +#. AsmDu +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id1001270\n" +"statistics_test_t.xhp\n" +"par_id1003030\n" "help.text" -msgid "For more information on Fourier analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Fourier_analysis\" name=\"English Wikipedia: Fourier analysis\">corresponding Wikipedia article</link>." +msgid "Observations" msgstr "" -#. VArYS -#: statistics_fourier.xhp +#. MmDD2 +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id301561811172762\n" +"statistics_test_t.xhp\n" +"par_id1003060\n" "help.text" -msgid "<emph>Input range has label</emph>: Mark when the first row or column of the input array is actually a label and not part of the data analysis." +msgid "Pearson Correlation" msgstr "" -#. Gi5kk -#: statistics_fourier.xhp +#. Nqq8i +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id741556228390897\n" +"statistics_test_t.xhp\n" +"par_id1003080\n" "help.text" -msgid "Input Range is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data." +msgid "Observed Mean Difference" msgstr "" -#. GqXZr -#: statistics_fourier.xhp +#. vDgsc +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"hd_id211561811324208\n" +"statistics_test_t.xhp\n" +"par_id1003100\n" "help.text" -msgid "Options:" +msgid "Variance of the Differences" msgstr "" -#. 68RRB -#: statistics_fourier.xhp +#. CFBrp +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id631556228516997\n" +"statistics_test_t.xhp\n" +"par_id1003120\n" "help.text" -msgid "<emph>Inverse</emph>: When checked, calculates the inverse Discrete Fourier Transform." +msgid "df" msgstr "" -#. MH9kg -#: statistics_fourier.xhp +#. mAixM +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id811561732287508\n" +"statistics_test_t.xhp\n" +"par_id1003140\n" "help.text" -msgid "<emph>Polar</emph>: When checked, the results are in polar coordinates (magnitude, phase)." +msgid "t Stat" msgstr "" -#. peNbe -#: statistics_fourier.xhp +#. utcA9 +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id661561732521977\n" +"statistics_test_t.xhp\n" +"par_id1003160\n" "help.text" -msgid "<emph>Minimum magnitude for polar form output (in dB)</emph>: used only when output is in polar form. All frequency components with magnitude less than this value in decibels will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed." +msgid "P (T<=t) one-tail" msgstr "" -#. 8pLcW -#: statistics_fourier.xhp +#. 7mezL +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id731561827207828\n" +"statistics_test_t.xhp\n" +"par_id1003180\n" "help.text" -msgid "The source data for this example is the same of the <link href=\"text/scalc/01/func_fourier.xhp\" name=\"Fourier function\">FOURIER function page</link>." +msgid "t Critical one-tail" msgstr "" -#. 4XJPB -#: statistics_fourier.xhp +#. GdcRG +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257279817\n" +"statistics_test_t.xhp\n" +"par_id1003200\n" "help.text" -msgid "Fourier Transform" +msgid "P (T<=t) two-tail" msgstr "" -#. nfhVE -#: statistics_fourier.xhp +#. kh5E7 +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id29062019125727379\n" +"statistics_test_t.xhp\n" +"par_id1003220\n" "help.text" -msgid "Fourier Transform" +msgid "t Critical two-tail" msgstr "" -#. G6aEG -#: statistics_fourier.xhp +#. QA9fL +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257276510\n" +"statistics_test_z.xhp\n" +"tit\n" "help.text" -msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgid "Z Test Statistics in Calc" msgstr "" -#. 5L22z -#: statistics_fourier.xhp +#. EQw7L +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257273433\n" +"statistics_test_z.xhp\n" +"bm_id05003\n" "help.text" -msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgid "<bookmark_value>Analysis toolpack;Z-test</bookmark_value><bookmark_value>Z-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Z-test</bookmark_value>" msgstr "" -#. Vyu9a -#: statistics_fourier.xhp +#. XEQkC +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257273688\n" +"statistics_test_z.xhp\n" +"hd_id1000210\n" "help.text" -msgid "<emph>Real</emph>" +msgid "<variable id=\"ztesth1\"><link href=\"text/scalc/01/statistics_test_z.xhp\" name=\"Z-test\">Z-test</link></variable>" msgstr "" -#. qEshW -#: statistics_fourier.xhp +#. vjPXp +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257276202\n" +"statistics_test_z.xhp\n" +"par_id1003640\n" "help.text" -msgid "<emph>Imaginary</emph>" +msgid "<ahelp hid=\"modules/scalc/ui/ztestdialog/ZTestDialog\">Calculates the z-Test of two data samples.</ahelp>" msgstr "" -#. fJ6BG -#: statistics_fourier.xhp +#. FeUKV +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id481561825547527\n" +"statistics_test_z.xhp\n" +"par_id1003650\n" "help.text" -msgid "<emph>Magnitude</emph>" +msgid "<variable id=\"sam02\">Choose <menuitem>Data - Statistics - Z-test</menuitem></variable>" msgstr "" -#. XcXJz -#: statistics_fourier.xhp +#. DrfAa +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id751561825556834\n" +"statistics_test_z.xhp\n" +"par_id1003660\n" "help.text" -msgid "<emph>Phase</emph>" +msgid "For more information on Z-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Z-test\" name=\"English Wikipedia: Z-test\">corresponding Wikipedia article</link>." msgstr "" -#. 7f8Bq -#: statistics_fourier.xhp +#. uj2zU +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id14337286612130\n" +"statistics_test_z.xhp\n" +"hd_id1000220\n" "help.text" -msgid "<link href=\"text/scalc/01/statistics.xhp#datasampling\">Sampling</link>, <link href=\"text/scalc/01/statistics.xhp#descriptivestatistics\">Descriptive Statistics</link>, <link href=\"text/scalc/01/statistics.xhp#anova\">Analysis of Variance (ANOVA)</link>, <link href=\"text/scalc/01/statistics.xhp#correlation\">Correlation</link>, <link href=\"text/scalc/01/statistics.xhp#covariance\">Covariance</link>, <link href=\"text/scalc/01/statistics.xhp#exponentialsmoothing\">Exponential Smoothing</link>, <link href=\"text/scalc/01/statistics.xhp#movingaverage\">Moving Average</link>, <link href=\"text/scalc/01/statistics.xhp#ttest\">Paired t-test</link>, <link href=\"text/scalc/01/statistics.xhp#ftest\">F-test</link>, <link href=\"text/scalc/01/statistics.xhp#ztest\">Z-test</link>, <link href=\"text/scalc/01/statistics.xhp#chisqtest\">Chi-square test</link>." +msgid "Data" msgstr "" -#. 7EZAg -#: statistics_regression.xhp +#. G5qUC +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"tit\n" +"statistics_test_z.xhp\n" +"par_id1003670\n" "help.text" -msgid "Regression Analysis" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." msgstr "" -#. UPKr7 -#: statistics_regression.xhp +#. 6sDZb +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"hd_id1701201615033510\n" +"statistics_test_z.xhp\n" +"par_id1003680\n" "help.text" -msgid "<variable id=\"regressionanalysish1\"><link href=\"text/scalc/01/statistics_regression.xhp\" name=\"regression analysis\">Regression Analysis</link></variable>" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." msgstr "" -#. NFhSA -#: statistics_regression.xhp +#. SRfn5 +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001240\n" +"statistics_test_z.xhp\n" +"par_id1003690\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the regression analysis of a data set</ahelp>" +msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." msgstr "" -#. wDYsU -#: statistics_regression.xhp +#. WLqsj +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"bm_id2764278\n" +"statistics_test_z.xhp\n" +"hd_id1000230\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value>" +msgid "Results for z-Test:" msgstr "" -#. nCe3o -#: statistics_regression.xhp +#. bS4Zx +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1000040\n" +"statistics_test_z.xhp\n" +"par_id1003700\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Regression</emph></variable>" +msgid "The following table shows the <emph>z-Test</emph> for the data series above:" msgstr "" -#. zADGk -#: statistics_regression.xhp +#. cyNij +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001270\n" +"statistics_test_z.xhp\n" +"par_id1003710\n" "help.text" -msgid "For more information on regression analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">corresponding Wikipedia article</link>." +msgid "z-test" msgstr "" -#. rdATw -#: statistics_regression.xhp +#. 2jGDY +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"hd_id1000070\n" +"statistics_test_z.xhp\n" +"par_id1003720\n" "help.text" -msgid "Output Regression Type" +msgid "Alpha" msgstr "" -#. QMDBG -#: statistics_regression.xhp +#. S4FZC +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001280\n" +"statistics_test_z.xhp\n" +"par_id1003740\n" "help.text" -msgid "Set the regression type. Three types are available:" +msgid "Hypothesized Mean Difference" msgstr "" -#. 7Avaz -#: statistics_regression.xhp +#. EyFTK +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201620334364\n" +"statistics_test_z.xhp\n" +"par_id1003760\n" "help.text" -msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data." +msgid "Variable 1" msgstr "" -#. B6dex -#: statistics_regression.xhp +#. yybKF +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201620340168\n" +"statistics_test_z.xhp\n" +"par_id1003770\n" "help.text" -msgid "<emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type=\"literal\">y = a.ln(x) + b</item>, where <item type=\"literal\">a</item> is the slope, <item type=\"literal\">b</item> is the intercept and <item type=\"literal\">ln(x)</item> is the natural logarithm of <item type=\"literal\">x</item>, that best fits the data." +msgid "Variable 2" msgstr "" -#. txgoZ -#: statistics_regression.xhp +#. zi3v9 +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201620340139\n" +"statistics_test_z.xhp\n" +"par_id1003780\n" "help.text" -msgid "<emph>Power regression</emph>: Find a power curve in the form of <item type=\"literal\">y = a.x^b</item>, where <item type=\"literal\">a</item> is the coefficient, <item type=\"literal\">b</item> is the power that best fits the data." +msgid "Known Variance" msgstr "" -#. EtPbr -#: statistics_regression.xhp +#. RozyW +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001310\n" +"statistics_test_z.xhp\n" +"par_id1003810\n" "help.text" -msgid "The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below." +msgid "Mean" msgstr "" -#. iJ7yf -#: statistics_regression.xhp +#. fV5Cq +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090526\n" +"statistics_test_z.xhp\n" +"par_id1003840\n" "help.text" -msgid "Regression" +msgid "Observations" msgstr "" -#. cSAoU -#: statistics_regression.xhp +#. Nfz8K +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090542\n" +"statistics_test_z.xhp\n" +"par_id1003870\n" "help.text" -msgid "Regression Model" +msgid "Observed Mean Difference" msgstr "" -#. YAGFi -#: statistics_regression.xhp +#. MDCGb +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090596\n" +"statistics_test_z.xhp\n" +"par_id1003890\n" "help.text" -msgid "Linear" -msgstr "直線" +msgid "z" +msgstr "" -#. 2zcqS -#: statistics_regression.xhp +#. N35cE +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090586\n" +"statistics_test_z.xhp\n" +"par_id1003900\n" "help.text" -msgid "Logarithmic" +msgid "#DIV/0!" msgstr "" -#. QvaFq -#: statistics_regression.xhp +#. BiBJi +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090555\n" +"statistics_test_z.xhp\n" +"par_id1003910\n" "help.text" -msgid "Power" -msgstr "功率" +msgid "P (Z<=z) one-tail" +msgstr "" -#. oHBnC -#: statistics_regression.xhp +#. HqGPf +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090553\n" +"statistics_test_z.xhp\n" +"par_id1003920\n" "help.text" -msgid "R^2" +msgid "#DIV/0!" msgstr "" -#. egmFM -#: statistics_regression.xhp +#. 2NUBk +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090595\n" +"statistics_test_z.xhp\n" +"par_id1003930\n" "help.text" -msgid "Standard Error" +msgid "z Critical one-tail" msgstr "" -#. woESA -#: statistics_regression.xhp +#. WBGeU +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090563\n" +"statistics_test_z.xhp\n" +"par_id1003950\n" "help.text" -msgid "Slope" +msgid "P (Z<=z) two-tail" msgstr "" -#. qfNCA -#: statistics_regression.xhp +#. TPsmf +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090642\n" +"statistics_test_z.xhp\n" +"par_id1003960\n" "help.text" -msgid "Intercept" +msgid "#DIV/0!" msgstr "" -#. ZAad5 -#: statistics_regression.xhp +#. NCMYu +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id14337286612130\n" +"statistics_test_z.xhp\n" +"par_id1003970\n" "help.text" -msgid "<link href=\"text/scalc/01/statistics.xhp#datasampling\">Sampling</link>, <link href=\"text/scalc/01/statistics.xhp#descriptivestatistics\">Descriptive Statistics</link>, <link href=\"text/scalc/01/statistics.xhp#anova\">Analysis of Variance (ANOVA)</link>, <link href=\"text/scalc/01/statistics.xhp#correlation\">Correlation</link>, <link href=\"text/scalc/01/statistics.xhp#covariance\">Covariance</link>, <link href=\"text/scalc/01/statistics.xhp#exponentialsmoothing\">Exponential Smoothing</link>, <link href=\"text/scalc/01/statistics.xhp#movingaverage\">Moving Average</link>, <link href=\"text/scalc/01/statistics.xhp#ttest\">Paired t-test</link>, <link href=\"text/scalc/01/statistics.xhp#ftest\">F-test</link>, <link href=\"text/scalc/01/statistics.xhp#ztest\">Z-test</link>, <link href=\"text/scalc/01/statistics.xhp#chisqtest\">Chi-square test</link>." +msgid "z Critical two-tail" msgstr "" #. bdLFh @@ -66958,14 +67012,14 @@ msgctxt "" msgid "<link href=\"text/scalc/01/text2columns.xhp\">Text to Columns</link>" msgstr "<link href=\"text/scalc/01/text2columns.xhp\">資料剖析</link>" -#. y8ix9 +#. pvPPw #: text2columns.xhp msgctxt "" "text2columns.xhp\n" "par_id655232\n" "help.text" -msgid "<variable id=\"text2columns\">Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells. </variable>" -msgstr "<variable id=\"text2columns\">開啟 [資料剖析] 對話方塊，您可以在此輸入設定，以將選取儲存格的內容延伸到多個儲存格。 </variable>" +msgid "<variable id=\"text2columns\">Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells.</variable>" +msgstr "" #. YwdL2 #: text2columns.xhp |