diff options
Diffstat (limited to 'source/de/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/de/helpcontent2/source/text/scalc/01.po | 2357 |
1 files changed, 1522 insertions, 835 deletions
diff --git a/source/de/helpcontent2/source/text/scalc/01.po b/source/de/helpcontent2/source/text/scalc/01.po index 2feb0a796b0..1cc2eb0db8f 100644 --- a/source/de/helpcontent2/source/text/scalc/01.po +++ b/source/de/helpcontent2/source/text/scalc/01.po @@ -3,8 +3,8 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2014-11-26 19:57+0100\n" -"PO-Revision-Date: 2015-04-02 12:50+0000\n" +"POT-Creation-Date: 2015-05-11 16:11+0200\n" +"PO-Revision-Date: 2015-05-17 12:57+0000\n" "Last-Translator: Christian <kuehl.christian@googlemail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: de\n" @@ -14,23 +14,23 @@ msgstr "" "Plural-Forms: nplurals=2; plural=(n != 1);\n" "X-Generator: Pootle 2.5.1\n" "X-Accelerator-Marker: ~\n" -"X-POOTLE-MTIME: 1427979045.000000\n" +"X-POOTLE-MTIME: 1431867472.000000\n" #: 01120000.xhp msgctxt "" "01120000.xhp\n" "tit\n" "help.text" -msgid "Page Preview" -msgstr "Seitenansicht" +msgid "Print Preview" +msgstr "Druckvorschau" #: 01120000.xhp msgctxt "" "01120000.xhp\n" "hd_id1918698\n" "help.text" -msgid "<link href=\"text/scalc/01/01120000.xhp\">Page Preview</link>" -msgstr "<link href=\"text/scalc/01/01120000.xhp\">Seitenansicht</link>" +msgid "<link href=\"text/scalc/01/01120000.xhp\">Print Preview</link>" +msgstr "<link href=\"text/scalc/01/01120000.xhp\">Druckvorschau</link>" #: 01120000.xhp msgctxt "" @@ -38,15 +38,15 @@ msgctxt "" "par_id3831598\n" "help.text" msgid "<ahelp hid=\".uno:PrintPreview\">Displays a preview of the printed page or closes the preview.</ahelp>" -msgstr "<ahelp hid=\".uno:PrintPreview\">Öffnet oder schließt eine Vorschau der gedruckten Seite.</ahelp>" +msgstr "<ahelp hid=\".uno:PrintPreview\">Öffnet oder schließt die Druckvorschau.</ahelp>" #: 01120000.xhp 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 "In der Symbolleiste <emph>Seitenvorschau</emph> stehen Symbole zum Durchlaufen der Seiten oder Drucken des Dokuments zur Verfügung." +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 "Benutzen Sie die Schaltflächen in der Symbolleiste <emph>Druckvorschau</emph>, um durch die Seiten des Dokuments zu blättern oder das Dokument zu drucken." #: 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 "In der Seitenansicht ist keine Bearbeitung des Dokuments möglich." +msgid "You cannot edit your document while you are in the print preview." +msgstr "In der Druckvorschau ist keine Bearbeitung des Dokuments möglich." #: 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\">Zum Verlassen der Seitenansicht klicken Sie auf die Schaltfläche <emph>Seitenansicht schließen</emph>.</ahelp>" +msgid "<ahelp hid=\".\" visibility=\"hidden\">To exit the print preview, click the <emph>Close Preview</emph> button.</ahelp>" +msgstr "<ahelp hid=\".\" visibility=\"hidden\">Um die Druckvorschau zu verlassen, klicken Sie auf die Schaltfläche <emph>Druckvorschau schließen</emph>.</ahelp>" #: 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\">Diese Kategorie enthält <emph>Informationsfunktionen</emph>.</variable>" +msgid "<variable id=\"informationtext\">This category contains the <emph>Information</emph> functions.</variable>" +msgstr "<variable id=\"informationtext\">Diese Kategorie enthält die Funktionen zu <emph>Information</emph>.</variable>" #: 04060104.xhp msgctxt "" @@ -9454,6 +9454,95 @@ msgstr "<item type=\"input\">=ISTFEHLER(C9)</item>, wobei WAHR zurückgegeben wi #: 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 +#, fuzzy +msgctxt "" +"04060104.xhp\n" +"hd_id31470811\n" +"53\n" +"help.text" +msgid "IFERROR" +msgstr "ISTFEHLER" + +#: 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 "Syntax" + +#: 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 "Beispiel" + +#: 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 +9614,110 @@ msgstr "<item type=\"input\">=ISTFORMEL(C4)</item> gibt FALSCH zurück, wenn Zel #: 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 "<bookmark_value>ISTGERADE (Funktion)</bookmark_value><bookmark_value>Gerade ganze Zahlen</bookmark_value>" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3156048\n" +"help.text" +msgid "ISEVEN" +msgstr "ISTGERADE" + +#: 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 "<ahelp hid=\"HID_FUNC_ISTGERADE\">Gibt WAHR zurück, falls der Wert eine gerade Zahl ist, oder FALSCH, falls der Wert ungerade ist.</ahelp>" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3146928\n" +"help.text" +msgid "Syntax" +msgstr "Syntax" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3151203\n" +"help.text" +msgid "ISEVEN(Value)" +msgstr "ISTGERADE(Wert)" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3150491\n" +"help.text" +msgid "<emph>Value</emph> is the value to be checked." +msgstr "<emph>Wert</emph> ist der zu prüfende Wert." + +#: 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 "Falls Wert keine ganze Zahl ist, werden alle Stellen nach dem Dezimaltrennzeichen ignoriert. Das Vorzeichen von Wert wird ebenfalls ignoriert." + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3154136\n" +"help.text" +msgid "Example" +msgstr "Beispiel" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3163813\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(48)</item> returns TRUE" +msgstr "<item type=\"input\">=ISTGERADE(48)</item> gibt WAHR zurück." + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id8378856\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(33)</item> returns FALSE" +msgstr "<item type=\"input\">=ISTGERADE(33)</item> gibt FALSCH zurück." + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id7154759\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(0)</item> returns TRUE" +msgstr "<item type=\"input\">=ISTGERADE(0)</item> ergibt WAHR." + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id1912289\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(-2.1)</item> returns TRUE" +msgstr "<item type=\"input\">=ISTGERADE(-2,1)</item> gibt WAHR zurück" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id5627307\n" +"help.text" +msgid "<item type=\"input\">=ISEVEN(3.999)</item> returns FALSE" +msgstr "<item type=\"input\">=ISTGERADE(3,999)</item> gibt FALSCH zurück." + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" "bm_id3149760\n" "help.text" msgid "<bookmark_value>ISEVEN_ADD function</bookmark_value>" @@ -9929,6 +10122,87 @@ msgstr "<item type=\"input\">=ISTNV(D3)</item> gibt als Ergebnis FALSCH zurück. #: 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 +#, fuzzy +msgctxt "" +"04060104.xhp\n" +"hd_id31536851\n" +"93\n" +"help.text" +msgid "IFNA" +msgstr "ISTNV" + +#: 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 "Syntax" + +#: 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 "Beispiel" + +#: 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 +10291,102 @@ msgstr "<item type=\"input\">=ISTTEXT(C3)</item> gibt FALSCH zurück, wenn Zelle #: 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 "<bookmark_value>ISTUNGERADE (Funktion)</bookmark_value><bookmark_value>Ungerade ganze Zahlen</bookmark_value>" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3156034\n" +"help.text" +msgid "ISODD" +msgstr "ISTUNGERADE" + +#: 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 "<ahelp hid=\"HID_FUNC_ISTUNGERADE\">Gibt WAHR zurück, falls der Wert eine ungerade Zahl ist, oder FALSCH, falls die Zahl gerade ist.</ahelp>" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3151006\n" +"help.text" +msgid "Syntax" +msgstr "Syntax" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3151375\n" +"help.text" +msgid "ISODD(value)" +msgstr "ISTUNGERADE(Wert)" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3155139\n" +"help.text" +msgid "<emph>Value</emph> is the value to be checked." +msgstr "<emph>Wert</emph> ist der zu prüfende Wert." + +#: 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 "Falls Wert keine ganze Zahl ist, werden alle Stellen nach dem Dezimaltrennzeichen ignoriert. Das Vorzeichen von Wert wird ebenfalls ignoriert." + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"hd_id3163723\n" +"help.text" +msgid "Example" +msgstr "Beispiel" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id3155345\n" +"help.text" +msgid "<item type=\"input\">=ISODD(33)</item> returns TRUE" +msgstr "<item type=\"input\">=ISODD(33)</item> gibt WAHR zurück" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id9392986\n" +"help.text" +msgid "<item type=\"input\">=ISODD(48)</item> returns FALSE" +msgstr "<item type=\"input\">=ISTUNGERADE(48)</item> ergibt FALSCH" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id5971251\n" +"help.text" +msgid "<item type=\"input\">=ISODD(3.999)</item> returns TRUE" +msgstr "<item type=\"input\">=ISTUNGERADE(3,999)</item> gibt WAHR zurück" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" +"par_id4136478\n" +"help.text" +msgid "<item type=\"input\">=ISODD(-3.1)</item> returns TRUE" +msgstr "<item type=\"input\">=ISTUNGERADE(-3,1)</item> gibt WAHR zurück" + +#: 04060104.xhp +msgctxt "" +"04060104.xhp\n" "bm_id3153939\n" "help.text" msgid "<bookmark_value>ISODD_ADD function</bookmark_value>" @@ -11848,77 +12218,6 @@ msgstr "<item type=\"input\">=ABS(0)</item> ergibt 0." #: 04060106.xhp msgctxt "" "04060106.xhp\n" -"bm_id3150896\n" -"help.text" -msgid "<bookmark_value>COUNTBLANK function</bookmark_value><bookmark_value>counting;empty cells</bookmark_value><bookmark_value>empty cells;counting</bookmark_value>" -msgstr "<bookmark_value>ANZAHLLEEREZELLEN (Funktion)</bookmark_value><bookmark_value>Zählen; leere Zellen</bookmark_value><bookmark_value>Leere Zellen; zählen</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3150896\n" -"42\n" -"help.text" -msgid "COUNTBLANK" -msgstr "ANZAHLLEEREZELLEN" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155260\n" -"43\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\">Returns the number of empty cells.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\">Gibt die Anzahl der leeren Zellen zurück.</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3145144\n" -"44\n" -"help.text" -msgid "Syntax" -msgstr "Syntax" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3153931\n" -"45\n" -"help.text" -msgid "COUNTBLANK(Range)" -msgstr "ANZAHLLEEREZELLEN(Bereich)" - -#: 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 "Gibt die Anzahl der leeren Zellen im Zellbereich <emph>Bereich</emph> zurück." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3146139\n" -"47\n" -"help.text" -msgid "Example" -msgstr "Beispiel" - -#: 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\">=ANZAHLLEEREZELLEN(A1:B2)</item> ergibt 4, wenn die Zellen A1, A2, B1 und B2 leer sind." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" "bm_id3153114\n" "help.text" msgid "<bookmark_value>ACOS function</bookmark_value>" @@ -13765,220 +14064,6 @@ msgstr "<item type=\"input\">=GGT_ADD(5;15;25)</item> ergibt 5." #: 04060106.xhp msgctxt "" "04060106.xhp\n" -"bm_id3156048\n" -"help.text" -msgid "<bookmark_value>ISEVEN function</bookmark_value><bookmark_value>even integers</bookmark_value>" -msgstr "<bookmark_value>ISTGERADE (Funktion)</bookmark_value><bookmark_value>Gerade ganze Zahlen</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3156048\n" -"245\n" -"help.text" -msgid "ISEVEN" -msgstr "ISTGERADE" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3149169\n" -"246\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ISTGERADE\">Returns TRUE if the value is an even integer, or FALSE if the value is odd.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ISTGERADE\">Liefert WAHR, wenn der Wert eine gerade ganze Zahl ist, und FALSCH, wenn er ungerade ist.</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3146928\n" -"247\n" -"help.text" -msgid "Syntax" -msgstr "Syntax" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151203\n" -"248\n" -"help.text" -msgid "ISEVEN(Value)" -msgstr "ISTGERADE(Wert)" - -#: 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>Wert</emph> ist der zu prüfende Wert." - -#: 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 "Wenn Wert keine ganze Zahl ist, werden Ziffern nach dem Dezimalkomma ignoriert. Das Vorzeichen von Wert wird ebenfalls ignoriert." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3154136\n" -"250\n" -"help.text" -msgid "Example" -msgstr "Beispiel" - -#: 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\">=ISTGERADE(48)</item> gibt WAHR zurück." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8378856\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(33)</item> returns FALSE" -msgstr "<item type=\"input\">=ISTGERADE(33)</item> gibt FALSCH zurück." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id7154759\n" -"help.text" -msgid "<item type=\"input\">=ISEVEN(0)</item> returns TRUE" -msgstr "<item type=\"input\">=ISTGERADE(0)</item> ergibt WAHR." - -#: 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\">=ISTGERADE(-2,1)</item> gibt WAHR zurück" - -#: 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\">=ISTGERADE(3,999)</item> gibt FALSCH zurück." - -#: 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>ISTUNGERADE (Funktion)</bookmark_value><bookmark_value>Ungerade ganze Zahlen</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3156034\n" -"255\n" -"help.text" -msgid "ISODD" -msgstr "ISTUNGERADE" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155910\n" -"256\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ISTUNGERADE\">Returns TRUE if the value is odd, or FALSE if the number is even.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ISTUNGERADE\">Liefert WAHR, wenn der Wert eine ungerade ganze Zahl ist und FALSCH, wenn er gerade ist.</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3151006\n" -"257\n" -"help.text" -msgid "Syntax" -msgstr "Syntax" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151375\n" -"258\n" -"help.text" -msgid "ISODD(value)" -msgstr "ISTUNGERADE(Wert)" - -#: 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>Wert</emph> ist der zu prüfende Wert." - -#: 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 "Wenn Wert keine ganze Zahl ist, werden Ziffern nach dem Dezimalkomma ignoriert. Das Vorzeichen von Wert wird ebenfalls ignoriert." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3163723\n" -"260\n" -"help.text" -msgid "Example" -msgstr "Beispiel" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155345\n" -"261\n" -"help.text" -msgid "<item type=\"input\">=ISODD(33)</item> returns TRUE" -msgstr "<item type=\"input\">=ISODD(33)</item> gibt WAHR zurück" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id9392986\n" -"help.text" -msgid "<item type=\"input\">=ISODD(48)</item> returns FALSE" -msgstr "<item type=\"input\">=ISTUNGERADE(48)</item> ergibt FALSCH" - -#: 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\">=ISTUNGERADE(3,999)</item> gibt WAHR zurück" - -#: 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\">=ISTUNGERADE(-3,1)</item> gibt WAHR zurück" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" "bm_id3145213\n" "help.text" msgid "<bookmark_value>LCM function</bookmark_value><bookmark_value>least common multiples</bookmark_value><bookmark_value>lowest common multiples</bookmark_value>" @@ -17945,134 +18030,6 @@ msgctxt "" msgid "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." msgstr "<item type=\"input\">=ZUFALLSZAHL()</item> gibt eine Zufallszahl zwischen 0 und 1 zurück." -#: 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>ZÄHLENWENN (Funktion)</bookmark_value><bookmark_value>Zählen; bestimmte Zellen</bookmark_value>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3164897\n" -"547\n" -"help.text" -msgid "COUNTIF" -msgstr "ZÄHLENWENN" - -#: 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\">Gibt die Anzahl der Zellen in einem Zellbereich zurück, die ein bestimmtes Kriterium erfüllen.</ahelp>" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3164953\n" -"549\n" -"help.text" -msgid "Syntax" -msgstr "Syntax" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3164967\n" -"550\n" -"help.text" -msgid "COUNTIF(Range; Criteria)" -msgstr "ZÄHLENWENN(Bereich; Kriterien)" - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3164980\n" -"551\n" -"help.text" -msgid "<emph>Range</emph> is the range to which the criteria are to be applied." -msgstr "<emph>Bereich</emph> ist der Bereich, auf den die Kriterien angewendet werden sollen." - -#: 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>Kriterien</emph> legt die Kriterien in Form einer Zahl, eines Ausdrucks oder einer Zeichenkette fest. Diese Kriterien bestimmen, welche Zellen gezählt werden sollen. Sie können auch einen Suchtext in Form eines regulären Ausdrucks eingeben, z.B. b.* für alle Wörter, die mit b beginnen. Sie können auch einen Zellbereich angeben, in dem das Suchkriterium enthalten ist. Wenn Sie nach einem Literaltext suchen, schließen Sie den Text in doppelten Anführungsstrichen ein." - -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3165037\n" -"553\n" -"help.text" -msgid "Example" -msgstr "Beispiele" - -#: 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 ist ein Zellbereich, der die Zahlen <item type=\"input\">2000</item> bis <item type=\"input\">2009</item> enthält. Die Zelle B1 enthält die Zahl <item type=\"input\">2006</item>. In Zelle B2 geben Sie eine Formel ein:" - -#: 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\">=ZÄHLENWENN(A1:A10;2006)</item> ergibt 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\">=ZÄHLENWENN(A1:A10;B1)</item> ergibt 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\">=ZÄHLENWENN(A1:A10;\">=2006\") </item> ergibt 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\">=ZÄHLENWENN(A1:A10;\"<\"&B1)</item> - ergibt 6, wenn Zelle B1 <item type=\"input\">2006</item> enthält." - -#: 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\">=ZÄHLENWENN(A1:A10;C2)</item> zählt die Anzahl von Zellen im Bereich A1:A10, für die das Ergebnis >2006 ist, wenn die Zelle C2 den Text <item type=\"input\">>2006</item> enthält." - -#: 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 "So zählen Sie ausschließlich negative Zahlen: <item type=\"input\">=ZÄHLENWENN(A1:A10;\"<0\")</item>" - #: 04060107.xhp msgctxt "" "04060107.xhp\n" @@ -25641,19 +25598,49 @@ msgstr "<emph>Anzahl_Bytes</emph> (optional) gibt die Anzahl an Zeichen an, die msgctxt "" "04060110.xhp\n" "hd_id2950260\n" -"101\n" "help.text" -msgid "Example" -msgstr "Beispiel" +msgid "Examples" +msgstr "Beispiele" #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2949141\n" -"102\n" "help.text" -msgid "<item type=\"input\">=LEFTB(\"output\";3)</item> returns “out”." -msgstr "<item type=\"input\">=LINKSB(\"ausgabe\";3)</item> gibt \"aus\" zurück." +msgid "<item type=\"input\">LEFTB(\"中国\";1)</item> returns \" \" (1 byte is only half a DBCS character and a space character is returned instead)." +msgstr "<item type=\"input\">LINKSB(\"中国\";1)</item> gibt \" \" zurück (1 Byte ist nur ein halbes DBCS-Zeichen, deshalb wird ersatzweise ein Leerzeichen zurückgegeben)." + +#: 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 "<item type=\"input\">LINKSB(\"中国\";2)</item> gibt \"中\" zurück (2 Bytes bilden ein komplettes DBCS-Zeichen)." + +#: 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 "<item type=\"input\">LINKSB(\"中国\";3)</item> gibt \"中 \" zurück (3 Bytes bilden ein-einhalb DBCS-Zeichen; als zweites Zeichen wird deshalb ersatzweise ein Leerzeichen zurückgegeben)." + +#: 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 "<item type=\"input\">LINKSB(\"中国\";4)</item> gibt \"中国\" zurück (4 Bytes bilden zwei komplette DBCS-Zeichen)." + +#: 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 "<item type=\"input\">LINKSB(\"Office\";3)</item> gibt \"Off\" zurück (3 nicht-DBCS-Zeichen, jedes mit der Länge 1 Byte)." #: 04060110.xhp msgctxt "" @@ -25792,10 +25779,33 @@ msgstr "<emph>Text</emph> ist der Text, dessen Länge bestimmt werden soll." msgctxt "" "04060110.xhp\n" "hd_id2953884\n" -"109\n" "help.text" -msgid "Example" -msgstr "Beispiel" +msgid "Examples" +msgstr "Beispiele" + +#: 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 "<item type=\"input\">LÄNGEB(\"中\")</item> gibt 2 zurück (1 DBCS-Zeichen, bestehend aus 2 Bytes)." + +#: 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 "<item type=\"input\">LÄNGEB(\"中国\")</item> gibt 4 zurück (2 DBCS-Zeichen, bestehend aus je 2 Bytes)." + +#: 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 "<item type=\"input\">LÄNGEB(\"Office\")</item> gibt 6 zurück (6 nicht-DBCS-Zeichen, bestehend aus je 1 Byte)." #: 04060110.xhp msgctxt "" @@ -26050,19 +26060,98 @@ msgstr "<emph>Anzahl_Bytes</emph> legt die Anzahl der Zeichen in Bytes fest, die msgctxt "" "04060110.xhp\n" "hd_id2950509\n" -"155\n" "help.text" -msgid "Example" -msgstr "Beispiel" +msgid "Examples" +msgstr "Beispiele" #: 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 "<item type=\"input\">TEILB(\"中国\";1;0)</item> gibt \"\" zurück (0 Bytes entsprechen immer einer leeren Zeichenfolge)." + +#: 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 "<item type=\"input\">TEILB(\"中国\";1;1)</item> gibt \" \" zurück (1 Byte ist lediglich ein halbes DBCS-Zeichen, deshalb wird ersatzweise ein Leerzeichen zurückgegeben)." + +#: 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 "<item type=\"input\">TEILB(\"中国\";1;2)</item> gibt \"中\" zurück (2 Bytes bilden ein komplettes DBCS-Zeichen)." + +#: 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 "<item type=\"input\">TEILB(\"中国\";1;3)</item> gibt \"中 \" zurück (3 Bytes bilden ein-einhalb DBCS-Zeichen; als zweites Zeichen wird deshalb ersatzweise ein Leerzeichen zurückgegeben)." + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958457\n" "help.text" -msgid "<item type=\"input\">=MIDB(\"office\";2;2)</item> returns ff." -msgstr "<item type=\"input\">=TEILB(\"Office\";2;2)</item> gibt ff zurück." +msgid "<item type=\"input\">MIDB(\"中国\";1;4)</item> returns \"中国\" (4 bytes constitute two complete DBCS characters)." +msgstr "<item type=\"input\">TEILB(\"中国\";1;4)</item> gibt \"中国\" zurück (4 Bytes bilden zwei komplette DBCS-Zeichen)." + +#: 04060110.xhp +#, fuzzy +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 "<item type=\"input\">TEILB(\"中国\";2;1)</item> gibt \" \" zurück (die 2. Byteposition ist nicht am Anfang eines Zeichens einer DBCS-Zeichenfolge; deshalb wird ersatzweise ein Leerzeichen zurückgegeben)." + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958477\n" +"help.text" +msgid "<item type=\"input\">MIDB(\"中国\";2;2)</item> returns \" \" (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned)." +msgstr "<item type=\"input\">TEILB(\"中国\";2;2)</item> gibt \" \" zurück (die 2. Byteposition ist nicht am Anfang eines Zeichens einer DBCS-Zeichenfolge; die 2 Bytes, die zurückgegeben werden sollen, bilden stattdessen die zweite Hälfte des ersten Zeichens und die erste Hälfte des zweiten Zeichens in der Zeichenfolge; deshalb werden ersatzweise zwei Leerzeichen zurückgegeben)." + +#: 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 "<item type=\"input\">TEILB(\"中国\";2;3)</item> gibt \" 国\" zurück (die 2. Byteposition ist nicht am Anfang eines Zeichens einer DBCS-Zeichenfolge; deshalb wird ersatzweise ein Leerzeichen für die 2. Byteposition zurückgegeben)." + +#: 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 msgctxt "" @@ -26477,19 +26566,49 @@ msgstr "<emph>Anzahl_Bytes</emph> (optional) gibt die Anzahl der auf Bytes basie msgctxt "" "04060110.xhp\n" "hd_id2948661\n" -"119\n" "help.text" -msgid "Example" -msgstr "Beispiel" +msgid "Examples" +msgstr "Beispiele" #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2951132\n" -"120\n" "help.text" -msgid "<item type=\"input\">=RIGHTB(\"Sun\";2)</item> returns un." -msgstr "<item type=\"input\">=RECHTSB(\"Sonne\";2)</item> gibt ne zurück." +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 msgctxt "" @@ -30882,8 +31001,8 @@ msgctxt "" "par_id2963824\n" "138\n" "help.text" -msgid "ERF(LowerLimit; UpperLimit)" -msgstr "GAUSSFEHLER(UntererGrenzwert; ObererGrenzwert)" +msgid "ERF.PRECISE(LowerLimit; UpperLimit)" +msgstr "GAUSSF.GENAU(UntererGrenzwert; ObererGrenzwert)" #: 04060115.xhp msgctxt "" @@ -39574,6 +39693,191 @@ msgstr "<item type=\"input\">=ANZAHL2(2;4;6;\"acht\")</item> = 4. Die Anzahl von #: 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 "ANZAHLLEEREZELLEN" + +#: 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 "Syntax" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3153931\n" +"help.text" +msgid "COUNTBLANK(Range)" +msgstr "ANZAHLLEEREZELLEN(Bereich)" + +#: 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 "Beispiel" + +#: 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 "ZÄHLENWENN" + +#: 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 "Syntax" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id3164967\n" +"help.text" +msgid "COUNTIF(Range; Criteria)" +msgstr "ZÄHLENWENN(Bereich; Kriterien)" + +#: 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 "Beispiel" + +#: 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 "<item type=\"input\">=ZÄHLENWENN(A1:A10;2006)</item> ergibt 1." + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id708639\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - this returns 1" +msgstr "<item type=\"input\">=ZÄHLENWENN(A1:A10;B1)</item> ergibt 1." + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id5169225\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- this returns 4" +msgstr "<item type=\"input\">=ZÄHLENWENN(A1:A10;\">=2006\") </item> ergibt 3." + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2118594\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - when B1 contains <item type=\"input\">2006</item>, this returns 6" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id166020\n" +"help.text" +msgid "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type=\"input\">>2006</item> counts the number of cells in the range A1:A10 which are >2006" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id6386913\n" +"help.text" +msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3150267\n" "help.text" msgid "<bookmark_value>B function</bookmark_value> <bookmark_value>probabilities of samples with binomial distribution</bookmark_value>" @@ -40187,8 +40491,8 @@ 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." -msgstr "<emph>Kumulativ</emph> (erforderlich). 0 oder FALSCH berechnet die Wahrscheinlichkeit der Schutzfunktion. Anderer Wert, WAHR oder fehlend berechnet die kumulative Verteilungsfunktion." +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 msgctxt "" @@ -41211,8 +41515,8 @@ 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." -msgstr "<ahelp hid=\"HID_FUNC_CHITEST_MS\">Liefert anhand des Chi-Quadrat-Tests aus den Messdaten direkt den Wahrscheinlichkeitswert dafür, dass eine Hypothese erfüllt ist. Dabei werden beobachtete und erwartete Größen einer Stichprobe verglichen:</ahelp> CHITEST liefert die Chi-Quadrat-Verteilung der Daten." +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 msgctxt "" @@ -41220,8 +41524,8 @@ 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." -msgstr "Die durch CHI.TEST ermittelte Wahrscheinlichkeit kann auch mit CHI.VERT bestimmt werden, wobei statt der Datenreihen das Chi-Quadrat der Stichprobe als Parameter übergeben werden muss." +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 msgctxt "" @@ -41622,8 +41926,8 @@ 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." -msgstr "<emph>Kumulativ</emph>: 0 oder FALSCH berechnet die Wahrscheinlichkeit der Dichtefunktion. Anderer Wert, WAHR oder fehlend berechnet die kumulative Verteilungsfunktion." +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 msgctxt "" @@ -48300,8 +48604,8 @@ msgctxt "" "hd_id2855071\n" "2\n" "help.text" -msgid "RANK.AVG" -msgstr "RANG.MITTELW" +msgid "RANK.EQ" +msgstr "" #: 04060185.xhp msgctxt "" @@ -49700,8 +50004,8 @@ 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>" -msgstr "<bookmark_value>T.INV (Funktion)</bookmark_value><bookmark_value>Umkehrfunktion der t-Verteilung</bookmark_value>" +msgid "<bookmark_value>T.INV function</bookmark_value> <bookmark_value>one tailed inverse of t-distribution</bookmark_value>" +msgstr "" #: 04060185.xhp msgctxt "" @@ -49718,8 +50022,8 @@ 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>" -msgstr "<ahelp hid=\"HID_FUNC_TINV_MS\">Berechnet die Quantile der inversen beidseitigen t-Verteilung.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_TINV_MS\">Returns the one tailed inverse of the t-distribution.</ahelp>" +msgstr "" #: 04060185.xhp msgctxt "" @@ -49745,8 +50049,8 @@ msgctxt "" "par_id2954070\n" "102\n" "help.text" -msgid "<emph>Number</emph> is the probability associated with the two-tailed t-distribution." -msgstr "<emph>Zahl</emph> ist der Wahrscheinlichkeitswert, zu dem die beidseitige t-Verteilung berechnet werden soll." +msgid "<emph>Number</emph> is the probability associated with the one-tailed t-distribution." +msgstr "" #: 04060185.xhp msgctxt "" @@ -52147,8 +52451,8 @@ msgctxt "" "par_id3154366\n" "2\n" "help.text" -msgid "<variable id=\"namenfestlegentext\"><ahelp hid=\".uno:DefineName\">Opens a dialog where you can specify a name for a selected area.</ahelp></variable>" -msgstr "<variable id=\"namenfestlegentext\"><ahelp hid=\".uno:DefineName\">Öffnet einen Dialog, in dem Sie einen Namen für einen ausgewählten Bereich festlegen können.</ahelp></variable>" +msgid "<variable id=\"namenfestlegentext\"><ahelp hid=\".uno:DefineName\">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp></variable>" +msgstr "" #: 04070100.xhp msgctxt "" @@ -52165,8 +52469,8 @@ msgctxt "" "par_id3155131\n" "30\n" "help.text" -msgid "The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." -msgstr "Das Feld <emph>Tabellenbereich</emph> in der Rechenleiste enthält eine Liste der definierten Bereichsnamen. Klicken Sie auf einen Namen in diesem Feld, um den entsprechenden Bezug in der Tabelle hervorzuheben. Für Formeln oder Formelteile definierte Namen sind hier nicht aufgeführt." +msgid "The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." +msgstr "" #: 04070100.xhp msgctxt "" @@ -52183,8 +52487,8 @@ msgctxt "" "par_id3163712\n" "29\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/definename/edit\">Enter the name of the area for which you want to define a reference. All area names already defined in the spreadsheet are listed in the text field below.</ahelp> If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames." -msgstr "<ahelp hid=\"modules/scalc/ui/definename/edit\" visibility=\"visible\">Geben Sie den Namen des Bereichs ein, für den Sie einen Bezug definieren möchten. Alle bereits festgelegten Bereichsnamen dieser Tabelle sind im Textfeld darunter aufgeführt.</ahelp> Wenn Sie auf einen Namen in der Liste klicken, wird der entsprechende Bezug im Dokument mit einem blauen Rahmen hervorgehoben. Sollten mehrere Zellbereiche demselben Bereichsnamen zugeordnet sein, so werden sie in unterschiedlichen Farben umrandet." +msgid "<ahelp hid=\"modules/scalc/ui/definename/edit\">Enter the name of the area for which you want to define a reference or a formula expression. All area names already defined in the spreadsheet are listed in the text field below.</ahelp> If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames." +msgstr "" #: 04070100.xhp msgctxt "" @@ -52192,8 +52496,8 @@ msgctxt "" "hd_id3153728\n" "9\n" "help.text" -msgid "Assigned to" -msgstr "Zugeordnet zu" +msgid "Range or formula expression" +msgstr "" #: 04070100.xhp msgctxt "" @@ -52210,35 +52514,44 @@ msgctxt "" "par_id3146986\n" "12\n" "help.text" -msgid "To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document." -msgstr "Möchten Sie einen neuen Bereichsbezug eingeben, können Sie die Einfügemarke in diesem Feld plazieren und den Bezug direkt durch Markieren des entsprechenden Tabellenbereichs im aktuellen oder einem anderen Blatt aufnehmen." +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 "Zusätze>>" +msgid "Scope" +msgstr "" #: 04070100.xhp msgctxt "" "04070100.xhp\n" -"par_id3149958\n" -"14\n" +"hd_id31547291\n" +"13\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/definename/more\">Allows you to specify the <emph>Area type </emph>(optional) for the reference.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/definename/more\">Dient zur Angabe einer <emph>Bereichsart</emph> (optional) für den Bezug.</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 "Range options" +msgstr "" + +#: 04070100.xhp +msgctxt "" +"04070100.xhp\n" +"par_id3149958\n" +"14\n" "help.text" -msgid "Area type" -msgstr "Bereichsart" +msgid "<ahelp hid=\"modules/scalc/ui/definename/more\">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp>" +msgstr "" #: 04070100.xhp msgctxt "" @@ -65240,7 +65553,7 @@ msgstr "Klicken Sie auf OK, um die Änderungen zu übernehmen und zum Dialogfeld #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id200820141553364965\n" +"tit\n" "help.text" msgid "Data" msgstr "Daten" @@ -65248,23 +65561,31 @@ msgstr "Daten" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533682345\n" +"hd_id1000010\n" +"help.text" +msgid "Data" +msgstr "Daten" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id1000010\n" "help.text" msgid "<emph>Input Range</emph>: The reference of the range of the data to analyze." -msgstr "<emph>Eingabebereich</emph>: Der Bezug zum zu analysierenden Datenbereich." +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 "<emph>Ergebnisse nach</emph>: Der Bezug zur oberen linken Zelle des Bereichs, in dem das Ergebnis angezeigt werden soll." +msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533630182\n" +"hd_id1000020\n" "help.text" msgid "Grouped By" msgstr "Gruppiert nach" @@ -65272,15 +65593,15 @@ msgstr "Gruppiert nach" #: 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 "Wähen Sie, ob die Eingabedaten ein Layout in <emph>Spalten</emph> oder <emph>Zeilen</emph> besitzt." +msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533366360\n" +"hd_id1000030\n" "help.text" msgid "Example" msgstr "Beispiel" @@ -65288,7 +65609,7 @@ msgstr "Beispiel" #: 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 "Die folgenden Daten werden als Beispiel verwendet" @@ -65296,7 +65617,7 @@ msgstr "Die folgenden Daten werden als Beispiel verwendet" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id200820141553335121\n" +"par_id1000090\n" "help.text" msgid "Maths" msgstr "Mathematik" @@ -65304,7 +65625,7 @@ msgstr "Mathematik" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533379519\n" +"par_id1000100\n" "help.text" msgid "Physics" msgstr "Physik" @@ -65312,7 +65633,7 @@ msgstr "Physik" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id200820141553333644\n" +"par_id1000110\n" "help.text" msgid "Biology" msgstr "Biologie" @@ -65320,7 +65641,7 @@ msgstr "Biologie" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"hd_id2008201415533624784\n" +"hd_id1000040\n" "help.text" msgid "Example" msgstr "Beispiel" @@ -65328,26 +65649,26 @@ msgstr "Beispiel" #: 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 "Die folgende Tabelle hat zwei Zeitreihen, eine, die eine Stoßfunktion zur Zeit t=0 darstellt, und die andere, die sie zur Zeit t=2 darstellt." +msgstr "" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533654405\n" +"hd_id1000050\n" "help.text" -msgid "A" -msgstr "A" +msgid "Example" +msgstr "Beispiel" #: stat_data.xhp msgctxt "" "stat_data.xhp\n" -"par_id2008201415533633771\n" +"par_id1000970\n" "help.text" -msgid "B" -msgstr "B" +msgid "The following table has two data sets." +msgstr "" #: statistics.xhp msgctxt "" @@ -65360,8 +65681,7 @@ msgstr "Datenstatistiken in Calc" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id1\n" -"1\n" +"hd_id1000010\n" "help.text" msgid "Data Statistics in Calc" msgstr "Datenstatistiken in Calc" @@ -65369,7 +65689,7 @@ msgstr "Datenstatistiken in Calc" #: 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 "Benutzen Sie die Datenstatistik in Calc, um komplexe Datenanalysen durchzuführen" @@ -65377,23 +65697,23 @@ msgstr "Benutzen Sie die Datenstatistik in Calc, um komplexe Datenanalysen durch #: 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." -msgstr "Um komplexe statistischen oder technischen Analysen durchzuführen, können Sie durch Calcs Datenstatistik Schritte und Zeit sparen. Sie stellen die Daten und Parameter für jede Analyse zusammen und verwenden die geeigneten statistischen oder technischen Funktionen, um die Ergebnisse zu berechnen und in einer Ausgabetabelle anzuzeigen." +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 msgctxt "" "statistics.xhp\n" "bm_id2764278\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;sampling</bookmark_value> <bookmark_value>sampling;Analysis toolpack</bookmark_value> <bookmark_value>Data statistics;sampling</bookmark_value>" -msgstr "<bookmark_value>Analysefunktionen; Stichproben</bookmark_value><bookmark_value>Stichproben; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistiken; Stichproben</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 "Stichproben" @@ -65401,41 +65721,39 @@ msgstr "Stichproben" #: 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 "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Erzeugt eine Tabelle mit Daten, die von einer anderen Tabelle abgefragt wurden.</ahelp>" +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 "<variable id=\"sam01\">Wählen Sie im Menü <emph>Daten - Statistiken - Stichproben...</emph></variable>" +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 "Stichproben erlauben es Ihnen, Daten von einer <emph>Quelltabelle</emph> zum Füllen einer <emph>Zieltabelle</emph> zu verwenden. Die Stichprobe kann zufällig oder periodisch sein." +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 "Eine Stichprobe wird zeilenweise ausgeführt. Das bedeutet, dass die Stichprobendaten die ganze Zeile der Quelltabelle auslesen und in eine Zeile der Zieltabelle kopieren wird." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533154722\n" +"hd_id1000030\n" "help.text" msgid "Sampling Method" msgstr "Stichprobenmethode" @@ -65443,39 +65761,39 @@ msgstr "Stichprobenmethode" #: 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 "<emph>Zufällig</emph>: Greift zufällig Zeilen heraus, die durch die <emph>Stichprobengröße</emph> der Quelltabelle exakt festgelegt sind." +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 "<emph>Stichprobengröße</emph>: Anzahl der Zeilen, die von der Quelltabelle genommen werden." +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 "<emph>Periodisch</emph>: Greift schrittweise die Zeilen heraus, die durch <emph>Periode</emph> festgelegt sind." +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 "<emph>Periode</emph>: die Anzahl der Zeilen, die periodisch bei der Stichprobe übersprungen werden." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533195750\n" +"hd_id1000040\n" "help.text" msgid "Example" msgstr "Beispiel" @@ -65483,15 +65801,15 @@ msgstr "Beispiel" #: 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 "Die folgenden Daten werden als Beispiel einer Quelltabelle für Stichproben verwendet:" +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 "Eine Stichprobe mit der Periode 2 ergibt folgende Tabelle:" @@ -65501,14 +65819,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>" -msgstr "<bookmark_value>Analysefunktionen; Beschreibende Statistik</bookmark_value><bookmark_value>Beschreibende Statistik; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistiken; Beschreibende Statistik</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 "Beschreibende Statistik" @@ -65516,49 +65833,47 @@ msgstr "Beschreibende Statistik" #: 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 "<ahelp hid=\"modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog\">Einen Bereich im Tabellenblatt mit den statistischen Haupteigenschaften des Datensatzes füllen.</ahelp>" +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 "<variable id=\"sam01\">Wählen Sie im Menü <emph>Daten - Statistiken - Beschreibende Statistik...</emph></variable>" +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 "Das Analysewerkzeug der beschreibenden Statistik generiert einen Bericht der eindimensionalen Statistik für Daten im Eingabebereich, der Informationen zur zentralen Tendenz und Abweichung Ihrer Daten liefert." +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 "Für weitere Informationen besuchen Sie bitte Wikipedia: <link href=\"http://de.wikipedia.org/wiki/Deskriptive_Statistik\">http://de.wikipedia.org/wiki/Deskriptive_Statistik</link>" +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 "Die folgende Tabelle zeigt die Ergebnisse der beschreibenden Statistik der Beispieldaten von oben an." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533454721\n" +"par_id1000690\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -65566,7 +65881,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533415805\n" +"par_id1000700\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -65574,7 +65889,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533413862\n" +"par_id1000710\n" "help.text" msgid "Column 3" msgstr "Spalte 3" @@ -65582,7 +65897,7 @@ msgstr "Spalte 3" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533476173\n" +"par_id1000720\n" "help.text" msgid "Mean" msgstr "Mittelwert" @@ -65590,7 +65905,7 @@ msgstr "Mittelwert" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533480973\n" +"par_id1000760\n" "help.text" msgid "Standard Error" msgstr "Standardfehler" @@ -65598,7 +65913,7 @@ msgstr "Standardfehler" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533433244\n" +"par_id1000800\n" "help.text" msgid "Mode" msgstr "Modus" @@ -65606,7 +65921,7 @@ msgstr "Modus" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553341353\n" +"par_id1000840\n" "help.text" msgid "Median" msgstr "Zentralwert" @@ -65614,7 +65929,7 @@ msgstr "Zentralwert" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533490736\n" +"par_id1000880\n" "help.text" msgid "Variance" msgstr "Varianz" @@ -65622,7 +65937,7 @@ msgstr "Varianz" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533495501\n" +"par_id1000920\n" "help.text" msgid "Standard Deviation" msgstr "Standardabweichung" @@ -65630,7 +65945,7 @@ msgstr "Standardabweichung" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533498745\n" +"par_id1000960\n" "help.text" msgid "Kurtosis" msgstr "Kurtosis" @@ -65638,7 +65953,7 @@ msgstr "Kurtosis" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533479359\n" +"par_id1001000\n" "help.text" msgid "Skewness" msgstr "Schräge" @@ -65646,7 +65961,7 @@ msgstr "Schräge" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533473279\n" +"par_id1001040\n" "help.text" msgid "Range" msgstr "Bereich" @@ -65654,7 +65969,7 @@ msgstr "Bereich" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533467981\n" +"par_id1001080\n" "help.text" msgid "Minimum" msgstr "Minimum" @@ -65662,7 +65977,7 @@ msgstr "Minimum" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533456155\n" +"par_id1001120\n" "help.text" msgid "Maximum" msgstr "Maximum" @@ -65670,7 +65985,7 @@ msgstr "Maximum" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533452737\n" +"par_id1001160\n" "help.text" msgid "Sum" msgstr "Summe" @@ -65678,7 +65993,7 @@ msgstr "Summe" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533535276\n" +"par_id1001200\n" "help.text" msgid "Count" msgstr "Count" @@ -65688,14 +66003,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>" -msgstr "<bookmark_value>Analysefunktionen; Varianzanalyse</bookmark_value><bookmark_value>Varianzanalyse; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistik; Varianzanalyse</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 "Varianzanalyse (ANOVA)" @@ -65703,41 +66017,39 @@ msgstr "Varianzanalyse (ANOVA)" #: 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 "<ahelp hid=\"modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog\">Liefert die Varianzanalyse (ANOVA) eines gegebenen Datensatzes.</ahelp>" +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 "<variable id=\"sam01\">Wählen Sie im Menü <emph>Daten - Statistiken - Varianzanalyse (ANOVA)...</emph></variable>" +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." -msgstr "Varianzanalyse (ANOVA) ist eine Sammlung statistischer Modelle, die zur Analyse der Unterschiede zwischen Gruppenmittelwert und ihrer zugehörigen Verfahren (wie „Variationen“ unter und zwischen Gruppen) benutzt werden. In der ANOVA-Einstellung wird die beobachtete Varianz in einer speziellen Variablen in Komponenten unterteilt, die unterschiedlichen Variationsquellen zurechenbar sind. In ihrer einfachsten Form bietet ANOVA einen statistischen Test, ob die Mittelwerte mehrerer Gruppen gleich sind oder nicht, und verallgemeinert folglich den t-Test auf mehr als zwei Gruppen. Da das Ausführen mehrerer beidseitiger t-Tests zur Häufung von statistischen Typ-I-Fehlers führen würde, sind ANOVAs beim Vergleichen (Testen) von drei oder mehr Mittelwerten (von Gruppen oder Variablen) für die statistische Aussagekraft nützlich." +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 "Für weitere Informationen besuchen Sie bitte Wikipedia: <link href=\"http://de.wikipedia.org/wiki/Varianzanalyse\">http://de.wikipedia.org/wiki/Varianzanalyse</link>." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533538729\n" +"hd_id1000070\n" "help.text" msgid "Type" msgstr "Type" @@ -65745,15 +66057,15 @@ msgstr "Type" #: 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 "Wählen Sie, ob die Varianzanalyse <emph>einfaktoriell</emph> oder <emph>zweifaktoriell</emph> ist." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533538856\n" +"hd_id1000080\n" "help.text" msgid "Parameters" msgstr "Parameter" @@ -65761,7 +66073,7 @@ msgstr "Parameter" #: 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 "<emph>Alpha</emph>: Das Signifikanzniveau des Tests." @@ -65769,7 +66081,7 @@ msgstr "<emph>Alpha</emph>: Das Signifikanzniveau des Tests." #: 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 "<emph>Zeilen pro Beispiel</emph>: Legt fest, wie viele Zeilen ein Beispiel hat." @@ -65777,15 +66089,15 @@ msgstr "<emph>Zeilen pro Beispiel</emph>: Legt fest, wie viele Zeilen ein Beispi #: 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 "Die folgende Tabelle zeigt die Ergebnisse der <emph>Varianzanalyse</emph> der Beispieldaten oberhalb." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533531121\n" +"par_id1001320\n" "help.text" msgid "ANOVA - Single Factor" msgstr "Varianzanalyse - Einfaktoriell" @@ -65793,7 +66105,7 @@ msgstr "Varianzanalyse - Einfaktoriell" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533586267\n" +"par_id1001330\n" "help.text" msgid "Alpha" msgstr "Alpha" @@ -65801,7 +66113,7 @@ msgstr "Alpha" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533562036\n" +"par_id1001350\n" "help.text" msgid "Groups" msgstr "Gruppierung" @@ -65809,7 +66121,7 @@ msgstr "Gruppierung" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533516564\n" +"par_id1001360\n" "help.text" msgid "Count" msgstr "Count" @@ -65817,7 +66129,7 @@ msgstr "Count" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533511954\n" +"par_id1001370\n" "help.text" msgid "Sum" msgstr "Summe" @@ -65825,7 +66137,7 @@ msgstr "Summe" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533560198\n" +"par_id1001380\n" "help.text" msgid "Mean" msgstr "Mittelwert" @@ -65833,7 +66145,7 @@ msgstr "Mittelwert" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533547195\n" +"par_id1001390\n" "help.text" msgid "Variance" msgstr "Varianz" @@ -65841,7 +66153,7 @@ msgstr "Varianz" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533526297\n" +"par_id1001400\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -65849,7 +66161,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533571610\n" +"par_id1001450\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -65857,7 +66169,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553358382\n" +"par_id1001500\n" "help.text" msgid "Column 3" msgstr "Spalte 3" @@ -65865,7 +66177,7 @@ msgstr "Spalte 3" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533555826\n" +"par_id1001550\n" "help.text" msgid "Source of Variation" msgstr "Varianzquelle" @@ -65873,7 +66185,7 @@ msgstr "Varianzquelle" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533515237\n" +"par_id1001560\n" "help.text" msgid "SS" msgstr "SS" @@ -65881,7 +66193,7 @@ msgstr "SS" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533550319\n" +"par_id1001570\n" "help.text" msgid "df" msgstr "df" @@ -65889,7 +66201,7 @@ msgstr "df" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533582581\n" +"par_id1001580\n" "help.text" msgid "MS" msgstr "MS" @@ -65897,15 +66209,15 @@ msgstr "MS" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533546247\n" +"par_id1001590\n" "help.text" msgid "F" -msgstr "F" +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533553834\n" +"par_id1001600\n" "help.text" msgid "P-value" msgstr "P-Wert" @@ -65913,7 +66225,7 @@ msgstr "P-Wert" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533554659\n" +"par_id1001610\n" "help.text" msgid "Between Groups" msgstr "Zwischen den Gruppen" @@ -65921,7 +66233,7 @@ msgstr "Zwischen den Gruppen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533560423\n" +"par_id1001670\n" "help.text" msgid "Within Groups" msgstr "Innerhalb der Gruppen" @@ -65929,7 +66241,7 @@ msgstr "Innerhalb der Gruppen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533597992\n" +"par_id1001710\n" "help.text" msgid "Total" msgstr "Insgesamt" @@ -65939,14 +66251,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>" -msgstr "<bookmark_value>Analysefunktionen; Korrelation</bookmark_value><bookmark_value>Korrelation; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistik; Korrelation</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 "Korrelation" @@ -65954,65 +66265,63 @@ msgstr "Korrelation" #: 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 "<ahelp hid=\"modules/scalc/ui/correlationdialog/CorrelationDialog\">Berechnet die Korrelation zwischen zwei numerischen Datensätzen.</ahelp>" +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 "<variable id=\"corr01\">Wählen Sie im Menü <emph>Daten - Statistiken - Korrelation...</emph></variable>" +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 "Der Korrelationskoeffizient (ein Wert zwischen -1 und +1) gibt an, wie stark zwei Variablen voneinander abhängen. Sie können wahlweise die Funktion KORREL oder die Datenstatistik verwenden, um den Korrelationskoeffizienten zwischen zwei Variablen herauszufinden." +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 "Ein Korrelationskoeffizient von +1 zeigt eine perfekte positive Korrelation an." +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 "Ein Korrelationskoeffizient von -1 zeigt eine perfekte negative Korrelation an." +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 "Weitere Informationen zur statistischen Korrelation erhalten Sie in Wikipedia: <link href=\"http://de.wikipedia.org/wiki/Korrelation\">http://de.wikipedia.org/wiki/Korrelation</link>" +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 "Die folgende Tabelle zeigt die Ergebnisse der Korrelation der Beispieldaten oberhalb." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533666011\n" +"par_id1001810\n" "help.text" msgid "Correlations" msgstr "Korrelationen" @@ -66020,7 +66329,7 @@ msgstr "Korrelationen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533643141\n" +"par_id1001820\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -66028,7 +66337,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533674994\n" +"par_id1001830\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -66036,7 +66345,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533691064\n" +"par_id1001840\n" "help.text" msgid "Column 3" msgstr "Spalte 3" @@ -66044,7 +66353,7 @@ msgstr "Spalte 3" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533613299\n" +"par_id1001850\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -66052,7 +66361,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533698236\n" +"par_id1001870\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -66060,7 +66369,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533614553\n" +"par_id1001900\n" "help.text" msgid "Column 3" msgstr "Spalte 3" @@ -66070,14 +66379,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>" -msgstr "<bookmark_value>Analysefunktionen; Kovarianz</bookmark_value><bookmark_value>Kovarianz; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistik; Kovarianz</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 "Kovarianz" @@ -66085,49 +66393,47 @@ msgstr "Kovarianz" #: 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 "<ahelp hid=\"modules/scalc/ui/covariancedialog/CovarianceDialog\">Berechnet die Kovarianz von zwei numerischen Datensätzen.</ahelp>" +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 "<variable id=\"cov01\">Wählen Sie im Menü <emph>Daten - Statistiken - Kovarianz...</emph></variable>" +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." -msgstr "In Wahrscheinlichkeitstheorie und Statistik ist die Kovarianz ein Maß dafür, wie groß der Einfluss zweier Zufallsvariablen aufeinander ist. Falls die größeren Werte einer Variabel hauptsächlich mit den größeren Werten der anderen übereinstimmen, und das selbe für die kleineren Werte gilt, d.h. die Variablen dazu tendieren, ein ähnliches Verhalten zu zeigen, ist die Kovarianz positiv. Im umgekehrten Fall, wenn die größeren Werte einer Variablen hauptsächlich zu den kleineren Werten der anderen korrespondieren, d.h. die Variablen dazu tendieren, das gegenteilige Verhalten zu zeigen, ist die Kovarianz negativ. Das Vorzeichen der Kovarianz zeigt folglich die Tendenz in der linearen Beziehung zwischen den Variablen. Die Bedeutung der Kovarianz ist nicht leicht zu interpretieren. Die normierte Version der Kovarianz, der Korrelationskoeffizient, zeigt jedoch durch die Größe seines Wertes die Stärke der linearen Beziehung." +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 "Weitere Informationen zur statistischen Kovarianz finden Sie in Wikipedia: <link href=\"http://de.wikipedia.org/wiki/Kovarianz_(Stochastik)\">http://de.wikipedia.org/wiki/Kovarianz_(Stochastik)</link>" +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 "Die folgende Tabelle zeigt die Ergebnisse der Kovarianz für die Beispieldaten oberhalb." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533635095\n" +"par_id1001990\n" "help.text" msgid "Covariances" msgstr "Kovarianzen" @@ -66135,7 +66441,7 @@ msgstr "Kovarianzen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533619955\n" +"par_id1002000\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -66143,7 +66449,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533651324\n" +"par_id1002010\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -66151,7 +66457,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533613800\n" +"par_id1002020\n" "help.text" msgid "Column 3" msgstr "Spalte 3" @@ -66159,7 +66465,7 @@ msgstr "Spalte 3" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533640180\n" +"par_id1002030\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -66167,7 +66473,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553367596\n" +"par_id1002050\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -66175,7 +66481,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553364047\n" +"par_id1002080\n" "help.text" msgid "Column 3" msgstr "Spalte 3" @@ -66185,14 +66491,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>" -msgstr "<bookmark_value>Analysefunktionen; Exponentielle Glättung</bookmark_value><bookmark_value>Exponentielle Glättung; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistiken; Exponentielle Glättung</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 "Exponentielle Glättung" @@ -66200,49 +66505,39 @@ msgstr "Exponentielle Glättung" #: 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 "<ahelp hid=\"modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog\">Liefert eine geglättete Datenreihe.</ahelp>" +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 "<variable id=\"sam01\">Wählen Sie im Menü <emph>Daten - Statistiken - Exponentielle Glättung...</emph></variable>" - -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id2008201415533682260\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." -msgstr "Exponentielle Glättung ist eine Technik, die auf die Daten von Zeitreihen angewendet werden kann, entweder um geglättete Daten zur Präsentation zu produzieren oder um Vorhersagen zu treffen. Die Zeitreihendaten selbst sind eine beobachtete Reihe. Das beobachtete Phänomen kann im Grunde ein Zufallsprozess oder ein ordnungsgemäßer aber unregelmäßiger Prozess sein. Während im einfachen gleitenden Mittelwert die letzten Beobachtungen gleich gewichtet werden, verwendet exponentielles Glätten die exponentiell fallende Gewichtung im Laufe der Zeit." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533641726\n" +"par_id1002140\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 "Exponentielles Glätten wird im allgemeinen bei Finanzmarkt- und Wirtschaftsdaten angewendet, kann aber auch auf jede diskrete Reihe sich wiederholender Messungen angewendet werden. Die einfachste Form des exponentiellen Glättens sollte nur für Daten ohne irgendwelche systematischen Trends oder periodisches Verhalten verwendet werden." +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_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 "Weitere Informationen zur <emph>exponentiellen Glättung</emph> finden Sie in Wikipedia: <link href=\"http://de.wikipedia.org/wiki/Exponentielle_Glättung\">http://de.wikipedia.org/wiki/Exponentielle_Glättung</link>" +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id200820141553364794\n" +"hd_id1000120\n" "help.text" msgid "Parameters" msgstr "Parameter" @@ -66250,15 +66545,15 @@ msgstr "Parameter" #: 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 "<emph>Glättungsfaktor</emph>: Ein Parameter zwischen 0 und 1, der den Dämpfungsfaktor Alpha in der Glättungsgleichung darstellt." +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 "Die sich unten ergebende Glättung erfolgt mit dem Glättungsfaktor 0,5:" @@ -66266,7 +66561,7 @@ msgstr "Die sich unten ergebende Glättung erfolgt mit dem Glättungsfaktor 0,5: #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533725829\n" +"par_id1002180\n" "help.text" msgid "Alpha" msgstr "Alpha" @@ -66274,7 +66569,7 @@ msgstr "Alpha" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533712984\n" +"par_id1002200\n" "help.text" msgid "Column 1" msgstr "Spalte 1" @@ -66282,7 +66577,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764774\n" +"par_id1002210\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -66292,14 +66587,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>" -msgstr "<bookmark_value>Analysefunktionen; Gleitender Mittelwert</bookmark_value><bookmark_value>Gleitender Mittelwert; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistik; Gleitender Mittelwert</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 "Gleitender Mittelwert" @@ -66307,57 +66601,55 @@ msgstr "Gleitender Mittelwert" #: 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 "<ahelp hid=\"modules/scalc/ui/movingaveragedialog/MovingAverageDialog\">Berechnet den gleitenden Mittelwert einer Zeitreihe.</ahelp>" +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 "<variable id=\"sam01\">Wählen Sie im Menü <emph>Daten - Statistiken - Gleitender Mittelwert...</emph></variable>" +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." -msgstr "Ein gleitender Mittelwert ist in der Statistik eine Berechnung, bei der Datenpunkte analysiert werden, indem mehrere Mittelwerte von jeweils gleichgroßen Teilmengen eines Datensatzes berechnet werden. Der gleitende Mittelwert ist eine Art Filter mit endlicher Impulsantwort (FIR-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>" -msgstr "Weitere Informationen zum gleitenden Mittelwert finden Sie in Wikipedia: <link href=\"http://de.wikipedia.org/wiki/Gleitender_Mittelwert\">http://de.wikipedia.org/wiki/Gleitender_Mittelwert</link>" +msgid "Parameters" +msgstr "Parameter" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533751077\n" +"par_id1002530\n" "help.text" -msgid "Parameters" -msgstr "Parameter" +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." -msgstr "<emph>Intervall</emph>: Die Anzahl an Beispielen, die für die Berechnung des gleitenden Mittelwertes verwendet werden." +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 "Spalte 1" @@ -66365,7 +66657,7 @@ msgstr "Spalte 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533791711\n" +"par_id1002550\n" "help.text" msgid "Column 2" msgstr "Spalte 2" @@ -66373,7 +66665,7 @@ msgstr "Spalte 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533764431\n" +"par_id1002560\n" "help.text" msgid "#N/A" msgstr "#NV" @@ -66381,7 +66673,7 @@ msgstr "#NV" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533754380\n" +"par_id1002570\n" "help.text" msgid "#N/A" msgstr "#NV" @@ -66389,7 +66681,7 @@ msgstr "#NV" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533847092\n" +"par_id1002800\n" "help.text" msgid "#N/A" msgstr "#NV" @@ -66397,7 +66689,7 @@ msgstr "#NV" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533890018\n" +"par_id1002810\n" "help.text" msgid "#N/A" msgstr "#NV" @@ -66407,81 +66699,53 @@ 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>" -msgstr "<bookmark_value>Analysefunktionen; t-Test</bookmark_value><bookmark_value>t-Test; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistiken; t-Test</bookmark_value><bookmark_value>Analysefunktionen; F-Test</bookmark_value><bookmark_value>F-Test; Analysefunktionen</bookmark_value><bookmark_value>Datenstatistiken; 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" -msgstr "t-Test und F-Test" +msgid "t-test" +msgstr "t-Test" #: 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>" -msgstr "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Berechnet den t-Test oder F-Test zweier Beispieldaten.</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 "<variable id=\"sam01\">Wählen Sie im Menü <emph>Daten - Statsistiken - t-Test...</emph></variable>" - -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id050051\n" -"26\n" -"help.text" -msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - F-test...</emph></variable>" -msgstr "<variable id=\"sam02\">Wählen Sie im Menü <emph>Daten - Statistiken - F-Test...</emph></variable>" - -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id2008201415533888599\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." -msgstr "Ein <emph>t-Test</emph> ist ein statistischer Hypothesentest bei dem die Teststatistik der Student'schen Verteilung folgt, falls die Nullhypothese unterstützt wird. Er kann verwendet werden, um festzustellen, ob sich zwei Datensätze signifikant voneinander unterscheiden, und wird häufig verwendet, wenn eine Normalverteilung zugrunde liegt, für die der Wert des Skalierungsterms bekannt ist. Wenn der Skalierungsterm unbekannt ist und durch einen Schätzwert basierend auf dem Datensatz ersetzt wird, folgt die Teststatistik (unter bestimmten Voraussetzungen) einer Student'schen Verteilung." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533819476\n" +"par_id1002840\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." -msgstr "Ein <emph>F-Test</emph> ist jeglicher statistischer Test, in dem die Teststatistik eine F-Verteilung unter der Nullhypothese hat. Er wird meistens verwendet, wenn statistische Modelle miteinander verglichen werden sollen, die an einem Datensatz angepasst wurden, um dasjenige Modell zu identifizieren, welches am besten in die Population passt, von der die Daten abgefragt wurden. Exakte \"F-Tests\" kommen vor allem zum Einsatz, wenn die Modelle an die Daten angepasst wurden, die die kleinsten Quadrate haben." +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_id2008201415533844122\n" +"par_id1002850\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>" -msgstr "Weitere Informationen zum t-Test finden Sie in Wikipedia: <link href=\"http://de.wikipedia.org/wiki/T-Test\">http://de.wikipedia.org/wiki/T-Test</link>" - -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id2008201415533423222\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 "Weitere Informationen zum F-Test finden Sie in Wikipedia: <link href=\"http://de.wikipedia.org/wiki/F-Test\">http://de.wikipedia.org/wiki/F-Test</link>" +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533817070\n" +"hd_id1000160\n" "help.text" msgid "Data" msgstr "Daten" @@ -66489,47 +66753,47 @@ msgstr "Daten" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533823950\n" +"par_id1002860\n" "help.text" msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." -msgstr "<emph>Variable 1-Bereich</emph>: Der Bezug zum Bereich der ersten zu analysierenden Datenreihe." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533822766\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 "<emph>Variable 2-Bereich</emph>: Der Bezug zum Bereich der zweiten zu analysierenden Datenreihe." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533879965\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 "<emph>Ergebnisse nach</emph>: Der Bezug zur Zelle oben links des Bereichs, in dem der Test ausgegeben wird." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"hd_id2008201415533956416\n" +"hd_id1000170\n" "help.text" -msgid "Example for t-Test:" -msgstr "Beispiel für t-Test:" +msgid "Results for t-Test:" +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553388982\n" +"par_id1002890\n" "help.text" msgid "The following table shows the <emph>t-Test</emph> for the data series above:" -msgstr "Die folgenden Tabellen zeigen den <emph>t-Test</emph> für die Datenreihe oberhalb." +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533892337\n" +"par_id1002900\n" "help.text" msgid "t-test" msgstr "t-Test" @@ -66537,7 +66801,7 @@ msgstr "t-Test" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533864455\n" +"par_id1002910\n" "help.text" msgid "Alpha" msgstr "Alpha" @@ -66545,7 +66809,15 @@ msgstr "Alpha" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533863306\n" +"par_id1002930\n" +"help.text" +msgid "Hypothesized Mean Difference" +msgstr "Hypothetische Mittelwertdifferenz" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1002950\n" "help.text" msgid "Variable 1" msgstr "Variable 1" @@ -66553,7 +66825,7 @@ msgstr "Variable 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533818481\n" +"par_id1002960\n" "help.text" msgid "Variable 2" msgstr "Variable 2" @@ -66561,7 +66833,7 @@ msgstr "Variable 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533858438\n" +"par_id1002970\n" "help.text" msgid "Mean" msgstr "Mittelwert" @@ -66569,7 +66841,7 @@ msgstr "Mittelwert" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533897974\n" +"par_id1003000\n" "help.text" msgid "Variance" msgstr "Varianz" @@ -66577,7 +66849,7 @@ msgstr "Varianz" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533868040\n" +"par_id1003030\n" "help.text" msgid "Observations" msgstr "Beobachtungen" @@ -66585,7 +66857,7 @@ msgstr "Beobachtungen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533825806\n" +"par_id1003060\n" "help.text" msgid "Pearson Correlation" msgstr "Pearson-Korrelation" @@ -66593,15 +66865,7 @@ msgstr "Pearson-Korrelation" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533840871\n" -"help.text" -msgid "Hypothesized Mean Difference" -msgstr "Hypothetische Mittelwertdifferenz" - -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id2008201415533859489\n" +"par_id1003080\n" "help.text" msgid "Observed Mean Difference" msgstr "Beobachtete Mittelwertdifferenz" @@ -66609,7 +66873,7 @@ msgstr "Beobachtete Mittelwertdifferenz" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533826221\n" +"par_id1003100\n" "help.text" msgid "Variance of the Differences" msgstr "Varianz der Differenzen" @@ -66617,7 +66881,7 @@ msgstr "Varianz der Differenzen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533860284\n" +"par_id1003120\n" "help.text" msgid "df" msgstr "df" @@ -66625,7 +66889,7 @@ msgstr "df" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533871121\n" +"par_id1003140\n" "help.text" msgid "t Stat" msgstr "t-Statistik" @@ -66633,7 +66897,7 @@ msgstr "t-Statistik" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533822174\n" +"par_id1003160\n" "help.text" msgid "P (T<=t) one-tail" msgstr "P (T<=t) einseitig" @@ -66641,7 +66905,7 @@ msgstr "P (T<=t) einseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533811741\n" +"par_id1003180\n" "help.text" msgid "t Critical one-tail" msgstr "t kritisch, einseitig" @@ -66649,7 +66913,7 @@ msgstr "t kritisch, einseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533829667\n" +"par_id1003200\n" "help.text" msgid "P (T<=t) two-tail" msgstr "P (T<=t) beidseitig" @@ -66657,47 +66921,120 @@ msgstr "P (T<=t) beidseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533865577\n" +"par_id1003220\n" "help.text" -msgid "5.91750215348761E-010" -msgstr "5,91750215348761E-010" +msgid "t Critical two-tail" +msgstr "t kritisch, beidseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533931877\n" +"bm_id05002\n" "help.text" -msgid "t Critical two-tail" -msgstr "t kritisch, beidseitig" +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_id2008201415533942416\n" +"hd_id1000180\n" "help.text" -msgid "Example for F-Test:" -msgstr "Beispiel für F-Test:" +msgid "F-test" +msgstr "F-Test" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533978190\n" +"par_id1003240\n" "help.text" -msgid "The following table shows the <emph>F</emph><emph>-Test</emph> for the data series above:" -msgstr "Die folgende Tabelle zeigt den <emph>F-Test</emph> der Datenreihe oberhalb:" +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_id2008201415533950785\n" +"par_id1003250\n" "help.text" -msgid "F-test" +msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - F-test...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003260\n" +"help.text" +msgid "A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003270\n" +"help.text" +msgid "For more information on F-tests, see the Wikipedia: <link href=\"http://en.wikipedia.org/wiki/F-test\">http://en.wikipedia.org/wiki/F-test</link>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000190\n" +"help.text" +msgid "Data" +msgstr "Daten" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003280\n" +"help.text" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003290\n" +"help.text" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003300\n" +"help.text" +msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1000200\n" +"help.text" +msgid "Results for F-Test:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003310\n" +"help.text" +msgid "The following table shows the <emph>F-Test</emph> for the data series above:" +msgstr "" + +#: statistics.xhp +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"par_id1003320\n" +"help.text" +msgid "Ftest" msgstr "F-Test" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533911319\n" +"par_id1003330\n" "help.text" msgid "Alpha" msgstr "Alpha" @@ -66705,7 +67042,7 @@ msgstr "Alpha" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533999353\n" +"par_id1003350\n" "help.text" msgid "Variable 1" msgstr "Variable 1" @@ -66713,7 +67050,7 @@ msgstr "Variable 1" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533926248\n" +"par_id1003360\n" "help.text" msgid "Variable 2" msgstr "Variable 2" @@ -66721,7 +67058,7 @@ msgstr "Variable 2" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533918157\n" +"par_id1003370\n" "help.text" msgid "Mean" msgstr "Mittelwert" @@ -66729,7 +67066,7 @@ msgstr "Mittelwert" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id200820141553392922\n" +"par_id1003400\n" "help.text" msgid "Variance" msgstr "Varianz" @@ -66737,7 +67074,7 @@ msgstr "Varianz" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533924413\n" +"par_id1003430\n" "help.text" msgid "Observations" msgstr "Beobachtungen" @@ -66745,7 +67082,7 @@ msgstr "Beobachtungen" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533948860\n" +"par_id1003460\n" "help.text" msgid "df" msgstr "df" @@ -66753,15 +67090,15 @@ msgstr "df" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533928162\n" +"par_id1003490\n" "help.text" msgid "F" -msgstr "F" +msgstr "" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533996864\n" +"par_id1003510\n" "help.text" msgid "P (F<=f) right-tail" msgstr "P (F<=f) rechtsseitig" @@ -66769,7 +67106,7 @@ msgstr "P (F<=f) rechtsseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533921377\n" +"par_id1003530\n" "help.text" msgid "F Critical right-tail" msgstr "F kritisch, rechtsseitig" @@ -66777,7 +67114,7 @@ msgstr "F kritisch, rechtsseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533960592\n" +"par_id1003550\n" "help.text" msgid "P (F<=f) left-tail" msgstr "P (F<=f) linksseitig" @@ -66785,7 +67122,7 @@ msgstr "P (F<=f) linksseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533922655\n" +"par_id1003570\n" "help.text" msgid "F Critical left-tail" msgstr "F kritisch, linksseitig" @@ -66793,7 +67130,7 @@ msgstr "F kritisch, linksseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533918990\n" +"par_id1003590\n" "help.text" msgid "P two-tail" msgstr "P beidseitig" @@ -66801,11 +67138,361 @@ msgstr "P beidseitig" #: statistics.xhp msgctxt "" "statistics.xhp\n" -"par_id2008201415533940157\n" +"par_id1003610\n" "help.text" msgid "F Critical two-tail" msgstr "F kritisch, beidseitig" +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"bm_id05003\n" +"help.text" +msgid "<bookmark_value>Analysis toolpack;Z-test</bookmark_value><bookmark_value>Z-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Z-test</bookmark_value>" +msgstr "" + +#: statistics.xhp +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"hd_id1000210\n" +"help.text" +msgid "Z-test" +msgstr "t-Test" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003640\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the z-Test of two data samples.</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003650\n" +"help.text" +msgid "<variable id=\"sam02\">Menu <emph>Data - Statistics - Z-test...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003660\n" +"help.text" +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" +"hd_id1000220\n" +"help.text" +msgid "Data" +msgstr "Daten" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003670\n" +"help.text" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003680\n" +"help.text" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003690\n" +"help.text" +msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"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 +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"par_id1003710\n" +"help.text" +msgid "z-test" +msgstr "t-Test" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003720\n" +"help.text" +msgid "Alpha" +msgstr "Alpha" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003740\n" +"help.text" +msgid "Hypothesized Mean Difference" +msgstr "Hypothetische Mittelwertdifferenz" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003760\n" +"help.text" +msgid "Variable 1" +msgstr "Variable 1" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003770\n" +"help.text" +msgid "Variable 2" +msgstr "Variable 2" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003780\n" +"help.text" +msgid "Known Variance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003810\n" +"help.text" +msgid "Mean" +msgstr "Mittelwert" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003840\n" +"help.text" +msgid "Observations" +msgstr "Beobachtungen" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003870\n" +"help.text" +msgid "Observed Mean Difference" +msgstr "Beobachtete Mittelwertdifferenz" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003890\n" +"help.text" +msgid "z" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003900\n" +"help.text" +msgid "#DIV/0!" +msgstr "" + +#: statistics.xhp +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"par_id1003910\n" +"help.text" +msgid "P (Z<=z) one-tail" +msgstr "P (T<=t) einseitig" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003920\n" +"help.text" +msgid "#DIV/0!" +msgstr "" + +#: statistics.xhp +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"par_id1003930\n" +"help.text" +msgid "z Critical one-tail" +msgstr "t kritisch, einseitig" + +#: statistics.xhp +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"par_id1003950\n" +"help.text" +msgid "P (Z<=z) two-tail" +msgstr "P (T<=t) beidseitig" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1003960\n" +"help.text" +msgid "#DIV/0!" +msgstr "" + +#: statistics.xhp +#, fuzzy +msgctxt "" +"statistics.xhp\n" +"par_id1003970\n" +"help.text" +msgid "z Critical two-tail" +msgstr "t kritisch, beidseitig" + +#: 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 "Daten" + +#: 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 "Alpha" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004060\n" +"help.text" +msgid "df" +msgstr "df" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id1004080\n" +"help.text" +msgid "P-value" +msgstr "P-Wert" + +#: 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 msgctxt "" "text2columns.xhp\n" |