diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2015-05-19 22:09:03 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2015-05-19 23:09:38 +0200 |
| commit | f7efc4ecf69cba536cd0391d4673e31226b1fe86 (patch) | |
| tree | f4ccf2ceee59e7cbb7ab866471e3225989cb9ae6 /source/zh-TW/helpcontent2/source/text/scalc | |
| parent | 625f07e0dc9a40453c54c4dc8ebfbc6062f54f86 (diff) | |
update translations for 5.0.0 beta1libreoffice-5-0-branch-point
and force-fix errors using pocheck
Change-Id: I295e6d2e6b47a06165cdf8900e2775b7157af809
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc')
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/00.po | 8 | ||||
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/01.po | 2153 | ||||
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/04.po | 10 | ||||
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/05.po | 243 | ||||
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/guide.po | 24 |
5 files changed, 1679 insertions, 759 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/00.po b/source/zh-TW/helpcontent2/source/text/scalc/00.po index e40f42afee4..3ec0ecd82ee 100644 --- a/source/zh-TW/helpcontent2/source/text/scalc/00.po +++ b/source/zh-TW/helpcontent2/source/text/scalc/00.po @@ -3,8 +3,8 @@ 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: 2014-11-18 11:23+0100\n" -"PO-Revision-Date: 2012-07-13 08:48+0200\n" +"POT-Creation-Date: 2015-04-22 23:39+0200\n" +"PO-Revision-Date: 2015-01-20 12:04+0000\n" "Last-Translator: Cheng-Chia <pswo10680@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: zh_TW\n" @@ -14,6 +14,7 @@ msgstr "" "Plural-Forms: nplurals=1; plural=0;\n" "X-Generator: LibreOffice\n" "X-Accelerator-Marker: ~\n" +"X-POOTLE-MTIME: 1421755477.000000\n" #: 00000004.xhp msgctxt "" @@ -1430,13 +1431,14 @@ msgid "Choose <emph>Data - Filter - Advanced Filter - More>></emph> button" msgstr "選擇 <emph>[資料] - [篩選] - [特殊篩選] - [其他>>]</emph> 按鈕" #: 00000412.xhp +#, fuzzy msgctxt "" "00000412.xhp\n" "par_id3156382\n" "20\n" "help.text" msgid "Choose <emph>Data - Filter - Reset Filter</emph>" -msgstr "" +msgstr "選擇 <emph>[資料] - [篩選] - [自動篩選]</emph>" #: 00000412.xhp msgctxt "" diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po index 3dcce3c10ce..14c1f90d31d 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: 2014-11-26 19:57+0100\n" +"POT-Creation-Date: 2015-05-11 16:11+0200\n" "PO-Revision-Date: 2012-08-13 09:33+0000\n" "Last-Translator: Cheng-Chia <pswo10680@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -21,16 +21,16 @@ msgctxt "" "01120000.xhp\n" "tit\n" "help.text" -msgid "Page Preview" -msgstr "頁面預覽" +msgid "Print Preview" +msgstr "" #: 01120000.xhp msgctxt "" "01120000.xhp\n" "hd_id1918698\n" "help.text" -msgid "<link href=\"text/scalc/01/01120000.xhp\">Page Preview</link>" -msgstr "<link href=\"text/scalc/01/01120000.xhp\">頁面預覽</link>" +msgid "<link href=\"text/scalc/01/01120000.xhp\">Print Preview</link>" +msgstr "" #: 01120000.xhp msgctxt "" @@ -45,8 +45,8 @@ msgctxt "" "01120000.xhp\n" "par_id3145847\n" "help.text" -msgid "Use the icons on the <emph>Page Preview Bar</emph> to scroll through the pages of the document or to print the document." -msgstr "使用 <emph>[頁面預覽列]</emph> 上的圖示捲動文件的頁面或列印文件。" +msgid "Use the icons on the <emph>Print Preview Bar</emph> to scroll through the pages of the document or to print the document." +msgstr "" #: 01120000.xhp msgctxt "" @@ -61,16 +61,16 @@ msgctxt "" "01120000.xhp\n" "par_id7211828\n" "help.text" -msgid "You cannot edit your document while you are in the page preview." -msgstr "處於頁面預覽中時，您無法編輯文件。" +msgid "You cannot edit your document while you are in the print preview." +msgstr "" #: 01120000.xhp msgctxt "" "01120000.xhp\n" "par_id460829\n" "help.text" -msgid "<ahelp hid=\".\" visibility=\"hidden\">To exit the page preview, click the <emph>Close Preview</emph> button.</ahelp>" -msgstr "<ahelp hid=\".\" visibility=\"hidden\">若要結束頁面預覽，請按一下 <emph>[關閉預覽]</emph> 按鈕。</ahelp>" +msgid "<ahelp hid=\".\" visibility=\"hidden\">To exit the print preview, click the <emph>Close Preview</emph> button.</ahelp>" +msgstr "" #: 01120000.xhp msgctxt "" @@ -8580,8 +8580,8 @@ msgctxt "" "par_id3147499\n" "2\n" "help.text" -msgid "<variable id=\"informationtext\">This category contains the <emph>Information</emph> functions. </variable>" -msgstr "<variable id=\"informationtext\">此分類包含<emph>資訊</emph>函數。 </variable>" +msgid "<variable id=\"informationtext\">This category contains the <emph>Information</emph> functions.</variable>" +msgstr "" #: 04060104.xhp msgctxt "" @@ -9454,6 +9454,94 @@ msgstr "<item type=\"input\">=ISERROR(C9)</item> (其中儲存格 C9 包含 <ite #: 04060104.xhp msgctxt "" "04060104.xhp\n" +"bm_id31470811\n" +"help.text" +msgid "<bookmark_value>IFERROR function</bookmark_value><bookmark_value>testing;general errors</bookmark_value>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id31470811\n" +"53\n" +"help.text" +msgid "IFERROR" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31563161\n" +"54\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_IFERROR\">Returns the value if the cell does not contains an error value, or the alternative value if it does.</ahelp>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id31475691\n" +"55\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31531551\n" +"56\n" +"help.text" +msgid "IFERROR(Value;Alternate_value)" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31540471\n" +"57\n" +"help.text" +msgid "<emph>Value</emph> is the value or expression to be be returned if it does not equal or result in an error." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31540472\n" +"57\n" +"help.text" +msgid "<emph>Alternate_value</emph> is the value or expression to be be returned if the expression or value of <emph>Value</emph> does equal or result in an error." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id31559941\n" +"58\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31502561\n" +"59\n" +"help.text" +msgid "<item type=\"input\">=IFERROR(C8;C9)</item> where cell C8 contains <item type=\"input\">=1/0</item> returns the value of C9, because 1/0 is an error." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id18890951\n" +"help.text" +msgid "<item type=\"input\">=IFERROR(C8;C9)</item> where cell C8 contains <item type=\"input\">13</item> returns 13, the value of C8, which is not an error." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" "bm_id3153618\n" "help.text" msgid "<bookmark_value>ISFORMULA function</bookmark_value><bookmark_value>recognizing formula cells</bookmark_value><bookmark_value>formula cells;recognizing</bookmark_value>" @@ -9525,6 +9613,110 @@ msgstr "若儲存格 C4 包含數字 <item type=\"input\">5</item>，則 <item t #: 04060104.xhp msgctxt "" "04060104.xhp\n" +"bm_id3156048\n" +"help.text" +msgid "<bookmark_value>ISEVEN function</bookmark_value><bookmark_value>even integers</bookmark_value>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3156048\n" +"help.text" +msgid "ISEVEN" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3149170\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ISTGERADE\">Returns TRUE if the value is an even integer, or FALSE if the value is odd.</ahelp>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3146928\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3151203\n" +"help.text" +msgid "ISEVEN(Value)" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3150491\n" +"help.text" +msgid "<emph>Value</emph> is the value to be checked." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3445844\n" +"help.text" +msgid "If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3154136\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3163813\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(48)</item> returns TRUE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id8378856\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(33)</item> returns FALSE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id7154759\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(0)</item> returns TRUE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id1912289\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(-2.1)</item> returns TRUE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id5627307\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(3.999)</item> returns FALSE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" "bm_id3149760\n" "help.text" msgid "<bookmark_value>ISEVEN_ADD function</bookmark_value>" @@ -9929,6 +10121,86 @@ msgstr "<item type=\"input\">=ISNA(D3)</item> 傳回結果為 FALSE。" #: 04060104.xhp msgctxt "" "04060104.xhp\n" +"bm_id31536851\n" +"help.text" +msgid "<bookmark_value>IFNA function</bookmark_value><bookmark_value>#N/A error;testing</bookmark_value>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id31536851\n" +"93\n" +"help.text" +msgid "IFNA" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31491051\n" +"94\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_IFNA\">Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does.</ahelp>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id31529471\n" +"95\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31537481\n" +"96\n" +"help.text" +msgid "IFNA(Value;Alternate_value)" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31528841\n" +"97\n" +"help.text" +msgid "<emph>Value</emph> is the value or expression to be be returned if it does not equal or result in an #N/A error." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31528842\n" +"97\n" +"help.text" +msgid "<emph>Alternate_value</emph> is the value or expression to be be returned if the expression or value of <emph>Value</emph> does equal or result in an #N/A error." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id31499641\n" +"98\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id31548521\n" +"99\n" +"help.text" +msgid "<item type=\"input\">=IFNA(D3;D4)</item> returns the value of D3 if D3 does not result in an #N/A error, or D4 if it does." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" "bm_id3149426\n" "help.text" msgid "<bookmark_value>ISTEXT function</bookmark_value><bookmark_value>cell contents;text</bookmark_value>" @@ -10017,6 +10289,102 @@ msgstr "若儲存格 C3 包含數字 <item type=\"input\">3</item>，則 <item t #: 04060104.xhp msgctxt "" "04060104.xhp\n" +"bm_id3156034\n" +"help.text" +msgid "<bookmark_value>ISODD function</bookmark_value><bookmark_value>odd integers</bookmark_value>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3156034\n" +"help.text" +msgid "ISODD" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3155920\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ISTUNGERADE\">Returns TRUE if the value is odd, or FALSE if the number is even.</ahelp>" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3151006\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3151375\n" +"help.text" +msgid "ISODD(value)" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3155139\n" +"help.text" +msgid "<emph>Value</emph> is the value to be checked." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id9027680\n" +"help.text" +msgid "If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored." +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3163723\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3155345\n" +"help.text" +msgid "<item type=\"input\">=ISODD(33)</item> returns TRUE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id9392986\n" +"help.text" +msgid "<item type=\"input\">=ISODD(48)</item> returns FALSE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id5971251\n" +"help.text" +msgid "<item type=\"input\">=ISODD(3.999)</item> returns TRUE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id4136478\n" +"help.text" +msgid "<item type=\"input\">=ISODD(-3.1)</item> returns TRUE" +msgstr "" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" "bm_id3153939\n" "help.text" msgid "<bookmark_value>ISODD_ADD function</bookmark_value>" @@ -11848,77 +12216,6 @@ msgstr "<item type=\"input\">=ABS(0)</item> 傳回 0。" #: 04060106.xhp msgctxt "" "04060106.xhp\n" -"bm_id3150896\n" -"help.text" -msgid "<bookmark_value>COUNTBLANK function</bookmark_value><bookmark_value>counting;empty cells</bookmark_value><bookmark_value>empty cells;counting</bookmark_value>" -msgstr "<bookmark_value>COUNTBLANK 函數</bookmark_value><bookmark_value>計數; 空白儲存格</bookmark_value><bookmark_value>空白儲存格; 計數</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3150896\n" -"42\n" -"help.text" -msgid "COUNTBLANK" -msgstr "COUNTBLANK" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155260\n" -"43\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\">Returns the number of empty cells.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\">傳回空的儲存格數。</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3145144\n" -"44\n" -"help.text" -msgid "Syntax" -msgstr "語法" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3153931\n" -"45\n" -"help.text" -msgid "COUNTBLANK(Range)" -msgstr "COUNTBLANK(Range)" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3149512\n" -"46\n" -"help.text" -msgid "Returns the number of empty cells in the cell range <emph>Range</emph>." -msgstr "傳回儲存格範圍 <emph>Range</emph> 中空白的儲存格數。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3146139\n" -"47\n" -"help.text" -msgid "Example" -msgstr "範例" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3148586\n" -"48\n" -"help.text" -msgid "<item type=\"input\">=COUNTBLANK(A1:B2)</item> returns 4 if cells A1, A2, B1, and B2 are all empty." -msgstr "若儲存格 A1、A2、B1 與 B2 皆為空白，則 <item type=\"input\">=COUNTBLANK(A1:B2)</item> 會傳回 4。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" "bm_id3153114\n" "help.text" msgid "<bookmark_value>ACOS function</bookmark_value>" @@ -13765,220 +14062,6 @@ msgstr "<item type=\"input\">=GCD_ADD(5;15;25)</item> 傳回 5。" #: 04060106.xhp msgctxt "" "04060106.xhp\n" -"bm_id3156048\n" -"help.text" -msgid "<bookmark_value>ISEVEN function</bookmark_value><bookmark_value>even integers</bookmark_value>" -msgstr "<bookmark_value>ISEVEN 函數</bookmark_value><bookmark_value>偶數</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3156048\n" -"245\n" -"help.text" -msgid "ISEVEN" -msgstr "ISEVEN" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3149169\n" -"246\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ISTGERADE\">Returns TRUE if the value is an even integer, or FALSE if the value is odd.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ISTGERADE\">如果數值是偶數整數，則傳回 TRUE；如果是奇數，則傳回 FALSE。</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3146928\n" -"247\n" -"help.text" -msgid "Syntax" -msgstr "語法" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151203\n" -"248\n" -"help.text" -msgid "ISEVEN(Value)" -msgstr "ISEVEN(Value)" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3150491\n" -"249\n" -"help.text" -msgid "<emph>Value</emph> is the value to be checked." -msgstr "<emph>Value</emph> 是要檢查的數值。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3445844\n" -"help.text" -msgid "If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored." -msgstr "若 Value 不是整數，則將忽略小數點後的所有位數。同時也會忽略 Value 的正負號。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3154136\n" -"250\n" -"help.text" -msgid "Example" -msgstr "範例" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163813\n" -"251\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(48)</item> returns TRUE" -msgstr "<item type=\"input\">=ISEVEN(48)</item> 傳回 TRUE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8378856\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(33)</item> returns FALSE" -msgstr "<item type=\"input\">=ISEVEN(33)</item> 傳回 FALSE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id7154759\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(0)</item> returns TRUE" -msgstr "<item type=\"input\">=ISEVEN(0)</item> 傳回 TRUE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id1912289\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(-2.1)</item> returns TRUE" -msgstr "<item type=\"input\">=ISEVEN(-2.1)</item> 傳回 TRUE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id5627307\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(3.999)</item> returns FALSE" -msgstr "<item type=\"input\">=ISEVEN(3.999)</item> 傳回 FALSE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id3156034\n" -"help.text" -msgid "<bookmark_value>ISODD function</bookmark_value><bookmark_value>odd integers</bookmark_value>" -msgstr "<bookmark_value>ISODD 函數</bookmark_value><bookmark_value>奇數</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3156034\n" -"255\n" -"help.text" -msgid "ISODD" -msgstr "ISODD" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155910\n" -"256\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ISTUNGERADE\">Returns TRUE if the value is odd, or FALSE if the number is even.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ISTUNGERADE\">如果數值是奇數，則傳回 TRUE；如果是偶數，則傳回 FALSE。</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3151006\n" -"257\n" -"help.text" -msgid "Syntax" -msgstr "語法" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151375\n" -"258\n" -"help.text" -msgid "ISODD(value)" -msgstr "ISODD(value)" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155139\n" -"259\n" -"help.text" -msgid "<emph>Value</emph> is the value to be checked." -msgstr "<emph>Value</emph> 是要檢查的數值。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id9027680\n" -"help.text" -msgid "If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored." -msgstr "若 Value 不是整數，則將忽略小數點後的所有位數。同時也會忽略 Value 的正負號。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3163723\n" -"260\n" -"help.text" -msgid "Example" -msgstr "範例" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155345\n" -"261\n" -"help.text" -msgid "<item type=\"input\">=ISODD(33)</item> returns TRUE" -msgstr "<item type=\"input\">=ISODD(33)</item> 傳回 TRUE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id9392986\n" -"help.text" -msgid "<item type=\"input\">=ISODD(48)</item> returns FALSE" -msgstr "<item type=\"input\">=ISODD(48)</item> 傳回 FALSE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id5971251\n" -"help.text" -msgid "<item type=\"input\">=ISODD(3.999)</item> returns TRUE" -msgstr "<item type=\"input\">=ISODD(3.999)</item> 傳回 TRUE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id4136478\n" -"help.text" -msgid "<item type=\"input\">=ISODD(-3.1)</item> returns TRUE" -msgstr "<item type=\"input\">=ISODD(-3.1)</item> 傳回 TRUE。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" "bm_id3145213\n" "help.text" msgid "<bookmark_value>LCM function</bookmark_value><bookmark_value>least common multiples</bookmark_value><bookmark_value>lowest common multiples</bookmark_value>" @@ -17945,134 +18028,6 @@ msgctxt "" msgid "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." msgstr "<item type=\"input\">=RAND()</item> 傳回介於 0 與 1 之間的隨機數。" -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id3164897\n" -"help.text" -msgid "<bookmark_value>COUNTIF function</bookmark_value><bookmark_value>counting;specified cells</bookmark_value>" -msgstr "<bookmark_value>COUNTIF 函數</bookmark_value><bookmark_value>計數; 指定的儲存格</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3164897\n" -"547\n" -"help.text" -msgid "COUNTIF" -msgstr "COUNTIF" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3164926\n" -"548\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">Returns the number of cells that meet with certain criteria within a cell range.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">傳回某一儲存格範圍中符合一定條件的儲存格數。</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3164953\n" -"549\n" -"help.text" -msgid "Syntax" -msgstr "語法" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3164967\n" -"550\n" -"help.text" -msgid "COUNTIF(Range; Criteria)" -msgstr "COUNTIF(Range; Criteria)" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3164980\n" -"551\n" -"help.text" -msgid "<emph>Range</emph> is the range to which the criteria are to be applied." -msgstr "<emph>Range</emph> 是要套用條件的範圍。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3165000\n" -"552\n" -"help.text" -msgid "<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes." -msgstr "<emph>Criteria</emph> 表示會以數字、表示式或字元字串的格式來表示條件。這些條件可決定要計算的儲存格。您也可以使用常規表示式的格式輸入搜尋文字，例如 b.* 代表所有以 b 開頭的字詞。您還可以指定包含搜尋條件的儲存格範圍。若要搜尋文字，請在文字前後加上雙引號。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3165037\n" -"553\n" -"help.text" -msgid "Example" -msgstr "範例" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3166505\n" -"627\n" -"help.text" -msgid "A1:A10 is a cell range containing the numbers <item type=\"input\">2000</item> to <item type=\"input\">2009</item>. Cell B1 contains the number <item type=\"input\">2006</item>. In cell B2, you enter a formula:" -msgstr "A1:A10 是包含數字 <item type=\"input\">2000</item> 到 <item type=\"input\">2009</item> 的儲存格範圍。儲存格 B1 包含數字 <item type=\"input\">2006</item>。在儲存格 B2 中，輸入公式：" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3581652\n" -"help.text" -msgid "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - this returns 1" -msgstr "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - 傳回 1。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id708639\n" -"help.text" -msgid "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - this returns 1" -msgstr "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - 傳回 1。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id5169225\n" -"help.text" -msgid "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- this returns 4" -msgstr "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- 傳回 4。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id2118594\n" -"help.text" -msgid "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - when B1 contains <item type=\"input\">2006</item>, this returns 6" -msgstr "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - 當 B1 包含 <item type=\"input\">2006</item> 時，此函數傳回 6。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id166020\n" -"help.text" -msgid "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type=\"input\">>2006</item> counts the number of cells in the range A1:A10 which are >2006" -msgstr "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> 其中儲存格 C2 包含文字 <item type=\"input\">>2006</item>，計算範圍 A1:A10 中 >2006 的儲存格數。" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id6386913\n" -"help.text" -msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" -msgstr "僅計算負數：<item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" - #: 04060107.xhp msgctxt "" "04060107.xhp\n" @@ -25641,18 +25596,48 @@ msgstr "" msgctxt "" "04060110.xhp\n" "hd_id2950260\n" -"101\n" "help.text" -msgid "Example" +msgid "Examples" msgstr "" #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949141\n" -"102\n" "help.text" -msgid "<item type=\"input\">=LEFTB(\"output\";3)</item> returns “out”." +msgid "<item type=\"input\">LEFTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2949151\n" +"help.text" +msgid "<item type=\"input\">LEFTB(\"中国\";2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2949161\n" +"help.text" +msgid "<item type=\"input\">LEFTB(\"中国\";3)</item> returns \"中 \" (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2949171\n" +"help.text" +msgid "<item type=\"input\">LEFTB(\"中国\";4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2949181\n" +"help.text" +msgid "<item type=\"input\">LEFTB(\"office\";3)</item> returns \"off\" (3 non-DBCS characters each consisting of 1 byte)." msgstr "" #: 04060110.xhp @@ -25792,9 +25777,32 @@ msgstr "" msgctxt "" "04060110.xhp\n" "hd_id2953884\n" -"109\n" "help.text" -msgid "Example" +msgid "Examples" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2956018\n" +"help.text" +msgid "<item type=\"input\">LENB(\"中\")</item> returns 2 (1 DBCS character consisting of 2 bytes)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2956028\n" +"help.text" +msgid "<item type=\"input\">LENB(\"中国\")</item> returns 4 (2 DBCS characters each consisting of 2 bytes)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2956038\n" +"help.text" +msgid "<item type=\"input\">LENB(\"office\")</item> returns 6 (6 non-DBCS characters each consisting of 1 byte)." msgstr "" #: 04060110.xhp @@ -26050,18 +26058,96 @@ msgstr "" msgctxt "" "04060110.xhp\n" "hd_id2950509\n" -"155\n" "help.text" -msgid "Example" +msgid "Examples" msgstr "" #: 04060110.xhp msgctxt "" "04060110.xhp\n" -"par_id2958407\n" -"156\n" +"par_id2958417\n" "help.text" -msgid "<item type=\"input\">=MIDB(\"office\";2;2)</item> returns ff." +msgid "<item type=\"input\">MIDB(\"中国\";1;0)</item> returns \"\" (0 bytes is always an empty string)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958427\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";1;1)</item> returns \" \" (1 byte is only half a DBCS character and therefore the result is a space character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958437\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";1;2)</item> returns \"中\" (2 bytes constitute one complete DBCS character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958447\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";1;3)</item> returns \"中 \" (3 bytes constitute one and a half DBCS character; the last byte results in a space character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958457\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";1;4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958467\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";2;1)</item> returns \" \" (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958477\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";2;2)</item> returns \" \" (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958487\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";2;3)</item> returns \" 国\" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958497\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";3;1)</item> returns \" \" (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958507\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";3;2)</item> returns \"国\" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958517\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"office\";2;3)</item> returns \"ffi\" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters)." msgstr "" #: 04060110.xhp @@ -26477,18 +26563,48 @@ msgstr "" msgctxt "" "04060110.xhp\n" "hd_id2948661\n" -"119\n" "help.text" -msgid "Example" +msgid "Examples" msgstr "" #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2951132\n" -"120\n" "help.text" -msgid "<item type=\"input\">=RIGHTB(\"Sun\";2)</item> returns un." +msgid "<item type=\"input\">RIGHTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2951142\n" +"help.text" +msgid "<item type=\"input\">RIGHTB(\"中国\";2)</item> returns \"国\" (2 bytes constitute one complete DBCS character)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2951152\n" +"help.text" +msgid "<item type=\"input\">RIGHTB(\"中国\";3)</item> returns \" 国\" (3 bytes constitute one half DBCS character and one whole DBCS character; a space is returned for the first half)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2951162\n" +"help.text" +msgid "<item type=\"input\">RIGHTB(\"中国\";4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2951172\n" +"help.text" +msgid "<item type=\"input\">RIGHTB(\"office\";3)</item> returns \"ice\" (3 non-DBCS characters each consisting of 1 byte)." msgstr "" #: 04060110.xhp @@ -30882,7 +30998,7 @@ msgctxt "" "par_id2963824\n" "138\n" "help.text" -msgid "ERF(LowerLimit; UpperLimit)" +msgid "ERF.PRECISE(LowerLimit; UpperLimit)" msgstr "" #: 04060115.xhp @@ -39574,6 +39690,191 @@ msgstr "<item type=\"input\">=COUNTA(2;4;6;\"eight\")</item> = 4。值的計數 #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id3150896\n" +"help.text" +msgid "<bookmark_value>COUNTBLANK function</bookmark_value><bookmark_value>counting;empty cells</bookmark_value><bookmark_value>empty cells;counting</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id3150896\n" +"help.text" +msgid "COUNTBLANK" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3155260\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\">Returns the number of empty cells.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id3145144\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3153931\n" +"help.text" +msgid "COUNTBLANK(Range)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3149512\n" +"help.text" +msgid "Returns the number of empty cells in the cell range <emph>Range</emph>." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id3146139\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3148586\n" +"help.text" +msgid "<item type=\"input\">=COUNTBLANK(A1:B2)</item> returns 4 if cells A1, A2, B1, and B2 are all empty." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"bm_id3164897\n" +"help.text" +msgid "<bookmark_value>COUNTIF function</bookmark_value><bookmark_value>counting;specified cells</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id3164897\n" +"547\n" +"help.text" +msgid "COUNTIF" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3164926\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">Returns the number of cells that meet with certain criteria within a cell range.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id3164953\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3164967\n" +"help.text" +msgid "COUNTIF(Range; Criteria)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3164980\n" +"help.text" +msgid "<emph>Range</emph> is the range to which the criteria are to be applied." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3165000\n" +"help.text" +msgid "<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id3165037\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3166505\n" +"help.text" +msgid "A1:A10 is a cell range containing the numbers <item type=\"input\">2000</item> to <item type=\"input\">2009</item>. Cell B1 contains the number <item type=\"input\">2006</item>. In cell B2, you enter a formula:" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3581652\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - this returns 1" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id708639\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - this returns 1" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id5169225\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- this returns 4" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2118594\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - when B1 contains <item type=\"input\">2006</item>, this returns 6" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id166020\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type=\"input\">>2006</item> counts the number of cells in the range A1:A10 which are >2006" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id6386913\n" +"help.text" +msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3150267\n" "help.text" msgid "<bookmark_value>B function</bookmark_value> <bookmark_value>probabilities of samples with binomial distribution</bookmark_value>" @@ -40187,7 +40488,7 @@ msgctxt "" "04060181.xhp\n" "par_id062920141254453\n" "help.text" -msgid "<emph>Cumulative</emph> (required) can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function." +msgid "<emph>Cumulative</emph> (required) can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function." msgstr "" #: 04060181.xhp @@ -41211,7 +41512,7 @@ msgctxt "" "par_id2951052\n" "98\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_CHITEST_MS\">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHI.TEST returns the chi-squared distribution of the data." +msgid "<ahelp hid=\"HID_FUNC_CHITEST_MS\">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHISQ.TEST returns the chi-squared distribution of the data." msgstr "" #: 04060181.xhp @@ -41220,7 +41521,7 @@ msgctxt "" "par_id2948925\n" "135\n" "help.text" -msgid "The probability determined by CHI.TEST can also be determined with CHI.DIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row." +msgid "The probability determined by CHISQ.TEST can also be determined with CHISQ.DIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row." msgstr "" #: 04060181.xhp @@ -41622,7 +41923,7 @@ msgctxt "" "04060181.xhp\n" "par_id282020091254453\n" "help.text" -msgid "<emph>Cumulative</emph> can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function." +msgid "<emph>Cumulative</emph> can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function." msgstr "" #: 04060181.xhp @@ -48300,7 +48601,7 @@ msgctxt "" "hd_id2855071\n" "2\n" "help.text" -msgid "RANK.AVG" +msgid "RANK.EQ" msgstr "" #: 04060185.xhp @@ -49700,7 +50001,7 @@ msgctxt "" "04060185.xhp\n" "bm_id2949579\n" "help.text" -msgid "<bookmark_value>T.INV function</bookmark_value> <bookmark_value>two tailed inverse of t-distribution</bookmark_value>" +msgid "<bookmark_value>T.INV function</bookmark_value> <bookmark_value>one tailed inverse of t-distribution</bookmark_value>" msgstr "" #: 04060185.xhp @@ -49718,7 +50019,7 @@ msgctxt "" "par_id2943232\n" "99\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_TINV_MS\">Returns the two tailed inverse of the t-distribution.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_TINV_MS\">Returns the one tailed inverse of the t-distribution.</ahelp>" msgstr "" #: 04060185.xhp @@ -49745,7 +50046,7 @@ msgctxt "" "par_id2954070\n" "102\n" "help.text" -msgid "<emph>Number</emph> is the probability associated with the two-tailed t-distribution." +msgid "<emph>Number</emph> is the probability associated with the one-tailed t-distribution." msgstr "" #: 04060185.xhp @@ -52147,8 +52448,8 @@ msgctxt "" "par_id3154366\n" "2\n" "help.text" -msgid "<variable id=\"namenfestlegentext\"><ahelp hid=\".uno:DefineName\">Opens a dialog where you can specify a name for a selected area.</ahelp></variable>" -msgstr "<variable id=\"namenfestlegentext\"><ahelp hid=\".uno:DefineName\">開啟對話方塊，在此處您可以指定所選區域的名稱。</ahelp></variable>" +msgid "<variable id=\"namenfestlegentext\"><ahelp hid=\".uno:DefineName\">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp></variable>" +msgstr "" #: 04070100.xhp msgctxt "" @@ -52165,8 +52466,8 @@ msgctxt "" "par_id3155131\n" "30\n" "help.text" -msgid "The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." -msgstr "編輯列上的<emph>[試算表區域]</emph>方塊中包含為範圍所定義的名稱之清單。按一下此方塊中的某個名稱，以突出顯示試算表中對應的參照。此處未列出已命名公式或公式的一部份。" +msgid "The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." +msgstr "" #: 04070100.xhp msgctxt "" @@ -52183,8 +52484,8 @@ msgctxt "" "par_id3163712\n" "29\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/definename/edit\">Enter the name of the area for which you want to define a reference. All area names already defined in the spreadsheet are listed in the text field below.</ahelp> If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames." -msgstr "<ahelp hid=\"modules/scalc/ui/definename/edit\">輸入要定義參照的區域之名稱。試算表中已定義的所有區域名稱都列在以下的文字欄位。</ahelp>如果在清單上按一下名稱，文件中的對應參照會以藍色訊框顯示。如果同一個區域名稱對應多個儲存格範圍，則這些儲存格範圍以不同顏色的框來顯示。" +msgid "<ahelp hid=\"modules/scalc/ui/definename/edit\">Enter the name of the area for which you want to define a reference or a formula expression. All area names already defined in the spreadsheet are listed in the text field below.</ahelp> If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames." +msgstr "" #: 04070100.xhp msgctxt "" @@ -52192,8 +52493,8 @@ msgctxt "" "hd_id3153728\n" "9\n" "help.text" -msgid "Assigned to" -msgstr "指定給" +msgid "Range or formula expression" +msgstr "" #: 04070100.xhp msgctxt "" @@ -52210,35 +52511,44 @@ msgctxt "" "par_id3146986\n" "12\n" "help.text" -msgid "To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document." -msgstr "若要插入新的區域參照，請將游標置入此欄位，然後使用滑鼠來選取試算表文件中任一工作表的所要區域。" +msgid "To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression." +msgstr "" #: 04070100.xhp msgctxt "" "04070100.xhp\n" -"hd_id3154729\n" +"hd_id31547290\n" "13\n" "help.text" -msgid "More" -msgstr "其他" +msgid "Scope" +msgstr "" #: 04070100.xhp msgctxt "" "04070100.xhp\n" -"par_id3149958\n" -"14\n" +"hd_id31547291\n" +"13\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/definename/more\">Allows you to specify the <emph>Area type </emph>(optional) for the reference.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/definename/more\">允許您為此參照指定 <emph>[區域類型]</emph> (可選擇的)。</ahelp>" +msgid "Select the scope of the named range or named formula. Document(Global) means the name is valid for the whole document. Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet." +msgstr "" #: 04070100.xhp msgctxt "" "04070100.xhp\n" -"hd_id3147394\n" -"15\n" +"hd_id3154729\n" +"13\n" "help.text" -msgid "Area type" -msgstr "區域類型" +msgid "Range options" +msgstr "" + +#: 04070100.xhp +msgctxt "" +"04070100.xhp\n" +"par_id3149958\n" +"14\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/definename/more\">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp>" +msgstr "" #: 04070100.xhp msgctxt "" @@ -65240,7 +65550,15 @@ msgstr "按一下 [確定] 接受變更，然後返回 [<link href=\"text/scalc/ #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id200820141553364965\n" +"tit\n" +"help.text" +msgid "Data" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"hd_id1000010\n" "help.text" msgid "Data" msgstr "" @@ -65248,7 +65566,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533682345\n" +"par_id1000010\n" "help.text" msgid "<emph>Input Range</emph>: The reference of the range of the data to analyze." msgstr "" @@ -65256,7 +65574,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533690271\n" +"par_id1000020\n" "help.text" msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the results will be displayed." msgstr "" @@ -65264,7 +65582,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533630182\n" +"hd_id1000020\n" "help.text" msgid "Grouped By" msgstr "" @@ -65272,7 +65590,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533694478\n" +"par_id1000030\n" "help.text" msgid "Select whether the input data has <emph>columns</emph> or <emph>rows</emph> layout." msgstr "" @@ -65280,7 +65598,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533366360\n" +"hd_id1000030\n" "help.text" msgid "Example" msgstr "" @@ -65288,7 +65606,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533343874\n" +"par_id1000040\n" "help.text" msgid "The following data will be used as example" msgstr "" @@ -65296,7 +65614,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id200820141553335121\n" +"par_id1000090\n" "help.text" msgid "Maths" msgstr "" @@ -65304,7 +65622,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533379519\n" +"par_id1000100\n" "help.text" msgid "Physics" msgstr "" @@ -65312,7 +65630,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id200820141553333644\n" +"par_id1000110\n" "help.text" msgid "Biology" msgstr "" @@ -65320,7 +65638,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533624784\n" +"hd_id1000040\n" "help.text" msgid "Example" msgstr "" @@ -65328,7 +65646,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533648925\n" +"par_id1000550\n" "help.text" msgid "The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2." msgstr "" @@ -65336,17 +65654,17 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533654405\n" +"hd_id1000050\n" "help.text" -msgid "A" +msgid "Example" msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533633771\n" +"par_id1000970\n" "help.text" -msgid "B" +msgid "The following table has two data sets." msgstr "" #: statistics.xhp @@ -65360,8 +65678,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id1\n" -"1\n" +"hd_id1000010\n" "help.text" msgid "Data Statistics in Calc" msgstr "" @@ -65369,7 +65686,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533013547\n" +"par_id1000010\n" "help.text" msgid "Use the data statistics in Calc to perform complex data analysis" msgstr "" @@ -65377,9 +65694,9 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533090579\n" +"par_id1000020\n" "help.text" -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." +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 "" #: statistics.xhp @@ -65387,13 +65704,13 @@ 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>" +msgid "<bookmark_value>Analysis toolpack;sampling</bookmark_value><bookmark_value>sampling;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;sampling</bookmark_value>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533083500\n" +"hd_id1000020\n" "help.text" msgid "Sampling" msgstr "" @@ -65401,8 +65718,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2756327\n" -"2\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 "" @@ -65410,8 +65726,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2752992\n" -"26\n" +"par_id1000040\n" "help.text" msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Sampling...</emph></variable>" msgstr "" @@ -65419,7 +65734,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533091337\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 "" @@ -65427,7 +65742,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533022103\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 "" @@ -65435,7 +65750,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533154722\n" +"hd_id1000030\n" "help.text" msgid "Sampling Method" msgstr "" @@ -65443,7 +65758,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533127849\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 "" @@ -65451,7 +65766,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533118838\n" +"par_id1000080\n" "help.text" msgid "<emph>Sample size</emph>: Number of lines sampled from the source table." msgstr "" @@ -65459,7 +65774,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533154688\n" +"par_id1000090\n" "help.text" msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>." msgstr "" @@ -65467,7 +65782,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533199288\n" +"par_id1000100\n" "help.text" msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling." msgstr "" @@ -65475,7 +65790,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533195750\n" +"hd_id1000040\n" "help.text" msgid "Example" msgstr "" @@ -65483,7 +65798,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533199646\n" +"par_id1000110\n" "help.text" msgid "The following data will be used as example of source data table for sampling:" msgstr "" @@ -65491,7 +65806,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533317386\n" +"par_id1000510\n" "help.text" msgid "Sampling with a period of 2 will result in the following table:" msgstr "" @@ -65501,14 +65816,13 @@ 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>" +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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id01003\n" -"1\n" +"hd_id1000050\n" "help.text" msgid "Descriptive Statistics" msgstr "" @@ -65516,8 +65830,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id01004\n" -"2\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 "" @@ -65525,8 +65838,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id01005\n" -"26\n" +"par_id1000650\n" "help.text" msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Descriptive Statistics...</emph></variable>" msgstr "" @@ -65534,7 +65846,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533312518\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 "" @@ -65542,7 +65854,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201423333515443\n" +"par_id1000670\n" "help.text" msgid "For more information, please visit the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/Descriptive_statistics\">http://en.wikipedia.org/wiki/Descriptive_statistics</link>" msgstr "" @@ -65550,7 +65862,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533458095\n" +"par_id1000680\n" "help.text" msgid "The following table displays the results of the descriptive statistics of the sample data above." msgstr "" @@ -65558,7 +65870,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533454721\n" +"par_id1000690\n" "help.text" msgid "Column 1" msgstr "" @@ -65566,7 +65878,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533415805\n" +"par_id1000700\n" "help.text" msgid "Column 2" msgstr "" @@ -65574,7 +65886,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533413862\n" +"par_id1000710\n" "help.text" msgid "Column 3" msgstr "" @@ -65582,7 +65894,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533476173\n" +"par_id1000720\n" "help.text" msgid "Mean" msgstr "" @@ -65590,7 +65902,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533480973\n" +"par_id1000760\n" "help.text" msgid "Standard Error" msgstr "" @@ -65598,7 +65910,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533433244\n" +"par_id1000800\n" "help.text" msgid "Mode" msgstr "" @@ -65606,7 +65918,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553341353\n" +"par_id1000840\n" "help.text" msgid "Median" msgstr "" @@ -65614,7 +65926,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533490736\n" +"par_id1000880\n" "help.text" msgid "Variance" msgstr "" @@ -65622,7 +65934,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533495501\n" +"par_id1000920\n" "help.text" msgid "Standard Deviation" msgstr "" @@ -65630,7 +65942,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533498745\n" +"par_id1000960\n" "help.text" msgid "Kurtosis" msgstr "" @@ -65638,7 +65950,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533479359\n" +"par_id1001000\n" "help.text" msgid "Skewness" msgstr "" @@ -65646,7 +65958,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533473279\n" +"par_id1001040\n" "help.text" msgid "Range" msgstr "" @@ -65654,7 +65966,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533467981\n" +"par_id1001080\n" "help.text" msgid "Minimum" msgstr "" @@ -65662,7 +65974,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533456155\n" +"par_id1001120\n" "help.text" msgid "Maximum" msgstr "" @@ -65670,7 +65982,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533452737\n" +"par_id1001160\n" "help.text" msgid "Sum" msgstr "" @@ -65678,7 +65990,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533535276\n" +"par_id1001200\n" "help.text" msgid "Count" msgstr "" @@ -65688,14 +66000,13 @@ msgctxt "" "statistics.xhp\n" "bm_id02001\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;analysis of variance</bookmark_value> <bookmark_value>analysis of variance;Analysis toolpack</bookmark_value> <bookmark_value>Data statistics;analysis of variance</bookmark_value>" +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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id02003\n" -"1\n" +"hd_id1000060\n" "help.text" msgid "Analysis of Variance (ANOVA)" msgstr "" @@ -65703,8 +66014,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id02004\n" -"2\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 "" @@ -65712,8 +66022,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id02005\n" -"26\n" +"par_id1001250\n" "help.text" msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Analysis of Variance (ANOVA)...</emph></variable>" msgstr "" @@ -65721,15 +66030,15 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533512990\n" +"par_id1001260\n" "help.text" -msgid "Analysis of variance (ANOVA) is a collection of statistical models used to analyze the differences between group means and their associated procedures (such as \"variation\" among and between groups). In the ANOVA setting, the observed variance in a particular variable is partitioned into components attributable to different sources of variation. In its simplest form, ANOVA provides a statistical test of whether or not the means of several groups are equal, and therefore generalizes the t-test to more than two groups. As doing multiple two-sample t-tests would result in an increased chance of committing a statistical type I error, ANOVAs are useful in comparing (testing) three or more means (groups or variables) for statistical significance." +msgid "ANOVA is the acronym fir A<emph>N</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. Produces the analysis of variance (ANOVA) of a given data set" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533515443\n" +"par_id1001270\n" "help.text" msgid "For more information, please visit the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/ANOVA\">http://en.wikipedia.org/wiki/ANOVA</link>" msgstr "" @@ -65737,7 +66046,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533538729\n" +"hd_id1000070\n" "help.text" msgid "Type" msgstr "" @@ -65745,7 +66054,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553351190\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 "" @@ -65753,7 +66062,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533538856\n" +"hd_id1000080\n" "help.text" msgid "Parameters" msgstr "" @@ -65761,7 +66070,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533516218\n" +"par_id1001290\n" "help.text" msgid "<emph>Alpha</emph>: the level of significance of the test." msgstr "" @@ -65769,7 +66078,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533592749\n" +"par_id1001300\n" "help.text" msgid "<emph>Rows per sample</emph>: Define how many rows a sample has." msgstr "" @@ -65777,7 +66086,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533543611\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 "" @@ -65785,7 +66094,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533531121\n" +"par_id1001320\n" "help.text" msgid "ANOVA - Single Factor" msgstr "" @@ -65793,7 +66102,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533586267\n" +"par_id1001330\n" "help.text" msgid "Alpha" msgstr "" @@ -65801,7 +66110,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533562036\n" +"par_id1001350\n" "help.text" msgid "Groups" msgstr "" @@ -65809,7 +66118,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533516564\n" +"par_id1001360\n" "help.text" msgid "Count" msgstr "" @@ -65817,7 +66126,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533511954\n" +"par_id1001370\n" "help.text" msgid "Sum" msgstr "" @@ -65825,7 +66134,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533560198\n" +"par_id1001380\n" "help.text" msgid "Mean" msgstr "" @@ -65833,7 +66142,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533547195\n" +"par_id1001390\n" "help.text" msgid "Variance" msgstr "" @@ -65841,7 +66150,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533526297\n" +"par_id1001400\n" "help.text" msgid "Column 1" msgstr "" @@ -65849,7 +66158,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533571610\n" +"par_id1001450\n" "help.text" msgid "Column 2" msgstr "" @@ -65857,7 +66166,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553358382\n" +"par_id1001500\n" "help.text" msgid "Column 3" msgstr "" @@ -65865,7 +66174,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533555826\n" +"par_id1001550\n" "help.text" msgid "Source of Variation" msgstr "" @@ -65873,7 +66182,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533515237\n" +"par_id1001560\n" "help.text" msgid "SS" msgstr "" @@ -65881,7 +66190,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533550319\n" +"par_id1001570\n" "help.text" msgid "df" msgstr "" @@ -65889,7 +66198,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533582581\n" +"par_id1001580\n" "help.text" msgid "MS" msgstr "" @@ -65897,7 +66206,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533546247\n" +"par_id1001590\n" "help.text" msgid "F" msgstr "" @@ -65905,7 +66214,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533553834\n" +"par_id1001600\n" "help.text" msgid "P-value" msgstr "" @@ -65913,7 +66222,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533554659\n" +"par_id1001610\n" "help.text" msgid "Between Groups" msgstr "" @@ -65921,7 +66230,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533560423\n" +"par_id1001670\n" "help.text" msgid "Within Groups" msgstr "" @@ -65929,7 +66238,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533597992\n" +"par_id1001710\n" "help.text" msgid "Total" msgstr "" @@ -65939,14 +66248,13 @@ msgctxt "" "statistics.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>" +msgid "<bookmark_value>Analysis toolpack;correlation</bookmark_value><bookmark_value>correlation;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;correlation</bookmark_value>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id3153032\n" -"1\n" +"hd_id1000090\n" "help.text" msgid "Correlation" msgstr "" @@ -65954,8 +66262,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id3156327\n" -"2\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 "" @@ -65963,8 +66270,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id3152992\n" -"26\n" +"par_id1001750\n" "help.text" msgid "<variable id=\"corr01\">Menu <emph>Data - Statistics - Correlation...</emph></variable>" msgstr "" @@ -65972,7 +66278,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533536318\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 "" @@ -65980,7 +66286,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533586869\n" +"par_id1001770\n" "help.text" msgid "A correlation coefficient of +1 indicates a perfect positive correlation." msgstr "" @@ -65988,7 +66294,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533567951\n" +"par_id1001780\n" "help.text" msgid "A correlation coefficient of -1 indicates a perfect negative correlation" msgstr "" @@ -65996,7 +66302,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533654986\n" +"par_id1001790\n" "help.text" msgid "For more information on statistical correlation, refer to <link href=\"http://en.wikipedia.org/wiki/Correlation\">http://en.wikipedia.org/wiki/Correlation</link>" msgstr "" @@ -66004,7 +66310,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533680006\n" +"par_id1001800\n" "help.text" msgid "The following table displays the results of the correlation of the sample data above." msgstr "" @@ -66012,7 +66318,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533666011\n" +"par_id1001810\n" "help.text" msgid "Correlations" msgstr "" @@ -66020,7 +66326,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533643141\n" +"par_id1001820\n" "help.text" msgid "Column 1" msgstr "" @@ -66028,7 +66334,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533674994\n" +"par_id1001830\n" "help.text" msgid "Column 2" msgstr "" @@ -66036,7 +66342,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533691064\n" +"par_id1001840\n" "help.text" msgid "Column 3" msgstr "" @@ -66044,7 +66350,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533613299\n" +"par_id1001850\n" "help.text" msgid "Column 1" msgstr "" @@ -66052,7 +66358,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533698236\n" +"par_id1001870\n" "help.text" msgid "Column 2" msgstr "" @@ -66060,7 +66366,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533614553\n" +"par_id1001900\n" "help.text" msgid "Column 3" msgstr "" @@ -66070,14 +66376,13 @@ msgctxt "" "statistics.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>" +msgid "<bookmark_value>Analysis toolpack;covariance</bookmark_value><bookmark_value>covariance;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;covariance</bookmark_value>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2953032\n" -"1\n" +"hd_id1000100\n" "help.text" msgid "Covariance" msgstr "" @@ -66085,8 +66390,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2956327\n" -"2\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 "" @@ -66094,8 +66398,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2952992\n" -"26\n" +"par_id1001950\n" "help.text" msgid "<variable id=\"cov01\">Menu <emph>Data - Statistics - Covariance...</emph></variable>" msgstr "" @@ -66103,15 +66406,15 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533662738\n" +"par_id1001960\n" "help.text" -msgid "In probability theory and statistics, covariance is a measure of how much two random variables change together. If the greater values of one variable mainly correspond with the greater values of the other variable, and the same holds for the smaller values, i.e., the variables tend to show similar behavior, the covariance is positive. In the opposite case, when the greater values of one variable mainly correspond to the smaller values of the other, i.e., the variables tend to show opposite behavior, the covariance is negative. The sign of the covariance therefore shows the tendency in the linear relationship between the variables. The magnitude of the covariance is not easy to interpret. The normalized version of the covariance, the correlation coefficient, however, shows by its magnitude the strength of the linear relation." +msgid "The covariance is a measure of how much two random variables change together." msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2009201415533654986\n" +"par_id1001970\n" "help.text" msgid "For more information on statistical covariance, refer to <link href=\"http://en.wikipedia.org/wiki/Covariance\">http://en.wikipedia.org/wiki/Covariance</link>" msgstr "" @@ -66119,7 +66422,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533643866\n" +"par_id1001980\n" "help.text" msgid "The following table displays the results of the covariance of the sample data above." msgstr "" @@ -66127,7 +66430,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533635095\n" +"par_id1001990\n" "help.text" msgid "Covariances" msgstr "" @@ -66135,7 +66438,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533619955\n" +"par_id1002000\n" "help.text" msgid "Column 1" msgstr "" @@ -66143,7 +66446,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533651324\n" +"par_id1002010\n" "help.text" msgid "Column 2" msgstr "" @@ -66151,7 +66454,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533613800\n" +"par_id1002020\n" "help.text" msgid "Column 3" msgstr "" @@ -66159,7 +66462,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533640180\n" +"par_id1002030\n" "help.text" msgid "Column 1" msgstr "" @@ -66167,7 +66470,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553367596\n" +"par_id1002050\n" "help.text" msgid "Column 2" msgstr "" @@ -66175,7 +66478,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553364047\n" +"par_id1002080\n" "help.text" msgid "Column 3" msgstr "" @@ -66185,14 +66488,13 @@ msgctxt "" "statistics.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>" +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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id03003\n" -"1\n" +"hd_id1000110\n" "help.text" msgid "Exponential Smoothing" msgstr "" @@ -66200,8 +66502,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id03004\n" -"2\n" +"par_id1002120\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog\">Results in a smoothed data series</ahelp>" msgstr "" @@ -66209,8 +66510,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id03005\n" -"26\n" +"par_id1002130\n" "help.text" msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Exponential Smoothing...</emph></variable>" msgstr "" @@ -66218,23 +66518,15 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533682260\n" +"par_id1002140\n" "help.text" -msgid "Exponential smoothing is a technique that can be applied to time series data, either to produce smoothed data for presentation, or to make forecasts. The time series data themselves are a sequence of observations. The observed phenomenon may be an essentially random process, or it may be an orderly, but noisy, process. Whereas in the simple moving average the past observations are weighted equally, exponential smoothing assigns exponentially decreasing weights over time." +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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533641726\n" -"help.text" -msgid "Exponential smoothing is commonly applied to financial market and economic data, but it can be used with any discrete set of repeated measurements. The simplest form of exponential smoothing should be used only for data without any systematic trend or seasonal components." -msgstr "" - -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id2008201415533698172\n" +"par_id1002150\n" "help.text" msgid "For more information on <emph>exponential smoothing</emph>, refer to <link href=\"http://en.wikipedia.org/wiki/Exponential_smoothing\">http://en.wikipedia.org/wiki/Exponential_smoothing</link>" msgstr "" @@ -66242,7 +66534,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id200820141553364794\n" +"hd_id1000120\n" "help.text" msgid "Parameters" msgstr "" @@ -66250,7 +66542,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533649086\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 "" @@ -66258,7 +66550,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764911\n" +"par_id1002170\n" "help.text" msgid "The resulting smoothing is below with smoothing factor as 0.5:" msgstr "" @@ -66266,7 +66558,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533725829\n" +"par_id1002180\n" "help.text" msgid "Alpha" msgstr "" @@ -66274,7 +66566,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533712984\n" +"par_id1002200\n" "help.text" msgid "Column 1" msgstr "" @@ -66282,7 +66574,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764774\n" +"par_id1002210\n" "help.text" msgid "Column 2" msgstr "" @@ -66292,14 +66584,13 @@ msgctxt "" "statistics.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>" +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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id04003\n" -"1\n" +"hd_id1000130\n" "help.text" msgid "Moving Average" msgstr "" @@ -66307,8 +66598,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id04004\n" -"2\n" +"par_id1002500\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/movingaveragedialog/MovingAverageDialog\">Calculates the moving average of a time series</ahelp>" msgstr "" @@ -66316,8 +66606,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id04005\n" -"26\n" +"par_id1002510\n" "help.text" msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Moving Average...</emph></variable>" msgstr "" @@ -66325,39 +66614,39 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533748861\n" +"par_id1002520\n" "help.text" -msgid "In statistics, a moving average (rolling average or running average) is a calculation to analyze data points by creating a series of averages of different subsets of the full data set. It is also called a moving mean or rolling mean and is a type of finite impulse response filter." +msgid "You can get more details about moving average in the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/Moving_average\">http://en.wikipedia.org/wiki/Moving_average</link>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533744678\n" +"hd_id1000140\n" "help.text" -msgid "You can get more details about moving average in the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/Moving_average\">http://en.wikipedia.org/wiki/Moving_average</link>" +msgid "Parameters" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533751077\n" +"par_id1002530\n" "help.text" -msgid "Parameters" +msgid "<emph>Interval</emph>: The number of samples used in the moving average calculation." msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533787018\n" +"hd_id1000171\n" "help.text" -msgid "<emph>Interval</emph>: The number of samples used in the moving average calculation." +msgid "Results of the moving average:" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533779483\n" +"par_id1002540\n" "help.text" msgid "Column 1" msgstr "" @@ -66365,7 +66654,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533791711\n" +"par_id1002550\n" "help.text" msgid "Column 2" msgstr "" @@ -66373,7 +66662,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764431\n" +"par_id1002560\n" "help.text" msgid "#N/A" msgstr "" @@ -66381,7 +66670,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533754380\n" +"par_id1002570\n" "help.text" msgid "#N/A" msgstr "" @@ -66389,7 +66678,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533847092\n" +"par_id1002800\n" "help.text" msgid "#N/A" msgstr "" @@ -66397,7 +66686,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533890018\n" +"par_id1002810\n" "help.text" msgid "#N/A" msgstr "" @@ -66407,32 +66696,29 @@ msgctxt "" "statistics.xhp\n" "bm_id05001\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;t-test</bookmark_value> <bookmark_value>t-test;Analysis toolpack</bookmark_value> <bookmark_value>Data statistics;t-test</bookmark_value> <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 "<bookmark_value>Analysis toolpack;t-test</bookmark_value><bookmark_value>t-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;t-test</bookmark_value>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id05003\n" -"1\n" +"hd_id1000150\n" "help.text" -msgid "t-test and F-test" +msgid "t-test" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id05004\n" -"2\n" +"par_id1002820\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the t-Test or the F-Test of two data samples.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the t-Test of two data samples.</ahelp>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id05005\n" -"26\n" +"par_id1002830\n" "help.text" msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - t-test...</emph></variable>" msgstr "" @@ -66440,40 +66726,247 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id050051\n" -"26\n" +"par_id1002840\n" "help.text" -msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - F-test...</emph></variable>" +msgid "A <emph>t-test</emph> is any statistical hypothesis test that follows a Student's t distribution." msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533888599\n" +"par_id1002850\n" "help.text" -msgid "A <emph>t-test</emph> is any statistical hypothesis test in which the test statistic follows a Student's t distribution if the null hypothesis is supported. It can be used to determine if two sets of data are significantly different from each other, and is most commonly applied when the test statistic would follow a normal distribution if the value of a scaling term in the test statistic were known. When the scaling term is unknown and is replaced by an estimate based on the data, the test statistic (under certain conditions) follows a Student's t distribution." +msgid "For more information on t-tests, see the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/T-test\">http://en.wikipedia.org/wiki/T-test</link>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533819476\n" +"hd_id1000160\n" "help.text" -msgid "A <emph>F-test</emph> is any statistical test in which the test statistic has an F-distribution under the null hypothesis. It is most often used when comparing statistical models that have been fitted to a data set, in order to identify the model that best fits the population from which the data were sampled. Exact \"F-tests\" mainly arise when the models have been fitted to the data using least squares." +msgid "Data" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533844122\n" +"par_id1002860\n" "help.text" -msgid "For more information on t-tests, see the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/T-test\">http://en.wikipedia.org/wiki/T-test</link>" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002870\n" +"help.text" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002880\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000170\n" +"help.text" +msgid "Results for t-Test:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002890\n" +"help.text" +msgid "The following table shows the <emph>t-Test</emph> for the data series above:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002900\n" +"help.text" +msgid "t-test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002910\n" +"help.text" +msgid "Alpha" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002930\n" +"help.text" +msgid "Hypothesized Mean Difference" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002950\n" +"help.text" +msgid "Variable 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002960\n" +"help.text" +msgid "Variable 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002970\n" +"help.text" +msgid "Mean" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003000\n" +"help.text" +msgid "Variance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003030\n" +"help.text" +msgid "Observations" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533423222\n" +"par_id1003060\n" +"help.text" +msgid "Pearson Correlation" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003080\n" +"help.text" +msgid "Observed Mean Difference" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003100\n" +"help.text" +msgid "Variance of the Differences" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003120\n" +"help.text" +msgid "df" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003140\n" +"help.text" +msgid "t Stat" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003160\n" +"help.text" +msgid "P (T<=t) one-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003180\n" +"help.text" +msgid "t Critical one-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003200\n" +"help.text" +msgid "P (T<=t) two-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003220\n" +"help.text" +msgid "t Critical two-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"bm_id05002\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>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000180\n" +"help.text" +msgid "F-test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003240\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the F-Test of two data samples.</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003250\n" +"help.text" +msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - F-test...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003260\n" +"help.text" +msgid "A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003270\n" "help.text" msgid "For more information on F-tests, see the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/F-test\">http://en.wikipedia.org/wiki/F-test</link>" msgstr "" @@ -66481,7 +66974,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533817070\n" +"hd_id1000190\n" "help.text" msgid "Data" msgstr "" @@ -66489,7 +66982,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533823950\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 "" @@ -66497,7 +66990,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533822766\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 "" @@ -66505,7 +66998,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533879965\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 "" @@ -66513,31 +67006,31 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533956416\n" +"hd_id1000200\n" "help.text" -msgid "Example for t-Test:" +msgid "Results for F-Test:" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553388982\n" +"par_id1003310\n" "help.text" -msgid "The following table shows the <emph>t-Test</emph> for the data series above:" +msgid "The following table shows the <emph>F-Test</emph> for the data series above:" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533892337\n" +"par_id1003320\n" "help.text" -msgid "t-test" +msgid "Ftest" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533864455\n" +"par_id1003330\n" "help.text" msgid "Alpha" msgstr "" @@ -66545,7 +67038,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533863306\n" +"par_id1003350\n" "help.text" msgid "Variable 1" msgstr "" @@ -66553,7 +67046,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533818481\n" +"par_id1003360\n" "help.text" msgid "Variable 2" msgstr "" @@ -66561,7 +67054,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533858438\n" +"par_id1003370\n" "help.text" msgid "Mean" msgstr "" @@ -66569,7 +67062,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533897974\n" +"par_id1003400\n" "help.text" msgid "Variance" msgstr "" @@ -66577,7 +67070,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533868040\n" +"par_id1003430\n" "help.text" msgid "Observations" msgstr "" @@ -66585,119 +67078,167 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533825806\n" +"par_id1003460\n" "help.text" -msgid "Pearson Correlation" +msgid "df" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533840871\n" +"par_id1003490\n" "help.text" -msgid "Hypothesized Mean Difference" +msgid "F" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533859489\n" +"par_id1003510\n" "help.text" -msgid "Observed Mean Difference" +msgid "P (F<=f) right-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533826221\n" +"par_id1003530\n" "help.text" -msgid "Variance of the Differences" +msgid "F Critical right-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533860284\n" +"par_id1003550\n" "help.text" -msgid "df" +msgid "P (F<=f) left-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533871121\n" +"par_id1003570\n" "help.text" -msgid "t Stat" +msgid "F Critical left-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533822174\n" +"par_id1003590\n" "help.text" -msgid "P (T<=t) one-tail" +msgid "P two-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533811741\n" +"par_id1003610\n" "help.text" -msgid "t Critical one-tail" +msgid "F Critical two-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533829667\n" +"bm_id05003\n" "help.text" -msgid "P (T<=t) two-tail" +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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533865577\n" +"hd_id1000210\n" "help.text" -msgid "5.91750215348761E-010" +msgid "Z-test" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533931877\n" +"par_id1003640\n" "help.text" -msgid "t Critical two-tail" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the z-Test of two data samples.</ahelp>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533942416\n" +"par_id1003650\n" "help.text" -msgid "Example for F-Test:" +msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - Z-test...</emph></variable>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533978190\n" +"par_id1003660\n" "help.text" -msgid "The following table shows the <emph>F</emph><emph>-Test</emph> for the data series above:" +msgid "For more information on Z-tests, see the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/Z-test\">http://en.wikipedia.org/wiki/Z-test</link>" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533950785\n" +"hd_id1000220\n" "help.text" -msgid "F-test" +msgid "Data" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003670\n" +"help.text" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003680\n" +"help.text" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003690\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 "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533911319\n" +"hd_id1000230\n" +"help.text" +msgid "Results for z-Test:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003700\n" +"help.text" +msgid "The following table shows the <emph>z-Test</emph> for the data series above:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003710\n" +"help.text" +msgid "z-test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003720\n" "help.text" msgid "Alpha" msgstr "" @@ -66705,7 +67246,15 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533999353\n" +"par_id1003740\n" +"help.text" +msgid "Hypothesized Mean Difference" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003760\n" "help.text" msgid "Variable 1" msgstr "" @@ -66713,7 +67262,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533926248\n" +"par_id1003770\n" "help.text" msgid "Variable 2" msgstr "" @@ -66721,23 +67270,23 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533918157\n" +"par_id1003780\n" "help.text" -msgid "Mean" +msgid "Known Variance" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553392922\n" +"par_id1003810\n" "help.text" -msgid "Variance" +msgid "Mean" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533924413\n" +"par_id1003840\n" "help.text" msgid "Observations" msgstr "" @@ -66745,65 +67294,193 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533948860\n" +"par_id1003870\n" "help.text" -msgid "df" +msgid "Observed Mean Difference" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533928162\n" +"par_id1003890\n" "help.text" -msgid "F" +msgid "z" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533996864\n" +"par_id1003900\n" "help.text" -msgid "P (F<=f) right-tail" +msgid "#DIV/0!" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533921377\n" +"par_id1003910\n" "help.text" -msgid "F Critical right-tail" +msgid "P (Z<=z) one-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533960592\n" +"par_id1003920\n" "help.text" -msgid "P (F<=f) left-tail" +msgid "#DIV/0!" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533922655\n" +"par_id1003930\n" "help.text" -msgid "F Critical left-tail" +msgid "z Critical one-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533918990\n" +"par_id1003950\n" "help.text" -msgid "P two-tail" +msgid "P (Z<=z) two-tail" msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533940157\n" +"par_id1003960\n" "help.text" -msgid "F Critical two-tail" +msgid "#DIV/0!" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003970\n" +"help.text" +msgid "z Critical two-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"bm_id05004\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>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000240\n" +"help.text" +msgid "Chi-square test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003641\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog\">Calculates the Chi-square test of a data sample.</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003990\n" +"help.text" +msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - Chi-square Test...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004000\n" +"help.text" +msgid "For more information on Chi-square tests, see the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/Chi-square_test\">http://en.wikipedia.org/wiki/Chi-square_test</link>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000250\n" +"help.text" +msgid "Data" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004010\n" +"help.text" +msgid "<emph>Input range</emph>: The reference of the range of the data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004020\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000231\n" +"help.text" +msgid "Results for Chi-square Test:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004030\n" +"help.text" +msgid "Test of Independence (Chi-Square)" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004040\n" +"help.text" +msgid "Alpha" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004060\n" +"help.text" +msgid "df" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004080\n" +"help.text" +msgid "P-value" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004100\n" +"help.text" +msgid "Test Statistic" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004120\n" +"help.text" +msgid "Critical Value" msgstr "" #: text2columns.xhp diff --git a/source/zh-TW/helpcontent2/source/text/scalc/04.po b/source/zh-TW/helpcontent2/source/text/scalc/04.po index 7b6ae332357..854258d775c 100644 --- a/source/zh-TW/helpcontent2/source/text/scalc/04.po +++ b/source/zh-TW/helpcontent2/source/text/scalc/04.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: 2013-11-20 13:02+0100\n" +"POT-Creation-Date: 2015-04-22 23:39+0200\n" "PO-Revision-Date: 2012-07-04 19:03+0200\n" "Last-Translator: Cheng-Chia <pswo10680@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -379,8 +379,8 @@ msgctxt "" "par_id3149725\n" "131\n" "help.text" -msgid "In the page preview: Moves to the previous print page." -msgstr "在頁面預覽中：移至上一個列印頁。" +msgid "In the print preview: Moves to the previous print page." +msgstr "" #: 01020000.xhp msgctxt "" @@ -406,8 +406,8 @@ msgctxt "" "par_id3159120\n" "132\n" "help.text" -msgid "In the page preview: Moves to the next print page." -msgstr "在頁面預覽中：移至下一個列印頁。" +msgid "In the print preview: Moves to the next print page." +msgstr "" #: 01020000.xhp msgctxt "" diff --git a/source/zh-TW/helpcontent2/source/text/scalc/05.po b/source/zh-TW/helpcontent2/source/text/scalc/05.po index 2fb322010b4..760ec7806af 100644 --- a/source/zh-TW/helpcontent2/source/text/scalc/05.po +++ b/source/zh-TW/helpcontent2/source/text/scalc/05.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: 2014-05-02 00:11+0200\n" +"POT-Creation-Date: 2015-04-22 23:39+0200\n" "PO-Revision-Date: 2012-08-13 09:33+0000\n" "Last-Translator: Cheng-Chia <pswo10680@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -772,6 +772,247 @@ msgctxt "" msgid "Division operator / if the denominator is 0<br/>Some more functions return this error, for example:<br/>VARP with less than 1 argument<br/>STDEVP with less than 1 argument<br/>VAR with less than 2 arguments<br/>STDEV with less than 2 arguments<br/>STANDARDIZE with stdev=0<br/>NORMDIST with stdev=0" msgstr "除法運算子 / 如果分母為 0<br/>有更多函數傳回此錯誤，例如：<br/>不含引數的 VARP<br/>不含引數的 STDEVP<br/>包含引數少於 2 個的 VAR<br/>包含引數少於 2 個的 STDEV<br/>stdev=0 時的 STANDARDIZE<br/>stdev=0 時的 NORMDIST" +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"tit\n" +"help.text" +msgid "OpenCL Options" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"bm_id3146799\n" +"help.text" +msgid "<bookmark_value>OpenCl;options</bookmark_value>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"hd_id1502121\n" +"help.text" +msgid "<variable id=\"empty_cells\"><link href=\"text/scalc/05/OpenCL_options.xhp\">OpenCL Options</link></variable>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id5293740\n" +"help.text" +msgid "This page is under construction" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id2733542\n" +"help.text" +msgid "OpenCL: the open standard for parallel programming of heterogeneous systems." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id2752992\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Tools - Options - LibreOffice Calc - Formula</emph>, and in section <emph>Detailed Calculation Settings</emph> press <emph>Details...</emph> button</variable>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id8266853\n" +"help.text" +msgid "OpenCL™ is the first open, royalty-free standard for cross-platform, parallel programming of modern processors found in personal computers, servers and handheld/embedded devices. OpenCL (Open Computing Language) greatly improves speed and responsiveness for a wide spectrum of applications in numerous market categories from gaming and entertainment to scientific and medical software" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id5293741\n" +"help.text" +msgid "for more information on OpenCL, visit <link href=\"http://www.khronos.org/opencl/\">the OpenCL site</link>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id4238715\n" +"help.text" +msgid "Contents to Numbers" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id8277230\n" +"help.text" +msgid "Conversion from text to number" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id396740\n" +"help.text" +msgid "How to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Unambiguous conversion is possible for integer numbers including exponents and ISO 8601 dates and times in their extended formats with separators. Fractional numeric values with decimal separators or dates other than ISO 8601 are locale dependent. Note that in locale dependent conversions the resulting numeric value may differ between locales!" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id4086428\n" +"help.text" +msgid "<emph>Generate #VALUE! error:</emph> Text found where numeric data is expected will generate #VALUE! error. Example: <item type=\"input\">\"123.45\"</item> will generate a #VALUE! error, while <item type=\"input\">123.45</item> not." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id9024628\n" +"help.text" +msgid "<emph>Treat as zero:</emph> Any text found where numeric data is expected will be considered as a number of value zero. Example: <item type=\"input\">\"123.45\"</item> will map to zero, while <item type=\"input\">123.45</item> not." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id3067110\n" +"help.text" +msgid "<emph>Convert only if unambiguous:</emph> If the text represents a valid and unambiguous numeric value, convert it. Example: <item type=\"input\">\"+55.21.9.8822.8813\"</item> will map to zero, because the numbers don't represent a numeric value." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id8841822\n" +"help.text" +msgid "<emph>Convert also locale dependent:</emph> convert values valid in the locale representation. Example: <item type=\"input\">\"123,45\"</item> is a valid number in some locales because the comma is the decimal separator there." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id4077578\n" +"help.text" +msgid "Treat empty string as zero" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id9094515\n" +"help.text" +msgid "This option determines how an empty string is treated when used in arithmetic operations. If you have set \"Conversion from text to number\" to either \"Generate #VALUE! error\" or \"Treat as zero\", you cannot choose (here) if conversion of an empty string to a number will generate an error or if it will treat empty strings as zero. Otherwise this option determines how empty strings are treated." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id3859675\n" +"help.text" +msgid "Reference syntax for string reference" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id402233\n" +"help.text" +msgid "Formula syntax to use when parsing references given in string parameters. This affects built-in functions such as INDIRECT that takes a reference as a string value." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id1623889\n" +"help.text" +msgid "<emph>Use formula syntax:</emph>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id7781914\n" +"help.text" +msgid "<emph>Calc A1:</emph>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id300912\n" +"help.text" +msgid "<emph>Excel A1:</emph>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id9534592\n" +"help.text" +msgid "<emph>Excel R1C1:</emph>" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id4969328\n" +"help.text" +msgid "OpenCL Settings" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id9635914\n" +"help.text" +msgid "Use Open_CL only for a subset of operations" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id2476577\n" +"help.text" +msgid "Use OpenCL only for some of the operations that spreadsheet formulas are translated to." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id4217047\n" +"help.text" +msgid "Minimum data size for OpenCL use:" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id2629474\n" +"help.text" +msgid "An approximate lower limit on the number of data cells a spreadsheet formula should use for OpenCL to be considered." +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id8069704\n" +"help.text" +msgid "Subset of OpCodes for which OpenCL is used" +msgstr "" + +#: OpenCL_options.xhp +msgctxt "" +"OpenCL_options.xhp\n" +"par_id4524674\n" +"help.text" +msgid "The list of operators and function opcodes for which to use OpenCL. If a formula contains only these operators and functions, it might be calculated using OpenCL." +msgstr "" + #: empty_cells.xhp msgctxt "" "empty_cells.xhp\n" diff --git a/source/zh-TW/helpcontent2/source/text/scalc/guide.po b/source/zh-TW/helpcontent2/source/text/scalc/guide.po index 7e359427621..46812e5818d 100644 --- a/source/zh-TW/helpcontent2/source/text/scalc/guide.po +++ b/source/zh-TW/helpcontent2/source/text/scalc/guide.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: 2014-05-30 13:09+0200\n" +"POT-Creation-Date: 2015-04-22 23:39+0200\n" "PO-Revision-Date: 2013-05-27 15:01+0000\n" "Last-Translator: Andras <timar74@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -5369,16 +5369,16 @@ msgctxt "" "finding.xhp\n" "par_id9121982\n" "help.text" -msgid "Either click <emph>Find</emph> or <emph>Find All</emph>." -msgstr "按一下 <emph>[搜尋]</emph> 或 <emph>[搜尋全部]</emph>。" +msgid "Either click <emph>Find Next</emph> or <emph>Find All</emph>." +msgstr "" #: finding.xhp msgctxt "" "finding.xhp\n" "par_id3808404\n" "help.text" -msgid "When you click <emph>Find</emph>, Calc will select the next cell that contains your text. You can watch and edit the text, then click <emph>Find</emph> again to advance to the next found cell." -msgstr "按一下 <emph>[搜尋]</emph> 時，Calc 會選取包含該文字的下一個儲存格。您可以檢視並編輯文字，然後再按一下 <emph>[搜尋]</emph> 以前進到下一個找到的儲存格。" +msgid "When you click <emph>Find Next</emph>, Calc will select the next cell that contains your text. You can watch and edit the text, then click <emph>Find Next</emph> again to advance to the next found cell." +msgstr "" #: finding.xhp msgctxt "" @@ -5549,7 +5549,7 @@ msgctxt "" "par_id3145389\n" "22\n" "help.text" -msgid "An image that you have loaded with <item type=\"menuitem\">Format - Page - Background</item> is only visible in print or in the page preview. To display a background image on screen as well, insert the graphic image by choosing <item type=\"menuitem\">Insert - Image - From File</item> and arrange the image behind the cells by choosing <item type=\"menuitem\">Format - Arrange - To Background</item>. Use the <link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link> to select the background image." +msgid "An image that you have loaded with <item type=\"menuitem\">Format - Page - Background</item> is only visible in print or in the print preview. To display a background image on screen as well, insert the graphic image by choosing <item type=\"menuitem\">Insert - Image - From File</item> and arrange the image behind the cells by choosing <item type=\"menuitem\">Format - Arrange - To Background</item>. Use the <link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link> to select the background image." msgstr "" #: format_table.xhp @@ -7287,8 +7287,8 @@ msgctxt "" "hd_id3153070\n" "7\n" "help.text" -msgid "Printing and Page Preview" -msgstr "列印和頁面預覽" +msgid "Printing and Print Preview" +msgstr "" #: main.xhp msgctxt "" @@ -9284,8 +9284,8 @@ msgctxt "" "printranges.xhp\n" "par_idN108D7\n" "help.text" -msgid "<variable id=\"printranges\"><link href=\"text/scalc/guide/printranges.xhp\">Defining Print Ranges on a Sheet</link> </variable>" -msgstr "<variable id=\"printranges\"><link href=\"text/scalc/guide/printranges.xhp\">定義工作表的列印範圍</link> </variable>" +msgid "<variable id=\"printranges\"><link href=\"text/scalc/guide/printranges.xhp\">Defining Print Ranges on a Sheet</link></variable>" +msgstr "" #: printranges.xhp msgctxt "" @@ -9372,8 +9372,8 @@ msgctxt "" "printranges.xhp\n" "par_idN10929\n" "help.text" -msgid "Choose <emph>Format - Print Ranges - Remove</emph>." -msgstr "選擇 <emph>「格式」 - 「列印範圍」 - 「移除」</emph>。" +msgid "Choose <emph>Format - Print Ranges - Clear</emph>." +msgstr "" #: printranges.xhp msgctxt "" |