diff options
Diffstat (limited to 'source/bs/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/bs/helpcontent2/source/text/scalc/01.po | 2143 |
1 files changed, 1410 insertions, 733 deletions
diff --git a/source/bs/helpcontent2/source/text/scalc/01.po b/source/bs/helpcontent2/source/text/scalc/01.po index e33a6d18d19..c5b04ab97cc 100644 --- a/source/bs/helpcontent2/source/text/scalc/01.po +++ b/source/bs/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: 2014-01-27 23:57+0000\n" "Last-Translator: megaribi <samir.ribic@etf.unsa.ba>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -21,16 +21,16 @@ msgctxt "" "01120000.xhp\n" "tit\n" "help.text" -msgid "Page Preview" -msgstr "Pregled Stranice" +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/02140400.xhp\" name=\"Left\">Lijevo</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 "Koristite ikone na <emph>Traci za pregled stranice</emph> da pregledate stranice dokumenta ili da odštampate dokument." +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 "Ne možete mijenjati vaš dokument dok ste u Pregledu stranice." +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\">Da izadete iz Pregleda stranice, kliknite <emph>Zatvori pregled</emph> dugme.</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\">Ova kategorija sadrži <emph>Informacije</emph> funkcije. </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> gdje ćelija C9 sadrži <item #: 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 "<item type=\"input\">=ISFORMULA(C4)</item> returns <emph>FALSE</emph> if #: 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> returns <emph>FALSE</emph>." #: 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 "<item type=\"input\">=ISTEXT(C3)</item> returns <emph>FALSE</emph> if ce #: 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>" @@ -11852,77 +12220,6 @@ msgstr "<item type=\"input\">=ODD(0)</item> vraca 1." #: 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 funkcija</bookmark_value><bookmark_value>brojanje;prazne ćelije</bookmark_value><bookmark_value>prazne ćelije;brojanje</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 "" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3145144\n" -"44\n" -"help.text" -msgid "Syntax" -msgstr "Sintaksa" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3153931\n" -"45\n" -"help.text" -msgid "COUNTBLANK(Range)" -msgstr "" - -#: 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 "vraca broj praznih celija u dometu celija <emph>Opseg</emph>." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3146139\n" -"47\n" -"help.text" -msgid "Example" -msgstr "Primjer" - -#: 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 "<item type=\"input\">=COUNTBLANK(A1:B2)</item> returns 4 if cells A1, A2, B1 and B2 are all empty." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" "bm_id3153114\n" "help.text" msgid "<bookmark_value>ACOS function</bookmark_value>" @@ -13769,220 +14066,6 @@ msgstr "<item type=\"input\">=ODD(1.2)</item> vraca 3." #: 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 funkcija</bookmark_value><bookmark_value>parni cijeli brojevi</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 "" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3146928\n" -"247\n" -"help.text" -msgid "Syntax" -msgstr "Sintaksa" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151203\n" -"248\n" -"help.text" -msgid "ISEVEN(Value)" -msgstr "" - -#: 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>Vrijednost</emph> je sadrzaj koji se testira." - -#: 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 "" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3154136\n" -"250\n" -"help.text" -msgid "Example" -msgstr "Primjer" - -#: 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\">=ISREF(4)</item> returns <emph>FALSE</emph>." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8378856\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(33)</item> returns FALSE" -msgstr "<item type=\"input\">=ISREF(4)</item> returns <emph>FALSE</emph>." - -#: 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_ADD(5)</item> vraća 0." - -#: 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\">=SIGN(-4.5)</item> vraca -1." - -#: 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\">=ISREF(4)</item> returns <emph>FALSE</emph>." - -#: 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 funkcija</bookmark_value><bookmark_value>neparni cijeli brojevi</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 "" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3151006\n" -"257\n" -"help.text" -msgid "Syntax" -msgstr "Sintaksa" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151375\n" -"258\n" -"help.text" -msgid "ISODD(value)" -msgstr "" - -#: 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>Vrijednost</emph> je sadrzaj koji se testira." - -#: 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 "" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3163723\n" -"260\n" -"help.text" -msgid "Example" -msgstr "Primjer" - -#: 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\">=ODD(1)</item> vraca 1." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id9392986\n" -"help.text" -msgid "<item type=\"input\">=ISODD(48)</item> returns FALSE" -msgstr "<item type=\"input\">=ISREF(4)</item> returns <emph>FALSE</emph>." - -#: 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\">=ODD(1.2)</item> vraca 3." - -#: 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\">=ODD(-3.1)</item>vraca -5." - -#: 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>" @@ -17949,134 +18032,6 @@ msgctxt "" msgid "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." msgstr "<item type=\"input\">=RAND()</item> vraca nasumicni broj u rangu od0.0 do 1.0." -#: 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 funkcija</bookmark_value><bookmark_value>brojanje;određene celije</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\">Vraca broj celija koje zadovaoljavaju odredjeni uslov unutar celijskog ranga.</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3164953\n" -"549\n" -"help.text" -msgid "Syntax" -msgstr "Sintaksa" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3164967\n" -"550\n" -"help.text" -msgid "COUNTIF(Range; Criteria)" -msgstr "COUNTIF(Rang; Kriterija)" - -#: 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 "" - -#: 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>Kriteriji</emph>indicira kriteriju u formi broja, izraz ili karakterni znak. Ovi kriteriji odredjuju koje su celije prebrojavane. Mozete takodjer unijeti i trazeni tekst u formi regularnog izraza, npr: \"b.*\" za sve rijeci koje pocinju sa b. MOzete takodje i oznaciti celijski rang koji sadrzi trazeni kriterij. Ako trazite literalni tekst, zatvorite tekst u duple navodnike." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3165037\n" -"553\n" -"help.text" -msgid "Example" -msgstr "Primjer" - -#: 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 je celijski rang koji sadrzi brojeve <item type=\"input\">2000</item> to <item type=\"input\">2009</item>. Celija B1 Sadrzi broj <item type=\"input\">2006</item>. U celiju B2 mozete unijeti formulu:" - -#: 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> - vraca 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> - vraca 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> - vraca 3" - -#: 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> - kada B1 sadrzi <item type=\"input\">2006</item>, ovo vraca 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> gdje celija C2 sadrzi tekst<item type=\"input\">>2006</item> zbraja brojeve celija u rangu A1:A10 koji su > 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 "Z zbrajanje samo negativnih brojeva: <item type=\"input\">=COUNTIF(A1:A10; \"<0\")</item>" - #: 04060107.xhp msgctxt "" "04060107.xhp\n" @@ -25645,18 +25600,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 @@ -25796,9 +25781,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 @@ -26054,18 +26062,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(\"中国\";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(\"office\";2;2)</item> returns ff." +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 @@ -26481,18 +26567,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 @@ -30895,7 +31011,7 @@ msgctxt "" "par_id2963824\n" "138\n" "help.text" -msgid "ERF(LowerLimit; UpperLimit)" +msgid "ERF.PRECISE(LowerLimit; UpperLimit)" msgstr "" #: 04060115.xhp @@ -39587,6 +39703,191 @@ msgstr "" #: 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>" @@ -40200,7 +40501,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 @@ -41224,7 +41525,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 @@ -41233,7 +41534,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 @@ -41635,7 +41936,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 @@ -48313,7 +48614,7 @@ msgctxt "" "hd_id2855071\n" "2\n" "help.text" -msgid "RANK.AVG" +msgid "RANK.EQ" msgstr "" #: 04060185.xhp @@ -49713,7 +50014,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 @@ -49731,7 +50032,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 @@ -49758,7 +50059,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 @@ -52160,7 +52461,7 @@ 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>" +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 @@ -52178,7 +52479,7 @@ 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." +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 @@ -52196,7 +52497,7 @@ 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." +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 @@ -52205,8 +52506,8 @@ msgctxt "" "hd_id3153728\n" "9\n" "help.text" -msgid "Assigned to" -msgstr "Dodijeljen" +msgid "Range or formula expression" +msgstr "" #: 04070100.xhp msgctxt "" @@ -52223,35 +52524,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." +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 "Opširnije" +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>" +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 "Vrsta područja" +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 "" @@ -65256,7 +65566,15 @@ msgstr "Kliknite OK da prihvatite promjene i da se vratite na <link href=\"text/ #: 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 "" @@ -65264,7 +65582,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 "" @@ -65272,7 +65590,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 "" @@ -65280,7 +65598,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533630182\n" +"hd_id1000020\n" "help.text" msgid "Grouped By" msgstr "" @@ -65288,7 +65606,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 "" @@ -65296,7 +65614,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533366360\n" +"hd_id1000030\n" "help.text" msgid "Example" msgstr "" @@ -65304,7 +65622,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 "" @@ -65312,7 +65630,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id200820141553335121\n" +"par_id1000090\n" "help.text" msgid "Maths" msgstr "" @@ -65320,7 +65638,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533379519\n" +"par_id1000100\n" "help.text" msgid "Physics" msgstr "" @@ -65328,7 +65646,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id200820141553333644\n" +"par_id1000110\n" "help.text" msgid "Biology" msgstr "" @@ -65336,7 +65654,7 @@ msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533624784\n" +"hd_id1000040\n" "help.text" msgid "Example" msgstr "" @@ -65344,7 +65662,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 "" @@ -65352,17 +65670,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 @@ -65376,8 +65694,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id1\n" -"1\n" +"hd_id1000010\n" "help.text" msgid "Data Statistics in Calc" msgstr "" @@ -65385,7 +65702,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 "" @@ -65393,9 +65710,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 @@ -65403,13 +65720,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 "" @@ -65417,8 +65734,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 "" @@ -65426,8 +65742,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 "" @@ -65435,7 +65750,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 "" @@ -65443,7 +65758,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 "" @@ -65451,7 +65766,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533154722\n" +"hd_id1000030\n" "help.text" msgid "Sampling Method" msgstr "" @@ -65459,7 +65774,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 "" @@ -65467,7 +65782,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 "" @@ -65475,7 +65790,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 "" @@ -65483,7 +65798,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 "" @@ -65491,7 +65806,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533195750\n" +"hd_id1000040\n" "help.text" msgid "Example" msgstr "" @@ -65499,7 +65814,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 "" @@ -65507,7 +65822,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 "" @@ -65517,14 +65832,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 "" @@ -65532,8 +65846,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 "" @@ -65541,8 +65854,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 "" @@ -65550,7 +65862,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 "" @@ -65558,7 +65870,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 "" @@ -65566,7 +65878,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 "" @@ -65574,7 +65886,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533454721\n" +"par_id1000690\n" "help.text" msgid "Column 1" msgstr "" @@ -65582,7 +65894,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533415805\n" +"par_id1000700\n" "help.text" msgid "Column 2" msgstr "" @@ -65590,7 +65902,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533413862\n" +"par_id1000710\n" "help.text" msgid "Column 3" msgstr "" @@ -65598,7 +65910,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533476173\n" +"par_id1000720\n" "help.text" msgid "Mean" msgstr "" @@ -65606,7 +65918,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533480973\n" +"par_id1000760\n" "help.text" msgid "Standard Error" msgstr "" @@ -65614,7 +65926,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533433244\n" +"par_id1000800\n" "help.text" msgid "Mode" msgstr "" @@ -65622,7 +65934,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553341353\n" +"par_id1000840\n" "help.text" msgid "Median" msgstr "" @@ -65630,7 +65942,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533490736\n" +"par_id1000880\n" "help.text" msgid "Variance" msgstr "" @@ -65638,7 +65950,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533495501\n" +"par_id1000920\n" "help.text" msgid "Standard Deviation" msgstr "" @@ -65646,7 +65958,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533498745\n" +"par_id1000960\n" "help.text" msgid "Kurtosis" msgstr "" @@ -65654,7 +65966,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533479359\n" +"par_id1001000\n" "help.text" msgid "Skewness" msgstr "" @@ -65662,7 +65974,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533473279\n" +"par_id1001040\n" "help.text" msgid "Range" msgstr "" @@ -65670,7 +65982,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533467981\n" +"par_id1001080\n" "help.text" msgid "Minimum" msgstr "" @@ -65678,7 +65990,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533456155\n" +"par_id1001120\n" "help.text" msgid "Maximum" msgstr "" @@ -65686,7 +65998,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533452737\n" +"par_id1001160\n" "help.text" msgid "Sum" msgstr "" @@ -65694,7 +66006,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533535276\n" +"par_id1001200\n" "help.text" msgid "Count" msgstr "" @@ -65704,14 +66016,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 "" @@ -65719,8 +66030,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 "" @@ -65728,8 +66038,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 "" @@ -65737,15 +66046,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 "" @@ -65753,7 +66062,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533538729\n" +"hd_id1000070\n" "help.text" msgid "Type" msgstr "" @@ -65761,7 +66070,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 "" @@ -65769,7 +66078,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533538856\n" +"hd_id1000080\n" "help.text" msgid "Parameters" msgstr "" @@ -65777,7 +66086,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 "" @@ -65785,7 +66094,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 "" @@ -65793,7 +66102,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 "" @@ -65801,7 +66110,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533531121\n" +"par_id1001320\n" "help.text" msgid "ANOVA - Single Factor" msgstr "" @@ -65809,7 +66118,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533586267\n" +"par_id1001330\n" "help.text" msgid "Alpha" msgstr "" @@ -65817,7 +66126,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533562036\n" +"par_id1001350\n" "help.text" msgid "Groups" msgstr "" @@ -65825,7 +66134,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533516564\n" +"par_id1001360\n" "help.text" msgid "Count" msgstr "" @@ -65833,7 +66142,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533511954\n" +"par_id1001370\n" "help.text" msgid "Sum" msgstr "" @@ -65841,7 +66150,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533560198\n" +"par_id1001380\n" "help.text" msgid "Mean" msgstr "" @@ -65849,7 +66158,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533547195\n" +"par_id1001390\n" "help.text" msgid "Variance" msgstr "" @@ -65857,7 +66166,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533526297\n" +"par_id1001400\n" "help.text" msgid "Column 1" msgstr "" @@ -65865,7 +66174,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533571610\n" +"par_id1001450\n" "help.text" msgid "Column 2" msgstr "" @@ -65873,7 +66182,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553358382\n" +"par_id1001500\n" "help.text" msgid "Column 3" msgstr "" @@ -65881,7 +66190,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533555826\n" +"par_id1001550\n" "help.text" msgid "Source of Variation" msgstr "" @@ -65889,7 +66198,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533515237\n" +"par_id1001560\n" "help.text" msgid "SS" msgstr "" @@ -65897,7 +66206,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533550319\n" +"par_id1001570\n" "help.text" msgid "df" msgstr "" @@ -65905,7 +66214,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533582581\n" +"par_id1001580\n" "help.text" msgid "MS" msgstr "" @@ -65913,7 +66222,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533546247\n" +"par_id1001590\n" "help.text" msgid "F" msgstr "" @@ -65921,7 +66230,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533553834\n" +"par_id1001600\n" "help.text" msgid "P-value" msgstr "" @@ -65929,7 +66238,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533554659\n" +"par_id1001610\n" "help.text" msgid "Between Groups" msgstr "" @@ -65937,7 +66246,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533560423\n" +"par_id1001670\n" "help.text" msgid "Within Groups" msgstr "" @@ -65945,7 +66254,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533597992\n" +"par_id1001710\n" "help.text" msgid "Total" msgstr "" @@ -65955,14 +66264,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 "" @@ -65970,8 +66278,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 "" @@ -65979,8 +66286,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 "" @@ -65988,7 +66294,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 "" @@ -65996,7 +66302,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 "" @@ -66004,7 +66310,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 "" @@ -66012,7 +66318,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 "" @@ -66020,7 +66326,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 "" @@ -66028,7 +66334,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533666011\n" +"par_id1001810\n" "help.text" msgid "Correlations" msgstr "" @@ -66036,7 +66342,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533643141\n" +"par_id1001820\n" "help.text" msgid "Column 1" msgstr "" @@ -66044,7 +66350,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533674994\n" +"par_id1001830\n" "help.text" msgid "Column 2" msgstr "" @@ -66052,7 +66358,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533691064\n" +"par_id1001840\n" "help.text" msgid "Column 3" msgstr "" @@ -66060,7 +66366,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533613299\n" +"par_id1001850\n" "help.text" msgid "Column 1" msgstr "" @@ -66068,7 +66374,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533698236\n" +"par_id1001870\n" "help.text" msgid "Column 2" msgstr "" @@ -66076,7 +66382,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533614553\n" +"par_id1001900\n" "help.text" msgid "Column 3" msgstr "" @@ -66086,14 +66392,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 "" @@ -66101,8 +66406,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 "" @@ -66110,8 +66414,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 "" @@ -66119,15 +66422,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 "" @@ -66135,7 +66438,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 "" @@ -66143,7 +66446,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533635095\n" +"par_id1001990\n" "help.text" msgid "Covariances" msgstr "" @@ -66151,7 +66454,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533619955\n" +"par_id1002000\n" "help.text" msgid "Column 1" msgstr "" @@ -66159,7 +66462,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533651324\n" +"par_id1002010\n" "help.text" msgid "Column 2" msgstr "" @@ -66167,7 +66470,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533613800\n" +"par_id1002020\n" "help.text" msgid "Column 3" msgstr "" @@ -66175,7 +66478,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533640180\n" +"par_id1002030\n" "help.text" msgid "Column 1" msgstr "" @@ -66183,7 +66486,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553367596\n" +"par_id1002050\n" "help.text" msgid "Column 2" msgstr "" @@ -66191,7 +66494,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553364047\n" +"par_id1002080\n" "help.text" msgid "Column 3" msgstr "" @@ -66201,14 +66504,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 "" @@ -66216,8 +66518,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 "" @@ -66225,8 +66526,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 "" @@ -66234,23 +66534,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 "" @@ -66258,7 +66550,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id200820141553364794\n" +"hd_id1000120\n" "help.text" msgid "Parameters" msgstr "" @@ -66266,7 +66558,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 "" @@ -66274,7 +66566,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 "" @@ -66282,7 +66574,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533725829\n" +"par_id1002180\n" "help.text" msgid "Alpha" msgstr "" @@ -66290,7 +66582,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533712984\n" +"par_id1002200\n" "help.text" msgid "Column 1" msgstr "" @@ -66298,7 +66590,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764774\n" +"par_id1002210\n" "help.text" msgid "Column 2" msgstr "" @@ -66308,14 +66600,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 "" @@ -66323,8 +66614,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 "" @@ -66332,8 +66622,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 "" @@ -66341,39 +66630,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 "" @@ -66381,7 +66670,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533791711\n" +"par_id1002550\n" "help.text" msgid "Column 2" msgstr "" @@ -66389,7 +66678,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764431\n" +"par_id1002560\n" "help.text" msgid "#N/A" msgstr "" @@ -66397,7 +66686,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533754380\n" +"par_id1002570\n" "help.text" msgid "#N/A" msgstr "" @@ -66405,7 +66694,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533847092\n" +"par_id1002800\n" "help.text" msgid "#N/A" msgstr "" @@ -66413,7 +66702,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533890018\n" +"par_id1002810\n" "help.text" msgid "#N/A" msgstr "" @@ -66423,32 +66712,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 "" @@ -66456,40 +66742,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_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_id2008201415533423222\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 "" @@ -66497,7 +66990,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533817070\n" +"hd_id1000190\n" "help.text" msgid "Data" msgstr "" @@ -66505,7 +66998,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 "" @@ -66513,7 +67006,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 "" @@ -66521,7 +67014,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 "" @@ -66529,31 +67022,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 "" @@ -66561,7 +67054,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533863306\n" +"par_id1003350\n" "help.text" msgid "Variable 1" msgstr "" @@ -66569,7 +67062,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533818481\n" +"par_id1003360\n" "help.text" msgid "Variable 2" msgstr "" @@ -66577,7 +67070,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533858438\n" +"par_id1003370\n" "help.text" msgid "Mean" msgstr "" @@ -66585,7 +67078,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533897974\n" +"par_id1003400\n" "help.text" msgid "Variance" msgstr "" @@ -66593,7 +67086,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533868040\n" +"par_id1003430\n" "help.text" msgid "Observations" msgstr "" @@ -66601,119 +67094,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_id2008201415533911319\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" +"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 "" @@ -66721,7 +67262,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 "" @@ -66729,7 +67278,7 @@ msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533926248\n" +"par_id1003770\n" "help.text" msgid "Variable 2" msgstr "" @@ -66737,23 +67286,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 "" @@ -66761,65 +67310,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 |