Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=79
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=80", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=78", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<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>" ], "previous_source": "", "target": [ "" ], "id_hash": 4650533187414655294, "content_hash": 4650533187414655294, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2950758\nhelp.text", "note": "xo3Fc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3901, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/111042353/?format=api", "priority": 100, "id": 112432208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c08a034b5c04013e", "url": "https://translations.documentfoundation.org/api/units/112432208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.817919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Z.TEST(Data; mu [; Sigma])" ], "previous_source": "", "target": [ "" ], "id_hash": 6039968643450445427, "content_hash": 6039968643450445427, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2953274\nhelp.text", "note": "Ug83K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3902, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111042419/?format=api", "priority": 100, "id": 112432209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d3d2477ae75c9e73", "url": "https://translations.documentfoundation.org/api/units/112432209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.818901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> is the given sample, drawn from a normally distributed population." ], "previous_source": "", "target": [ "" ], "id_hash": -4688687849677694639, "content_hash": -4688687849677694639, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2956109\nhelp.text", "note": "2peSH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3903, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111042561/?format=api", "priority": 100, "id": 112432210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3eee6f3e11455951", "url": "https://translations.documentfoundation.org/api/units/112432210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.819891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>mu</emph> is the known mean of the population." ], "previous_source": "", "target": [ "" ], "id_hash": 2550841215093408997, "content_hash": 2550841215093408997, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2949977\nhelp.text", "note": "havEd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3904, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111042574/?format=api", "priority": 100, "id": 112432211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a3666891f81184e5", "url": "https://translations.documentfoundation.org/api/units/112432211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.820866Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used." ], "previous_source": "", "target": [ "" ], "id_hash": -4345402988332874879, "content_hash": -4345402988332874879, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2954740\nhelp.text", "note": "uuVdM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3905, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111042583/?format=api", "priority": 100, "id": 112432212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=43b207014a7f8381", "url": "https://translations.documentfoundation.org/api/units/112432212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.822542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "" ], "id_hash": -2297621333757577964, "content_hash": -2297621333757577964, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2948770\nhelp.text", "note": "sbnS9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3906, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/111042594/?format=api", "priority": 100, "id": 112432213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=601d3591fd053514", "url": "https://translations.documentfoundation.org/api/units/112432213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.825431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>HARMEAN function</bookmark_value> <bookmark_value>means;harmonic</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 942439209612771997, "content_hash": 942439209612771997, "location": "04060182.xhp", "context": "04060182.xhp\nbm_id3153623\nhelp.text", "note": "E34M8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3907, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111042664/?format=api", "priority": 100, "id": 112432214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8d143777c75e829d", "url": "https://translations.documentfoundation.org/api/units/112432214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.828017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HARMEAN" ], "previous_source": "", "target": [ "" ], "id_hash": -8559400109436081212, "content_hash": -8559400109436081212, "location": "04060182.xhp", "context": "04060182.xhp\nhd_id3153623\nhelp.text", "note": "QgAHe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3908, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111042704/?format=api", "priority": 100, "id": 112432215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0936e6f33a9f6bc4", "url": "https://translations.documentfoundation.org/api/units/112432215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.829944Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HARMITTEL\">Returns the harmonic mean of a data set.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -8966420965118014409, "content_hash": -8966420965118014409, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3155102\nhelp.text", "note": "Mp6mJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3909, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111042752/?format=api", "priority": 100, "id": 112432216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0390dfa36b868c37", "url": "https://translations.documentfoundation.org/api/units/112432216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.831697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HARMEAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": -9058043313621347542, "content_hash": -9058043313621347542, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3149287\nhelp.text", "note": "EKBXf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3910, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111042809/?format=api", "priority": 100, "id": 112432217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=024b5d990b7f532a", "url": "https://translations.documentfoundation.org/api/units/112432217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.833488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=HARMEAN(23;46;69)</item> = 37.64. The harmonic mean of this random sample is thus 37.64" ], "previous_source": "", "target": [ "" ], "id_hash": 8186600637588396402, "content_hash": 8186600637588396402, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3146093\nhelp.text", "note": "DMCH7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3911, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/111042846/?format=api", "priority": 100, "id": 112432218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f19ca5e7c9715972", "url": "https://translations.documentfoundation.org/api/units/112432218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.834953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>HYPGEOMDIST function</bookmark_value> <bookmark_value>sampling without replacement</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4467563399851631061, "content_hash": 4467563399851631061, "location": "04060182.xhp", "context": "04060182.xhp\nbm_id3152801\nhelp.text", "note": "Cd5VE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3912, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111042865/?format=api", "priority": 100, "id": 112432219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bdfff93df3b161d5", "url": "https://translations.documentfoundation.org/api/units/112432219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.835961Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HYPGEOMDIST" ], "previous_source": "", "target": [ "" ], "id_hash": 8430947320739666064, "content_hash": 8430947320739666064, "location": "04060182.xhp", "context": "04060182.xhp\nhd_id3152801\nhelp.text", "note": "9mrAG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3913, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111042889/?format=api", "priority": 100, "id": 112432220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f500bdeb4cb81890", "url": "https://translations.documentfoundation.org/api/units/112432220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.836940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 295134613271242650, "content_hash": 295134613271242650, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3159341\nhelp.text", "note": "XWGNo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3914, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111042932/?format=api", "priority": 100, "id": 112432221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8418875df8f4679a", "url": "https://translations.documentfoundation.org/api/units/112432221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.837871Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative])" ], "previous_source": "", "target": [ "" ], "id_hash": -8999162391082469966, "content_hash": -8999162391082469966, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3155388\nhelp.text", "note": "BEUMD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3915, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111043001/?format=api", "priority": 100, "id": 112432222, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=031c8d7c237975b2", "url": "https://translations.documentfoundation.org/api/units/112432222/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.838797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>X</emph> is the number of results achieved in the random sample." ], "previous_source": "", "target": [ "" ], "id_hash": -7607057655886478847, "content_hash": -7607057655886478847, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3154933\nhelp.text", "note": "ingyW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3916, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111043091/?format=api", "priority": 100, "id": 112432223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=166e4d5daaf88201", "url": "https://translations.documentfoundation.org/api/units/112432223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.839710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>NSample</emph> is the size of the random sample." ], "previous_source": "", "target": [ "" ], "id_hash": -21246565217862334, "content_hash": -21246565217862334, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3153106\nhelp.text", "note": "EXbsZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3917, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111043145/?format=api", "priority": 100, "id": 112432224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7fb4845c8b7dfd42", "url": "https://translations.documentfoundation.org/api/units/112432224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.840693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Successes</emph> is the number of possible results in the total population." ], "previous_source": "", "target": [ "" ], "id_hash": 2130957629832182108, "content_hash": 2130957629832182108, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3146992\nhelp.text", "note": "dxUiA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3918, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111043223/?format=api", "priority": 100, "id": 112432225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9d92aeac8d8e395c", "url": "https://translations.documentfoundation.org/api/units/112432225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.841714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>NPopulation </emph>is the size of the total population." ], "previous_source": "", "target": [ "" ], "id_hash": 7733664477768198662, "content_hash": 7733664477768198662, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3148826\nhelp.text", "note": "CtC87", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3919, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111043262/?format=api", "priority": 100, "id": 112432226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eb537ede296e2a06", "url": "https://translations.documentfoundation.org/api/units/112432226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.842689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability mass function (FALSE or 0) or the cumulative distribution function (any other value). The probability mass function is the default if no value is specified for this parameter." ], "previous_source": "", "target": [ "" ], "id_hash": 2279116313704847810, "content_hash": 2279116313704847810, "location": "04060182.xhp", "context": "04060182.xhp\npar_id231585952506847\nhelp.text", "note": "MDMvu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3920, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/111043312/?format=api", "priority": 100, "id": 112432227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9fa10c36482cd9c2", "url": "https://translations.documentfoundation.org/api/units/112432227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.843705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "" ], "id_hash": -6447868649844901511, "content_hash": -6447868649844901511, "location": "04060182.xhp", "context": "04060182.xhp\npar_id3154904\nhelp.text", "note": "WUiB6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3921, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/111043349/?format=api", "priority": 100, "id": 112432228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=268491a00f9df979", "url": "https://translations.documentfoundation.org/api/units/112432228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.844788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>HYPGEOM.DIST function</bookmark_value> <bookmark_value>sampling without replacement</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -5838898684740429819, "content_hash": -5838898684740429819, "location": "04060182.xhp", "context": "04060182.xhp\nbm_id2952801\nhelp.text", "note": "V8zPJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3922, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111043381/?format=api", "priority": 100, "id": 112432229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2ef81095008d1805", "url": "https://translations.documentfoundation.org/api/units/112432229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.845968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HYPGEOM.DIST" ], "previous_source": "", "target": [ "" ], "id_hash": -8360183656428898054, "content_hash": -8360183656428898054, "location": "04060182.xhp", "context": "04060182.xhp\nhd_id2952801\nhelp.text", "note": "CoN4S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3923, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111043428/?format=api", "priority": 100, "id": 112432230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0bfaa942358778fa", "url": "https://translations.documentfoundation.org/api/units/112432230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.847022Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYP_GEOM_DIST_MS\">Returns the hypergeometric distribution.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -8224398599657107687, "content_hash": -8224398599657107687, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2959341\nhelp.text", "note": "CB8RU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3924, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111043440/?format=api", "priority": 100, "id": 112432231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0ddd110c6037cf19", "url": "https://translations.documentfoundation.org/api/units/112432231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.847992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative)" ], "previous_source": "", "target": [ "" ], "id_hash": 2578829530255404649, "content_hash": 2578829530255404649, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2955388\nhelp.text", "note": "cr6Cw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3925, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111043452/?format=api", "priority": 100, "id": 112432232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a3c9d7cb67292e69", "url": "https://translations.documentfoundation.org/api/units/112432232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.848979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>X</emph> is the number of results achieved in the random sample." ], "previous_source": "", "target": [ "" ], "id_hash": -2671796621107358721, "content_hash": -2671796621107358721, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2954933\nhelp.text", "note": "CuQSa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3926, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111043616/?format=api", "priority": 100, "id": 112432233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5aebdf20fece93ff", "url": "https://translations.documentfoundation.org/api/units/112432233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.851689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>NSample</emph> is the size of the random sample." ], "previous_source": "", "target": [ "" ], "id_hash": -4535479031550650732, "content_hash": -4535479031550650732, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2953106\nhelp.text", "note": "6BMz6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3927, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111043629/?format=api", "priority": 100, "id": 112432234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=410ebdd9ce30d694", "url": "https://translations.documentfoundation.org/api/units/112432234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.853981Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Successes</emph> is the number of possible results in the total population." ], "previous_source": "", "target": [ "" ], "id_hash": 3870084298717870662, "content_hash": 3870084298717870662, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2946992\nhelp.text", "note": "GvWAn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3928, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111043649/?format=api", "priority": 100, "id": 112432235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b5b54d2a43e53a46", "url": "https://translations.documentfoundation.org/api/units/112432235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.856218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>NPopulation </emph>is the size of the total population." ], "previous_source": "", "target": [ "" ], "id_hash": -1942417869773319253, "content_hash": -1942417869773319253, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2948826\nhelp.text", "note": "VEzuG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3929, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111043674/?format=api", "priority": 100, "id": 112432236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=650b253d22ca53ab", "url": "https://translations.documentfoundation.org/api/units/112432236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.858010Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Cumulative </emph>: 0 or False calculates the probability density function. Other values or True calculates the cumulative distribution function." ], "previous_source": "", "target": [ "" ], "id_hash": -3414385637703310584, "content_hash": -3414385637703310584, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2948827\nhelp.text", "note": "JG59B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3930, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111043752/?format=api", "priority": 100, "id": 112432237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=509daa5a4a7fa308", "url": "https://translations.documentfoundation.org/api/units/112432237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.859081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "" ], "id_hash": 3065472909195678950, "content_hash": 3065472909195678950, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2954904\nhelp.text", "note": "xhCCb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3931, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/111043775/?format=api", "priority": 100, "id": 112432238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=aa8abf5e8d3114e6", "url": "https://translations.documentfoundation.org/api/units/112432238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.860400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1." ], "previous_source": "", "target": [ "" ], "id_hash": 5830292459840691085, "content_hash": 5830292459840691085, "location": "04060182.xhp", "context": "04060182.xhp\npar_id2954905\nhelp.text", "note": "FEcD8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3932, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111043797/?format=api", "priority": 100, "id": 112432239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d0e95c1a1d715b8d", "url": "https://translations.documentfoundation.org/api/units/112432239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.861581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Statistical Functions Part Three" ], "previous_source": "", "target": [ "" ], "id_hash": -3234383842447754803, "content_hash": -3234383842447754803, "location": "04060183.xhp", "context": "04060183.xhp\ntit\nhelp.text", "note": "L3n3y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3933, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111043821/?format=api", "priority": 100, "id": 112432240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=531d290823a379cd", "url": "https://translations.documentfoundation.org/api/units/112432240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.862551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"kl\"><link href=\"text/scalc/01/04060183.xhp\">Statistical Functions Part Three</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5028260164627553746, "content_hash": -5028260164627553746, "location": "04060183.xhp", "context": "04060183.xhp\nhd_id3166425\nhelp.text", "note": "vPFBu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3934, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111043846/?format=api", "priority": 100, "id": 112432241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3a3808056920a22e", "url": "https://translations.documentfoundation.org/api/units/112432241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.863650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>LARGE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -6341562117081971601, "content_hash": -6341562117081971601, "location": "04060183.xhp", "context": "04060183.xhp\nbm_id3149530\nhelp.text", "note": "bB7mP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3935, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111043884/?format=api", "priority": 100, "id": 112432242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=27fe3eda8241446f", "url": "https://translations.documentfoundation.org/api/units/112432242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.864562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "LARGE" ], "previous_source": "", "target": [ "" ], "id_hash": -1023176563680745474, "content_hash": -1023176563680745474, "location": "04060183.xhp", "context": "04060183.xhp\nhd_id3149530\nhelp.text", "note": "CBSo7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3936, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111043926/?format=api", "priority": 100, "id": 112432243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=71ccf2561b4de7fe", "url": "https://translations.documentfoundation.org/api/units/112432243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.865462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_KGROESSTE\">Returns the Rank_c-th largest value in a data set.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 7269346318294578572, "content_hash": 7269346318294578572, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3150518\nhelp.text", "note": "Hr8AM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3937, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111044026/?format=api", "priority": 100, "id": 112432244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e4e1e7f63b3df58c", "url": "https://translations.documentfoundation.org/api/units/112432244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.866377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "LARGE(Data; RankC)" ], "previous_source": "", "target": [ "" ], "id_hash": -6024254460788408271, "content_hash": -6024254460788408271, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3154372\nhelp.text", "note": "nrZUw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3938, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111044048/?format=api", "priority": 100, "id": 112432245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2c658c7c5c250031", "url": "https://translations.documentfoundation.org/api/units/112432245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.867351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> is the cell range of data." ], "previous_source": "", "target": [ "" ], "id_hash": -6057338040103995537, "content_hash": -6057338040103995537, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3152986\nhelp.text", "note": "Z5puA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3939, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111044099/?format=api", "priority": 100, "id": 112432246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2bf003254b23f76f", "url": "https://translations.documentfoundation.org/api/units/112432246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.868266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>RankC</emph> is the ranking of the value. If RankC is an array, the function becomes an <link href=\"text/scalc/01/04060107.xhp\">array function</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 9189301188743548876, "content_hash": 9189301188743548876, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3156448\nhelp.text", "note": "TvB38", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3940, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111044151/?format=api", "priority": 100, "id": 112432247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ff86f4be81224fcc", "url": "https://translations.documentfoundation.org/api/units/112432247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.869171Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=LARGE(A1:C50;2)</input> gives the second largest value in A1:C50." ], "previous_source": "", "target": [ "" ], "id_hash": -6613113807793286706, "content_hash": -6613113807793286706, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3148702\nhelp.text", "note": "9gMJx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3941, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111044192/?format=api", "priority": 100, "id": 112432248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=24398007934011ce", "url": "https://translations.documentfoundation.org/api/units/112432248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.870272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=LARGE(A1:C50;B1:B5)</input> entered as an array function gives an array of the c-th largest value in A1:C50 with ranks defined in B1:B5." ], "previous_source": "", "target": [ "" ], "id_hash": 7385347688449855772, "content_hash": 7385347688449855772, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3248702\nhelp.text", "note": "fdcAk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3942, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111044236/?format=api", "priority": 100, "id": 112432249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e67e0697e8ce511c", "url": "https://translations.documentfoundation.org/api/units/112432249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.871675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>SMALL function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2123050956903722335, "content_hash": 2123050956903722335, "location": "04060183.xhp", "context": "04060183.xhp\nbm_id3154532\nhelp.text", "note": "p8pZc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3943, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111044311/?format=api", "priority": 100, "id": 112432250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9d769798ce4cad5f", "url": "https://translations.documentfoundation.org/api/units/112432250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.873191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "SMALL" ], "previous_source": "", "target": [ "" ], "id_hash": -8296115154123032801, "content_hash": -8296115154123032801, "location": "04060183.xhp", "context": "04060183.xhp\nhd_id3154532\nhelp.text", "note": "mzbdE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3944, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111044350/?format=api", "priority": 100, "id": 112432251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0cde4738d6c2f71f", "url": "https://translations.documentfoundation.org/api/units/112432251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.874340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_KKLEINSTE\">Returns the Rank_c-th smallest value in a data set.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 2060151539794964996, "content_hash": 2060151539794964996, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3157981\nhelp.text", "note": "6ApAi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3945, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111044384/?format=api", "priority": 100, "id": 112432252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9c9720e908f3f204", "url": "https://translations.documentfoundation.org/api/units/112432252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.875482Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "SMALL(Data; RankC)" ], "previous_source": "", "target": [ "" ], "id_hash": 3308754017022525057, "content_hash": 3308754017022525057, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3153974\nhelp.text", "note": "jXJsY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3946, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111044422/?format=api", "priority": 100, "id": 112432253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=adeb0e3f79c63e81", "url": "https://translations.documentfoundation.org/api/units/112432253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.876632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> is the cell range of data." ], "previous_source": "", "target": [ "" ], "id_hash": 2440600531480468558, "content_hash": 2440600531480468558, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3154540\nhelp.text", "note": "LxZAE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3947, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111044565/?format=api", "priority": 100, "id": 112432254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a1dec140a585dc4e", "url": "https://translations.documentfoundation.org/api/units/112432254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.877709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>RankC</emph> is the rank of the value. If RankC is an array, the function becomes an <link href=\"text/scalc/01/04060107.xhp\">array function</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 4032003350830427584, "content_hash": 4032003350830427584, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3155094\nhelp.text", "note": "xBJHr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3948, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111044594/?format=api", "priority": 100, "id": 112432255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b7f48daf636eadc0", "url": "https://translations.documentfoundation.org/api/units/112432255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.879368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=SMALL(A1:C50;2)</input> gives the second smallest value in A1:C50." ], "previous_source": "", "target": [ "" ], "id_hash": 6414258481560929304, "content_hash": 6414258481560929304, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3149897\nhelp.text", "note": "8BLf3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3949, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111044630/?format=api", "priority": 100, "id": 112432256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d904061ad2f9c418", "url": "https://translations.documentfoundation.org/api/units/112432256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.880871Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=SMALL(A1:C50;B1:B5)</input> entered as an array function gives an array of the c-th smallest value in A1:C50 with ranks defined in B1:B5." ], "previous_source": "", "target": [ "" ], "id_hash": 7072759967355682694, "content_hash": 7072759967355682694, "location": "04060183.xhp", "context": "04060183.xhp\npar_id3249897\nhelp.text", "note": "AuKCZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3950, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111044684/?format=api", "priority": 100, "id": 112432257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e2277db79bd6bf86", "url": "https://translations.documentfoundation.org/api/units/112432257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:09.882181Z" } ] }{ "count": 8439, "next": "