diff options
Diffstat (limited to 'source/ne/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/ne/helpcontent2/source/text/scalc/01.po | 8093 |
1 files changed, 8068 insertions, 25 deletions
diff --git a/source/ne/helpcontent2/source/text/scalc/01.po b/source/ne/helpcontent2/source/text/scalc/01.po index 7aeb80810c0..3dafc9bd6c3 100644 --- a/source/ne/helpcontent2/source/text/scalc/01.po +++ b/source/ne/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2014-05-30 13:09+0200\n" +"POT-Creation-Date: 2014-11-18 11:23+0100\n" "PO-Revision-Date: 2012-12-10 12:57+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -1629,6 +1629,406 @@ msgctxt "" msgid "The term \"increment\" denotes the amount by which a given value increases.<ahelp hid=\"modules/scalc/ui/filldlg/increment\"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected." msgstr "पद \"increment\" दिएको मान वृद्धि मात्रा बुझाउँदछ ।<ahelp hid=\"modules/scalc/ui/filldlg/increment\">प्रत्येक चरणद्वारा चयन गरेको प्रकार वृद्धिहरू श्रृङ्खलाहरूद्वारा मान निर्धारण गर्दछ ।</ahelp>प्रविष्टिहरू रेखात्मक मात्र बन्न सकेको खण्डमा वृद्धि वा मिति श्रृङ्खखला प्रकारहरू चयन हुन्छन् ।" +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"tit\n" +"help.text" +msgid "Fill Random Numbers" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431520596\n" +"help.text" +msgid "Fill Random Numbers" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431525817\n" +"help.text" +msgid "Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"bm_id2308201416102526759\n" +"help.text" +msgid "<bookmark_value>fill range;random numbers</bookmark_value><bookmark_value>random rumbers;fill range</bookmark_value><bookmark_value>random rumbers;distribution</bookmark_value>" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415500176457\n" +"help.text" +msgid "Menu <item type=\"menuitem\">Edit – Fill – Random Numbers</item>" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431233475\n" +"help.text" +msgid "Data" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431883475\n" +"help.text" +msgid "Cell Range" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431811111\n" +"help.text" +msgid "Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431850229\n" +"help.text" +msgid "Random number generator" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431880497\n" +"help.text" +msgid "Distribution" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431874867\n" +"help.text" +msgid "<ahelp hid=\"\">The distribution function for the random number generator.</ahelp>" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201416441240058\n" +"help.text" +msgid "Valid distributions function and their parameters are" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id230820141543181813\n" +"help.text" +msgid "Distribution" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431868807\n" +"help.text" +msgid "Parameters" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431869872\n" +"help.text" +msgid "Uniform" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431850857\n" +"help.text" +msgid "<emph>Minimum:</emph> The minimum value of the sample." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431859422\n" +"help.text" +msgid "<emph>Maximum:</emph> The maximum value of the sample." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431848733\n" +"help.text" +msgid "Uniform Integer" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431813421\n" +"help.text" +msgid "<emph>Minimum:</emph> The minimum value of the sample." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431821789\n" +"help.text" +msgid "<emph>Maximum:</emph> The maximum value of the sample." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431870493\n" +"help.text" +msgid "Normal" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431973994\n" +"help.text" +msgid "<emph>Mean:</emph> The mean of the Normal distribution." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431951090\n" +"help.text" +msgid "<emph>Standard Deviation:</emph> The standard deviation of the Normal distribution." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431990992\n" +"help.text" +msgid "The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431912748\n" +"help.text" +msgid "Cauchy" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431923135\n" +"help.text" +msgid "<emph>Median:</emph> the median of the data or location parameter." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431997296\n" +"help.text" +msgid "<emph>Sigma:</emph> the scale parameter." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431971536\n" +"help.text" +msgid "The median and sigma of the generated numbers may not equal the data inserted in the dialog." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431962173\n" +"help.text" +msgid "Bernoulli" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431994157\n" +"help.text" +msgid "<emph>p Value:</emph> The probability of success." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431979367\n" +"help.text" +msgid "Binomial" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431958372\n" +"help.text" +msgid "<emph>p Value:</emph> The probability of success of each trial." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431919718\n" +"help.text" +msgid "<emph>Number of trials:</emph> the number of trials of the experiment." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431985648\n" +"help.text" +msgid "Chi Squared" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id230820141543194944\n" +"help.text" +msgid "<emph>Nu Value: </emph>a positive integer that specifies the number of degrees of freedom." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431935636\n" +"help.text" +msgid "Geometric" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431978150\n" +"help.text" +msgid "<emph>p Value:</emph> The probability of success of each trial." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id230820141543197085\n" +"help.text" +msgid "Negative Binomial" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431916718\n" +"help.text" +msgid "<emph>p Value:</emph> The probability of success of each trial." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431951891\n" +"help.text" +msgid "<emph>Number of trials:</emph> the number of trials of the experiment." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431232932\n" +"help.text" +msgid "Options" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431832932\n" +"help.text" +msgid "Enable custom seed" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431841782\n" +"help.text" +msgid "Set the initial value of the random number generator to a known value <emph>Seed.</emph>" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431881107\n" +"help.text" +msgid "Seed" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431834837\n" +"help.text" +msgid "Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431875641\n" +"help.text" +msgid "Enable rounding" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431822157\n" +"help.text" +msgid "Truncate the number to a given number of <emph>Decimal Places</emph>." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"hd_id2308201415431826506\n" +"help.text" +msgid "Decimal places" +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id2308201415431820502\n" +"help.text" +msgid "Number of decimal places of the numbers generated." +msgstr "" + +#: 02140700.xhp +msgctxt "" +"02140700.xhp\n" +"par_id230820141705438801\n" +"help.text" +msgid "For more information on the distributions, see the Wikipedia" +msgstr "" + #: 02150000.xhp msgctxt "" "02150000.xhp\n" @@ -2024,8 +2424,8 @@ msgctxt "" "par_id3145801\n" "7\n" "help.text" -msgid "You cannot delete a sheet while <emph>Edit - Changes - Record</emph> is activated." -msgstr "जब <emph>सम्पादन गर्नुहोस् - परिवर्तन गर्नुहोस् - रेकर्ड गर्नुहोस्</emph>को रूपमा सक्रिय गरिन्छ, रेकर्ड गरिसकेका कागजातमा परिवर्तन गरेको खण्डमा तपाईँं पाना मेट्न सक्नुहुन्न ।" +msgid "You cannot delete a sheet while <emph>Edit - Track Changes - Record Changes</emph> is activated." +msgstr "" #: 02170000.xhp msgctxt "" @@ -14364,6 +14764,166 @@ msgstr "=CEILING( -11; -2; 1) ले -12 फर्काउँछ" #: 04060106.xhp msgctxt "" "04060106.xhp\n" +"bm_id2952518\n" +"help.text" +msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id2952518\n" +"332\n" +"help.text" +msgid "CEILING.PRECISE" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2953422\n" +"558\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id2953440\n" +"334\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2953454\n" +"335\n" +"help.text" +msgid "CEILING.PRECISE(Number; Significance)" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2953467\n" +"336\n" +"help.text" +msgid "<emph>Number</emph> (required) is the number that is to be rounded up." +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2955000\n" +"337\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up." +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id2945697\n" +"338\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2945710\n" +"339\n" +"help.text" +msgid "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> returns -10" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"bm_id8952518\n" +"help.text" +msgid "<bookmark_value>ISO.CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id8952518\n" +"332\n" +"help.text" +msgid "ISO.CEILING" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id8953422\n" +"558\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id8953440\n" +"334\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id8953454\n" +"335\n" +"help.text" +msgid "ISO.CEILING(Number; Significance)" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id8953467\n" +"336\n" +"help.text" +msgid "<emph>Number</emph> (required) is the number that is to be rounded up." +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id8955000\n" +"337\n" +"help.text" +msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up." +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id8945697\n" +"338\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id8945710\n" +"339\n" +"help.text" +msgid "<item type=\"input\">=ISO.CEILING(-11;-2)</item> returns -10" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" "bm_id3157762\n" "help.text" msgid "<bookmark_value>PI function</bookmark_value>" @@ -16699,6 +17259,86 @@ msgstr "यदि सङ्ख्या १.०१ प्रविष्टि #: 04060106.xhp msgctxt "" "04060106.xhp\n" +"bm_id2957404\n" +"help.text" +msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id2957404\n" +"512\n" +"help.text" +msgid "FLOOR.PRECISE" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2957432\n" +"513\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp>" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id2957451\n" +"514\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2957464\n" +"515\n" +"help.text" +msgid "FLOOR.PRECISE(Number; Significance)" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2957478\n" +"516\n" +"help.text" +msgid "<emph>Number</emph> is the number that is to be rounded down." +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2957497\n" +"517\n" +"help.text" +msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down." +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id2963932\n" +"518\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id2963945\n" +"519\n" +"help.text" +msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12" +msgstr "" + +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" "bm_id3157404\n" "help.text" msgid "<bookmark_value>FLOOR function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" @@ -24938,6 +25578,86 @@ msgstr "LEFT(\"output\";3) ले <emph>बाहिर</emph> फर्का #: 04060110.xhp msgctxt "" "04060110.xhp\n" +"bm_id2947083\n" +"help.text" +msgid "<bookmark_value>LEFTB function</bookmark_value>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2947083\n" +"95\n" +"help.text" +msgid "LEFTB" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2953622\n" +"96\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_LEFTB\">Returns the first characters of a DBCS text.</ahelp>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2956116\n" +"97\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2946786\n" +"98\n" +"help.text" +msgid "LEFTB(\"Text\"; Number_bytes)" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2947274\n" +"99\n" +"help.text" +msgid "<emph>Text</emph> is the text where the initial partial words are to be determined." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2953152\n" +"100\n" +"help.text" +msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2950260\n" +"101\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2949141\n" +"102\n" +"help.text" +msgid "<item type=\"input\">=LEFTB(\"output\";3)</item> returns “out”." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" "bm_id3156110\n" "help.text" msgid "<bookmark_value>LEN function</bookmark_value>" @@ -25018,6 +25738,86 @@ msgstr "LEN(12345.67)ले <emph>८</emph>फर्काउँदछ ।" #: 04060110.xhp msgctxt "" "04060110.xhp\n" +"bm_id2956110\n" +"help.text" +msgid "<bookmark_value>LENB function</bookmark_value>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2956110\n" +"104\n" +"help.text" +msgid "LENB" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2950147\n" +"105\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_LENB\">For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.</ahelp>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2955108\n" +"106\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2954063\n" +"107\n" +"help.text" +msgid "LENB(\"Text\")" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2946894\n" +"108\n" +"help.text" +msgid "<emph>Text</emph> is the text whose length is to be determined." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2953884\n" +"109\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2956008\n" +"110\n" +"help.text" +msgid "<item type=\"input\">=LENB(\"Good Afternoon\")</item> returns 14." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2954300\n" +"111\n" +"help.text" +msgid "<item type=\"input\">=LENB(12345.67)</item> returns 8." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" "bm_id3153983\n" "help.text" msgid "<bookmark_value>LOWER function</bookmark_value>" @@ -25178,6 +25978,95 @@ msgstr "MID(\"Sun Microsystems\";5;5)ले <emph>माइक्रो</emph> #: 04060110.xhp msgctxt "" "04060110.xhp\n" +"bm_id2954589\n" +"help.text" +msgid "<bookmark_value>MIDB function</bookmark_value>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2954589\n" +"148\n" +"help.text" +msgid "MIDB" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2954938\n" +"149\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_MIDB\">Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters.</ahelp>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2948829\n" +"150\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2950526\n" +"151\n" +"help.text" +msgid "MIDB(\"Text\"; Start; Number_bytes)" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2948820\n" +"152\n" +"help.text" +msgid "<emph>Text</emph> is the text containing the characters to extract." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2950774\n" +"153\n" +"help.text" +msgid "<emph>Start</emph> is the position of the first character in the text to extract." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2953063\n" +"154\n" +"help.text" +msgid "<emph>Number_bytes</emph> specifies the number of characters MIDB will return from text, in bytes." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2950509\n" +"155\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2958407\n" +"156\n" +"help.text" +msgid "<item type=\"input\">=MIDB(\"office\";2;2)</item> returns ff." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" "bm_id3159143\n" "help.text" msgid "<bookmark_value>PROPER function</bookmark_value>" @@ -25525,6 +26414,86 @@ msgstr "RIGHT(\"Sun\";2) ले <emph>un</emph> फर्काउँदछ ।" #: 04060110.xhp msgctxt "" "04060110.xhp\n" +"bm_id2949805\n" +"help.text" +msgid "<bookmark_value>RIGHTB function</bookmark_value>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2949805\n" +"113\n" +"help.text" +msgid "RIGHTB" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2945375\n" +"114\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RIGHTB\">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp>" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2950837\n" +"115\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2954344\n" +"116\n" +"help.text" +msgid "RIGHTB(\"Text\"; Number_bytes)" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2949426\n" +"117\n" +"help.text" +msgid "<emph>Text</emph> is the text of which the right part is to be determined." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2953350\n" +"118\n" +"help.text" +msgid "<emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"hd_id2948661\n" +"119\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id2951132\n" +"120\n" +"help.text" +msgid "<item type=\"input\">=RIGHTB(\"Sun\";2)</item> returns un." +msgstr "" + +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" "bm_id3153534\n" "help.text" msgid "<bookmark_value>ROMAN function</bookmark_value>" @@ -29875,6 +30844,86 @@ msgstr "=ERF(0;1) ले ०.८४२७०१ फर्काउँदछ ।" #: 04060115.xhp msgctxt "" "04060115.xhp\n" +"bm_id2983446\n" +"help.text" +msgid "<bookmark_value>ERF.PRECISE function</bookmark_value><bookmark_value>Gaussian error integral</bookmark_value>" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"hd_id2983446\n" +"135\n" +"help.text" +msgid "ERF.PRECISE" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2950381\n" +"136\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ERF_MS\">Returns values of the Gaussian error integral.</ahelp>" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"hd_id2952475\n" +"137\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2963824\n" +"138\n" +"help.text" +msgid "ERF(LowerLimit; UpperLimit)" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2949715\n" +"139\n" +"help.text" +msgid "<emph>LowerLimit</emph> is the lower limit of the integral." +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2956294\n" +"140\n" +"help.text" +msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit." +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"hd_id2954819\n" +"141\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2952974\n" +"142\n" +"help.text" +msgid "<item type=\"input\">=ERF.PRECISE(0;1)</item> returns 0.842701." +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" "bm_id3145082\n" "help.text" msgid "<bookmark_value>ERFC function</bookmark_value>" @@ -29946,6 +30995,77 @@ msgstr "=ERFC(1)ले ०.१५७२९९ फर्काउँदछ ।" #: 04060115.xhp msgctxt "" "04060115.xhp\n" +"bm_id2945082\n" +"help.text" +msgid "<bookmark_value>ERFC.PRECISE function</bookmark_value>" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"hd_id2945082\n" +"143\n" +"help.text" +msgid "ERFC.PRECISE" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2949453\n" +"144\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ERFC_MS\">Returns complementary values of the Gaussian error integral between x and infinity.</ahelp>" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"hd_id2955839\n" +"145\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2953220\n" +"146\n" +"help.text" +msgid "ERFC.PRECISE(LowerLimit)" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2947620\n" +"147\n" +"help.text" +msgid "<emph>LowerLimit</emph> is the lower limit of the integral" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"hd_id2946861\n" +"148\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"par_id2956102\n" +"149\n" +"help.text" +msgid "<item type=\"input\">=ERFC.PRECISE(1)</item> returns 0.157299." +msgstr "" + +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" "bm_id3152927\n" "help.text" msgid "<bookmark_value>GESTEP function</bookmark_value><bookmark_value>numbers;greater than or equal to</bookmark_value>" @@ -30055,8 +31175,8 @@ msgctxt "" "par_id3152810\n" "83\n" "help.text" -msgid "<emph>Number</emph> is a hexadecimal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement." -msgstr "सङ्ख्या: हेक्सादशमलब सङ्ख्या । सङ्ख्यासँग अधिक्तम रूपमा १० स्थानहरू हुन सक्छ । अति महत्वपूर्ण बिट साइन बिट हो, निम्न बिटले मान फर्काउँछ । ऋणात्मक सङ्ख्याहरू दुई पूरकको रुपमा प्रविष्टि भएका छन् ।" +msgid "<emph>Number</emph> is a hexadecimal number or a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement." +msgstr "" #: 04060115.xhp msgctxt "" @@ -30082,8 +31202,8 @@ msgctxt "" "par_id3156002\n" "86\n" "help.text" -msgid "<item type=\"input\">=HEX2BIN(64;8)</item> returns 01100100." -msgstr "=HEX2BIN(64;8)ले ०११००१०० फर्काउँदछ ।" +msgid "<item type=\"input\">=HEX2BIN(\"6a\";8)</item> returns 01101010." +msgstr "" #: 04060115.xhp msgctxt "" @@ -30135,8 +31255,8 @@ msgctxt "" "par_id3159176\n" "91\n" "help.text" -msgid "<emph>Number</emph> is a hexadecimal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement." -msgstr "सङ्ख्या: हेक्सादशमलब सङ्ख्या । सङ्ख्यासँग अधिक्तम रूपमा १० स्थानहरू हुन सक्छ । अति महत्वपूर्ण बिट साइन बिट हो, निम्न बिटले मान फर्काउँछ । ऋणात्मक सङ्ख्याहरू दुई पूरकको रुपमा प्रविष्टि भएका छन् ।" +msgid "<emph>Number</emph> is a hexadecimal number or a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement." +msgstr "" #: 04060115.xhp msgctxt "" @@ -30153,8 +31273,8 @@ msgctxt "" "par_id3146093\n" "93\n" "help.text" -msgid "<item type=\"input\">=HEX2DEC(64)</item> returns 100." -msgstr "=HEX2DEC(64) ले १०० फर्काउँदछ ।" +msgid "<item type=\"input\">=HEX2DEC(\"6a\")</item> returns 106." +msgstr "" #: 04060115.xhp msgctxt "" @@ -30206,8 +31326,8 @@ msgctxt "" "par_id3152795\n" "98\n" "help.text" -msgid "<emph>Number</emph> is a hexadecimal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement." -msgstr "सङ्ख्या: हेक्सादशमलब सङ्ख्या । सङ्ख्यासँग अधिक्तम रूपमा १० स्थानहरू हुन सक्छ । अति महत्वपूर्ण बिट साइन बिट हो, निम्न बिटले मान फर्काउँछ । ऋणात्मक सङ्ख्याहरू दुई पूरकको रुपमा प्रविष्टि भएका छन् ।" +msgid "<emph>Number</emph> is a hexadecimal number or a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement." +msgstr "" #: 04060115.xhp msgctxt "" @@ -30233,8 +31353,8 @@ msgctxt "" "par_id3159341\n" "101\n" "help.text" -msgid "<item type=\"input\">=HEX2OCT(64;4)</item> returns 0144." -msgstr "=HEX2OCT(64;4) ले ०१४४ फर्काउँदछ ।" +msgid "<item type=\"input\">=HEX2OCT(\"6a\";4)</item> returns 0152." +msgstr "" #: 04060116.xhp msgctxt "" @@ -38756,6 +39876,121 @@ msgstr "=BETAINV(०.५; ५; १०)ले मान ०.३३ फर्क #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2945620\n" +"help.text" +msgid "<bookmark_value>BETA.INV function</bookmark_value> <bookmark_value>cumulative probability density function;inverse of</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2945620\n" +"52\n" +"help.text" +msgid "BETA.INV" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949825\n" +"53\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_BETAINV_MS\">Returns the inverse of the cumulative beta probability density function.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2952479\n" +"54\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956300\n" +"55\n" +"help.text" +msgid "BETA.INV(Number; Alpha; Beta; Start; End)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949266\n" +"56\n" +"help.text" +msgid "<emph>Number</emph> is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949710\n" +"57\n" +"help.text" +msgid "<emph>Alpha</emph> is a parameter to the distribution." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956306\n" +"58\n" +"help.text" +msgid "<emph>Beta</emph> is a parameter to the distribution." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950960\n" +"59\n" +"help.text" +msgid "<emph>Start</emph> (optional) is the lower bound for <emph>Number</emph>." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2951268\n" +"60\n" +"help.text" +msgid "<emph>End</emph> (optional) is the upper bound for <emph>Number</emph>." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_idN109DFms\n" +"help.text" +msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2947077\n" +"61\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2946859\n" +"62\n" +"help.text" +msgid "<item type=\"input\">=BETA.INV(0.5;5;10)</item> returns the value 0.3257511553." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3156096\n" "help.text" msgid "<bookmark_value>BETADIST function</bookmark_value> <bookmark_value>cumulative probability density function;calculating</bookmark_value>" @@ -38879,6 +40114,138 @@ msgstr "=BETADIST(०.५७; ३; ४)ले मान ०९६ फर्क #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2956096\n" +"help.text" +msgid "<bookmark_value>BETA.DIST function</bookmark_value> <bookmark_value>cumulative probability density function;calculating</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2956096\n" +"64\n" +"help.text" +msgid "BETA.DIST" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950880\n" +"65\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_BETADIST_MS\">Returns the beta function.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2950762\n" +"66\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2947571\n" +"67\n" +"help.text" +msgid "BETA.DIST(Number; Alpha; Beta; Cumulative; Start; End)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956317\n" +"68\n" +"help.text" +msgid "<emph>Number</emph> (required) is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956107\n" +"69\n" +"help.text" +msgid "<emph>Alpha</emph> (required) is a parameter to the distribution." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2953619\n" +"70\n" +"help.text" +msgid "<emph>Beta</emph> (required) is a parameter to the distribution." +msgstr "" + +#: 04060181.xhp +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 "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950254\n" +"71\n" +"help.text" +msgid "<emph>Start</emph> (optional) is the lower bound for <emph>Number</emph>." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949138\n" +"72\n" +"help.text" +msgid "<emph>End</emph> (optional) is the upper bound for <emph>Number</emph>." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_idN10AB3ms\n" +"help.text" +msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2945649\n" +"73\n" +"help.text" +msgid "Examples" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956118\n" +"74\n" +"help.text" +msgid "<item type=\"input\">=BETA.DIST(2;8;10;1;1;3)</item> returns the value 0.6854706" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956119\n" +"74\n" +"help.text" +msgid "<item type=\"input\">=BETA.DIST(2;8;10;0;1;3)</item> returns the value 1.4837646" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3143228\n" "help.text" msgid "<bookmark_value>BINOMDIST function</bookmark_value>" @@ -38986,6 +40353,202 @@ msgstr "=BINOMDIST(A1; 12; 0.5; 1) उही श्रृङ्खलाका #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2943228\n" +"help.text" +msgid "<bookmark_value>BINOM.DIST function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2943228\n" +"76\n" +"help.text" +msgid "BINOM.DIST" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2946897\n" +"77\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_BINOM_DIST_MS\">Returns the individual term binomial distribution probability.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2949289\n" +"78\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956009\n" +"79\n" +"help.text" +msgid "BINOM.DIST(X; Trials; SP; C)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2954304\n" +"80\n" +"help.text" +msgid "<emph>X</emph> is the number of successes in a set of trials." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2947492\n" +"81\n" +"help.text" +msgid "<emph>Trials</emph> is the number of independent trials." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2946085\n" +"82\n" +"help.text" +msgid "<emph>SP</emph> is the probability of success on each trial." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id299760\n" +"83\n" +"help.text" +msgid "<emph>C</emph> = 0 calculates the probability of a single event and <emph>C</emph> = 1 calculates the cumulative probability." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id291171\n" +"84\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id295666\n" +"85\n" +"help.text" +msgid "<item type=\"input\">=BINOM.DIST(A1;12;0.5;0)</item> shows (if the values <item type=\"input\">0</item> to <item type=\"input\">12</item> are entered in A1) the probabilities for 12 flips of a coin that <emph>Heads</emph> will come up exactly the number of times entered in A1." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id290120\n" +"86\n" +"help.text" +msgid "<item type=\"input\">=BINOM.DIST(A1;12;0.5;1)</item> shows the cumulative probabilities for the same series. For example, if A1 = <item type=\"input\">4</item>, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR)." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"bm_id2843228\n" +"help.text" +msgid "<bookmark_value>BINOM.INV function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2843228\n" +"76\n" +"help.text" +msgid "BINOM.INV" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2846897\n" +"77\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_BINOM_INV_MS\">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2849289\n" +"78\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2856009\n" +"79\n" +"help.text" +msgid "BINOM.INV(Trials; SP; Alpha)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2847492\n" +"81\n" +"help.text" +msgid "<emph>Trials</emph> The total number of trials." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2846085\n" +"82\n" +"help.text" +msgid "<emph>SP</emph> is the probability of success on each trial." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id289760\n" +"83\n" +"help.text" +msgid "<emph>Alpha</emph>The border probability that is attained or exceeded." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id281171\n" +"84\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id285666\n" +"85\n" +"help.text" +msgid "<item type=\"input\">=BINOM.INV(8;0.6;0.9)</item> returns 7, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id0119200902432928\n" "help.text" msgid "<bookmark_value>CHISQINV function</bookmark_value>" @@ -39034,6 +40597,81 @@ msgstr "<emph>Degrees_freedom</emph> परीक्षण स्वतन्त #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2919200902432928\n" +"help.text" +msgid "<bookmark_value>CHISQ.INV function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2919200902421451\n" +"help.text" +msgid "CHISQ.INV" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2919200902421449\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CHISQINV_MS\">Returns the inverse of the left-tailed probability of the chi-square distribution.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2919200902475241\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id1150504\n" +"91\n" +"help.text" +msgid "CHISQ.INV(Probability; DegreesFreedom)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2919200902475286\n" +"help.text" +msgid "<emph>Probability</emph> is the probability value for which the inverse of the chi-square distribution is to be calculated." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2919200902475282\n" +"help.text" +msgid "<emph>Degrees Of Freedom</emph> is the degrees of freedom for the chi-square function." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id271171\n" +"84\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id275666\n" +"85\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.INV(0,5;1)</item> returns 0.4549364231." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3148835\n" "help.text" msgid "<bookmark_value>CHIINV function</bookmark_value>" @@ -39159,6 +40797,131 @@ msgstr "यदि गल्तीको सम्भाव्यता ५% छ #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2948835\n" +"help.text" +msgid "<bookmark_value>CHISQ.INV.RT function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2948835\n" +"88\n" +"help.text" +msgid "CHISQ.INV.RT" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949906\n" +"89\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CHISQINV_MS\">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2959157\n" +"90\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950504\n" +"91\n" +"help.text" +msgid "CHISQ.INV.RT(Number; DegreesFreedom)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2954898\n" +"92\n" +"help.text" +msgid "<emph>Number</emph> is the value of the error probability." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2954294\n" +"93\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> is the degrees of freedom of the experiment." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2954208\n" +"94\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950777\n" +"130\n" +"help.text" +msgid "A die is thrown 1020 times. The numbers on the die 1 through 6 come up 195, 151, 148, 189, 183 and 154 times (observation values). The hypothesis that the die is not fixed is to be tested." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2953062\n" +"131\n" +"help.text" +msgid "The Chi square distribution of the random sample is determined by the formula given above. Since the expected value for a given number on the die for n throws is n times 1/6, thus 1020/6 = 170, the formula returns a Chi square value of 13.27." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2948806\n" +"132\n" +"help.text" +msgid "If the (observed) Chi square is greater than or equal to the (theoretical) Chi square CHIINV, the hypothesis will be discarded, since the deviation between theory and experiment is too great. If the observed Chi square is less that CHIINV, the hypothesis is confirmed with the indicated probability of error." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949763\n" +"95\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.INV.RT(0.05;5)</item> returns 11.0704976935." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2959142\n" +"133\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.INV.RT(0.02;5)</item> returns 13.388222599." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2958401\n" +"134\n" +"help.text" +msgid "If the probability of error is 5%, the die is not true. If the probability of error is 2%, there is no reason to believe it is fixed." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3154260\n" "help.text" msgid "<bookmark_value>CHITEST function</bookmark_value>" @@ -39428,6 +41191,275 @@ msgstr "=CHITEST(A1:A6; B1:B6) बराबर ०.०२ हुन्छ । #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2954260\n" +"help.text" +msgid "<bookmark_value>CHISQ.TEST function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2954260\n" +"97\n" +"help.text" +msgid "CHISQ.TEST" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"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 "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"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 "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2954280\n" +"99\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949162\n" +"100\n" +"help.text" +msgid "CHISQ.TEST(DataB; DataE)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2958421\n" +"101\n" +"help.text" +msgid "<emph>DataB</emph> is the array of the observations." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2966453\n" +"102\n" +"help.text" +msgid "<emph>DataE</emph> is the range of the expected values." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2946946\n" +"103\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2954096\n" +"136\n" +"help.text" +msgid "Data_B (observed)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2952948\n" +"137\n" +"help.text" +msgid "Data_E (expected)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2952876\n" +"138\n" +"help.text" +msgid "1" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2959279\n" +"139\n" +"help.text" +msgid "<item type=\"input\">195</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949105\n" +"140\n" +"help.text" +msgid "<item type=\"input\">170</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949922\n" +"141\n" +"help.text" +msgid "2" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2948621\n" +"142\n" +"help.text" +msgid "<item type=\"input\">151</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2948987\n" +"143\n" +"help.text" +msgid "<item type=\"input\">170</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949417\n" +"144\n" +"help.text" +msgid "3" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2948661\n" +"145\n" +"help.text" +msgid "<item type=\"input\">148</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2951128\n" +"146\n" +"help.text" +msgid "<item type=\"input\">170</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2948467\n" +"147\n" +"help.text" +msgid "4" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949237\n" +"148\n" +"help.text" +msgid "<item type=\"input\">189</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2945304\n" +"149\n" +"help.text" +msgid "<item type=\"input\">170</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949927\n" +"150\n" +"help.text" +msgid "5" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950630\n" +"151\n" +"help.text" +msgid "<item type=\"input\">183</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950423\n" +"152\n" +"help.text" +msgid "<item type=\"input\">170</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2943275\n" +"153\n" +"help.text" +msgid "6" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2944750\n" +"154\n" +"help.text" +msgid "<item type=\"input\">154</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2953947\n" +"155\n" +"help.text" +msgid "<item type=\"input\">170</item>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949481\n" +"104\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.TEST(A1:A6;B1:B6)</item> equals 0.0209708029. This is the probability which suffices the observed data of the theoretical Chi-square distribution." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id3148690\n" "help.text" msgid "<bookmark_value>CHIDIST function</bookmark_value>" @@ -39526,6 +41558,201 @@ msgstr "यदि अनियमित नमूनाको ची वर् #: 04060181.xhp msgctxt "" "04060181.xhp\n" +"bm_id2848690\n" +"help.text" +msgid "<bookmark_value>CHISQ.DIST function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2848690\n" +"106\n" +"help.text" +msgid "CHISQ.DIST" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2856338\n" +"156\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CHISQDIST_MS\">Returns the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2855123\n" +"108\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2858439\n" +"109\n" +"help.text" +msgid "CHISQ.DIST(Number; DegreesFreedom; Cumulative)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2848675\n" +"110\n" +"help.text" +msgid "<emph>Number</emph> is the chi-square value of the random sample used to determine the error probability." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2855615\n" +"111\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> are the degrees of freedom of the experiment." +msgstr "" + +#: 04060181.xhp +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 "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2846787\n" +"112\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2845774\n" +"113\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.DIST(3; 2; 0) </item> equals 0.1115650801, the probability density function with 2 degrees of freedom, at x = 3." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2745774\n" +"113\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.DIST(3; 2; 1) </item> equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"bm_id2948690\n" +"help.text" +msgid "<bookmark_value>CHISQ.DIST.RT function</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2948690\n" +"106\n" +"help.text" +msgid "CHISQ.DIST.RT" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956338\n" +"156\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CHISQDIST_MS\">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2951316\n" +"157\n" +"help.text" +msgid "The probability determined by CHISQ.DIST.RT can also be determined by CHITEST." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2955123\n" +"108\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2958439\n" +"109\n" +"help.text" +msgid "CHISQ.DIST.RT(Number; DegreesFreedom)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2948675\n" +"110\n" +"help.text" +msgid "<emph>Number</emph> is the chi-square value of the random sample used to determine the error probability." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2955615\n" +"111\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> are the degrees of freedom of the experiment." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2946787\n" +"112\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2945774\n" +"113\n" +"help.text" +msgid "<item type=\"input\">=CHISQ.DIST.RT(13.27; 5)</item> equals 0.0209757694." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2956141\n" +"158\n" +"help.text" +msgid "If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of 2%." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" "bm_id0119200902231887\n" "help.text" msgid "<bookmark_value>CHISQDIST function</bookmark_value><bookmark_value>chi-square distribution</bookmark_value>" @@ -39676,6 +41903,95 @@ msgctxt "" msgid "<item type=\"input\">=EXPONDIST(3;0.5;1)</item> returns 0.78." msgstr "=EXPONDIST(3; 0.5; 1)ले ०.७८ फर्काउँदछ ।" +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"bm_id2950603\n" +"help.text" +msgid "<bookmark_value>EXPON.DIST function</bookmark_value> <bookmark_value>exponential distributions</bookmark_value>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2950603\n" +"115\n" +"help.text" +msgid "EXPON.DIST" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2949563\n" +"116\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_EXP_DIST_MS\">Returns the exponential distribution.</ahelp>" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2953789\n" +"117\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950987\n" +"118\n" +"help.text" +msgid "EXPON.DIST(Number; Lambda; C)" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2954663\n" +"119\n" +"help.text" +msgid "<emph>Number</emph> is the value of the function." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2954569\n" +"120\n" +"help.text" +msgid "<emph>Lambda</emph> is the parameter value." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2947332\n" +"121\n" +"help.text" +msgid "<emph>C</emph> is a logical value that determines the form of the function. <emph>C = 0</emph> calculates the density function, and <emph>C = 1</emph> calculates the distribution." +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"hd_id2946133\n" +"122\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060181.xhp +msgctxt "" +"04060181.xhp\n" +"par_id2950357\n" +"123\n" +"help.text" +msgid "<item type=\"input\">=EXPON.DIST(3;0.5;1)</item> returns 0.7768698399." +msgstr "" + #: 04060182.xhp msgctxt "" "04060182.xhp\n" @@ -39785,6 +42101,184 @@ msgstr "=FINV(0.5; 5; 10) उपजहरू ०.९३ ।" #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id2945388\n" +"help.text" +msgid "<bookmark_value>F.INV function</bookmark_value> <bookmark_value>Values of the inverse left tail of the F distribution</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2945388\n" +"2\n" +"help.text" +msgid "F.INV" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2955089\n" +"3\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_F_INV_LT\">Returns the inverse of the cumulative F distribution.</ahelp> The F distribution is used for F tests in order to set the relation between two differing data sets." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2953816\n" +"4\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2953068\n" +"5\n" +"help.text" +msgid "F.INV(Number; DegreesFreedom1; DegreesFreedom2)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2946866\n" +"6\n" +"help.text" +msgid "<emph>Number</emph> is probability value for which the inverse F distribution is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2953914\n" +"7\n" +"help.text" +msgid "<emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2948607\n" +"8\n" +"help.text" +msgid "<emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2956021\n" +"9\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2945073\n" +"10\n" +"help.text" +msgid "<item type=\"input\">=F.INV(0.5;5;10)</item> yields 0.9319331609." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"bm_id2845388\n" +"help.text" +msgid "<bookmark_value>F.INV.RT function</bookmark_value> <bookmark_value>Values of the inverse right tail of the F distribution</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2845388\n" +"2\n" +"help.text" +msgid "F.INV.RT" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2855089\n" +"3\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_F_INV_RT\">Returns the inverse right tail of the F distribution.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2853816\n" +"4\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2853068\n" +"5\n" +"help.text" +msgid "F.INV.RT(Number; DegreesFreedom1; DegreesFreedom2)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2846866\n" +"6\n" +"help.text" +msgid "<emph>Number</emph> is probability value for which the inverse F distribution is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2853914\n" +"7\n" +"help.text" +msgid "<emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2848607\n" +"8\n" +"help.text" +msgid "<emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2856021\n" +"9\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2845073\n" +"10\n" +"help.text" +msgid "<item type=\"input\">=F.INV.RT(0.5;5;10)</item> yields 0.9319331609." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id3150888\n" "help.text" msgid "<bookmark_value>FISHER function</bookmark_value>" @@ -40007,6 +42501,86 @@ msgstr "=FTEST(A1:A30; B1:B12) तिनीहरूको भेरियन् #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id2951390\n" +"help.text" +msgid "<bookmark_value>F.TEST function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2951390\n" +"28\n" +"help.text" +msgid "F.TEST" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950534\n" +"29\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_F_TEST_MS\">Returns the result of an F test.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2966466\n" +"30\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2953024\n" +"31\n" +"help.text" +msgid "F.TEST(Data1; Data2)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950032\n" +"32\n" +"help.text" +msgid "<emph>Data1</emph> is the first record array." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2953018\n" +"33\n" +"help.text" +msgid "<emph>Data2</emph> is the second record array." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2953123\n" +"34\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2959126\n" +"35\n" +"help.text" +msgid "<item type=\"input\">=F.TEST(A1:A30;B1:B12)</item> calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id3150372\n" "help.text" msgid "<bookmark_value>FDIST function</bookmark_value>" @@ -40096,6 +42670,202 @@ msgstr "=FDIST(0.8; 8; 12) उपजहरू ०.६१ ।" #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id2950372\n" +"help.text" +msgid "<bookmark_value>F.DIST function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2950372\n" +"37\n" +"help.text" +msgid "F.DIST" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2952981\n" +"38\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_F_DIST_LT\">Calculates the values of the left tail of the F distribution.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2950484\n" +"39\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2945826\n" +"40\n" +"help.text" +msgid "F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950461\n" +"41\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the F distribution is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950029\n" +"42\n" +"help.text" +msgid "<emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2946877\n" +"43\n" +"help.text" +msgid "<emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2946878\n" +"43\n" +"help.text" +msgid "<emph>Cumulative</emph> = 0 or False calculates the density function <emph>Cumulative</emph> = 1 or True calculates the distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2947423\n" +"44\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950696\n" +"45\n" +"help.text" +msgid "<item type=\"input\">=F.DIST(0.8;8;12;0)</item> yields 0.7095282499." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950697\n" +"45\n" +"help.text" +msgid "<item type=\"input\">=F.DIST(0.8;8;12;1)</item> yields 0.3856603563." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"bm_id2850372\n" +"help.text" +msgid "<bookmark_value>F.DIST.RT function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id280372\n" +"37\n" +"help.text" +msgid "F.DIST.RT" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2852981\n" +"38\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_F_DIST_RT\">Calculates the values of the right tail of the F distribution.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2850484\n" +"39\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2845826\n" +"40\n" +"help.text" +msgid "F.DIST.RT(Number; DegreesFreedom1; DegreesFreedom2)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2850461\n" +"41\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the F distribution is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2850029\n" +"42\n" +"help.text" +msgid "<emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2846877\n" +"43\n" +"help.text" +msgid "<emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2847423\n" +"44\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2850696\n" +"45\n" +"help.text" +msgid "<item type=\"input\">=F.DIST.RT(0.8;8;12)</item> yields 0.6143396437." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id0119200903223192\n" "help.text" msgid "<bookmark_value>GAMMA function</bookmark_value>" @@ -40225,6 +42995,103 @@ msgstr "=GAMMAINV(0.8; 1; 1) उपजहरू १.६१ ।" #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id2914841\n" +"help.text" +msgid "<bookmark_value>GAMMA.INV function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2914841\n" +"47\n" +"help.text" +msgid "GAMMA.INV" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2913932\n" +"48\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_GAMMAINV_MS\">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id291422405814\n" +"help.text" +msgid "This function is identical to GAMAINV and was introduced for interoperability with other office suites." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2919949\n" +"49\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2915828\n" +"50\n" +"help.text" +msgid "GAMMA.INV(Number; Alpha; Beta)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2915138\n" +"51\n" +"help.text" +msgid "<emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2912785\n" +"52\n" +"help.text" +msgid "<emph>Alpha</emph> is the parameter Alpha of the Gamma distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2914561\n" +"53\n" +"help.text" +msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2918734\n" +"54\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2913331\n" +"55\n" +"help.text" +msgid "<item type=\"input\">=GAMMA.INV(0.8;1;1)</item> yields 1.61." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id3154806\n" "help.text" msgid "<bookmark_value>GAMMALN function</bookmark_value> <bookmark_value>natural logarithm of Gamma function</bookmark_value>" @@ -40296,6 +43163,77 @@ msgstr "=GAMMALN(2) yields 0." #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id2914806\n" +"help.text" +msgid "<bookmark_value>GAMMALN.PRECISE function</bookmark_value> <bookmark_value>natural logarithm of Gamma function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2914806\n" +"57\n" +"help.text" +msgid "GAMMALN.PRECISE" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2918572\n" +"58\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_GAMMALN_MS\">Returns the natural logarithm of the Gamma function: G(x).</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2912999\n" +"59\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2913112\n" +"60\n" +"help.text" +msgid "GAMMALN.PRECISE(Number)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2914502\n" +"61\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2913568\n" +"62\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2913730\n" +"63\n" +"help.text" +msgid "<item type=\"input\">=GAMMALN.PRECISE(2)</item> yields 0." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id3150132\n" "help.text" msgid "<bookmark_value>GAMMADIST function</bookmark_value>" @@ -40402,6 +43340,110 @@ msgstr "=GAMMADIST(2; 1; 1; 1)ले ०.८६ पैदा गर्दछ । #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id240620142206421\n" +"help.text" +msgid "<bookmark_value>GAMMA.DIST function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2406201422120061\n" +"help.text" +msgid "GAMMA.DIST" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422414690\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_GAMMADIST_MS\">Returns the values of a Gamma distribution.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id24061422414690\n" +"help.text" +msgid "The inverse function is GAMMAINV or GAMMA.INV." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422405814\n" +"help.text" +msgid "This function is identical to GAMADIST and was introduced for interoperability with other office suites." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2406201422383599\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id240620142238475\n" +"help.text" +msgid "GAMMA.DIST(Number; Alpha; Beta; C)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422385134\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the Gamma distribution is to be calculated." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422385590\n" +"help.text" +msgid "<emph>Alpha</emph> is the parameter Alpha of the Gamma distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422390458\n" +"help.text" +msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422391058\n" +"help.text" +msgid "<emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2406201422391870\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2406201422392251\n" +"help.text" +msgid "<item type=\"input\">=GAMMA.DIST(2;1;1;1)</item> yields 0.86." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id3150272\n" "help.text" msgid "<bookmark_value>GAUSS function</bookmark_value> <bookmark_value>normal distribution; standard</bookmark_value>" @@ -40720,6 +43762,95 @@ msgstr "" #: 04060182.xhp msgctxt "" "04060182.xhp\n" +"bm_id2953216\n" +"help.text" +msgid "<bookmark_value>Z.TEST function</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2953216\n" +"103\n" +"help.text" +msgid "Z.TEST" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2950758\n" +"104\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_Z_TEST_MS\">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2950872\n" +"105\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2953274\n" +"106\n" +"help.text" +msgid "Z.TEST(Data; mu; Sigma)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2956109\n" +"107\n" +"help.text" +msgid "<emph>Data</emph> is the given sample, drawn from a normally distributed population." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2949977\n" +"108\n" +"help.text" +msgid "<emph>mu</emph> is the known mean of the population." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2954740\n" +"109\n" +"help.text" +msgid "<emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2949539\n" +"58\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2948770\n" +"59\n" +"help.text" +msgid "<item type=\"input\">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" "bm_id3153623\n" "help.text" msgid "<bookmark_value>HARMEAN function</bookmark_value> <bookmark_value>means;harmonic</bookmark_value>" @@ -40886,6 +44017,122 @@ msgctxt "" msgid "<item type=\"input\">=HYPGEOMDIST(2;2;90;100)</item> yields 0.81. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first." msgstr "=HYPGEOMDIST(2; 2; 90; 100)को उपज ०.८१ हुन्छ । यदि बटर्ड टोस्टहरूको १०० टुक्रहरू मध्ये ९० टेवलबाट खसेको र बटर्डको पहिलो साइडले भुईमा छुन्छ जसमा यदि बर्टड टोस्टको २ टुक्रा खसाएको खण्डमा दुवै बटर्डको पहिलो साइड ठोकिने सम्भाव्यता ८१% हुन्छ ।" +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"bm_id2952801\n" +"help.text" +msgid "<bookmark_value>HYPGEOM.DIST function</bookmark_value> <bookmark_value>sampling without replacement</bookmark_value>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2952801\n" +"122\n" +"help.text" +msgid "HYPGEOM.DIST" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2959341\n" +"123\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_HYP_GEOM_DIST_MS\">Returns the hypergeometric distribution.</ahelp>" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2954697\n" +"124\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2955388\n" +"125\n" +"help.text" +msgid "HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative)" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2954933\n" +"126\n" +"help.text" +msgid "<emph>X</emph> is the number of results achieved in the random sample." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2953106\n" +"127\n" +"help.text" +msgid "<emph>NSample</emph> is the size of the random sample." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2946992\n" +"128\n" +"help.text" +msgid "<emph>Successes</emph> is the number of possible results in the total population." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2948826\n" +"129\n" +"help.text" +msgid "<emph>NPopulation </emph>is the size of the total population." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2948827\n" +"129\n" +"help.text" +msgid "<emph>Cumulative </emph>: 0 or False calculates the probability density function. Other values or True calculates the cumulative distribution function." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"hd_id2950529\n" +"130\n" +"help.text" +msgid "Examples" +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2954904\n" +"131\n" +"help.text" +msgid "<item type=\"input\">=HYPGEOM.DIST(2;2;90;100;0)</item> yields 0.8090909091. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first." +msgstr "" + +#: 04060182.xhp +msgctxt "" +"04060182.xhp\n" +"par_id2954905\n" +"131\n" +"help.text" +msgid "<item type=\"input\">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1." +msgstr "" + #: 04060183.xhp msgctxt "" "04060183.xhp\n" @@ -41155,6 +44402,184 @@ msgstr "=CONFIDENCE(0.05; 1.5; 100)ले ०.२९ दिन्छ ।" #: 04060183.xhp msgctxt "" "04060183.xhp\n" +"bm_id2953559\n" +"help.text" +msgid "<bookmark_value>CONFIDENCE.T function</bookmark_value>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2953559\n" +"20\n" +"help.text" +msgid "CONFIDENCE.T" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2953814\n" +"21\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CONFIDENCE_T\">Returns the (1-alpha) confidence interval for a Student's t distribution.</ahelp>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2949315\n" +"22\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2947501\n" +"23\n" +"help.text" +msgid "CONFIDENCE.T(Alpha; StDev; Size)" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2949872\n" +"24\n" +"help.text" +msgid "<emph>Alpha</emph> is the level of the confidence interval." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2945324\n" +"25\n" +"help.text" +msgid "<emph>StDev</emph> is the standard deviation for the total population." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2953075\n" +"26\n" +"help.text" +msgid "<emph>Size</emph> is the size of the total population." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2950435\n" +"27\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2953335\n" +"28\n" +"help.text" +msgid "<item type=\"input\">=CONFIDENCE.T(0.05;1.5;100)</item> gives 0.2976325427." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"bm_id2853559\n" +"help.text" +msgid "<bookmark_value>CONFIDENCE.NORM function</bookmark_value>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2853559\n" +"20\n" +"help.text" +msgid "CONFIDENCE.NORM" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2853814\n" +"21\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_CONFIDENCE_N\">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2849315\n" +"22\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2847501\n" +"23\n" +"help.text" +msgid "CONFIDENCE.NORM(Alpha; StDev; Size)" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2849872\n" +"24\n" +"help.text" +msgid "<emph>Alpha</emph> is the level of the confidence interval." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2845324\n" +"25\n" +"help.text" +msgid "<emph>StDev</emph> is the standard deviation for the total population." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2853075\n" +"26\n" +"help.text" +msgid "<emph>Size</emph> is the size of the total population." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2850435\n" +"27\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2853335\n" +"28\n" +"help.text" +msgid "<item type=\"input\">=CONFIDENCE.NORM(0.05;1.5;100)</item> gives 0.2939945977." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" "bm_id3148746\n" "help.text" msgid "<bookmark_value>CORREL function</bookmark_value><bookmark_value>coefficient of correlation</bookmark_value>" @@ -41315,6 +44740,166 @@ msgstr "=COVAR(A1:A30; B1:B30)" #: 04060183.xhp msgctxt "" "04060183.xhp\n" +"bm_id2950652\n" +"help.text" +msgid "<bookmark_value>COVARIANCE.P function</bookmark_value>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2950652\n" +"39\n" +"help.text" +msgid "COVARIANCE.P" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2946875\n" +"40\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_COVARIANCE_P\">Returns the covariance of the product of paired deviations, for the entire population.</ahelp>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2949013\n" +"41\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2950740\n" +"42\n" +"help.text" +msgid "COVARIANCE.P(Data1; Data2)" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2945827\n" +"43\n" +"help.text" +msgid "<emph>Data1</emph> is the first data set." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2950465\n" +"44\n" +"help.text" +msgid "<emph>Data2</emph> is the second data set." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2954677\n" +"45\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2944748\n" +"46\n" +"help.text" +msgid "<item type=\"input\">=COVARIANCE.P(A1:A30;B1:B30)</item>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"bm_id280652\n" +"help.text" +msgid "<bookmark_value>COVARIANCE.S function</bookmark_value>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2850652\n" +"39\n" +"help.text" +msgid "COVARIANCE.S" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2846875\n" +"40\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_COVARIANCE_S\">Returns the covariance of the product of paired deviations, for a sample of the population.</ahelp>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2849013\n" +"41\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2850740\n" +"42\n" +"help.text" +msgid "COVARIANCE.S(Data1; Data2)" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2845827\n" +"43\n" +"help.text" +msgid "<emph>Data1</emph> is the first data set." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2850465\n" +"44\n" +"help.text" +msgid "<emph>Data2</emph> is the second data set." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id284677\n" +"45\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2844748\n" +"46\n" +"help.text" +msgid "<item type=\"input\">=COVARIANCE.S(A1:A30;B1:B30)</item>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" "bm_id3147472\n" "help.text" msgid "<bookmark_value>CRITBINOM function</bookmark_value>" @@ -41558,8 +45143,105 @@ msgctxt "" "par_id3155623\n" "74\n" "help.text" -msgid "<item type=\"input\">=LOGINV(0.05;0;1)</item> returns 0.19." -msgstr "=LOGINV(0.05; 0; 1)ले ०.१९ फर्काउँदछ ।" +msgid "<item type=\"input\">=LOGINV(0.05;0;1)</item> returns 0.1930408167." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"bm_id2901928\n" +"help.text" +msgid "<bookmark_value>LOGNORM.INV function</bookmark_value><bookmark_value>inverse of lognormal distribution</bookmark_value>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2901928\n" +"66\n" +"help.text" +msgid "LOGNORM.INV" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2901297\n" +"67\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_LOGINV_MS\">Returns the inverse of the lognormal distribution.</ahelp>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id290122405814\n" +"help.text" +msgid "This function is identical to LOGINV and was introduced for interoperability with other office suites." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2901016\n" +"68\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2901049\n" +"69\n" +"help.text" +msgid "LOGNORM.INV(Number; Mean; StDev)" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2901390\n" +"70\n" +"help.text" +msgid "<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2901538\n" +"71\n" +"help.text" +msgid "<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2901355\n" +"72\n" +"help.text" +msgid "<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2901768\n" +"73\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2901623\n" +"74\n" +"help.text" +msgid "<item type=\"input\">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167." +msgstr "" #: 04060183.xhp msgctxt "" @@ -41658,6 +45340,103 @@ msgctxt "" msgid "<item type=\"input\">=LOGNORMDIST(0.1;0;1)</item> returns 0.01." msgstr "=LOGNORMDIST(0.1; 0; 1)ले ०.०१ फर्काउँदछ ।" +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"bm_id2901417\n" +"help.text" +msgid "<bookmark_value>LOGNORM.DIST function</bookmark_value><bookmark_value>lognormal distribution</bookmark_value>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2908417\n" +"76\n" +"help.text" +msgid "LOGNORM.DIST" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2904953\n" +"77\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_NORMDIST_MS\">Returns the values of a lognormal distribution.</ahelp>" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2900474\n" +"78\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2900686\n" +"79\n" +"help.text" +msgid "LOGNORM.DIST(Number; Mean; StDev; Cumulative)" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2904871\n" +"80\n" +"help.text" +msgid "<emph>Number</emph> (required) is the probability value for which the standard logarithmic distribution is to be calculated." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2905820\n" +"81\n" +"help.text" +msgid "<emph>Mean</emph> (required) is the mean value of the standard logarithmic distribution." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2905991\n" +"82\n" +"help.text" +msgid "<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2905992\n" +"help.text" +msgid "<emph>Cumulative</emph> (required) = 0 calculates the density function, Cumulative = 1 calculates the distribution." +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"hd_id2903178\n" +"83\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060183.xhp +msgctxt "" +"04060183.xhp\n" +"par_id2909778\n" +"84\n" +"help.text" +msgid "<item type=\"input\">=LOGNORM.DIST(0.1;0;1;1)</item> returns 0.0106510993." +msgstr "" + #: 04060184.xhp msgctxt "" "04060184.xhp\n" @@ -42385,6 +46164,166 @@ msgstr "=MODE(A1:A50)" #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2953933\n" +"help.text" +msgid "<bookmark_value>MODE.SNGL function</bookmark_value><bookmark_value>most common value</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2953933\n" +"43\n" +"help.text" +msgid "MODE.SNGL" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953085\n" +"44\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_MODAL_VALUE_MS\">Returns the most frequently occurring, or repetitive, value in an array or range of data.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2953003\n" +"45\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2955950\n" +"46\n" +"help.text" +msgid "MODE.SNGL(Number1; Number2; ...Number30)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2950337\n" +"47\n" +"help.text" +msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2963792\n" +"629\n" +"help.text" +msgid "If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2953571\n" +"48\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953733\n" +"49\n" +"help.text" +msgid "<item type=\"input\">=MODE.SNGL(A1:A50)</item>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"bm_id2853933\n" +"help.text" +msgid "<bookmark_value>MODE.MULT function</bookmark_value><bookmark_value>most common value</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2853933\n" +"43\n" +"help.text" +msgid "MODE.MULT" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2853085\n" +"44\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_MODAL_VALUE_MULTI\">Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2853003\n" +"45\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2855950\n" +"46\n" +"help.text" +msgid "MODE.MULT(Number1; Number2; ...Number30)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2850337\n" +"47\n" +"help.text" +msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2863792\n" +"629\n" +"help.text" +msgid "As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2853571\n" +"48\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2853733\n" +"49\n" +"help.text" +msgid "<item type=\"input\">=MODE.MULT(A1:A50)</item>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3149879\n" "help.text" msgid "<bookmark_value>NEGBINOMDIST function</bookmark_value><bookmark_value>negative binomial distribution</bookmark_value>" @@ -42474,6 +46413,113 @@ msgstr "=NEGBINOMDIST(1; 1; 0.5)ले ०.२५ फर्काउँदछ #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2949879\n" +"help.text" +msgid "<bookmark_value>NEGBINOM.DIST function</bookmark_value><bookmark_value>negative binomial distribution</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2949879\n" +"51\n" +"help.text" +msgid "NEGBINOM.DIST" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2955437\n" +"52\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_NEGBINOMDIST_MS\">Returns the negative binomial density or distribution function.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2945351\n" +"53\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2950935\n" +"54\n" +"help.text" +msgid "NEGBINOM.DIST(X; R; SP; Cumulative)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953044\n" +"55\n" +"help.text" +msgid "<emph>X</emph> represents the value returned for unsuccessful tests." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2951018\n" +"56\n" +"help.text" +msgid "<emph>R</emph> represents the value returned for successful tests." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948878\n" +"57\n" +"help.text" +msgid "<emph>SP</emph> is the probability of the success of an attempt." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948879\n" +"57\n" +"help.text" +msgid "<emph>Cumulative</emph> = 0 calculates the density function, <emph>Cumulative</emph> = 1 calculates the distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2949539\n" +"58\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948770\n" +"59\n" +"help.text" +msgid "<item type=\"input\">=NEGBINOM.DIST(1;1;0.5;0)</item> returns 0.25." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948771\n" +"59\n" +"help.text" +msgid "<item type=\"input\">=NEGBINOM.DIST(1;1;0.5;1)</item> returns 0.75." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3155516\n" "help.text" msgid "<bookmark_value>NORMINV function</bookmark_value><bookmark_value>normal distribution;inverse of</bookmark_value>" @@ -42563,6 +46609,95 @@ msgstr "=NORMINV(0.9; 63; 5)ले ६९.४१ फर्काउँदछ । #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2955516\n" +"help.text" +msgid "<bookmark_value>NORM.INV function</bookmark_value><bookmark_value>normal distribution;inverse of</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2955516\n" +"61\n" +"help.text" +msgid "NORM.INV" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2954634\n" +"62\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_NORMINV_MS\">Returns the inverse of the normal cumulative distribution.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2953227\n" +"63\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2947534\n" +"64\n" +"help.text" +msgid "NORM.INV(Number; Mean; StDev)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2954950\n" +"65\n" +"help.text" +msgid "<emph>Number</emph> represents the probability value used to determine the inverse normal distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2950690\n" +"66\n" +"help.text" +msgid "<emph>Mean</emph> represents the mean value in the normal distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948594\n" +"67\n" +"help.text" +msgid "<emph>StDev</emph> represents the standard deviation of the normal distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2955822\n" +"68\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953921\n" +"69\n" +"help.text" +msgid "<item type=\"input\">=NORM.INV(0.9;63;5)</item> returns 69.4077578277. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3153722\n" "help.text" msgid "<bookmark_value>NORMDIST function</bookmark_value><bookmark_value>density function</bookmark_value>" @@ -42670,6 +46805,113 @@ msgstr "=NORMDIST(70; 63; 5; 1)ले ०.९२ फर्काउँदछ । #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2913722\n" +"help.text" +msgid "<bookmark_value>NORM.DIST function</bookmark_value><bookmark_value>density function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2913722\n" +"71\n" +"help.text" +msgid "NORM.DIST" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2910386\n" +"72\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_NORMDIST_MS\">Returns the density function or the normal cumulative distribution.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2913282\n" +"73\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2910613\n" +"74\n" +"help.text" +msgid "NORM.DIST(Number; Mean; StDev; C)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2919820\n" +"75\n" +"help.text" +msgid "<emph>Number</emph> is the value of the distribution based on which the normal distribution is to be calculated." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2916063\n" +"76\n" +"help.text" +msgid "<emph>Mean</emph> is the mean value of the distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2916295\n" +"77\n" +"help.text" +msgid "<emph>StDev</emph> is the standard deviation of the distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2915080\n" +"78\n" +"help.text" +msgid "<emph>C</emph> = 0 calculates the density function, <emph>C</emph> = 1 calculates the distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2912972\n" +"79\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2919283\n" +"80\n" +"help.text" +msgid "<item type=\"input\">=NORM.DIST(70;63;5;0)</item> returns 0.029945493." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2919448\n" +"81\n" +"help.text" +msgid "<item type=\"input\">=NORM.DIST(70;63;5;1)</item> returns 0.9192433408." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3152934\n" "help.text" msgid "<bookmark_value>PEARSON function</bookmark_value>" @@ -42928,6 +47170,95 @@ msgstr "=POISSON(60;50;1)ले ०.९३ फर्काउँदछ ।" #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2953985\n" +"help.text" +msgid "<bookmark_value>POISSON.DIST function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2953985\n" +"102\n" +"help.text" +msgid "POISSON.DIST" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2954298\n" +"103\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2959183\n" +"104\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2946093\n" +"105\n" +"help.text" +msgid "POISSON.DIST(Number; Mean; C)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2947253\n" +"106\n" +"help.text" +msgid "<emph>Number</emph> represents the value based on which the Poisson distribution is calculated." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2951177\n" +"107\n" +"help.text" +msgid "<emph>Mean</emph> represents the middle value of the Poisson distribution." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2949200\n" +"108\n" +"help.text" +msgid "<emph>C</emph> (optional) = 0 or False calculates the density function; <emph>C</emph> = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2959347\n" +"109\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2950113\n" +"110\n" +"help.text" +msgid "<item type=\"input\">=POISSON.DIST(60;50;1)</item> returns 0.9278398202." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3153100\n" "help.text" msgid "<bookmark_value>PERCENTILE function</bookmark_value>" @@ -43008,6 +47339,191 @@ msgstr "=PERCENTILE(A1:A50; 0.1) डेटा सेटमा मान प् #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2853100\n" +"help.text" +msgid "<bookmark_value>PERCENTILE.EXC function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2853100\n" +"112\n" +"help.text" +msgid "PERCENTILE.EXC" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2854940\n" +"113\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_PERCENTILE_EXC\">Returns the <item type=\"literal\">Alpha</item>'th percentile of a supplied range of values for a given value of <item type=\"literal\">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A percentile returns the scale value for a data series which goes from the smallest (<item type=\"literal\">Alpha=0</item>) to the largest value (<item type=\"literal\">Alpha=1</item>) of a data series. For <item type=\"literal\">Alpha</item> = 25%, the percentile means the first quartile; <item type=\"literal\">Alpha</item> = 50% is the MEDIAN." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2754940\n" +"113\n" +"help.text" +msgid "If <item type=\"literal\">Alpha</item> is not a multiple of <item type=\"literal\">1/(n+1)</item>, (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if <item type=\"literal\">Alpha</item> is less than <item type=\"literal\">1/(n+1)</item> or <item type=\"literal\">Alpha</item> is greater than <item type=\"literal\">n/(n+1)</item>, the function is unable to interpolate, and so returns an error." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2653976\n" +"help.text" +msgid "The difference between <item type=\"input\">PERCENTILE.INC</item> and <item type=\"input\">PERCENTILE.EXC</item> is that, in the <item type=\"input\">PERCENTILE.INC</item> function the value of alpha is is within the range 0 to 1 inclusive, and in the <item type=\"input\">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2850531\n" +"114\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2848813\n" +"115\n" +"help.text" +msgid "PERCENTILE.EXC(Data; Alpha)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2853054\n" +"116\n" +"help.text" +msgid "<emph>Data</emph> represents the array of data." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2854212\n" +"117\n" +"help.text" +msgid "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2854290\n" +"118\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2859147\n" +"119\n" +"help.text" +msgid "<item type=\"input\">=PERCENTILE.EXC(A1:A50;10%)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"bm_id2953100\n" +"help.text" +msgid "<bookmark_value>PERCENTILE.INC function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2953100\n" +"112\n" +"help.text" +msgid "PERCENTILE.INC" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2954940\n" +"113\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_PERCENTILE_INC\">Returns the alpha-percentile of data values in an array.</ahelp> A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For <item type=\"literal\">Alpha</item> = 25%, the percentile means the first quartile; <item type=\"literal\">Alpha</item> = 50% is the MEDIAN." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2753976\n" +"help.text" +msgid "The difference between <item type=\"input\">PERCENTILE.INC</item> and <item type=\"input\">PERCENTILE.EXC</item> is that, in the <item type=\"input\">PERCENTILE.INC</item> function the value of alpha is is within the range 0 to 1 inclusive, and in the <item type=\"input\">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2950531\n" +"114\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948813\n" +"115\n" +"help.text" +msgid "PERCENTILE.INC(Data; Alpha)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953054\n" +"116\n" +"help.text" +msgid "<emph>Data</emph> represents the array of data." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2954212\n" +"117\n" +"help.text" +msgid "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2954290\n" +"118\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2959147\n" +"119\n" +"help.text" +msgid "<item type=\"input\">=PERCENTILE.INC(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3148807\n" "help.text" msgid "<bookmark_value>PERCENTRANK function</bookmark_value>" @@ -43088,6 +47604,200 @@ msgstr "=PERCENTRANK(A1:A50; 50) ले A1:A50मा भेटाएका स #: 04060184.xhp msgctxt "" "04060184.xhp\n" +"bm_id2848807\n" +"help.text" +msgid "<bookmark_value>PERCENTRANK.EXC function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2848807\n" +"121\n" +"help.text" +msgid "PERCENTRANK.EXC" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2853573\n" +"122\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_PERCENTRANK_EXC\"> Returns the relative position, between 0 and 1 (exclusive), of a specified value within a supplied array.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2553976\n" +"help.text" +msgid "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2847512\n" +"123\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2847238\n" +"124\n" +"help.text" +msgid "PERCENTRANK.EXC(Data; Value; Significance)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2854266\n" +"125\n" +"help.text" +msgid "<emph>Data</emph> represents the array of data in the sample." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2848475\n" +"126\n" +"help.text" +msgid "<emph>Value</emph> represents the value whose percentile rank must be determined." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2748475\n" +"126\n" +"help.text" +msgid "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2855364\n" +"127\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2849163\n" +"128\n" +"help.text" +msgid "<item type=\"input\">=PERCENTRANK.EXC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"bm_id2948807\n" +"help.text" +msgid "<bookmark_value>PERCENTRANK.INC function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2948807\n" +"121\n" +"help.text" +msgid "PERCENTRANK.INC" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953573\n" +"122\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_PERCENTRANK_INC\">Returns the relative position, between 0 and 1 (inclusive), of a specified value within a supplied array.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2453976\n" +"help.text" +msgid "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2947512\n" +"123\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2947238\n" +"124\n" +"help.text" +msgid "PERCENTRANK.INC(Data; Value; Significance)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2954266\n" +"125\n" +"help.text" +msgid "<emph>Data</emph> represents the array of data in the sample." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2948475\n" +"126\n" +"help.text" +msgid "<emph>Value</emph> represents the value whose percentile rank must be determined." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2648475\n" +"126\n" +"help.text" +msgid "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2955364\n" +"127\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2949163\n" +"128\n" +"help.text" +msgid "<item type=\"input\">=PERCENTRANK.INC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" "bm_id3166442\n" "help.text" msgid "<bookmark_value>QUARTILE function</bookmark_value>" @@ -43165,6 +47875,182 @@ msgctxt "" msgid "<item type=\"input\">=QUARTILE(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50." msgstr "" +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"bm_id2866442\n" +"help.text" +msgid "<bookmark_value>QUARTILE.EXC function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2866442\n" +"130\n" +"help.text" +msgid "QUARTILE.EXC" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2846958\n" +"131\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_QUARTILE_EXC\">Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2353976\n" +"help.text" +msgid "The difference between <item type=\"input\">QUARTILE.INC</item> and <item type=\"input\">QUARTILE.EXC</item> is that the <item type=\"input\">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type=\"input\">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2852942\n" +"132\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2853684\n" +"133\n" +"help.text" +msgid "QUARTILE.EXC(Data; Type)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2853387\n" +"134\n" +"help.text" +msgid "<emph>Data</emph> represents the range of data values for which you want to calculate the specified quartile." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2855589\n" +"135\n" +"help.text" +msgid "<emph>Type</emph> An integer between 1 and 3, representing the required quartile. (if type = 1 or 3, the supplied array must contain more than 2 values)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2849103\n" +"136\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2859276\n" +"137\n" +"help.text" +msgid "<item type=\"input\">=QUARTILE.EXC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"bm_id2966442\n" +"help.text" +msgid "<bookmark_value>QUARTILE.INC function</bookmark_value>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2966442\n" +"130\n" +"help.text" +msgid "QUARTILE.INC" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2946958\n" +"131\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_QUARTILE_INC\">Returns the quartile of a data set.</ahelp>" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2253976\n" +"help.text" +msgid "The difference between <item type=\"input\">QUARTILE.INC</item> and <item type=\"input\">QUARTILE.EXC</item> is that the <item type=\"input\">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type=\"input\">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2952942\n" +"132\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953684\n" +"133\n" +"help.text" +msgid "QUARTILE.INC(Data; Type)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2953387\n" +"134\n" +"help.text" +msgid "<emph>Data</emph> represents the array of data in the sample." +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2955589\n" +"135\n" +"help.text" +msgid "<emph>Type</emph> represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id2949103\n" +"136\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"par_id2959276\n" +"137\n" +"help.text" +msgid "<item type=\"input\">=QUARTILE.INC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50." +msgstr "" + #: 04060185.xhp msgctxt "" "04060185.xhp\n" @@ -43290,6 +48176,232 @@ msgstr "=RANK(A10; A1:A50) दर्जा मिलाएको मान A10 #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2955071\n" +"help.text" +msgid "<bookmark_value>RANK.AVG function</bookmark_value> <bookmark_value>numbers;determining ranks</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2955071\n" +"2\n" +"help.text" +msgid "RANK.AVG" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953976\n" +"3\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RANK_AVG\">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, the average rank is returned." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2653976\n" +"help.text" +msgid "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2959206\n" +"4\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953250\n" +"5\n" +"help.text" +msgid "RANK.AVG(Value; Data; Type)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954543\n" +"6\n" +"help.text" +msgid "<emph>Value</emph> is the value, whose rank is to be determined." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949130\n" +"7\n" +"help.text" +msgid "<emph>Data</emph> is the array or range of data in the sample." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2950215\n" +"8\n" +"help.text" +msgid "<emph>Type</emph> (optional) is the sequence order." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id0305398\n" +"help.text" +msgid "Type = 0 means descending from the last item of the array to the first (this is the default)," +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id0996948\n" +"help.text" +msgid "Type = 1 means ascending from the first item of the range to the last." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2943223\n" +"9\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2955919\n" +"10\n" +"help.text" +msgid "<item type=\"input\">=RANK.AVG(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type=\"literal\">Value</item> does not exist within the range an error message is displayed." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"bm_id2855071\n" +"help.text" +msgid "<bookmark_value>RANK.EQ function</bookmark_value> <bookmark_value>numbers;determining ranks</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2855071\n" +"2\n" +"help.text" +msgid "RANK.AVG" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2853976\n" +"3\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RANK_EQ\">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, these are given the same rank." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2753976\n" +"help.text" +msgid "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2859206\n" +"4\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2853250\n" +"5\n" +"help.text" +msgid "RANK.EQ(Value; Data; Type)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2854543\n" +"6\n" +"help.text" +msgid "<emph>Value</emph> is the value, whose rank is to be determined." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2849130\n" +"7\n" +"help.text" +msgid "<emph>Data</emph> is the array or range of data in the sample." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2850215\n" +"8\n" +"help.text" +msgid "<emph>Type</emph> (optional) is the sequence order." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id89305398\n" +"help.text" +msgid "Type = 0 means descending from the last item of the array to the first (this is the default)," +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id89996948\n" +"help.text" +msgid "Type = 1 means ascending from the first item of the range to the last." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2843223\n" +"9\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2855919\n" +"10\n" +"help.text" +msgid "<item type=\"input\">=RANK.EQ(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type=\"literal\">Value</item> does not exist within the range an error message is displayed." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3153556\n" "help.text" msgid "<bookmark_value>SKEW function</bookmark_value>" @@ -43663,6 +48775,148 @@ msgstr "=STDEVP(A1:A50) सान्दर्भित डेटाको स् #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2949734\n" +"help.text" +msgid "<bookmark_value>STDEV.P function</bookmark_value> <bookmark_value>standard deviations in statistics;based on a population</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2949734\n" +"38\n" +"help.text" +msgid "STDEV.P" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949187\n" +"39\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ST_DEV_P_MS\">Calculates the standard deviation based on the entire population.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2954387\n" +"40\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954392\n" +"41\n" +"help.text" +msgid "STDEV.P(Number1;Number2;...Number30)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2955261\n" +"42\n" +"help.text" +msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2945591\n" +"43\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953933\n" +"44\n" +"help.text" +msgid "<item type=\"input\">=STDEV.P(A1:A50)</item> returns a standard deviation of the data referenced." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"bm_id2849734\n" +"help.text" +msgid "<bookmark_value>STDEV.S function</bookmark_value> <bookmark_value>standard deviations in statistics;based on a sample</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2849734\n" +"38\n" +"help.text" +msgid "STDEV.S" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2849187\n" +"39\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_ST_DEV_S\">Calculates the standard deviation based on sample of the population.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2854387\n" +"40\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2854392\n" +"41\n" +"help.text" +msgid "STDEV.S(Number1;Number2;...Number30)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2855261\n" +"42\n" +"help.text" +msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample of the population." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2845591\n" +"43\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2853933\n" +"44\n" +"help.text" +msgid "<item type=\"input\">=STDEV.S(A1:A50)</item> returns a standard deviation of the data referenced." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3154522\n" "help.text" msgid "<bookmark_value>STDEVPA function</bookmark_value>" @@ -43861,8 +49115,8 @@ msgctxt "" "par_id3154195\n" "59\n" "help.text" -msgid "NORMINV(Number)" -msgstr "NORMINV(सङ्ख्या)" +msgid "NORMSINV(Number)" +msgstr "" #: 04060185.xhp msgctxt "" @@ -43894,6 +49148,77 @@ msgstr "NORMSINV(0.908789)ले १.३३३३ फर्काउँदछ." #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2957986\n" +"help.text" +msgid "<bookmark_value>NORM.S.INV function</bookmark_value> <bookmark_value>normal distribution;inverse of standard</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2957986\n" +"56\n" +"help.text" +msgid "NORM.S.INV" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2951282\n" +"57\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_STD_NORMINV_MS\">Returns the inverse of the standard normal cumulative distribution.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2953261\n" +"58\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954195\n" +"59\n" +"help.text" +msgid "NORM.S.INV(Number)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2948772\n" +"60\n" +"help.text" +msgid "<emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2950934\n" +"61\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949030\n" +"62\n" +"help.text" +msgid "<item type=\"input\">=NORM.S.INV(0.908789)</item> returns 1.333334673." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3147538\n" "help.text" msgid "<bookmark_value>NORMSDIST function</bookmark_value> <bookmark_value>normal distribution;statistics</bookmark_value>" @@ -43973,6 +49298,95 @@ msgstr "=NORMSDIST(1)ले ०.८४ फर्काउँदछ । क्ष #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2947538\n" +"help.text" +msgid "<bookmark_value>NORM.S.DIST function</bookmark_value> <bookmark_value>normal distribution;statistics</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2947538\n" +"64\n" +"help.text" +msgid "NORM.S.DIST" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2950474\n" +"65\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_STD_NORMDIST_MS\">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2955083\n" +"66\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2958411\n" +"67\n" +"help.text" +msgid "NORM.S.DIST(Number; Cumulative)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954950\n" +"68\n" +"help.text" +msgid "<emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954951\n" +"68\n" +"help.text" +msgid "<emph>Cumulative</emph> 0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2993228\n" +"69\n" +"help.text" +msgid "Examples" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2955984\n" +"70\n" +"help.text" +msgid "<item type=\"input\">=NORM.S.DIST(1;0)</item> returns 0.2419707245." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2955985\n" +"70\n" +"help.text" +msgid "<item type=\"input\">=NORM.S.DIST(1;1)</item> returns 0.8413447461. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3152592\n" "help.text" msgid "<bookmark_value>SLOPE function</bookmark_value>" @@ -44127,8 +49541,8 @@ msgctxt "" "par_id3156131\n" "88\n" "help.text" -msgid "<item type=\"input\">=STEXY(A1:A50;B1:B50)</item>" -msgstr "=STEXY(A1:A50; B1:B50)" +msgid "<item type=\"input\">=STEYX(A1:A50;B1:B50)</item>" +msgstr "" #: 04060185.xhp msgctxt "" @@ -44284,6 +49698,166 @@ msgstr "=TINV(0.1; 6)ले १.९४ फर्काउँदछ ।" #: 04060185.xhp 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 "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2949579\n" +"98\n" +"help.text" +msgid "T.INV" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"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 "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2955101\n" +"100\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949289\n" +"101\n" +"help.text" +msgid "T.INV(Number; DegreesFreedom)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954070\n" +"102\n" +"help.text" +msgid "<emph>Number</emph> is the probability associated with the two-tailed t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2955315\n" +"103\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2953885\n" +"104\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2956010\n" +"105\n" +"help.text" +msgid "<item type=\"input\">=T.INV(0.1;6)</item> returns -1.4397557473." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"bm_id2849579\n" +"help.text" +msgid "<bookmark_value>T.INV.2T function</bookmark_value> <bookmark_value>inverse of two tailed t-distribution</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2849579\n" +"98\n" +"help.text" +msgid "T.INV.2T" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2843232\n" +"99\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_TINV_2T\">Calculates the inverse of the two-tailed Student's T Distribution </ahelp>, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2855101\n" +"100\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2849289\n" +"101\n" +"help.text" +msgid "T.INV.2T(Number; DegreesFreedom)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2854070\n" +"102\n" +"help.text" +msgid "<emph>Number</emph> is the probability associated with the two-tailed t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2855315\n" +"103\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2853885\n" +"104\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2856010\n" +"105\n" +"help.text" +msgid "<item type=\"input\">=T.INV.2T(0.25; 10)</item> returns 1.221255395." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3154129\n" "help.text" msgid "<bookmark_value>TTEST function</bookmark_value>" @@ -44382,6 +49956,104 @@ msgstr "=TTEST(A1:A50; B1:B50; 2; 2)" #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2954129\n" +"help.text" +msgid "<bookmark_value>T.TEST function</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2954129\n" +"107\n" +"help.text" +msgid "T.TEST" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2959184\n" +"108\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_TTEST_MS\">Returns the probability associated with a Student's t-Test.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2947257\n" +"109\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2951175\n" +"110\n" +"help.text" +msgid "T.TEST(Data1; Data2; Mode; Type)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949202\n" +"111\n" +"help.text" +msgid "<emph>Data1</emph> is the dependent array or range of data for the first record." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2945666\n" +"112\n" +"help.text" +msgid "<emph>Data2</emph> is the dependent array or range of data for the second record." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953903\n" +"113\n" +"help.text" +msgid "<emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2955327\n" +"114\n" +"help.text" +msgid "<emph>Type</emph> is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic)." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2959342\n" +"115\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2950119\n" +"116\n" +"help.text" +msgid "<item type=\"input\">=T.TEST(A1:A50;B1:B50;2;2)</item>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3154930\n" "help.text" msgid "<bookmark_value>TDIST function</bookmark_value> <bookmark_value>t-distribution</bookmark_value>" @@ -44471,6 +50143,255 @@ msgstr "=TDIST(12; 5; 1)" #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2954930\n" +"help.text" +msgid "<bookmark_value>T.DIST function</bookmark_value> <bookmark_value>t-distribution</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2954930\n" +"118\n" +"help.text" +msgid "T.DIST" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953372\n" +"119\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_TDIST_MS\">Returns the t-distribution.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2949911\n" +"120\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2950521\n" +"121\n" +"help.text" +msgid "T.DIST(Number; DegreesFreedom; Cumulative)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2946991\n" +"122\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the t-distribution is calculated." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2948824\n" +"123\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949340\n" +"124\n" +"help.text" +msgid "<emph>Cumulative</emph> = 0 or FALSE returns the probability density function, 1 or TRUE returns the cumulative distribution function." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2959150\n" +"125\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949773\n" +"126\n" +"help.text" +msgid "<item type=\"input\">=T.DIST(1; 10; TRUE)</item> returns 0.8295534338" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"bm_id2854930\n" +"help.text" +msgid "<bookmark_value>T.DIST.2T function</bookmark_value> <bookmark_value>two tailed t-distribution</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2854930\n" +"118\n" +"help.text" +msgid "T.DIST.2T" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2853372\n" +"119\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_TDIST_2T\">Calculates the two-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2849911\n" +"120\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2850521\n" +"121\n" +"help.text" +msgid "T.DIST.2T(Number; DegreesFreedom)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2846991\n" +"122\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the t-distribution is calculated." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2848824\n" +"123\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2859150\n" +"125\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2849773\n" +"126\n" +"help.text" +msgid "<item type=\"input\">=T.DIST.2T(1; 10)</item> returns 0.3408931323." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"bm_id274930\n" +"help.text" +msgid "<bookmark_value>T.DIST.RT function</bookmark_value> <bookmark_value>right tailed t-distribution</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id274930\n" +"118\n" +"help.text" +msgid "T.DIST.RT" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2753372\n" +"119\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_TDIST_RT\">Calculates the right-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2749911\n" +"120\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2750521\n" +"121\n" +"help.text" +msgid "T.DIST.RT(Number; DegreesFreedom)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2746991\n" +"122\n" +"help.text" +msgid "<emph>Number</emph> is the value for which the t-distribution is calculated." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2748824\n" +"123\n" +"help.text" +msgid "<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2759150\n" +"125\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2749773\n" +"126\n" +"help.text" +msgid "<item type=\"input\">=T.DIST.RT(1; 10)</item> returns 0.1704465662." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3153828\n" "help.text" msgid "<bookmark_value>VAR function</bookmark_value> <bookmark_value>variances</bookmark_value>" @@ -44542,6 +50463,77 @@ msgstr "=VAR(A1:A50)" #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2953828\n" +"help.text" +msgid "<bookmark_value>VAR.S function</bookmark_value> <bookmark_value>variances</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2953828\n" +"128\n" +"help.text" +msgid "VAR.S" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2959165\n" +"129\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_VAR_S\">Estimates the variance based on a sample.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2954286\n" +"130\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953054\n" +"131\n" +"help.text" +msgid "VAR.S(Number1; Number2; ...Number30)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2948938\n" +"132\n" +"help.text" +msgid "<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2947233\n" +"133\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953575\n" +"134\n" +"help.text" +msgid "<item type=\"input\">=VAR.S(A1:A50)</item>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3151045\n" "help.text" msgid "<bookmark_value>VARA function</bookmark_value>" @@ -44684,6 +50676,77 @@ msgstr "=VARP(A1:A50)" #: 04060185.xhp msgctxt "" "04060185.xhp\n" +"bm_id2966441\n" +"help.text" +msgid "<bookmark_value>VAR.P function</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2966441\n" +"136\n" +"help.text" +msgid "VAR.P" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2959199\n" +"137\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_VAR_P_MS\">Calculates a variance based on the entire population.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2950706\n" +"138\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2947282\n" +"139\n" +"help.text" +msgid "VAR.P(Number1; Number2; ...Number30)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2949793\n" +"140\n" +"help.text" +msgid "<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2952939\n" +"141\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2953385\n" +"142\n" +"help.text" +msgid "<item type=\"input\">=VAR.P(A1:A50)</item>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" "bm_id3153688\n" "help.text" msgid "<bookmark_value>VARPA function</bookmark_value>" @@ -45158,6 +51221,136 @@ msgctxt "" msgid "See also the <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function\">Wiki page</link>." msgstr "" +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"bm_id2950941\n" +"help.text" +msgid "<bookmark_value>WEIBULL.DIST function</bookmark_value>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2950941\n" +"175\n" +"help.text" +msgid "WEIBULL.DIST" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954916\n" +"176\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_WEIBULL_DIST_MS\">Returns the values of the Weibull distribution.</ahelp>" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2905200911372767\n" +"help.text" +msgid "The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale)." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2905200911372777\n" +"help.text" +msgid "If C is 0, WEIBULL.DIST calculates the probability density function." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2905200911372743\n" +"help.text" +msgid "If C is 1, WEIBULL.DIST calculates the cumulative distribution function." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2959393\n" +"177\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954478\n" +"178\n" +"help.text" +msgid "WEIBULL.DIST(Number; Alpha; Beta; C)" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2951317\n" +"179\n" +"help.text" +msgid "<emph>Number</emph> is the value at which to calculate the Weibull distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2958436\n" +"180\n" +"help.text" +msgid "<emph>Alpha </emph>is the shape parameter of the Weibull distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954668\n" +"181\n" +"help.text" +msgid "<emph>Beta</emph> is the scale parameter of the Weibull distribution." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2954825\n" +"182\n" +"help.text" +msgid "<emph>C</emph> indicates the type of function." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"hd_id2953794\n" +"183\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2946077\n" +"184\n" +"help.text" +msgid "<item type=\"input\">=WEIBULL.DIST(2;1;1;1)</item> returns 0.8646647168." +msgstr "" + +#: 04060185.xhp +msgctxt "" +"04060185.xhp\n" +"par_id2905200911372899\n" +"help.text" +msgid "See also the <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function\">Wiki page</link>." +msgstr "" + #: 04060199.xhp msgctxt "" "04060199.xhp\n" @@ -48059,8 +54252,8 @@ msgctxt "" "05080200.xhp\n" "tit\n" "help.text" -msgid "Remove" -msgstr "हटउनुहोस्" +msgid "Clear" +msgstr "" #: 05080200.xhp msgctxt "" @@ -48068,8 +54261,8 @@ msgctxt "" "hd_id3153562\n" "1\n" "help.text" -msgid "<link href=\"text/scalc/01/05080200.xhp\" name=\"Remove\">Remove</link>" -msgstr "<link href=\"text/scalc/01/05080200.xhp\" name=\"Remove\">हटाउनुहोस्</link>" +msgid "<link href=\"text/scalc/01/05080200.xhp\" name=\"Clear\">Clear</link>" +msgstr "" #: 05080200.xhp msgctxt "" @@ -57344,6 +63537,112 @@ msgctxt "" msgid "<item type=\"input\">=NOW()-A1</item> returns the difference between the date in A1 and now. Format the result as a number." msgstr "=NOW()-A1ले A1 र now बीचको मितिको फरक फर्काउँदछ । परिणाम सङ्ख्याको रूपमा ढाँचा गर्नु होस् ।." +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"tit\n" +"help.text" +msgid "NUMBERVALUE" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"bm_id3145621\n" +"help.text" +msgid "<bookmark_value>NUMBERVALUE function</bookmark_value>" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"hd_id3145621\n" +"18\n" +"help.text" +msgid "<variable id=\"datevalue\"> <link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link> </variable>" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3145087\n" +"19\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Convert text to number, in a locale-independent way.</ahelp>" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3149281\n" +"20\n" +"help.text" +msgid "Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"hd_id3156294\n" +"21\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3149268\n" +"22\n" +"help.text" +msgid "NUMBERVALUE(\"Text\";decimal_separator;group_separator)" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3154819\n" +"23\n" +"help.text" +msgid "<emph>Text</emph> is a valid number expression and must be entered with quotation marks." +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3154820\n" +"23\n" +"help.text" +msgid "<emph>decimal_separator</emph> (optional) defines the character used as the decimal separator." +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3154821\n" +"23\n" +"help.text" +msgid "<emph>group_separator</emph> (optional) defines the character(s) used as the group separator." +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"hd_id3156309\n" +"24\n" +"help.text" +msgid "Example" +msgstr "" + +#: func_numbervalue.xhp +msgctxt "" +"func_numbervalue.xhp\n" +"par_id3155841\n" +"25\n" +"help.text" +msgid "<item type=\"input\">=NUMBERVALUE(\"123.456\";\".\";\",\")</item> yields 123.456" +msgstr "" + #: func_second.xhp msgctxt "" "func_second.xhp\n" @@ -57722,6 +64021,181 @@ msgctxt "" msgid "<item type=\"input\">TODAY()</item> returns the current computer system date." msgstr "TODAY() हालको कम्प्युटर प्रणाली मिति फर्काउँदछ ।" +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"tit\n" +"help.text" +msgid "WEBSERVICE" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"bm_id3149012\n" +"help.text" +msgid "<bookmark_value>WEBSERVICE function</bookmark_value>" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id3149012\n" +"186\n" +"help.text" +msgid "WEBSERVICE" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id3149893\n" +"187\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_WEBSERVICE\">Get some web content from a URI.</ahelp>" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id3146944\n" +"188\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id3154844\n" +"189\n" +"help.text" +msgid "WEBSERVICE(URI)" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id3147469\n" +"190\n" +"help.text" +msgid "<emph>URI: </emph> URI text of the web service." +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id3150141\n" +"193\n" +"help.text" +msgid "Example" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id3146142\n" +"195\n" +"help.text" +msgid "=WEBSERVICE(\"http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric\")" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id3146143\n" +"help.text" +msgid "Returns the web page content of \"http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric\"" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"bm_id2949012\n" +"help.text" +msgid "<bookmark_value>FILTERXML function</bookmark_value>" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id2949012\n" +"186\n" +"help.text" +msgid "FILTERXML" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id2949893\n" +"187\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_FILTERXML\">Apply a XPath expression to a XML document.</ahelp>" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id2946944\n" +"188\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id2954844\n" +"189\n" +"help.text" +msgid "FILTERXML(XML Document; XPath expression)" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id2947469\n" +"190\n" +"help.text" +msgid "<emph>XML Document (required):</emph> String containing a valid XML stream." +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id2847469\n" +"190\n" +"help.text" +msgid "<emph>XPath expression (required):</emph> String containing a valid XPath expression." +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id2950141\n" +"193\n" +"help.text" +msgid "Example" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id2946142\n" +"195\n" +"help.text" +msgid "=FILTERXML(WEBSERVICE(\"http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric\");\"number(/weatherdata/forecast/time[2]/temperature/@value)\")" +msgstr "" + +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id2946143\n" +"help.text" +msgid "Returns information on Copenhagen weather temperature." +msgstr "" + #: func_weekday.xhp msgctxt "" "func_weekday.xhp\n" @@ -58763,6 +65237,1575 @@ msgctxt "" msgid "Click OK to accept the changes and to go back to the <link href=\"text/scalc/01/solver.xhp\">Solver</link> dialog." msgstr "" +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"hd_id200820141553364965\n" +"help.text" +msgid "Data" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533682345\n" +"help.text" +msgid "<emph>Input Range</emph>: The reference of the range of the data to analyze." +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533690271\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 "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"hd_id2008201415533630182\n" +"help.text" +msgid "Grouped By" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533694478\n" +"help.text" +msgid "Select whether the input data has <emph>columns</emph> or <emph>rows</emph> layout." +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"hd_id2008201415533366360\n" +"help.text" +msgid "Example" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533343874\n" +"help.text" +msgid "The following data will be used as example" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id200820141553335121\n" +"help.text" +msgid "Maths" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533379519\n" +"help.text" +msgid "Physics" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id200820141553333644\n" +"help.text" +msgid "Biology" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"hd_id2008201415533624784\n" +"help.text" +msgid "Example" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533648925\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 "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533654405\n" +"help.text" +msgid "A" +msgstr "" + +#: stat_data.xhp +msgctxt "" +"stat_data.xhp\n" +"par_id2008201415533633771\n" +"help.text" +msgid "B" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"tit\n" +"help.text" +msgid "Data Statistics in Calc" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id1\n" +"1\n" +"help.text" +msgid "Data Statistics in Calc" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533013547\n" +"help.text" +msgid "Use the data statistics in Calc to perform complex data analysis" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533090579\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 "" + +#: 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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533083500\n" +"help.text" +msgid "Sampling" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2756327\n" +"2\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Create a table with data sampled from another table.</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2752992\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Sampling...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533091337\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533022103\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533154722\n" +"help.text" +msgid "Sampling Method" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533127849\n" +"help.text" +msgid "<emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533118838\n" +"help.text" +msgid "<emph>Sample size</emph>: Number of lines sampled from the source table." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533154688\n" +"help.text" +msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533199288\n" +"help.text" +msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533195750\n" +"help.text" +msgid "Example" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533199646\n" +"help.text" +msgid "The following data will be used as example of source data table for sampling:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533317386\n" +"help.text" +msgid "Sampling with a period of 2 will result in the following table:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"bm_id01001\n" +"help.text" +msgid "<bookmark_value>Analysis toolpack;descriptive statistics</bookmark_value> <bookmark_value>descriptive statistics;Analysis toolpack</bookmark_value> <bookmark_value>Data statistics;descriptive statistics</bookmark_value>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id01003\n" +"1\n" +"help.text" +msgid "Descriptive Statistics" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id01004\n" +"2\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id01005\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Descriptive Statistics...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533312518\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201423333515443\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533458095\n" +"help.text" +msgid "The following table displays the results of the descriptive statistics of the sample data above." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533454721\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533415805\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533413862\n" +"help.text" +msgid "Column 3" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533476173\n" +"help.text" +msgid "Mean" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533480973\n" +"help.text" +msgid "Standard Error" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533433244\n" +"help.text" +msgid "Mode" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553341353\n" +"help.text" +msgid "Median" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533490736\n" +"help.text" +msgid "Variance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533495501\n" +"help.text" +msgid "Standard Deviation" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533498745\n" +"help.text" +msgid "Kurtosis" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533479359\n" +"help.text" +msgid "Skewness" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533473279\n" +"help.text" +msgid "Range" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533467981\n" +"help.text" +msgid "Minimum" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533456155\n" +"help.text" +msgid "Maximum" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533452737\n" +"help.text" +msgid "Sum" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533535276\n" +"help.text" +msgid "Count" +msgstr "" + +#: statistics.xhp +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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id02003\n" +"1\n" +"help.text" +msgid "Analysis of Variance (ANOVA)" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id02004\n" +"2\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog\">Produces the analysis of variance (ANOVA) of a given data set</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id02005\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Analysis of Variance (ANOVA)...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533512990\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533515443\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533538729\n" +"help.text" +msgid "Type" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553351190\n" +"help.text" +msgid "Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533538856\n" +"help.text" +msgid "Parameters" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533516218\n" +"help.text" +msgid "<emph>Alpha</emph>: the level of significance of the test." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533592749\n" +"help.text" +msgid "<emph>Rows per sample</emph>: Define how many rows a sample has." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533543611\n" +"help.text" +msgid "The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533531121\n" +"help.text" +msgid "ANOVA - Single Factor" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533586267\n" +"help.text" +msgid "Alpha" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533562036\n" +"help.text" +msgid "Groups" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533516564\n" +"help.text" +msgid "Count" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533511954\n" +"help.text" +msgid "Sum" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533560198\n" +"help.text" +msgid "Mean" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533547195\n" +"help.text" +msgid "Variance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533526297\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533571610\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553358382\n" +"help.text" +msgid "Column 3" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533555826\n" +"help.text" +msgid "Source of Variation" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533515237\n" +"help.text" +msgid "SS" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533550319\n" +"help.text" +msgid "df" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533582581\n" +"help.text" +msgid "MS" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533546247\n" +"help.text" +msgid "F" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533553834\n" +"help.text" +msgid "P-value" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533554659\n" +"help.text" +msgid "Between Groups" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533560423\n" +"help.text" +msgid "Within Groups" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533597992\n" +"help.text" +msgid "Total" +msgstr "" + +#: statistics.xhp +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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id3153032\n" +"1\n" +"help.text" +msgid "Correlation" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id3156327\n" +"2\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/correlationdialog/CorrelationDialog\">Calculates the correlation of two sets of numeric data.</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id3152992\n" +"26\n" +"help.text" +msgid "<variable id=\"corr01\">Menu <emph>Data - Statistics - Correlation...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533536318\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533586869\n" +"help.text" +msgid "A correlation coefficient of +1 indicates a perfect positive correlation." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533567951\n" +"help.text" +msgid "A correlation coefficient of -1 indicates a perfect negative correlation" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533654986\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533680006\n" +"help.text" +msgid "The following table displays the results of the correlation of the sample data above." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533666011\n" +"help.text" +msgid "Correlations" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533643141\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533674994\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533691064\n" +"help.text" +msgid "Column 3" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533613299\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533698236\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533614553\n" +"help.text" +msgid "Column 3" +msgstr "" + +#: statistics.xhp +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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2953032\n" +"1\n" +"help.text" +msgid "Covariance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2956327\n" +"2\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/covariancedialog/CovarianceDialog\">Calculates the covariance of two sets of numeric data.</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2952992\n" +"26\n" +"help.text" +msgid "<variable id=\"cov01\">Menu <emph>Data - Statistics - Covariance...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533662738\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2009201415533654986\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533643866\n" +"help.text" +msgid "The following table displays the results of the covariance of the sample data above." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533635095\n" +"help.text" +msgid "Covariances" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533619955\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533651324\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533613800\n" +"help.text" +msgid "Column 3" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533640180\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553367596\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553364047\n" +"help.text" +msgid "Column 3" +msgstr "" + +#: statistics.xhp +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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id03003\n" +"1\n" +"help.text" +msgid "Exponential Smoothing" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id03004\n" +"2\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog\">Results in a smoothed data series</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id03005\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Exponential Smoothing...</emph></variable>" +msgstr "" + +#: 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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533641726\n" +"help.text" +msgid "Exponential smoothing is commonly applied to financial market and economic data, but it can be used with any discrete set of repeated measurements. The simplest form of exponential smoothing should be used only for data without any systematic trend or seasonal components." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533698172\n" +"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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id200820141553364794\n" +"help.text" +msgid "Parameters" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533649086\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533764911\n" +"help.text" +msgid "The resulting smoothing is below with smoothing factor as 0.5:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533725829\n" +"help.text" +msgid "Alpha" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533712984\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533764774\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id04003\n" +"1\n" +"help.text" +msgid "Moving Average" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id04004\n" +"2\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/movingaveragedialog/MovingAverageDialog\">Calculates the moving average of a time series</ahelp>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id04005\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - Moving Average...</emph></variable>" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533748861\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533744678\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533751077\n" +"help.text" +msgid "Parameters" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533787018\n" +"help.text" +msgid "<emph>Interval</emph>: The number of samples used in the moving average calculation." +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533779483\n" +"help.text" +msgid "Column 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533791711\n" +"help.text" +msgid "Column 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533764431\n" +"help.text" +msgid "#N/A" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533754380\n" +"help.text" +msgid "#N/A" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533847092\n" +"help.text" +msgid "#N/A" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533890018\n" +"help.text" +msgid "#N/A" +msgstr "" + +#: statistics.xhp +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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id05003\n" +"1\n" +"help.text" +msgid "t-test and F-test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id05004\n" +"2\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id05005\n" +"26\n" +"help.text" +msgid "<variable id=\"sam01\">Menu <emph>Data - Statistics - t-test...</emph></variable>" +msgstr "" + +#: 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 "" + +#: 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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533819476\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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533844122\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 "" + +#: 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 "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533817070\n" +"help.text" +msgid "Data" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533823950\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_id2008201415533822766\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_id2008201415533879965\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_id2008201415533956416\n" +"help.text" +msgid "Example for t-Test:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553388982\n" +"help.text" +msgid "The following table shows the <emph>t-Test</emph> for the data series above:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533892337\n" +"help.text" +msgid "t-test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533864455\n" +"help.text" +msgid "Alpha" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533863306\n" +"help.text" +msgid "Variable 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533818481\n" +"help.text" +msgid "Variable 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533858438\n" +"help.text" +msgid "Mean" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533897974\n" +"help.text" +msgid "Variance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533868040\n" +"help.text" +msgid "Observations" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533825806\n" +"help.text" +msgid "Pearson Correlation" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533840871\n" +"help.text" +msgid "Hypothesized Mean Difference" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533859489\n" +"help.text" +msgid "Observed Mean Difference" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533826221\n" +"help.text" +msgid "Variance of the Differences" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533860284\n" +"help.text" +msgid "df" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533871121\n" +"help.text" +msgid "t Stat" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533822174\n" +"help.text" +msgid "P (T<=t) one-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533811741\n" +"help.text" +msgid "t Critical one-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533829667\n" +"help.text" +msgid "P (T<=t) two-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533865577\n" +"help.text" +msgid "5.91750215348761E-010" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533931877\n" +"help.text" +msgid "t Critical two-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"hd_id2008201415533942416\n" +"help.text" +msgid "Example for F-Test:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533978190\n" +"help.text" +msgid "The following table shows the <emph>F</emph><emph>-Test</emph> for the data series above:" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533950785\n" +"help.text" +msgid "F-test" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533911319\n" +"help.text" +msgid "Alpha" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533999353\n" +"help.text" +msgid "Variable 1" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533926248\n" +"help.text" +msgid "Variable 2" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533918157\n" +"help.text" +msgid "Mean" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id200820141553392922\n" +"help.text" +msgid "Variance" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533924413\n" +"help.text" +msgid "Observations" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533948860\n" +"help.text" +msgid "df" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533928162\n" +"help.text" +msgid "F" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533996864\n" +"help.text" +msgid "P (F<=f) right-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533921377\n" +"help.text" +msgid "F Critical right-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533960592\n" +"help.text" +msgid "P (F<=f) left-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533922655\n" +"help.text" +msgid "F Critical left-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533918990\n" +"help.text" +msgid "P two-tail" +msgstr "" + +#: statistics.xhp +msgctxt "" +"statistics.xhp\n" +"par_id2008201415533940157\n" +"help.text" +msgid "F Critical two-tail" +msgstr "" + #: text2columns.xhp msgctxt "" "text2columns.xhp\n" |