diff options
Diffstat (limited to 'source/id/helpcontent2/source/text/scalc')
-rw-r--r-- | source/id/helpcontent2/source/text/scalc/00.po | 38 | ||||
-rw-r--r-- | source/id/helpcontent2/source/text/scalc/01.po | 4429 | ||||
-rw-r--r-- | source/id/helpcontent2/source/text/scalc/02.po | 10 | ||||
-rw-r--r-- | source/id/helpcontent2/source/text/scalc/04.po | 6 | ||||
-rw-r--r-- | source/id/helpcontent2/source/text/scalc/05.po | 31 | ||||
-rw-r--r-- | source/id/helpcontent2/source/text/scalc/guide.po | 186 |
6 files changed, 2462 insertions, 2238 deletions
diff --git a/source/id/helpcontent2/source/text/scalc/00.po b/source/id/helpcontent2/source/text/scalc/00.po index 63c0bddf2dd..8de4910078f 100644 --- a/source/id/helpcontent2/source/text/scalc/00.po +++ b/source/id/helpcontent2/source/text/scalc/00.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: 2020-03-13 12:05+0100\n" +"POT-Creation-Date: 2020-03-31 10:35+0200\n" "PO-Revision-Date: 2020-02-05 07:20+0000\n" "Last-Translator: Andika Triwidada <andika@gmail.com>\n" "Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc00/id/>\n" @@ -1243,6 +1243,24 @@ msgctxt "" msgid "<variable id=\"dnsrt\">Choose <emph>Data - Sort...</emph>.</variable>" msgstr "<variable id=\"dnsrt\">Pilih <emph>Data - Urutkan...</emph>.</variable>" +#. rscQf +#: 00000412.xhp +msgctxt "" +"00000412.xhp\n" +"par_id641584647437810\n" +"help.text" +msgid "<variable id=\"datasortascending\">Choose <menuitem>Data - Sort Ascending</menuitem></variable>" +msgstr "" + +#. GHhdg +#: 00000412.xhp +msgctxt "" +"00000412.xhp\n" +"par_id711584647447316\n" +"help.text" +msgid "<variable id=\"datasortdescending\">Choose <menuitem>Data - Sort Descending</menuitem></variable>" +msgstr "" + #. oEATB #: 00000412.xhp msgctxt "" @@ -1252,23 +1270,23 @@ msgctxt "" msgid "Choose <emph>Data - Sort - Sort Criteria</emph> tab." msgstr "Pilih tab <emph>Data - Urut - Kriteria Pengurutan</emph>." -#. hBn6A +#. SG8FW #: 00000412.xhp msgctxt "" "00000412.xhp\n" "par_id3154516\n" "help.text" -msgid "On <emph>Standard</emph> bar, click" -msgstr "Pada bilah<emph>Standar</emph> , klik" +msgid "<variable id=\"onthestandardbar\">On <emph>Standard</emph> bar, click</variable>" +msgstr "" -#. tBEpr +#. GDBeV #: 00000412.xhp msgctxt "" "00000412.xhp\n" "par_id3148663\n" "help.text" -msgid "<image id=\"img_id3150543\" src=\"cmd/sc_sortup.png\" width=\"0.1665inch\" height=\"0.1665inch\"><alt id=\"alt_id3150543\">Icon</alt></image>" -msgstr "<image id=\"img_id3150543\" src=\"cmd/sc_sortup.png\" width=\"0.1665inch\" height=\"0.1665inch\"><alt id=\"alt_id3150543\">Ikon</alt></image>" +msgid "<image id=\"img_id3150543\" src=\"cmd/sc_sortup.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150543\">Icon Sort Ascending</alt></image>" +msgstr "" #. vv2Zk #: 00000412.xhp @@ -1279,14 +1297,14 @@ msgctxt "" msgid "Sort Ascending" msgstr "Urut Menaik" -#. fhex2 +#. QXzES #: 00000412.xhp msgctxt "" "00000412.xhp\n" "par_id3153969\n" "help.text" -msgid "<image id=\"img_id3125863\" src=\"cmd/sc_sortdown.png\" width=\"0.1701inch\" height=\"0.1701inch\"><alt id=\"alt_id3125863\">Icon</alt></image>" -msgstr "<image id=\"img_id3125863\" src=\"cmd/sc_sortdown.png\" width=\"0.1701inch\" height=\"0.1701inch\"><alt id=\"alt_id3125863\">Ikon</alt></image>" +msgid "<image id=\"img_id3125863\" src=\"cmd/sc_sortdown.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3125863\">Icon Sort Descending</alt></image>" +msgstr "" #. AHMAB #: 00000412.xhp diff --git a/source/id/helpcontent2/source/text/scalc/01.po b/source/id/helpcontent2/source/text/scalc/01.po index 632e1cfb12f..52adc0e2fcb 100644 --- a/source/id/helpcontent2/source/text/scalc/01.po +++ b/source/id/helpcontent2/source/text/scalc/01.po @@ -3,9 +3,9 @@ msgid "" msgstr "" "Project-Id-Version: libo_help scalc 4.2\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2020-03-13 12:05+0100\n" -"PO-Revision-Date: 2020-02-29 17:15+0000\n" -"Last-Translator: Imanuel Ronaldo <imanuelronaldo@gmail.com>\n" +"POT-Creation-Date: 2020-04-03 11:46+0200\n" +"PO-Revision-Date: 2020-04-03 09:53+0000\n" +"Last-Translator: Andika Triwidada <andika@gmail.com>\n" "Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/id/>\n" "Language: id\n" "MIME-Version: 1.0\n" @@ -4433,7 +4433,7 @@ msgctxt "" "par_id3154016\n" "help.text" msgid "The Database category may be confused with a database integrated in $[officename]. However, there is no connection between a database in $[officename] and the Database category in $[officename] Calc." -msgstr "Kategori Basis Data mungkin bingung dengan pangkalan data yang terintegrasi dalam $[officename]. Namun, tidak ada koneksi antara basis data dalam $[officename] dan kategori Basis Data dalam $[officename] Calc." +msgstr "Kategori Basis Data mungkin bingung dengan basis data yang terintegrasi dalam $[officename]. Namun, tidak ada koneksi antara basis data dalam $[officename] dan kategori Basis Data dalam $[officename] Calc." #. jEaEF #: 04060101.xhp @@ -4892,7 +4892,7 @@ msgctxt "" "par_id3153982\n" "help.text" msgid "In the example above (scroll up, please), you can search for the number of children whose name starts with an E or a subsequent letter. Edit the formula in B16 to read <item type=\"input\">=DCOUNTA(A1:E10;\"Name\";A13:E14)</item>. Delete the old search criteria and enter <item type=\"input\">>=E</item> under Name in field A14. The result is 5. If you now delete all number values for Greta in row 8, the result changes to 4. Row 8 is no longer included in the count because it does not contain any values. The name Greta is text, not a value. Note that the DatabaseField parameter must point to a column that can contain values." -msgstr "Pada contoh di atas (gulir ke atas), anda dapat mencari jumlah anak yang namanya berawalan dengan huruf E atau huruf berikutnya. Ubah rumus pada B16 untuk membaca<item type=\"input\">=DCOUNTA(A1:E10;\"Nama\";A13:E14)</item>. Hapus kriteria pencarian yang lama dan Enter <item type=\"input\">>=E</item> di bawah Nama pada ruas A14. Hasilnya adalah 5. Jika anda sekarang menghapus semua nilai angka untuk Greta di baris 8, hasil akan berubah menjadi 4. Baris 8 tidak lagi termasuk dalam hitungan karena tidak berisi nilai. Nama Greta adalah teks, bukan nilai. Perhatikan bahwa parameter Pangkalan Ruas Basis Data menunjuk pada kolom yang berisi nilai." +msgstr "Pada contoh di atas (gulir ke atas), Anda dapat mencari banyaknya anak yang namanya berawalan dengan huruf E atau huruf berikutnya. Ubah rumus pada B16 untuk membaca <item type=\"input\">=DCOUNTA(A1:E10;\"Nama\";A13:E14)</item>. Hapus kriteria pencarian yang lama dan Enter <item type=\"input\">>=E</item> di bawah Nama pada ruas A14. Hasilnya adalah 5. Jika Anda sekarang menghapus semua nilai angka untuk Greta di baris 8, hasil akan berubah menjadi 4. Baris 8 tidak lagi termasuk dalam hitungan karena tidak berisi nilai. Nama Greta adalah teks, bukan nilai. Perhatikan bahwa parameter DatabaseField harus menunjuk pada kolom yang berisi nilai." #. eBniZ #: 04060101.xhp @@ -10061,23 +10061,14 @@ msgctxt "" msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." msgstr "Argumen juga ekspresi logis itu sendiri(TRUE,1<5, 2+3=7, B8<10) yang mengembalikan nilai logika, atau arrays(A1:C3) yang berisi nilai logika" -#. W8DPe +#. 7ALjG #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3159123\n" "help.text" -msgid "AND(LogicalValue1; LogicalValue2 ...LogicalValue30)" -msgstr "AND(Nilai logika 1; Nilai logika 2 ...Nilai logika 30)" - -#. MoFG6 -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" -"par_id3150038\n" -"help.text" -msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE." -msgstr "<emph>NilaiLogis1; NilaiLogis2 ...NilaiLogis30</emph> adalah kondisi yang akan diperiksa.Semua kondisi bisa juga TRUE atau FALSE. Jika rentang yang dimasukkan adalah sebagai parameter, fungsi menggunakan semua rentang nilai. Hasilnya adalah TRUE jika nilai logis di dalam semua sel dalam rentang tersebut adalah TRUE." +msgid "AND(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" +msgstr "" #. 3exzA #: 04060105.xhp @@ -10322,23 +10313,14 @@ msgctxt "" msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." msgstr "Argumen juga ekspresi logis itu sendiri(TRUE,1<5, 2+3=7, B8<10) yang mengembalikan nilai logika, atau arrays(A1:C3) yang berisi nilai logika" -#. emuWZ +#. rpDNn #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3150468\n" "help.text" -msgid "OR(LogicalValue1; LogicalValue2 ...LogicalValue30)" -msgstr "OR(Nilai logika 1; Nilai logika 2 ...Nilai logika 30)" - -#. PJjmV -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" -"par_id3155819\n" -"help.text" -msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range." -msgstr "<emph>NilaiLogis1; NilaiLogis2 ...NilaiLogis30</emph> adalah kondisi yang diperiksa. Semua kondisi bisa menjadi TRUE atau FALSE. Jika sebuah rentang yang dimasukkan adalah sebagai parameter, fungsi menggunakan semua nilai rentang." +msgid "OR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" +msgstr "" #. oFKWj #: 04060105.xhp @@ -10475,14 +10457,14 @@ msgctxt "" msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." msgstr "Argumen juga ekspresi logis itu sendiri(TRUE,1<5, 2+3=7, B8<10) yang mengembalikan nilai logika, atau arrays(A1:C3) yang berisi nilai logika" -#. pdqV8 +#. fpCVV #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3150469\n" "help.text" -msgid "XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)" -msgstr "AND(Nilai logika 1; Nilai logika 2 ...Nilai logika 30)" +msgid "XOR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" +msgstr "" #. qpsgo #: 04060105.xhp @@ -12088,23 +12070,14 @@ msgctxt "" msgid "The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers." msgstr "Pembagi umum terbesar adalah bilangan bulat positif terbesar yang akan membagi, tanpa sisa, masing-masing bilangan bulat yang diberikan." -#. LEUYK +#. 84G6i #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3154524\n" "help.text" -msgid "GCD(Integer1; Integer2; ...; Integer30)" -msgstr "GCD(Integer1; Integer2; ...; Integer30)" - -#. KF2eB -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3149340\n" -"help.text" -msgid "<emph>Integer1 To 30</emph> are up to 30 integers whose greatest common divisor is to be calculated." -msgstr "<emph>Integer1 ke 30</emph>hingga 30 bilangan bulat yang pembagi umum terbesarnya harus dihitung." +msgid "GCD(<embedvar href=\"text/scalc/01/ful_func.xhp#integer255_1\" markup=\"keep\"/>)" +msgstr "" #. EeAKi #: 04060106.xhp @@ -12151,23 +12124,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_GCD\">The result is the greatest common divisor of a list of numbers.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_GCD\">Hasilnya adalah pembagi umum terbesar dari daftar angka.</ahelp>" -#. RcC6R +#. gQ2S4 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3156205\n" "help.text" -msgid "GCD_EXCEL2003(Number(s))" -msgstr "GCD_EXCEL2003(Bilangan(s))" - -#. Gt222 -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3145150\n" -"help.text" -msgid "<emph>Number(s)</emph> is a list of up to 30 numbers." -msgstr "<emph>Bilangan(s)</emph> adalah daftar sampai 30 bilangan." +msgid "GCD_EXCEL2003(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. wNE9S #: 04060106.xhp @@ -12205,32 +12169,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_KGV\">Returns the least common multiple of one or more integers.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_KGV\">Mengembalikan kelipatan paling umum dari satu atau lebih bilangan bulat.</ahelp>" -#. WUZq6 +#. BeETS #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3147279\n" "help.text" -msgid "LCM(Integer1; Integer2; ...; Integer30)" -msgstr "LCM(Integer1; Integer2; ...; Integer30)" - -#. Kqqia -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3156348\n" -"help.text" -msgid "<emph>Integer1 to 30</emph> are up to 30 integers whose lowest common multiple is to be calculated." -msgstr "<emph>Integer1 to 30</emph>hingga 30 bilangan bulat yang kelipatan umum terendahnya harus dihitung." +msgid "LCM(<embedvar href=\"text/scalc/01/ful_func.xhp#integer255_1\" markup=\"keep\"/>)" +msgstr "" -#. eAgPR +#. gzLdr #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3154914\n" "help.text" -msgid "If you enter the numbers <item type=\"input\">512</item>;<item type=\"input\">1024</item> and <item type=\"input\">2000</item> in the Integer 1;2 and 3 text boxes, 128000 will be returned as the result." -msgstr "Jika anda memasukkan bilangan <item type=\"input\">512</item>;<item type=\"input\">1024</item> dan <item type=\"input\">2000</item>pada kotak teks Integer1;2 dan 3, akan mengembalikan 128000 sebagai hasil." +msgid "If you enter the numbers 512; 1024 and 2000 as Integer 1;2 and 3, then 128000 will be returned." +msgstr "" #. 7vjBB #: 04060106.xhp @@ -12259,23 +12214,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_LCM\">The result is the lowest common multiple of a list of numbers.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_LCM\">Hasilnya adalah kelipatan umum terendah dari daftar nomor</ahelp>" -#. WnQpb +#. ZVaoq #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3154395\n" "help.text" -msgid "LCM_EXCEL2003(Number(s))" -msgstr "LCM_EXCEL2003(Bilangan(s))" - -#. EmCPA -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3147377\n" -"help.text" -msgid "<emph>Number(s)</emph> is a list of up to 30 numbers." -msgstr "<emph>Bilangan(s)</emph> adalah daftar sampai 30 bilangan." +msgid "LCM_EXCEL2003(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. dNCeM #: 04060106.xhp @@ -13204,23 +13150,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_MULTINOMIAL\">Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_MULTINOMIAL\">Mengembalikan jumlah faktorial argumen yang dibagi oleh hasil faktorial dari argumen argumen.</ahelp>" -#. KohhD +#. sRmYD #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3155660\n" "help.text" -msgid "MULTINOMIAL(Number(s))" -msgstr "MULTINOMIAL" - -#. RMEsV -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3155673\n" -"help.text" -msgid "<emph>Number(s)</emph> is a list of up to 30 numbers." -msgstr "<emph>Bilangan(s)</emph> adalah daftar sampai 30 bilangan." +msgid "MULTINOMIAL(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. YLFwC #: 04060106.xhp @@ -13425,32 +13362,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_PRODUKT\">Multiplies all the numbers given as arguments and returns the product.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_PRODUKT\">Melipatkan semua angka yang diberikan sebagai argumen dan mengembalikan hasil.</ahelp>" -#. uJFjB +#. Lsojw #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3144446\n" "help.text" -msgid "PRODUCT(Number1; Number2; ...; Number30)" -msgstr "PRODUCT(Bilangan1; Bilangan2; ...; Bilangan30)" - -#. tbeYN -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3144460\n" -"help.text" -msgid "<emph>Number1 to 30</emph> are up to 30 arguments whose product is to be calculated." -msgstr "<emph>Bilangan 1 sampai 30</emph> hingga 30 argumen yang hasilnya perlu dihitung." - -#. Gnz4g -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id1589098\n" -"help.text" -msgid "PRODUCT returns number1 * number2 * number3 * ..." -msgstr "PRODUCT mengembalikan bilangan1 * bilangan2 * bilangan3 * ..." +msgid "PRODUCT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. D5DEG #: 04060106.xhp @@ -13479,41 +13398,32 @@ msgctxt "" msgid "SUMSQ" msgstr "SUMSQ" -#. mgr6s +#. XFoEC #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3160368\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_QUADRATESUMME\">If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_QUADRATESUMME\">Jika anda ingin menghitung jumlah kuadrat dari bilangan bilangan (dengan jumlah kuadrat argumen), enter ini kedalam ruas teks.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_QUADRATESUMME\">Calculates the sum of the squares of a set of numbers.</ahelp>" +msgstr "" -#. CSJAJ +#. 2gNvN #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3160402\n" "help.text" -msgid "SUMSQ(Number1; Number2; ...; Number30)" -msgstr "SUMSQ(Bilangan1;Bilangan2; ...;Bilangan30)" - -#. 5R44a -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3160415\n" -"help.text" -msgid "<emph>Number1 to 30</emph> are up to 30 arguments the sum of whose squares is to be calculated." -msgstr "<emph>Bilangan 1 sampai 30</emph> hingga 30 argumen yang hasilnya perlu dihitung." +msgid "SUMSQ(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. QdbZ8 +#. ANvo3 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3160449\n" "help.text" -msgid "If you enter the numbers <item type=\"input\">2</item>; <item type=\"input\">3</item> and <item type=\"input\">4</item> in the Number 1; 2 and 3 text boxes, 29 is returned as the result." -msgstr "Jika anda memasukkan bilangan <item type=\"input\">2</item>; <item type=\"input\">3</item> dan <item type=\"input\">4</item> di kotak teks Bilangan1; 2 dan 3 , 29 dikembalikan sebagai hasil." +msgid "If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 arguments, 29 is returned as the result." +msgstr "" #. KGako #: 04060106.xhp @@ -14262,31 +14172,22 @@ msgctxt "" msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>" msgstr "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>" -#. DBrbm +#. 924XA #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3163625\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_SUMME\">Adds all the numbers in a range of cells.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_SUMME\">Menambahkan semua bilangan dalam rentang sel.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_SUMME\">Adds a set of numbers.</ahelp>" +msgstr "" -#. zBKBJ +#. NavGZ #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3163656\n" "help.text" -msgid "SUM(Number1; Number2; ...; Number30)" -msgstr "SUM(Bilangan1; Bilangan2; ...; Bilangan30)" - -#. wApie -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3163671\n" -"help.text" -msgid "<emph>Number1 to Number30</emph> are up to 30 arguments, either cells or ranges, whose sum is to be calculated." +msgid "SUM(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. fsBfG @@ -17396,32 +17297,32 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUMMENPRODUKT\">Multiplies corresponding elements in the given arrays, and returns the sum of those products.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_SUMMENPRODUKT\">Mengalikan elemen yang sesuai dalam array yang diberikan, dan mengembalikan jumlah produk-produk tersebut.</ahelp>" -#. rBb3u +#. zmqCZ #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3163347\n" "help.text" -msgid "SUMPRODUCT(Array1; Array2; ...; Array30)" -msgstr "SUMPRODUCT(Array1; Array2; ...; Array30)" +msgid "SUMPRODUCT(Array 1[; Array 2;][...;[Array 255]])" +msgstr "" -#. xBpX8 +#. gGK9K #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3163362\n" "help.text" -msgid "<emph>Array1, Array2; ...; Array30</emph> represent arrays whose corresponding elements are to be multiplied." -msgstr "<emph>Array1, Array2; ...; Array30</emph> mewakili array yang elemen terkaitnya harus dikalikan." +msgid "<emph>Array 1[; Array 2;][...;[Array 255]]</emph> represent arrays whose corresponding elements are to be multiplied." +msgstr "" -#. 6knhd +#. kCud6 #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_idN11B19\n" "help.text" -msgid "At least one array must be part of the argument list. If only one array is given, all array elements are summed." -msgstr "Setidaknya satu array harus menjadi bagian dari daftar argumen. Jika hanya satu array yang diberikan, semua elemen array dijumlahkan." +msgid "At least one array must be part of the argument list. If only one array is given, all array elements are summed. If more than one array is given, they must all be the same size." +msgstr "" #. DgsMB #: 04060107.xhp @@ -18422,6 +18323,15 @@ msgctxt "" msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518." msgstr "Jika sel A1 menampilkan Err: 518, fungsinya <item type=\"input\">=ERRORTYPE(A1)</item>mengembalikan nomor 518." +#. FWJTB +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"hd_id275141466817507\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_error_type.xhp#error_type_head\"/>" +msgstr "" + #. mtLKD #: 04060109.xhp msgctxt "" @@ -19925,14 +19835,23 @@ msgctxt "" msgid "Two different syntax definitions can be used:" msgstr "Dua definisi sintaksis berbeda dapat dipakai:" -#. LmQbe +#. V3C9Q #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id1665089\n" "help.text" -msgid "GETPIVOTDATA(TargetField; pivot table; [ Field 1; Item 1; ... ])" -msgstr "GETPIVOTDATA(TargetField; pivot table; [ Field 1; Item 1; ... ])" +msgid "GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field 126; Item 126]])" +msgstr "" + +#. 3kCjF +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"par_id661585662472832\n" +"help.text" +msgid "or" +msgstr "" #. QnCVY #: 04060109.xhp @@ -19952,6 +19871,15 @@ msgctxt "" msgid "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." msgstr "Sintaks kedua diasumsikan jika tepat dua parameter diberikan, parameter yang pertama adalah referensi sel atau rentang sel. Sintaks pertama diasumsikan dalam semua kasus lainnya. Fungsi Wisaya menampilkan sintaks pertama." +#. Cwsfn +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"hd_id431585688827982\n" +"help.text" +msgid "First Syntax" +msgstr "" + #. xTLTZ #: 04060109.xhp msgctxt "" @@ -20015,6 +19943,15 @@ msgctxt "" msgid "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below)." msgstr "Nilai subtotal dari tabel pivot hanya digunakan jika mereka menggunakan fungsi \"otomatis\" (kecuali ketika ditentukan dalam kendala, lihat <item type=\"literal\">Sintaks Kedua</item> di bawah)." +#. amRc3 +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"hd_id551585688835597\n" +"help.text" +msgid "Second Syntax" +msgstr "" + #. KETgR #: 04060109.xhp msgctxt "" @@ -20591,23 +20528,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERKETTEN\">Combines several text strings into one string.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VERKETTEN\">Menggabungkan beberapa string teks menjadi satu string.</ahelp>" -#. fWvjJ +#. DA2oR #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3155954\n" "help.text" -msgid "CONCATENATE(\"Text1\"; ...; \"Text30\")" -msgstr "CONCATENATE(\"Teks1\"; ...; \"Teks30\")" +msgid "CONCATENATE(<embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/>)" +msgstr "" -#. rrDyG +#. GCUtY #: 04060110.xhp msgctxt "" "04060110.xhp\n" -"par_id3146847\n" +"par_id781585222554150\n" "help.text" -msgid "<emph>Text 1; Text 2; ...</emph> represent up to 30 text passages which are to be combined into one string." -msgstr "<emph>Teks 1; Teks 2; ...</emph> mewakili hingga 30 bagian teks yang akan digabungkan menjadi satu string." +msgid "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings or references to cells containing strings." +msgstr "" #. 8Dfcz #: 04060110.xhp @@ -22400,32 +22337,32 @@ msgctxt "" msgid "TEXT" msgstr "TEXT" -#. woEeG +#. hZGtP #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147213\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_TEXT\">Converts a number into text according to a given format.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_TEXT\">Mengubah angka menjadi teks sesuai dengan format yang diberikan.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_TEXT\">Converts a value into text according to a given format.</ahelp>" +msgstr "" -#. 9xURB +#. YjEZu #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147377\n" "help.text" -msgid "TEXT(Number; Format)" -msgstr "TEKS(Format; Angka)" +msgid "TEXT(Value; Format)" +msgstr "" -#. BpPCe +#. hGrSa #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147389\n" "help.text" -msgid "<emph>Number</emph> is the numerical value to be converted." -msgstr "<emph>Nilai</emph> adalah nilai yang akan diperiksa." +msgid "<emph>Value</emph> is the value (numerical or textual) to be converted." +msgstr "" #. 3GZvU #: 04060110.xhp @@ -22454,6 +22391,15 @@ msgctxt "" msgid "<item type=\"input\">=TEXT(12.34567;\"000.00\")</item> returns the text 012.35" msgstr "<item type=\"input\">= TEXT (12.34567; \"000.00\")</item> mengembalikan teks 012.35" +#. iT5uP +#: 04060110.xhp +msgctxt "" +"04060110.xhp\n" +"par_id3674124\n" +"help.text" +msgid "<item type=\"input\">=TEXT(\"xyz\";\"=== @ ===\")</item> returns the text === xyz ===" +msgstr "" + #. yhDcc #: 04060110.xhp msgctxt "" @@ -26145,6 +26091,51 @@ msgctxt "" msgid "<item type=\"input\">=IMARGUMENT(\"3+4j\")</item> returns 0.927295." msgstr "<item type=\"input\">=IMARGUMENT(\"3+4j\")</item> mengembalikan 0.927295." +#. TVX4f +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id69271214320055\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos_head\"/>" +msgstr "" + +#. 4HGsN +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id217971417131058\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh_head\"/>" +msgstr "" + +#. H4rBq +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id7625634121212\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcot.xhp#imcot_head\"/>" +msgstr "" + +#. Fev3E +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id2907192866882\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcsc.xhp#imcsc_head\"/>" +msgstr "" + +#. U7uHv +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id2111268313694\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imcsch.xhp#imcsch_head\"/>" +msgstr "" + #. y5rLV #: 04060116.xhp msgctxt "" @@ -26443,23 +26434,23 @@ msgctxt "" msgid "IMPRODUCT" msgstr "IMPRODUCT" -#. i6VKG +#. DSBR5 #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3153545\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_IMPRODUCT\">The result is the product of up to 29 complex numbers.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_IMPRODUCT\">Hasilnya adalah produk dari sampai dengan 29 bilangan kompleks.</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_IMPRODUCT\">The result is the product of a set of complex numbers.</ahelp>" +msgstr "" -#. fUcG3 +#. RDe9u #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3149027\n" "help.text" -msgid "IMPRODUCT(\"ComplexNumber\"; \"ComplexNumber1\"; ...)" -msgstr "IMPRODUCT" +msgid "IMPRODUCT(<embedvar href=\"text/scalc/01/ful_func.xhp#complex255_1\" markup=\"keep\"/>)" +msgstr "" #. x58Ur #: 04060116.xhp @@ -26515,6 +26506,51 @@ msgctxt "" msgid "<item type=\"input\">=IMREAL(\"1+3j\")</item> returns 1." msgstr "<item type=\"input\">=IMREAL(\"1+3j\")</item> mengembalikan 1." +#. 7L6GP +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id882954222038\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsec.xhp#imsec_head\"/>" +msgstr "" + +#. WpR5E +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id25480538323169\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsech.xhp#imsech_head\"/>" +msgstr "" + +#. sWL67 +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id14741462320337\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin_head\"/>" +msgstr "" + +#. bXgFc +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id12978120123414\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imsinh.xhp#imsinh_head\"/>" +msgstr "" + +#. ZRj2s +#: 04060116.xhp +msgctxt "" +"04060116.xhp\n" +"hd_id186491693515289\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_imtan.xhp#imtan_head\"/>" +msgstr "" + #. rAXpY #: 04060116.xhp msgctxt "" @@ -26578,23 +26614,23 @@ msgctxt "" msgid "IMSUM" msgstr "IMSUM" -#. 6pmzk +#. sD27s #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3153215\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_IMSUM\">The result is the sum of up to 29 complex numbers.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_IMSUM\">Hasilnya adalah jumlah dari sampai dengan 29 bilangan kompleks.</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_IMSUM\">The result is the sum of a set of complex numbers.</ahelp>" +msgstr "" -#. 22fTk +#. dY4UY #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3152930\n" "help.text" -msgid "IMSUM(\"ComplexNumber1\"; \"ComplexNumber2\"; ...)" -msgstr "IMSUM" +msgid "IMSUM(<embedvar href=\"text/scalc/01/ful_func.xhp#complex255_1\" markup=\"keep\"/>)" +msgstr "" #. CNtPR #: 04060116.xhp @@ -31179,14 +31215,14 @@ msgctxt "" msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xnpv\" name=\"XNPV\">XNPV</link> function." msgstr "Jika pembayaran dilakukan pada interval yang tidak teratur, gunakan <link href=\"text/scalc/01/04060118.xhp#xnpv\" name=\"XNPV\">XNPV</link> fungsi." -#. QXdUJ +#. ZxBQz #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3153321\n" "help.text" -msgid "NPV(Rate; Value1; Value2; ...; Value30)" -msgstr "NPV(Menilai; Nilai1; Nilai2; ...; Nilai30)" +msgid "NPV(Rate; <embedvar href=\"text/scalc/01/ful_func.xhp#number254_1\" markup=\"keep\"/>)" +msgstr "" #. EEL34 #: 04060119.xhp @@ -31197,15 +31233,6 @@ msgctxt "" msgid "<emph>Rate</emph> is the discount rate for a period." msgstr "<emph>Nilai</emph> adalah nilai yang akan diperiksa." -#. YFAME -#: 04060119.xhp -msgctxt "" -"04060119.xhp\n" -"par_id3150427\n" -"help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are up to 30 values, which represent deposits or withdrawals." -msgstr "<emph>Value1, Value2, ..., Value30</emph> hingga 30 nilai, yang mewakili setoran atau penarikan." - #. DAypR #: 04060119.xhp msgctxt "" @@ -32700,23 +32727,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ANZAHL\">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored." msgstr "<ahelp hid=\"HID_FUNC_ANZAHL\">Menghitung berapa banyak angka dalam daftar argumen.</ahelp> Entri teks diabaikan." -#. ENuAv +#. AWuDZ #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3148585\n" "help.text" -msgid "COUNT(Value1; Value2; ...; Value30)" -msgstr "COUNT(Nilai1; Nilai2; ...; Nilai30)" - -#. ncvRM -#: 04060181.xhp -msgctxt "" -"04060181.xhp\n" -"par_id3155827\n" -"help.text" -msgid "<emph>Value1; Value2, ..., Value30</emph> are 1 to 30 values or ranges representing the values to be counted." -msgstr "<emph>Nilai1; Nilai2, ..., Nilai30</emph> adalah 1 hingga 30 nilai atau rentang yang mewakili nilai yang akan dihitung." +msgid "COUNT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. VBCGA #: 04060181.xhp @@ -32763,23 +32781,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ANZAHL2\">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored." msgstr "<ahelp hid=\"HID_FUNC_ANZAHL2\">Counts how many values are in the list of arguments.</ahelp> Antrian teks juga terhitung, meskipun mereka mengandung untaian kosong dengan panjang 0. jika isi adalah array kosong atau acuan, sel kosong yang ada di antara larik atau acuan diabaikan." -#. EyyFo +#. eEkCJ #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3153111\n" "help.text" -msgid "COUNTA(Value1; Value2; ...; Value30)" -msgstr "COUNTA(Nilai1; Nilai2; ...; Nilai30)" - -#. dZVxR -#: 04060181.xhp -msgctxt "" -"04060181.xhp\n" -"par_id3150001\n" -"help.text" -msgid "<emph>Value1; Value2, ..., Value30</emph> are 1 to 30 arguments representing the values to be counted." -msgstr "<emph>Value1; Value2, ..., Value30</emph> adalah 1 hingga 30 argumen yang mewakili nilai yang akan dihitung." +msgid "COUNTA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. QKY5C #: 04060181.xhp @@ -37525,23 +37534,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_KURT\">Returns the kurtosis of a data set (at least 4 values required).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_KURT\">Mengembalikan kurtosis dari kumpulan data (setidaknya diperlukan 4 nilai).</ahelp>" -#. rKFxG +#. VpSiM #: 04060183.xhp msgctxt "" "04060183.xhp\n" "par_id3154508\n" "help.text" -msgid "KURT(Number1; Number2; ...; Number30)" -msgstr "KURT(Number1; Number2; ...; Number30)" +msgid "KURT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. 3g87D +#. qFqj4 #: 04060183.xhp msgctxt "" "04060183.xhp\n" -"par_id3145167\n" +"par_id501585152669900\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges representing a random sample of distribution." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> merupakan argumen numerik atau representasi rentang sebuah distribusi contoh acak." +msgid "The parameters should specify at least four values." +msgstr "" #. V4wcF #: 04060183.xhp @@ -37921,23 +37930,14 @@ msgctxt "" msgid "Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN(\"string\"), still results in an error." msgstr "Mengembalikan 0 jika bukan numerik dan tidak ada kesalahan yang ditemukan dalam rentang sel(s) yang dilewatkan sebagai referensi sel(s). Sel-sel teks diabaikan oleh MIN() dan MAX(). Fungsi MINA() dan MAXA() mengembalikan 0 jika tidak ada nilai (numerik atau teks) dan tidak ada kesalahan yang ditemukan. Melewati argumen string literal ke MIN() atau MAX(), misalnya MIN(\"string\"), masih menghasilkan kesalahan." -#. c2Fno +#. gTV5V #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3147340\n" "help.text" -msgid "MAX(Number1; Number2; ...; Number30)" -msgstr "MAX(Nomor1; Nomor2; ...; Nomor30)" - -#. 3QEiy -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3149568\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "MAX(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. giyJK #: 04060184.xhp @@ -37993,23 +37993,14 @@ msgctxt "" msgid "The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered." msgstr "Fungsi MINA() dan MAXA() mengembalikan 0 jika tidak ada nilai (numerik atau teks) dan tidak ada kesalahan yang ditemukan." -#. 8wybP +#. X7jxS #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3166431\n" "help.text" -msgid "MAXA(Value1; Value2; ...; Value30)" -msgstr "MAXA(Nilai1; Nilai2; ...; Nilai30)" - -#. 3DZRe -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150202\n" -"help.text" -msgid "<emph>Value1; Value2;...; Value30</emph> are values or ranges. Text has the value of 0." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang. Teks memiliki nilai 0." +msgid "MAXA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. ZxXLp #: 04060184.xhp @@ -38056,23 +38047,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MEDIAN\">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_MEDIAN\">Mengembalikan median dari satu himpunan angka. Dalam satu himpunan berisi jumlah nilai yang tidak merata, median akan menjadi angka di tengah himpunan dan didalam himpunan yang berisi jumlah nilai genap, itu akan menjadi rata-rata dari dua nilai di tengah himpunan.</ahelp>" -#. 6ies7 +#. CGf4S #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3155264\n" "help.text" -msgid "MEDIAN(Number1; Number2; ...; Number30)" -msgstr "MEDIAN(Nomor1; Nomor2; ...., Nomor30)" - -#. qugaM -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150109\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang, yang mewakili sampel. Setiap nomor juga dapat diganti dengan referensi." +msgid "MEDIAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. bDCXJ #: 04060184.xhp @@ -38128,23 +38110,14 @@ msgctxt "" msgid "Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN(\"string\"), still results in an error." msgstr "Mengembalikan 0 jika bukan numerik dan tidak ada kesalahan yang ditemukan dalam rentang sel(s) yang dilewatkan sebagai referensi sel(s). Sel-sel teks diabaikan oleh MIN() dan MAX(). Fungsi MINA() dan MAXA() mengembalikan 0 jika tidak ada nilai (numerik atau teks) dan tidak ada kesalahan yang ditemukan. Melewati argumen string literal ke MIN() atau MAX(), misalnya MIN(\"string\"), masih menghasilkan kesalahan." -#. ewK5y +#. YtBaP #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3146964\n" "help.text" -msgid "MIN(Number1; Number2; ...; Number30)" -msgstr "MIN(Nomor1; Nomor2; ...; Nomor30)" - -#. sUDim -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3153486\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "MIN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. yutoe #: 04060184.xhp @@ -38191,23 +38164,14 @@ msgctxt "" msgid "The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered." msgstr "Fungsi MINA() dan MAXA() mengembalikan 0 jika tidak ada nilai (numerik atau teks) dan tidak ada kesalahan yang ditemukan." -#. cjn64 +#. AG7MH #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3153336\n" "help.text" -msgid "MINA(Value1; Value2; ...; Value30)" -msgstr "MINA(Nilai1; Nilai2; ...; Nilai30)" - -#. 3Go2h -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3146098\n" -"help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang. Teks memiliki nilai 0." +msgid "MINA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. TrF9C #: 04060184.xhp @@ -38254,23 +38218,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MITTELABW\">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set." msgstr "<ahelp hid=\"HID_FUNC_MITTELABW\">Mengembalikan rata-rata penyimpangan absolut dari titik data dari rerata mereka.</ahelp> Menampilkan difusi dalam satu set data." -#. 9zfs5 +#. sAUCf #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3145636\n" "help.text" -msgid "AVEDEV(Number1; Number2; ...; Number30)" -msgstr "AVEDEV(Nomor1; Nomor2; ...., Nomor30)" - -#. qNkLm -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3157871\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference." -msgstr "<emph>Nomor1, Nomor2, ..., Number30</emph> adalah nilai atau rentang yang mewakili sampel. Setiap nomor juga dapat diganti dengan referensi." +msgid "AVEDEV(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. UA5P6 #: 04060184.xhp @@ -38308,23 +38263,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MITTELWERT\">Returns the average of the arguments.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_MITTELWERT\">Mengembalikan rata-rata dari argumen.</ahelp>" -#. LVfcJ +#. K8QCj #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3154679\n" "help.text" -msgid "AVERAGE(Number1; Number2; ...; Number30)" -msgstr "AVERAGE(Nomor1; Nomor2; ..., Nomor30)" - -#. brJC4 -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150741\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "AVERAGE(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. AjUyH #: 04060184.xhp @@ -38362,32 +38308,41 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MITTELWERTA\">Returns the average of the arguments. The value of a text is 0.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_MITTELWERTA\">Mengembalikan rata-rata dari argumen. Nilai dari teks adalah 0.</ahelp>" -#. vvXZb +#. opsEb #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3149734\n" "help.text" -msgid "AVERAGEA(Value1; Value2; ...; Value30)" -msgstr "AVERAGE(Nilai1; Nilai2; ...; Nilai30)" +msgid "AVERAGEA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. kHd3R +#. sxYNi #: 04060184.xhp msgctxt "" "04060184.xhp\n" -"par_id3155260\n" +"par_id3150864\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang. Teks memiliki nilai 0." +msgid "<item type=\"input\">=AVERAGEA(A1:A50)</item>" +msgstr "-<item type=\"input\">10000</item>" -#. sxYNi +#. iLCTX #: 04060184.xhp msgctxt "" "04060184.xhp\n" -"par_id3150864\n" +"hd_id110421803716508\n" "help.text" -msgid "<item type=\"input\">=AVERAGEA(A1:A50)</item>" -msgstr "-<item type=\"input\">10000</item>" +msgid "<embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>" +msgstr "" + +#. K3rLb +#: 04060184.xhp +msgctxt "" +"04060184.xhp\n" +"hd_id5471656631510\n" +"help.text" +msgid "<embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>" +msgstr "" #. hKE9h #: 04060184.xhp @@ -38416,23 +38371,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_MODALWERT\">Returns the most common value in a data set.</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 "<ahelp hid=\"HID_FUNC_MODALWERT\">Mengembalikan nilai yang paling umum dalam sebuah pengaturan data.</ahelp> Jika ada beberapa nilai dengan frekuensi yang sama, maka mengembalikan nilai terkecil. Kesalahan terjadi ketika nilai tidak muncul dua kali." -#. FuKPf +#. DFEQv #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3155950\n" "help.text" -msgid "MODE(Number1; Number2; ...; Number30)" -msgstr "MODE(Nomor1; Nomor2; ...; Nomor30)" - -#. UkRWQ -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id3150337\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "MODE(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. VYNy2 #: 04060184.xhp @@ -38470,23 +38416,14 @@ msgctxt "" 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 "<ahelp hid=\"HID_FUNC_MODAL_VALUE_MS\">Mengembalikan yang paling sering terjadi, atau berulang, nilai di array atau rentang data.</ahelp> Jika ada beberapa nilai dengan frekuensi yang sama, maka mengembalikan nilai terkecil. Kesalahan terjadi ketika nilai tidak muncul dua kali." -#. 6wWnN +#. Y5cCt #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2955950\n" "help.text" -msgid "MODE.SNGL(Number1; Number2; ...; Number30)" -msgstr "MODE.SNGL(Nomor1; Nomor2; ...., Nomor30)" - -#. zJnLw -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id2950337\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "MODE.SNGL(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. BGawC #: 04060184.xhp @@ -38533,23 +38470,14 @@ msgctxt "" 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 "<ahelp hid=\"HID_FUNC_MODAL_VALUE_MULTI\">Mengembalikan sebuah vertikal larik dari mode statistik(nilai yang paling terjadi) dengan daftar dari pasokan angka-angka.</ahelp>" -#. ApATB +#. zDERD #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2855950\n" "help.text" -msgid "MODE.MULT(Number1; Number2; ...; Number30)" -msgstr "MODE.MULT(Nomor1; Nomor2; ...., Nomor30)" - -#. cBqq8 -#: 04060184.xhp -msgctxt "" -"04060184.xhp\n" -"par_id2850337\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "MODE.MULT(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. nrjtV #: 04060184.xhp @@ -40324,23 +40252,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SCHIEFE\">Returns the skewness of a distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_SCHIEFE\">Mengembalikan kemiringan penyaluran.</ahelp>" -#. pAGuG +#. EndQD #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3151191\n" "help.text" -msgid "SKEW(Number1; Number2; ...; Number30)" -msgstr "SKEW(Nomor1; Nomor2; ...., Nomor30)" +msgid "SKEW(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. UdXzQ +#. BmsyE #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3155757\n" +"par_id171585151428396\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik." +msgid "The parameters should specify at least three values." +msgstr "" #. sBJ47 #: 04060185.xhp @@ -40522,32 +40450,32 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABW\">Estimates the standard deviation based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABW\">Memperkirakan standar deviasi berdasarkan sampel.</ahelp>" -#. J44yd +#. 2b5hp #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149946\n" "help.text" -msgid "STDEV(Number1; Number2; ...; Number30)" -msgstr "STDEV(Nomor1; Nomor2; ...; Nomor30)" +msgid "STDEV(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. 8LECi +#. H3V9F #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3157904\n" +"par_id211585163957345\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili sampel berdasarkan seluruh populasi." +msgid "The parameters should specify at least two values." +msgstr "" -#. EAs58 +#. S754h #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149434\n" "help.text" -msgid "<item type=\"input\">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced." -msgstr "<item type=\"input\">=STDEV(A1:A50)</item> menghasilkan perkiraan standar deviasi berdasarkan data yang direferensikan." +msgid "<input>=STDEV(A1:A50)</input> returns the estimated standard deviation based on the data referenced." +msgstr "" #. EaGD7 #: 04060185.xhp @@ -40576,23 +40504,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABWA\">Calculates the standard deviation of an estimation based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWA\">Menghitung perkiraan standar deviasi berdasarkan sampel.</ahelp>" -#. 5HP5n +#. JfwF6 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3147422\n" "help.text" -msgid "STDEVA(Value1; Value2; ...; Value30)" -msgstr "STDEVA(Nilai1; Nilai2; ...; Nilai30)" +msgid "STDEVA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. Ai2oZ +#. iK7Ch #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3154547\n" +"par_id981585163977014\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang yang mewakili sampel yang berasal dari seluruh populasi. Teks memiliki nilai 0." +msgid "The parameters should specify at least two values. Text has the value 0." +msgstr "" #. mgbPX #: 04060185.xhp @@ -40630,23 +40558,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABWN\">Calculates the standard deviation based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWN\">Menghitung standar deviasi berdasarkan seluruh populasi.</ahelp>" -#. CoZTL +#. zoiE5 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3154392\n" "help.text" -msgid "STDEVP(Number1; Number2; ...; Number30)" -msgstr "STDEVP(Nomor1; Nomor2; ...; Nomor80)" - -#. oVXGo -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3155261\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili seluruh populasi." +msgid "STDEVP(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. ADXhB #: 04060185.xhp @@ -40684,23 +40603,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ST_DEV_P_MS\">Calculates the standard deviation based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ST_DEV_P_MS\"> Menghitung standar deviasi berdasarkan seluruh populasi.</ahelp>" -#. AeSxQ +#. J5bPQ #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2954392\n" "help.text" -msgid "STDEV.P(Number1; Number2; ...; Number30)" -msgstr "STDEV.P(Nomor1; Nomor2; ...; Nomor30)" - -#. mxvZc -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id2955261\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili seluruh populasi." +msgid "STDEV.P(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. 9PAi8 #: 04060185.xhp @@ -40738,23 +40648,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ST_DEV_S\">Calculates the standard deviation based on sample of the population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ST_DEV_S\">Menghitung standar deviasi berdasarkan sampel dari populasi.</ahelp>" -#. U7xDq +#. dG9nh #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2854392\n" "help.text" -msgid "STDEV.S(Number1; Number2; ...; Number30)" -msgstr "STDEV.S(Nomor1; Nomor2; ...; Nomor30)" +msgid "STDEV.S(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. agaSo +#. fPUck #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id2855261\n" +"par_id671585163972431\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai numerik atau rentang yang mewakili sampel populasi." +msgid "The parameters should specify at least two values." +msgstr "" #. 9GmUP #: 04060185.xhp @@ -40792,23 +40702,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_STABWNA\">Calculates the standard deviation based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_STABWNA\">Menghitung standar deviasi berdasarkan seluruh populasi.</ahelp>" -#. RhZBw +#. gqtD3 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3146851\n" "help.text" -msgid "STDEVPA(Value1; Value2; ...; Value30)" -msgstr "STDEVPA(Nilai1; Nilai2; ...; Nilai30)" +msgid "STDEVPA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. 5yKuZ +#. DL6D2 #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3153109\n" +"par_id961585163990543\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang yang mewakili seluruh populasi.Teks memiliki nilai 0." +msgid "Text has the value 0." +msgstr "" #. avUGE #: 04060185.xhp @@ -41287,23 +41197,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUMQUADABW\">Returns the sum of squares of deviations based on a sample mean.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_SUMQUADABW\">Mengembalikan jumlah kuadrat deviasi berdasarkan rerata sampel.</ahelp>" -#. soLp9 +#. pg3Aq #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3146790\n" "help.text" -msgid "DEVSQ(Number1; Number2; ...; Number30)" -msgstr "DEVSQ(Nomor1; Nomor2; ..., Nomor30)" - -#. u7jWS -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3155995\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai numerik atau rentang yang mewakili sampel." +msgid "DEVSQ(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. tETcx #: 04060185.xhp @@ -41962,23 +41863,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZ\">Estimates the variance based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZ\">Memperkirakan varians berdasarkan sampel.</ahelp>" -#. C8m5y +#. NGDxF #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3153054\n" "help.text" -msgid "VAR(Number1 ; Number2; ...; Number30)" -msgstr "VAR(Nomor1 ; Nomor2; ...; Nomor30)" +msgid "VAR(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. AUGbB +#. qsPg5 #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3148938\n" +"par_id721585215582420\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili sampel berdasarkan seluruh populasi." +msgid "The parameters should specify at least two values." +msgstr "" #. 7rJxK #: 04060185.xhp @@ -42016,23 +41917,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VAR_S\">Estimates the variance based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VAR_S\">Memperkirakan varians berdasarkan sampel.</ahelp>" -#. BAcfb +#. Y2B8P #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2953054\n" "help.text" -msgid "VAR.S(Number1; Number2; ...; Number30)" -msgstr "VAR.S(Nomor1; Nomor2; ...; Nomor30)" +msgid "VAR.S(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. SpFct +#. GGJFX #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id2948938\n" +"par_id891585215590756\n" "help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili sampel berdasarkan seluruh populasi." +msgid "The parameters should specify at least two values." +msgstr "" #. GMEXA #: 04060185.xhp @@ -42070,23 +41971,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZA\">Estimates a variance based on a sample. The value of text is 0.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZA\">Memperkirakan varians berdasarkan sampel. Nilai teks adalah 0.</ahelp>" -#. zpEAh +#. mrEpZ #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149999\n" "help.text" -msgid "VARA(Value1; Value2; ...; Value30)" -msgstr "VARA(Nilai1; Nilai2; ...; Nilai30)" +msgid "VARA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. 26jmj +#. KSAnB #: 04060185.xhp msgctxt "" "04060185.xhp\n" -"par_id3158421\n" +"par_id451585215586628\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang yang mewakili sampel yang berasal dari seluruh populasi. Teks memiliki nilai 0." +msgid "The parameters should specify at least two values." +msgstr "" #. 4Prou #: 04060185.xhp @@ -42124,23 +42025,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZEN\">Calculates a variance based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZEN\">Menghitung varian berdasarkan seluruh populasi.</ahelp>" -#. p2RDk +#. ArDPU #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3147282\n" "help.text" -msgid "VARP(Number1; Number2; ...; Number30)" -msgstr "VARP(Nomor1 ; Nomor2; ...; Nomor30)" - -#. mDRT9 -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3149793\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili seluruh populasi." +msgid "VARP(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. PGCgC #: 04060185.xhp @@ -42178,23 +42070,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VAR_P_MS\">Calculates a variance based on the entire population.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VAR_P_MS\">Menghitung varian berdasarkan seluruh populasi.</ahelp>" -#. LTWJn +#. t4tND #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2947282\n" "help.text" -msgid "VAR.P(Number1; Number2; ...; Number30)" -msgstr "VAR.P(Nomor1; Nomor2; ...; Nomor30)" - -#. oB7AH -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id2949793\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> adalah nilai atau rentang numerik yang mewakili seluruh populasi." +msgid "VAR.P(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. zF5Ys #: 04060185.xhp @@ -42232,23 +42115,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIANZENA\">Calculates the variance based on the entire population. The value of text is 0.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIANZENA\">Menghitung varian berdasarkan seluruh populasi. Nilai teks adalah 0.</ahelp>" -#. hdFhe +#. cAGPm #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3149967\n" "help.text" -msgid "VARPA(Value1; Value2; ...; Value30)" -msgstr "VARPA(Nilai1; Nilai2; ...; Nilai30)" - -#. wStfk -#: 04060185.xhp -msgctxt "" -"04060185.xhp\n" -"par_id3149920\n" -"help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population." -msgstr "<emph>Nilai1, Nilai2, ..., Nilai30</emph> adalah nilai atau rentang yang mewakili seluruh populasi." +msgid "VARPA(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" #. Fa9Jj #: 04060185.xhp @@ -48199,6 +48073,15 @@ msgctxt "" msgid "<link href=\"text/scalc/01/06080000.xhp\" name=\"Recalculate\">Recalculate</link>" msgstr "<link href=\"text/scalc/01/06080000.xhp\" name=\"Hitung ulang\">Hitung ulang</link>" +#. CBCeE +#: 06080000.xhp +msgctxt "" +"06080000.xhp\n" +"par_id951584669541929\n" +"help.text" +msgid "Recalculates formula cells." +msgstr "" + #. tCCr5 #: 06080000.xhp msgctxt "" @@ -48451,14 +48334,14 @@ msgctxt "" msgid "Define Database Range" msgstr "Menentukan Jangkauan Basis Data" -#. EgD2t +#. 3F2WA #: 12010000.xhp msgctxt "" "12010000.xhp\n" "hd_id3157909\n" "help.text" -msgid "Define Database Range" -msgstr "Menentukan Jangkauan Basis Data" +msgid "<link href=\"text/scalc/01/12010000.xhp\" name=\"Define Database Range\">Define Range</link>" +msgstr "" #. 8zFH5 #: 12010000.xhp @@ -48694,14 +48577,14 @@ msgctxt "" msgid "<bookmark_value>databases; selecting (Calc)</bookmark_value>" msgstr "<bookmark_value>basis data; memilih (Calc)</bookmark_value>" -#. D9fvg +#. LFBZy #: 12020000.xhp msgctxt "" "12020000.xhp\n" "hd_id3145068\n" "help.text" -msgid "Select Database Range" -msgstr "Memilih Jangkauan Basis Data" +msgid "<link href=\"text/scalc/01/12020000.xhp\" name=\"Select Database Range\">Select Range</link>" +msgstr "" #. DjALP #: 12020000.xhp @@ -48739,14 +48622,14 @@ msgctxt "" msgid "Sort" msgstr "Urutan" -#. uyAAQ +#. 2U5X4 #: 12030000.xhp msgctxt "" "12030000.xhp\n" "hd_id3150275\n" "help.text" -msgid "Sort" -msgstr "Urutan" +msgid "<link href=\"text/scalc/01/12030000.xhp\" name=\"\">Sort</link>" +msgstr "" #. BHBgn #: 12030000.xhp @@ -49270,14 +49153,14 @@ msgctxt "" msgid "Filter" msgstr "Penyaring" -#. uzVFC +#. A3xBE #: 12040000.xhp msgctxt "" "12040000.xhp\n" "hd_id3150767\n" "help.text" -msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filter</link>" -msgstr "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Tapis</link>" +msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filters</link>" +msgstr "" #. PgpNB #: 12040000.xhp @@ -49657,14 +49540,14 @@ msgctxt "" msgid "Subtotals" msgstr "Subtotal" -#. QTDg7 +#. zaCLT #: 12050000.xhp msgctxt "" "12050000.xhp\n" "hd_id3153822\n" "help.text" -msgid "Subtotals" -msgstr "Subtotal" +msgid "<variable id=\"subtotalheaderh1\"><link href=\"text/scalc/01/12050000.xhp\" name=\"subtotals\">Subtotals</link></variable>" +msgstr "" #. 2jiYA #: 12050000.xhp @@ -49729,69 +49612,6 @@ msgctxt "" msgid "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/SubTotalGrpPage\">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp>" msgstr "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/SubTotalGrpPage\">Tentukan pengaturan hingga tiga kelompok subtotal. Setiap tab memiliki tata letak yang sama.</ahelp>" -#. nEYZU -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3148797\n" -"help.text" -msgid "To insert subtotal values into a table:" -msgstr "Nilai yang akan disisipkan ke tabel" - -#. vSxgC -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3154908\n" -"help.text" -msgid "Ensure that the columns of the table have labels." -msgstr "Pastikan kolom tabel memiliki label." - -#. kAjkC -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3153968\n" -"help.text" -msgid "Select the table or the area in the table that you want to calculate subtotals for, and then choose <emph>Data – Subtotals</emph>." -msgstr "Pilih tabel atau area di tabel yang ingin Anda hitung subtotalnya, lalu pilih <emph>Data - Subtotal</emph>." - -#. MgpYw -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3161831\n" -"help.text" -msgid "In the <emph>Group By</emph> box, select the column that you want to add the subtotals to." -msgstr "Di kotak <emph>Grup Menurut</emph>, pilih kolom yang Anda ingin tambahkan subtotalnya." - -#. j4eTU -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3153188\n" -"help.text" -msgid "In the <emph>Calculate subtotals for</emph> box, select the check boxes for the columns containing the values that you want to subtotal." -msgstr "Dalam kotak <emph>Hitung subtotal untuk</emph>, pilih kotak centang untuk kolom yang berisi nilai yang ingin Anda subtotal." - -#. KKqre -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3152460\n" -"help.text" -msgid "In the <emph>Use function</emph> box, select the function that you want to use to calculate the subtotals." -msgstr "Dalam kotak <emph>Hitung subtotal untuk</emph>, pilih kotak centang untuk kolom yang berisi nilai yang ingin Anda subtotal." - -#. bDaWE -#: 12050100.xhp -msgctxt "" -"12050100.xhp\n" -"par_id3154321\n" -"help.text" -msgid "Click <emph>OK</emph>." -msgstr "Klik <emph>Oke</emph>." - #. a9Dzb #: 12050100.xhp msgctxt "" @@ -50026,14 +49846,14 @@ msgctxt "" msgid "Multiple Operations" msgstr "Operasi Berganda" -#. TeBAd +#. rc8Gi #: 12060000.xhp msgctxt "" "12060000.xhp\n" "hd_id3153381\n" "help.text" -msgid "Multiple Operations" -msgstr "Operasi Berganda" +msgid "<link href=\"text/scalc/01/12060000.xhp\" name=\"multiple operations\">Multiple Operations</link>" +msgstr "" #. WJG7J #: 12060000.xhp @@ -50134,14 +49954,14 @@ msgctxt "" msgid "Consolidate" msgstr "Konsolidasi" -#. UM7Jw +#. 4QnDV #: 12070000.xhp msgctxt "" "12070000.xhp\n" "hd_id3148946\n" "help.text" -msgid "Consolidate" -msgstr "Konsolidasi" +msgid "<link href=\"text/scalc/01/12070000.xhp\" name=\"Consolidate\">Consolidate</link>" +msgstr "" #. LGBKi #: 12070000.xhp @@ -53041,14 +52861,14 @@ msgctxt "" msgid "Validity" msgstr "Keabsahan" -#. BoEo2 +#. ib9Du #: 12120000.xhp msgctxt "" "12120000.xhp\n" "hd_id3156347\n" "help.text" -msgid "Validity" -msgstr "Keabsahan" +msgid "<link href=\"text/scalc/01/12120000.xhp\" name=\"validity\">Validity</link>" +msgstr "" #. EGFSj #: 12120000.xhp @@ -53734,6 +53554,33 @@ msgctxt "" msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)" msgstr "Fungsi ini adalah bagian dari Open Document Format untuk Aplikasi Perkantoran (OpenDocument) Versi 1.2. (ISO/IEC 26300:2-2015)" +#. SGHPh +#: calculate.xhp +msgctxt "" +"calculate.xhp\n" +"tit\n" +"help.text" +msgid "Calculate" +msgstr "" + +#. bgC7w +#: calculate.xhp +msgctxt "" +"calculate.xhp\n" +"hd_id621584668179317\n" +"help.text" +msgid "<link href=\"text/scalc/01/calculate.xhp\" name=\"Calculate\">Calculate</link>" +msgstr "" + +#. CFB7A +#: calculate.xhp +msgctxt "" +"calculate.xhp\n" +"par_id241584668179318\n" +"help.text" +msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>" +msgstr "" + #. AZNrM #: common_func.xhp msgctxt "" @@ -53977,23 +53824,23 @@ msgctxt "" msgid "<bookmark_value>data entry forms;for spreadsheets</bookmark_value> <bookmark_value>data entry forms;insert data in spreadsheets</bookmark_value> <bookmark_value>insert data;data entry forms for spreadsheets</bookmark_value> <bookmark_value>spreadsheet;form for inserting data</bookmark_value>" msgstr "<bookmark_value>data formulir entri;untuk lembar kerja</bookmark_value> <bookmark_value>data formulir entri;sisipkan data di lembar kerja</bookmark_value> <bookmark_value>sisipkan data;data entri formulir lembar kerja</bookmark_value> <bookmark_value>lembar kerja;formulir untuk menyisipkan data</bookmark_value>" -#. wAipd +#. wTC98 #: data_form.xhp msgctxt "" "data_form.xhp\n" "hd_id240920171003006302\n" "help.text" -msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Entry Forms for Spreadsheets</link>" -msgstr "<link href=\"text/scalc/01/data_form.xhp\">Data Formulir Entri untuk Lembar Kerja</link>" +msgid "<link href=\"text/scalc/01/data_form.xhp\">Form</link>" +msgstr "" -#. Q7Qbi +#. wrzkB #: data_form.xhp msgctxt "" "data_form.xhp\n" "par_id240920171003293400\n" "help.text" -msgid "<ahelp hid=\".\">Data Entry Form is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide." -msgstr "<ahelp hid=\".\">Data Formulir Entri adalah perkakas untuk membuat tabel entri data mudah di lembar kerja.</ahelp> Dengan Data Formulir Entri, kamu dapat masuk, sunting dan menghapus catatan (atau baris) dari data dan menghindari bergulir mendatar ketika tabel memiliki banyak kolom atau ketika beberapa kolom sangat lebar." +msgid "<ahelp hid=\".\"><emph>Data Entry Form</emph> is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide." +msgstr "" #. VoVM6 #: data_form.xhp @@ -54355,14 +54202,14 @@ msgctxt "" msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." msgstr "Dalam semua contoh di bawah ini, rentang untuk perhitungan mengandung baris #6, yang diabaikan karena mengandung teks." -#. hHEEK +#. 5DDEz #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" "par_id961527953004850\n" "help.text" -msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>" -msgstr "<variable id=\"args\">Func_Range; Range1; Kriteria1 [; Range2; Kriteria2 [; ...]])</variable>" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion1[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable>" +msgstr "" #. d8gmy #: ex_data_stat_func.xhp @@ -54382,6 +54229,15 @@ msgctxt "" msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." msgstr "<emph>Func_Range</emph> dan <emph> Range1, Range2 ... </emph> harus memiliki ukuran yang sama, jika tidak fungsi mengembalikan err: 502 - Argumen tidak valid." +#. XB7By +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id101585468691583\n" +"help.text" +msgid "<emph>Range1</emph> – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied." +msgstr "" + #. 3wJSR #: ex_data_stat_func.xhp msgctxt "" @@ -54949,6 +54805,132 @@ msgctxt "" msgid "The result is presented in the string format and has the character \"i\" or \"j\" as an imaginary unit." msgstr "Hasilnya disajikan dalam format string dan memiliki karakter \"i\" atau \"j\" sebagai unit imajiner." +#. 3yZht +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id71584446760037\n" +"help.text" +msgid "<variable id=\"string255_1\">String 1[; String 2][; … ;[String 255]]</variable>" +msgstr "" + +#. aZAJy +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id631556228516997\n" +"help.text" +msgid "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings, references to cells or to cell ranges of strings." +msgstr "" + +#. Gx7GF +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id401584447957914\n" +"help.text" +msgid "<variable id=\"integer255_1\">Integer 1[; Integer 2][; … ;[Integer 255]]</variable>" +msgstr "" + +#. sCxFS +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id1001584395844941\n" +"help.text" +msgid "<emph>Integer 1[; Integer 2][; … ;[Integer 255]]</emph> are integers, references to cells or to cell ranges of integers." +msgstr "" + +#. KJbXQ +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id101584447971004\n" +"help.text" +msgid "<variable id=\"number254_1\">Number 1[; Number 2][; … ;[Number 254]]</variable>" +msgstr "" + +#. JPXDA +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584305947010\n" +"help.text" +msgid "<emph>Number 1[; Number 2][; … ;[Number 254]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgstr "" + +#. y6bDp +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id101584447970004\n" +"help.text" +msgid "<variable id=\"number255_1\">Number 1[; Number 2][; … ;[Number 255]]</variable>" +msgstr "" + +#. BXZo8 +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584395947010\n" +"help.text" +msgid "<emph>Number 1[; Number 2][; … ;[Number 255]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgstr "" + +#. AWCP7 +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id291584447988879\n" +"help.text" +msgid "<variable id=\"logical255_1\">Logical 1[; Logical 2][; … ;[Logical 255]]</variable>" +msgstr "" + +#. CzEmY +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584395957010\n" +"help.text" +msgid "<emph>Logical 1[; Logical 2][; … ;[Logical 255]]</emph> are boolean values, references to cells or to cell ranges of logical values." +msgstr "" + +#. cjCCW +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id91584448008632\n" +"help.text" +msgid "<variable id=\"complex255_1\">Complex 1[; Complex 2][; … ;[Complex 255]]</variable>" +msgstr "" + +#. AfffT +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id931584335947010\n" +"help.text" +msgid "<emph>Complex 1[; Complex 2][; … ;[Complex 255]]</emph> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form \"x+yi\" or \"x+yj\"." +msgstr "" + +#. SDfoG +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id61584448028298\n" +"help.text" +msgid "<variable id=\"reference255_1\">Reference 1[; Reference 2][; … ;[Reference 255]]</variable>" +msgstr "" + +#. NwpZa +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id431584335947010\n" +"help.text" +msgid "<emph>Reference 1[; Reference 2][; … ;[Reference 255]]</emph> are references to cells." +msgstr "" + #. 8DbP2 #: func_aggregate.xhp msgctxt "" @@ -54994,14 +54976,14 @@ msgctxt "" msgid "AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row." msgstr "AGGREGATE fungsi diterapkan pada rentang vertikal dari data dengan mengaktifkan FilterOtomatis. Jika FilterOtomatis tidak diaktifkan, otomatik perhitungan ulang dari hasil fungsi tidak dapat bekerja untuk baris yang baru disembunyikan. Seharusnya tidak bekerja dengan rentang mendatar , namun, dapat diterapkan untuk mereka juga, namun dengan pembatasan.Khususnya, fungsi AGGREGATE diterapkan untuk rentang data mendatar tidak dikenali kolom yang bersembunyi, namun dengan benar menghilangkan kesalahan-kesalahan dan menghasilkan dari SUBTOTAL dan fungsi AGGREGATE lain disematkan ke baris." -#. 3XYPK +#. 7VEyN #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id200801176228491\n" "help.text" -msgid "AGGREGATE(Function; Option; Ref1 [; Ref2 [; …]])" -msgstr "AGGREGATE(Fungsi; Opsi; Ref1 [; Ref2 [; ...]])" +msgid "AGGREGATE(Function; Option; Number 1[; Number 2][; ... ;[Number 253]])" +msgstr "" #. Xt2VS #: func_aggregate.xhp @@ -55012,14 +54994,14 @@ msgctxt "" msgid "or" msgstr "atau" -#. pDFDZ +#. 2nzVY #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id30181907128680\n" "help.text" -msgid "AGGREGATE(Function; Option; Array [; k])" -msgstr "AGGREGATE(Fungsi; Opsi; Array [; k])" +msgid "AGGREGATE(Function; Option; Array[; k])" +msgstr "" #. WPGsi #: func_aggregate.xhp @@ -55318,32 +55300,32 @@ msgctxt "" msgid "Ignore only hidden rows and errors" msgstr "Hanya abaikan baris tersebunyi dan galat" -#. GyzCp +#. ztEnu #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id220402843321947\n" "help.text" -msgid "<emph>Ref1</emph> – obligatory argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it." -msgstr "<emph>Ref1</emph>– argumen wajib. Argumen numerik pertama (jika rentang diatur oleh daftar nilai didalam fungsi) atau acuan untuk sel yang berisi." +msgid "<emph>Number1</emph> – required argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it." +msgstr "" -#. HYjBf +#. wNPAv #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id2309201514193338\n" "help.text" -msgid "<emph>Ref2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value." -msgstr "<emph> Ref2, 3, ... </emph> - opsional. Argumen numerik atau referensi ke sel (hingga 253 argumen), untuk itu Anda memerlukan nilai agregat." +msgid "<emph>Number2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value." +msgstr "" -#. XGBRq +#. VQD44 #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id99381371214702\n" "help.text" -msgid "<emph>Array</emph> – obligatory argument. The array can be specified by the boundaries of the range, the name of the named range or the column label." -msgstr "<emph>Larik</emph> – argumen wajib. Larik dapat ditentukan oleh batas rentang, nama rentang bernama atau label kolom." +msgid "<emph>Array</emph> – required argument. The array can be specified by the boundaries of the range, the name of the named range or the column label." +msgstr "" #. tQG5i #: func_aggregate.xhp @@ -55354,14 +55336,14 @@ msgctxt "" msgid "For using column labels “Automatically find columns and rows labels” function needs to be enabled." msgstr "Untuk menggunakan label kolom, fungsi Secara otomatis menemukan kolom dan label baris perlu diaktifkan." -#. 7dDDM +#. FChoZ #: func_aggregate.xhp msgctxt "" "func_aggregate.xhp\n" "par_id2209201514174370\n" "help.text" -msgid "<emph>k</emph> – obligatory argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions." -msgstr "<emph>k</emph> – argumen wajib untuk fungsi-fungsi berikut: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. Ini adalah argumen numerik, yang harus sesuai dengan argumen kedua dari fungsi-fungsi ini." +msgid "<emph>k</emph> – required argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions." +msgstr "" #. 5M7aG #: func_aggregate.xhp @@ -56174,22 +56156,13 @@ msgctxt "" msgid "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate." msgstr "" -#. Em25Q +#. fJEF4 #: func_concat.xhp msgctxt "" "func_concat.xhp\n" -"par_id911556226813411\n" +"par_id911556226813412\n" "help.text" -msgid "CONCAT( string1[, string2][, …] )" -msgstr "" - -#. suFNR -#: func_concat.xhp -msgctxt "" -"func_concat.xhp\n" -"par_id581556227044166\n" -"help.text" -msgid "<emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains strings to concatenate." +msgid "CONCAT( <embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/> )" msgstr "" #. aTwgH @@ -56246,23 +56219,14 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Mengembalikan jumlah sel yang memenuhi kriteria pada beberapa rentang.</variable></ahelp>" -#. CQxwD +#. xRjyE #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" "par_id27421466710275\n" "help.text" -msgid "COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])" -msgstr "COUNTIFS(Rentang1; Kriteria1 [; Rentang2; Kriteria2 [; ...]])" - -#. fMsMm -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id242131304318587\n" -"help.text" -msgid "<emph>Range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for counting and finding the corresponding criterion." -msgstr "<emph> Range1 </emph> - argumen yang diperlukan. Ini adalah rentang sel, nama rentang bernama atau label kolom atau baris yang berisi nilai untuk menghitung dan menemukan kriteria yang sesuai." +msgid "COUNTIFS(Range1; Criterion1[; Range2; Criterion2][; ... ; [Range127; Criterion127]])" +msgstr "" #. 2BB8K #: func_countifs.xhp @@ -58587,13 +58551,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">IFS is a multiple IF-function.</ahelp></variable>" msgstr "" -#. pspe6 +#. WxB3F #: func_ifs.xhp msgctxt "" "func_ifs.xhp\n" "par_id271556235333493\n" "help.text" -msgid "IFS( expression1, result1[, expression2, result2][, …] )" +msgid "IFS(expression1; result1[; expression2; result2][; ... ; [expression127; result127]])" msgstr "" #. 3KbKX @@ -61132,32 +61096,50 @@ msgctxt "" msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors.</ahelp>" msgstr "<ahelp hid=\".\"> Kurangi satu set angka dan berikan hasilnya tanpa menghilangkan kesalahan pembulatan kecil. </ahelp>" -#. H2pwA +#. DZTdg #: func_rawsubtract.xhp msgctxt "" "func_rawsubtract.xhp\n" "par_2016112109233\n" "help.text" -msgid "RAWSUBTRACT(Minuend, Subtrahend1, Subtrahend2, ...)" -msgstr "RAWSUBTRACT (Minuend, Subtrahend1, Subtrahend2, ...)" +msgid "RAWSUBTRACT(Minuend; Subtrahend 1[; Subtrahend 2][; … ;[ Subtrahend 254]])" +msgstr "" -#. xbWdN +#. 7mBFv #: func_rawsubtract.xhp msgctxt "" "func_rawsubtract.xhp\n" "par_2016112109234\n" "help.text" -msgid "Subtracts the subtrahend(s) from the minuend without eliminating roundoff errors. The function should be called with at least two parameters." -msgstr "Kurangi subtrahend dari minuend tanpa menghilangkan kesalahan pembulatan. Fungsi harus dipanggil dengan setidaknya dua parameter." +msgid "<emph>Minuend</emph> is a number or a reference to a cell containing a number." +msgstr "" -#. fB4Ah +#. nFADC +#: func_rawsubtract.xhp +msgctxt "" +"func_rawsubtract.xhp\n" +"par_id241585352178687\n" +"help.text" +msgid "<emph>Subtrahend 1[; Subtrahend 2][; ... ;[ Subtrahend 254]]</emph> are numbers or references to cells containing numbers." +msgstr "" + +#. 7ciz5 #: func_rawsubtract.xhp msgctxt "" "func_rawsubtract.xhp\n" "par_2016112109235\n" "help.text" +msgid "The function should be called with at least two parameters." +msgstr "" + +#. gwtEM +#: func_rawsubtract.xhp +msgctxt "" +"func_rawsubtract.xhp\n" +"par_2016112109236\n" +"help.text" msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765, 0.9876543210987)</item> returns 6.53921361504217E-14" -msgstr "<item type=\"literal\">RAWSUBTRACT (0.987654321098765, 0.9876543210987) </item> mengembalikan 6.53921361504217E-14" +msgstr "" #. QZT3B #: func_rawsubtract.xhp @@ -61717,32 +61699,23 @@ msgctxt "" msgid "<ahelp hid=\".\">Calculates the skewness of a distribution using the population of a random variable.</ahelp>" msgstr "<ahelp hid=\".\">Menghitung kemiringan distribusi menggunakan populasi variabel acak.</ahelp>" -#. w2FMD +#. FCmqL #: func_skewp.xhp msgctxt "" "func_skewp.xhp\n" "par_id27421466710275\n" "help.text" -msgid "SKEWP(Number1; Number2; ...; Number30)" -msgstr "SKEWP(Nomor1; Nomor2; ...; Nomor30)" - -#. r6EFM -#: func_skewp.xhp -msgctxt "" -"func_skewp.xhp\n" -"par_id242131304318587\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are up to 30 numerical values or ranges." -msgstr "<emph>Nomor1, Nomor2, ..., Nomor30</emph> hingga 30 nilai numerik atau rentang." +msgid "SKEWP(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" +msgstr "" -#. 2Cw95 +#. Af6Mq #: func_skewp.xhp msgctxt "" "func_skewp.xhp\n" "par_id242131304315587\n" "help.text" -msgid "Calculates the skewness of a distribution using the population, i.e. the possible outcomes, of a random variable. The sequence shall contain three numbers at least." -msgstr "Menghitung kemiringan distribusi menggunakan populasi, yaitu hasil yang mungkin, dari variabel acak. Setidaknya urutan harus mengandung tiga angka." +msgid "The parameters should specify at least three values." +msgstr "" #. W8hYu #: func_skewp.xhp @@ -62005,13 +61978,22 @@ msgctxt "" msgid "<variable id=\"functionswitch\"><ahelp hid=\".\">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.</ahelp></variable>" msgstr "" -#. esoEp +#. tFvZx #: func_switch.xhp msgctxt "" "func_switch.xhp\n" "par_id521556242803283\n" "help.text" -msgid "SWITCH( expression, value1, result1[, value2, result2][, … ][, default_result] )" +msgid "SWITCH(expression; value1; result1[; value2; result2][; ... ; [value127; result127][; default_result]])" +msgstr "" + +#. p8fL8 +#: func_switch.xhp +msgctxt "" +"func_switch.xhp\n" +"par_id111585520651521\n" +"help.text" +msgid "If you choose not to specify a default result, 127 value / result pairs may be entered as parameters. If you choose to include a default result at the end of the list of parameters, then only 126 value / result pairs may be entered." msgstr "" #. nnW4D @@ -62113,13 +62095,13 @@ msgctxt "" msgid "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable>" msgstr "" -#. qZsoF +#. q72j4 #: func_textjoin.xhp msgctxt "" "func_textjoin.xhp\n" "par_id541556228253979\n" "help.text" -msgid "TEXTJOIN( delimiter, skip_empty, string1[, string2][, …] )" +msgid "TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )" msgstr "" #. WaME6 @@ -62140,13 +62122,13 @@ msgctxt "" msgid "<emph>skip_empty</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored." msgstr "" -#. emud3 +#. JoYks #: func_textjoin.xhp msgctxt "" "func_textjoin.xhp\n" "par_id631556228516997\n" "help.text" -msgid "<emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains text to join." +msgid "<emph>String 1[; String 2][; … ;[String 253]]</emph> are strings, references to cells or to cell ranges of strings." msgstr "" #. PDbCp @@ -64536,14 +64518,14 @@ msgctxt "" msgid "Data Statistics in Calc" msgstr "Statistik Data dalam Calc" -#. wekDu +#. VK8em #: statistics.xhp msgctxt "" "statistics.xhp\n" "hd_id1000010\n" "help.text" -msgid "Data Statistics in Calc" -msgstr "Statistik Data dalam Calc" +msgid "<link href=\"text/scalc/01/statistics.xhp\" name=\"Data Statistics in Calc\">Statistics</link>" +msgstr "" #. iXfGE #: statistics.xhp @@ -64563,2400 +64545,2471 @@ msgctxt "" 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 "Untuk mengerjakan analisis statistik atau teknik yang rumit, Anda dapat menghemat langkah dan waktu dengan menggunakan Statistik Data Calc. Anda memberikan data dan parameter untuk setiap analisis, dan seperangkat alat menggunakan fungsi statistik atau teknik yang sesuai untuk menghitung dan menampilkan hasil dalam tabel output." -#. MufZD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"bm_id2764278\n" -"help.text" -msgid "<bookmark_value>Analysis toolpack;sampling</bookmark_value><bookmark_value>sampling;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;sampling</bookmark_value>" -msgstr "<bookmark_value>Toolpack analisis; pengambilan sampel</bookmark_value><bookmark_value>sampling; Analisis toolpack</bookmark_value><bookmark_value>Statistik data; sampling</bookmark_value>" - -#. HBwLS -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000020\n" -"help.text" -msgid "Sampling" -msgstr "Contoh" - -#. Tg67b -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000030\n" -"help.text" -msgid "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Create a table with data sampled from another table.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Buat tabel dengan data sampel dari tabel lain.</ahelp>" - -#. omEF9 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000040\n" -"help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Sampling</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih <emph>Data - Statistik - Cuplikan</emph></variable>" - -#. PBJaF -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000050\n" -"help.text" -msgid "Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis." -msgstr "Pengambilan sampel memungkinkan Anda untuk mengambil data dari tabel <emph>sumber</emph> untuk mengisi tabel <emph>target</emph>. Pengambilan sampel dapat dilakukan secara acak atau secara berkala." - -#. EWdZp -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000060\n" -"help.text" -msgid "Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table." -msgstr "Pengambilan sampel dilakukan berdasarkan baris. Itu berarti, data sampel akan memilih seluruh baris tabel sumber dan menyalin ke dalam garis tabel target." - -#. SLV5d -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000030\n" -"help.text" -msgid "Sampling Method" -msgstr "Metoda Pencuplikan" - -#. Hz5r6 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000070\n" -"help.text" -msgid "<emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way." -msgstr "<emph>Acak</emph>: Memilih tepat garis <emph>Ukuran Sampel</emph> dari tabel sumber secara acak." - -#. xu8WG -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000080\n" -"help.text" -msgid "<emph>Sample size</emph>: Number of lines sampled from the source table." -msgstr "<emph>Ukuran Sampel</emph>: Jumlah garis yang diambil dari tabel sumber." - -#. JXVvj -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000090\n" -"help.text" -msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>." -msgstr "<emph> Periodic </emph>: Pilihan garis dalam langkah yang ditentukan oleh <emph> Periode </emph>." - -#. 8P2qJ -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000100\n" -"help.text" -msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling." -msgstr "<emph> Periode </emph>: jumlah baris yang dilewati secara berkala saat pengambilan sampel." - -#. oCAwA -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000110\n" -"help.text" -msgid "The following data will be used as example of source data table for sampling:" -msgstr "Data berikut akan digunakan sebagai contoh tabel data sumber untuk pengambilan sampel:" - -#. ig3WX -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000510\n" -"help.text" -msgid "Sampling with a period of 2 will result in the following table:" -msgstr "Pengambilan sampel dengan periode 2 akan menghasilkan tabel berikut:" - -#. GWdPA -#: 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 "<bookmark_value>Toolpack analisis; statistik deskriptif</bookmark_value><bookmark_value>statistik deskriptif; Alat analisis paket</bookmark_value><bookmark_value>Statistik data; statistik deskriptif</bookmark_value>" - -#. AFPzR -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000050\n" -"help.text" -msgid "Descriptive Statistics" -msgstr "Statistika Deskriptif" - -#. 268Cs -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000640\n" -"help.text" -msgid "<ahelp hid=\"modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog\">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog\">Isi tabel di spreadsheet dengan properti statistik utama dari kumpulan data.</ahelp>" - -#. KAFvp -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000650\n" -"help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Descriptive Statistics</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih <emph>Data - Statistik - Statistik Deskriptif</emph></variable>" - -#. kELPD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000660\n" -"help.text" -msgid "The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data." -msgstr "Alat analisis Statistik Deskriptif menghasilkan laporan statistik univariat untuk data dalam rentang input, memberikan informasi tentang kecenderungan sentral dan variabilitas data Anda." - -#. Ys6kB -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000670\n" -"help.text" -msgid "For more information on descriptive statistics, refer to the <link href=\"https://en.wikipedia.org/wiki/Descriptive_statistics\" name=\"English Wikipedia: Descriptive statistics\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang statistik deskriptif, lihat <link href=\"https://en.wikipedia.org/wiki/Descriptive_statistics\" name=\"English Wikipedia: Descriptive statistics\">artikel Wikipedia yang sesuai</link>." - -#. EDqCK -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000680\n" -"help.text" -msgid "The following table displays the results of the descriptive statistics of the sample data above." -msgstr "Tabel berikut menampilkan hasil statistik deskriptif dari data sampel di atas." - -#. H26q7 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000690\n" -"help.text" -msgid "Column 1" -msgstr "Kolom" - -#. Xo3Q9 -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000700\n" -"help.text" -msgid "Column 2" -msgstr "Kolom" - -#. 6kGNU -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000710\n" -"help.text" -msgid "Column 3" -msgstr "Kolom" - -#. Y7mYt -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000720\n" -"help.text" -msgid "Mean" -msgstr "Rerata (mean)" - -#. JKRLG -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000760\n" -"help.text" -msgid "Standard Error" -msgstr "Kesalahan Standar" - -#. 7Fdbc -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000800\n" -"help.text" -msgid "Mode" -msgstr "Lebih" - -#. 4qjpU -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000840\n" -"help.text" -msgid "Median" -msgstr "Median" - -#. wBD4D -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000880\n" -"help.text" -msgid "Variance" -msgstr "Varian" - -#. RoEEt -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000920\n" -"help.text" -msgid "Standard Deviation" -msgstr "Standar Deviasi" - -#. cWsBq -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1000960\n" -"help.text" -msgid "Kurtosis" -msgstr "Kurtosis" - -#. SGK2Y -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001000\n" -"help.text" -msgid "Skewness" -msgstr "Kemiringan" - -#. ye9tA -#: statistics.xhp +#. CGf5i +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" -"par_id1001040\n" -"help.text" -msgid "Range" -msgstr "Jangkauan" - -#. Y8X9J -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001080\n" -"help.text" -msgid "Minimum" -msgstr "Minimum" - -#. KumSv -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001120\n" -"help.text" -msgid "Maximum" -msgstr "Maksimum" - -#. HFRrE -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001160\n" -"help.text" -msgid "Sum" -msgstr "Sum (Jumlah)" - -#. bS8FL -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1001200\n" +"statistics_anova.xhp\n" +"tit\n" "help.text" -msgid "Count" -msgstr "Cacah" +msgid "ANOVA" +msgstr "" -#. Pxk9L -#: statistics.xhp +#. UAf2Q +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "bm_id02001\n" "help.text" msgid "<bookmark_value>Analysis toolpack;analysis of variance</bookmark_value><bookmark_value>Analysis toolpack;ANOVA</bookmark_value><bookmark_value>analysis of variance;Analysis toolpack</bookmark_value><bookmark_value>ANOVA;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;analysis of variance</bookmark_value><bookmark_value>Data statistics;ANOVA</bookmark_value>" -msgstr "<bookmark_value>Toolpack analisis; analisis varian</bookmark_value><bookmark_value>Toolpack analisis;ANOVA</bookmark_value><bookmark_value>analisis varians; Analisis toolpack</bookmark_value><bookmark_value>ANOVA;Toolpack analisis</bookmark_value><bookmark_value>Statistik data, analisis varian</bookmark_value><bookmark_value>Statistik Data;ANOVA</bookmark_value>" +msgstr "" -#. 5KmAN -#: statistics.xhp +#. DLedq +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "hd_id1000060\n" "help.text" -msgid "Analysis of Variance (ANOVA)" -msgstr "Analisis Varians (ANOVA)" +msgid "<variable id=\"anovah1\"><link href=\"text/scalc/01/statistics_anova.xhp\" name=\"Analysis of Variance (ANOVA)\">Analysis of Variance (ANOVA)</link></variable>" +msgstr "" -#. GyVwG -#: statistics.xhp +#. oSUDa +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001240\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog\">Produces the analysis of variance (ANOVA) of a given data set</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/analysisofvariancedialog/AnalysisOfVarianceDialog\">Menghasilkan analisis varian (ANOVA) dari kumpulan data yang diberikan</ahelp>" +msgstr "" -#. SupiC -#: statistics.xhp +#. w5pw6 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001250\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Analysis of Variance (ANOVA)</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih<emph>Data - Statistik - Analisis Varian (ANOVA)</emph></variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Analysis of Variance (ANOVA)</menuitem></variable>" +msgstr "" -#. MHFxP -#: statistics.xhp +#. r9GGt +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001260\n" "help.text" msgid "ANOVA is the acronym for <emph>AN</emph>alysis <emph>O</emph>f <emph>VA</emph>riance. This tool produces the analysis of variance of a given data set" -msgstr "ANOVA adalah singkatan untuk <emph>AN</emph>alysis <emph>O</emph>f <emph> VA </emph> riance. Alat ini menghasilkan analisis varian dari set data yang diberikan" +msgstr "" -#. v5YoG -#: statistics.xhp +#. fRyBD +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001270\n" "help.text" msgid "For more information on ANOVA, refer to the <link href=\"https://en.wikipedia.org/wiki/ANOVA\" name=\"English Wikipedia: ANOVA\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang ANOVA, lihat <link href=\"https://en.wikipedia.org/wiki/ANOVA\" name=\"English Wikipedia: ANOVA\">artikel Wikipedia yang sesuai</link>." +msgstr "" -#. 6BG9w -#: statistics.xhp +#. Lw9W4 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "hd_id1000070\n" "help.text" msgid "Type" -msgstr "Jenis" +msgstr "" -#. Lj8jU -#: statistics.xhp +#. t2j8D +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001280\n" "help.text" msgid "Select if the analysis is for a <emph>single factor</emph> or for <emph>two factor</emph> ANOVA." -msgstr "Pilih jika analisisnya untuk <emph>faktor tunggal</emph> atau untuk <emph>dua faktor</emph> ANOVA." +msgstr "" -#. dC3VK -#: statistics.xhp +#. msAwu +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "hd_id1000080\n" "help.text" msgid "Parameters" -msgstr "Parameter" +msgstr "" -#. urnKD -#: statistics.xhp +#. ARzmU +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001290\n" "help.text" msgid "<emph>Alpha</emph>: the level of significance of the test." -msgstr "<emph>Alpha</emph>: tingkat signifikansi tes." +msgstr "" -#. ThHAU -#: statistics.xhp +#. PyK5A +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001300\n" "help.text" msgid "<emph>Rows per sample</emph>: Define how many rows a sample has." -msgstr "<emph>Baris per sampel</emph>: Tentukan berapa banyak baris yang dimiliki sampel." +msgstr "" -#. ZN697 -#: statistics.xhp +#. 5yBo2 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001310\n" "help.text" msgid "The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above." -msgstr "Tabel berikut menampilkan hasil <emph> analisis varians (ANOVA) </emph> dari sampel data di atas." +msgstr "" -#. TKjsT -#: statistics.xhp +#. 5uDqB +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001320\n" "help.text" msgid "ANOVA - Single Factor" -msgstr "ANOVA - Faktor Tunggal" +msgstr "" -#. GPUcf -#: statistics.xhp +#. AzFd3 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001330\n" "help.text" msgid "Alpha" -msgstr "Alfa" +msgstr "" -#. jFRS3 -#: statistics.xhp +#. Dvbo3 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001350\n" "help.text" msgid "Groups" -msgstr "Kelompok" +msgstr "" -#. 6JGBA -#: statistics.xhp +#. L6VAY +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001360\n" "help.text" msgid "Count" -msgstr "Cacah" +msgstr "" -#. AWmMZ -#: statistics.xhp +#. G9fqK +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001370\n" "help.text" msgid "Sum" -msgstr "Sum (Jumlah)" +msgstr "" -#. 3LKBY -#: statistics.xhp +#. n2Ayi +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001380\n" "help.text" msgid "Mean" -msgstr "Rerata (mean)" +msgstr "" -#. 5kBZx -#: statistics.xhp +#. CnFDW +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001390\n" "help.text" msgid "Variance" -msgstr "Varian" +msgstr "" -#. HN9Kg -#: statistics.xhp +#. 2LDkn +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001400\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. S4dmD -#: statistics.xhp +#. p6hJA +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001450\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. Dqm5K -#: statistics.xhp +#. 6jqh4 +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001500\n" "help.text" msgid "Column 3" -msgstr "Kolom" +msgstr "" -#. G7cR5 -#: statistics.xhp +#. d3ASg +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001550\n" "help.text" msgid "Source of Variation" -msgstr "Sumber Variasi" +msgstr "" -#. YDAXn -#: statistics.xhp +#. CrpJv +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001560\n" "help.text" msgid "SS" -msgstr "SS" +msgstr "" -#. hThUx -#: statistics.xhp +#. 3BARp +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001570\n" "help.text" msgid "df" -msgstr "df" +msgstr "" -#. C5Mqo -#: statistics.xhp +#. YhWBw +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001580\n" "help.text" msgid "MS" -msgstr "MS" +msgstr "" -#. EUK48 -#: statistics.xhp +#. KV6Cy +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001590\n" "help.text" msgid "F" -msgstr "F" +msgstr "" -#. SdY8k -#: statistics.xhp +#. QRdrB +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001600\n" "help.text" msgid "P-value" -msgstr "Nilai-P" +msgstr "" -#. E6QVZ -#: statistics.xhp +#. Vabri +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id841554943563747\n" "help.text" msgid "F-critical" msgstr "" -#. oMeZQ -#: statistics.xhp +#. RR2va +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001610\n" "help.text" msgid "Between Groups" -msgstr "Antara Grup" +msgstr "" -#. JybQF -#: statistics.xhp +#. vuDTW +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id411554944014360\n" "help.text" msgid "3.340385558" msgstr "" -#. 6bYDS -#: statistics.xhp +#. tpzCU +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001670\n" "help.text" msgid "Within Groups" -msgstr "Dalam Grup" +msgstr "" -#. 6qH4W -#: statistics.xhp +#. Lcu3C +#: statistics_anova.xhp msgctxt "" -"statistics.xhp\n" +"statistics_anova.xhp\n" "par_id1001710\n" "help.text" msgid "Total" -msgstr "Total" +msgstr "" -#. WYXKV -#: statistics.xhp +#. NaUDo +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" +"tit\n" +"help.text" +msgid "Data Correlation in Calc" +msgstr "" + +#. agTA6 +#: statistics_correlation.xhp +msgctxt "" +"statistics_correlation.xhp\n" "bm_id1464278\n" "help.text" msgid "<bookmark_value>Analysis toolpack;correlation</bookmark_value><bookmark_value>correlation;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;correlation</bookmark_value>" -msgstr "<bookmark_value>Alat analisis; korelasi</bookmark_value><bookmark_value>korelasi, alat analisis</bookmark_value><bookmark_value>Statistik data; korelasi</bookmark_value>" +msgstr "" -#. qFxEj -#: statistics.xhp +#. GDsXj +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "hd_id1000090\n" "help.text" -msgid "Correlation" -msgstr "Korelasi" +msgid "<variable id=\"correlationh1\"><link href=\"text/scalc/01/statistics_correlation.xhp\" name=\"Correlation\">Correlation</link></variable>" +msgstr "" -#. Um82Z -#: statistics.xhp +#. zJrnQ +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001740\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/correlationdialog/CorrelationDialog\">Calculates the correlation of two sets of numeric data.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/correlationdialog/CorrelationDialog\">Menghitung korelasi dua set data numerik.</ahelp>" +msgstr "" -#. DtTZA -#: statistics.xhp +#. WK8ke +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001750\n" "help.text" -msgid "<variable id=\"corr01\">Choose <emph>Data - Statistics - Correlation</emph></variable>" -msgstr "<variable id=\"corr01\">Pilih <emph>Data - Statistik - Korelasi</emph></variable>" +msgid "<variable id=\"corr01\">Choose <menuitem>Data - Statistics - Correlation</menuitem></variable>" +msgstr "" -#. nyGfA -#: statistics.xhp +#. 85aLv +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001760\n" "help.text" msgid "The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables." -msgstr "Koefisien korelasi (nilai antara -1 dan +1) berarti seberapa kuat dua variabel terkait satu sama lain. Anda dapat menggunakan fungsi CORREL atau Statistik Data untuk menemukan koefisien korelasi antara dua variabel." +msgstr "" -#. Ahycu -#: statistics.xhp +#. Az6pZ +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001770\n" "help.text" msgid "A correlation coefficient of +1 indicates a perfect positive correlation." -msgstr "Koefisien korelasi +1 menunjukkan korelasi positif sempurna." +msgstr "" -#. 5AEs9 -#: statistics.xhp +#. FtKmy +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001780\n" "help.text" msgid "A correlation coefficient of -1 indicates a perfect negative correlation" -msgstr "Koefisien korelasi -1 menunjukkan korelasi negatif sempurna" +msgstr "" -#. uHjNT -#: statistics.xhp +#. rzVxG +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001790\n" "help.text" msgid "For more information on statistical correlation, refer to the <link href=\"https://en.wikipedia.org/wiki/Correlation\" name=\"English Wikipedia: Correlation\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang korelasi statistik, lihat <link href=\"https://en.wikipedia.org/wiki/Correlation\" name=\"English Wikipedia: Correlation\">artikel Wikipedia yang sesuai</link>." +msgstr "" -#. LQP4K -#: statistics.xhp +#. 9LxBc +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001800\n" "help.text" msgid "The following table displays the results of the correlation of the sample data above." -msgstr "Tabel berikut menampilkan hasil korelasi data sampel di atas." +msgstr "" -#. bJYwq -#: statistics.xhp +#. GZnGj +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001810\n" "help.text" msgid "Correlations" -msgstr "Korelasi" +msgstr "" -#. QAQyB -#: statistics.xhp +#. JMJ4R +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001820\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. CBoxF -#: statistics.xhp +#. EJm3M +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001830\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. WVNev -#: statistics.xhp +#. UjLAb +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001840\n" "help.text" msgid "Column 3" -msgstr "Kolom" +msgstr "" -#. QUWeh -#: statistics.xhp +#. JiUAt +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001850\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. bGwFq -#: statistics.xhp +#. h5ubU +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001870\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. qAAKN -#: statistics.xhp +#. j3GXA +#: statistics_correlation.xhp msgctxt "" -"statistics.xhp\n" +"statistics_correlation.xhp\n" "par_id1001900\n" "help.text" msgid "Column 3" -msgstr "Kolom" +msgstr "" -#. 9xF7p -#: statistics.xhp +#. SpEzh +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" +"tit\n" +"help.text" +msgid "Data Covariance in Calc" +msgstr "" + +#. FsgEU +#: statistics_covariance.xhp +msgctxt "" +"statistics_covariance.xhp\n" "bm_id2964278\n" "help.text" msgid "<bookmark_value>Analysis toolpack;covariance</bookmark_value><bookmark_value>covariance;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;covariance</bookmark_value>" -msgstr "<bookmark_value>alat analisis;kovarians</bookmark_value><bookmark_value>kovarians; Alat analisis</bookmark_value><bookmark_value>Statistik data; kovarians</bookmark_value>" +msgstr "" -#. YjBBG -#: statistics.xhp +#. mELGD +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "hd_id1000100\n" "help.text" -msgid "Covariance" -msgstr "Konvariansi" +msgid "<variable id=\"covarianceh1\"><link href=\"text/scalc/01/statistics_covariance.xhp\" name=\"Covariance\">Covariance</link></variable>" +msgstr "" -#. sD4Fo -#: statistics.xhp +#. xZ7MH +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001940\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/covariancedialog/CovarianceDialog\">Calculates the covariance of two sets of numeric data.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/covariancedialog/CovarianceDialog\">Menghitung kovarians dari dua set data numerik.</ahelp>" +msgstr "" -#. iCA2j -#: statistics.xhp +#. WgiEU +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001950\n" "help.text" -msgid "<variable id=\"cov01\">Choose <emph>Data - Statistics - Covariance</emph></variable>" -msgstr "<variable id=\"cov01\">Pilih <emph>Data - Statistik - Kovarian</emph></variable>" +msgid "<variable id=\"cov01\">Choose <menuitem>Data - Statistics - Covariance</menuitem></variable>" +msgstr "" -#. ZC5Fs -#: statistics.xhp +#. PrEaV +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001960\n" "help.text" msgid "The covariance is a measure of how much two random variables change together." -msgstr "Kovarians adalah ukuran dari seberapa banyak dua variabel acak berubah bersama." +msgstr "" -#. 8yDuo -#: statistics.xhp +#. mnNLA +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001970\n" "help.text" msgid "For more information on statistical covariance, refer to the <link href=\"https://en.wikipedia.org/wiki/Covariance\" name=\"English Wikipedia: Covariance\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang kovarians statistik, lihat <link href=\"https://en.wikipedia.org/wiki/Covariance\" name=\"English Wikipedia: Covariance\">artikel Wikipedia yang sesuai</link>." +msgstr "" -#. CPE2e -#: statistics.xhp +#. FNxfQ +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001980\n" "help.text" msgid "The following table displays the results of the covariance of the sample data above." -msgstr "Tabel berikut menampilkan hasil kovarians dari data sampel di atas." +msgstr "" -#. wXZ5E -#: statistics.xhp +#. NEWzK +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1001990\n" "help.text" msgid "Covariances" -msgstr "Kovarian" +msgstr "" -#. YL6nE -#: statistics.xhp +#. onYs5 +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002000\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. cKgoA -#: statistics.xhp +#. sqErz +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002010\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. ZeGD3 -#: statistics.xhp +#. n3e2C +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002020\n" "help.text" msgid "Column 3" -msgstr "Kolom" +msgstr "" -#. PfqDB -#: statistics.xhp +#. F4E2J +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002030\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. B6YQi -#: statistics.xhp +#. 3d6Ds +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002050\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. N7C2i -#: statistics.xhp +#. GajDs +#: statistics_covariance.xhp msgctxt "" -"statistics.xhp\n" +"statistics_covariance.xhp\n" "par_id1002080\n" "help.text" msgid "Column 3" -msgstr "Kolom" +msgstr "" -#. xGFXz -#: statistics.xhp +#. mc3YQ +#: statistics_descriptive.xhp msgctxt "" -"statistics.xhp\n" +"statistics_descriptive.xhp\n" +"tit\n" +"help.text" +msgid "Descriptive Statistics in Calc" +msgstr "" + +#. H4Cik +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.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 "" + +#. CWfuc +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"hd_id1000050\n" +"help.text" +msgid "<variable id=\"descriptivestatisticsh1\"><link href=\"text/scalc/01/statistics_descriptive.xhp\" name=\"Descriptive Statistics\">Descriptive Statistics</link></variable>" +msgstr "" + +#. 7XkEb +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000640\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/descriptivestatisticsdialog/DescriptiveStatisticsDialog\">Fill a table in the spreadsheet with the main statistical properties of the data set.</ahelp>" +msgstr "" + +#. EAywA +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000650\n" +"help.text" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Descriptive Statistics</menuitem></variable>" +msgstr "" + +#. cuUnJ +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000660\n" +"help.text" +msgid "The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data." +msgstr "" + +#. 2bsE3 +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000670\n" +"help.text" +msgid "For more information on descriptive statistics, refer to the <link href=\"https://en.wikipedia.org/wiki/Descriptive_statistics\" name=\"English Wikipedia: Descriptive statistics\">corresponding Wikipedia article</link>." +msgstr "" + +#. VccwM +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000680\n" +"help.text" +msgid "The following table displays the results of the descriptive statistics of the sample data above." +msgstr "" + +#. XC7CC +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000690\n" +"help.text" +msgid "Column 1" +msgstr "" + +#. HY2UN +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000700\n" +"help.text" +msgid "Column 2" +msgstr "" + +#. qTDSp +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000710\n" +"help.text" +msgid "Column 3" +msgstr "" + +#. AjAbs +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000720\n" +"help.text" +msgid "Mean" +msgstr "" + +#. CuH3F +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000760\n" +"help.text" +msgid "Standard Error" +msgstr "" + +#. bU9Yb +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000800\n" +"help.text" +msgid "Mode" +msgstr "" + +#. PH44f +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000840\n" +"help.text" +msgid "Median" +msgstr "" + +#. GKGy8 +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000880\n" +"help.text" +msgid "Variance" +msgstr "" + +#. XBfaP +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000920\n" +"help.text" +msgid "Standard Deviation" +msgstr "" + +#. JqtpV +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1000960\n" +"help.text" +msgid "Kurtosis" +msgstr "" + +#. CNLwk +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001000\n" +"help.text" +msgid "Skewness" +msgstr "" + +#. 4dWHz +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001040\n" +"help.text" +msgid "Range" +msgstr "" + +#. XX2DK +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001080\n" +"help.text" +msgid "Minimum" +msgstr "" + +#. LKHuw +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001120\n" +"help.text" +msgid "Maximum" +msgstr "" + +#. FM2fN +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001160\n" +"help.text" +msgid "Sum" +msgstr "" + +#. FZdrB +#: statistics_descriptive.xhp +msgctxt "" +"statistics_descriptive.xhp\n" +"par_id1001200\n" +"help.text" +msgid "Count" +msgstr "" + +#. gAEBc +#: statistics_exposmooth.xhp +msgctxt "" +"statistics_exposmooth.xhp\n" +"tit\n" +"help.text" +msgid "Exponential Smoothing in Calc" +msgstr "" + +#. cNRQD +#: statistics_exposmooth.xhp +msgctxt "" +"statistics_exposmooth.xhp\n" "bm_id03001\n" "help.text" msgid "<bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value><bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;exponential smoothing</bookmark_value>" -msgstr "<bookmark_value>Alat analisis;penghalusan eksponensial</bookmark_value><bookmark_value>pemulusan eksponensial;Analisis toolpak</bookmark_value><bookmark_value>Statistik data;pemulusan eksponensial</bookmark_value>" +msgstr "" -#. pjmjS -#: statistics.xhp +#. CF4hG +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "hd_id1000110\n" "help.text" -msgid "Exponential Smoothing" -msgstr "Penghalusan Eksponensial" +msgid "<variable id=\"exponentialsmoothingh1\"><link href=\"text/scalc/01/statistics_exposmooth.xhp\" name=\"Exponential Smoothing\">Exponential Smoothing</link></variable>" +msgstr "" -#. HQfdM -#: statistics.xhp +#. ESHYa +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002120\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog\">Results in a smoothed data series</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog\">Menghasilkan rangkaian data yang dihaluskan</ahelp>" +msgstr "" -#. GjYAF -#: statistics.xhp +#. CA94C +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002130\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Exponential Smoothing</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih <emph>Data - Statistik - Penghalusan Eksponensial</emph></variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Exponential Smoothing</menuitem></variable>" +msgstr "" -#. 5q76p -#: statistics.xhp +#. M4GPm +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002140\n" "help.text" msgid "Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements." -msgstr "Pemulusan eksponensial adalah teknik pemfilteran yang bila diterapkan pada kumpulan data, menghasilkan hasil yang diperhalus. Ini digunakan dalam banyak domain seperti pasar saham, ekonomi dan dalam pengukuran sampel." +msgstr "" -#. VGPLc -#: statistics.xhp +#. BX9Ci +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002150\n" "help.text" msgid "For more information on exponential smoothing, refer to the <link href=\"https://en.wikipedia.org/wiki/Exponential_smoothing\" name=\"English Wikipedia: Exponential smoothing\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang pemulusan eksponensial, lihat <link href=\"https://en.wikipedia.org/wiki/Exponential_smoothing\" name=\"English Wikipedia: Exponential smoothing\">artikel Wikipedia yang sesuai</link>." +msgstr "" -#. 5HoYB -#: statistics.xhp +#. 2PBvq +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "hd_id1000120\n" "help.text" msgid "Parameters" -msgstr "Parameter" +msgstr "" -#. Kk9Cq -#: statistics.xhp +#. 5FYLV +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002160\n" "help.text" msgid "<emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation." -msgstr "<emph>Faktor Perataan</emph>:Parameter antara 0 dan 1 yang mewakili faktor peredam Alfa dalam persamaan perataan." +msgstr "" -#. L8SEj -#: statistics.xhp +#. b4y8A +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002170\n" "help.text" msgid "The resulting smoothing is below with smoothing factor as 0.5:" -msgstr "Penghalusan yang dihasilkan di bawah ini dengan faktor penghalusan 0,5:" +msgstr "" -#. tbXxy -#: statistics.xhp +#. GnSwW +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002180\n" "help.text" msgid "Alpha" -msgstr "Alfa" +msgstr "" -#. HNgFX -#: statistics.xhp +#. ZJzEM +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002200\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. MR6ET -#: statistics.xhp +#. dMdDR +#: statistics_exposmooth.xhp msgctxt "" -"statistics.xhp\n" +"statistics_exposmooth.xhp\n" "par_id1002210\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. 9PsYD -#: statistics.xhp +#. AXaMM +#: statistics_fourier.xhp msgctxt "" -"statistics.xhp\n" +"statistics_fourier.xhp\n" +"tit\n" +"help.text" +msgid "Fourier Analysis" +msgstr "" + +#. F2ncB +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"bm_id2764278\n" +"help.text" +msgid "<bookmark_value>Analysis toolpack;Fourier analysis</bookmark_value><bookmark_value>Fourier analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Fourier analysis</bookmark_value>" +msgstr "" + +#. EV56D +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"hd_id431561808831965\n" +"help.text" +msgid "<variable id=\"fourieranalysysh1\"><link href=\"text/scalc/01/statistics_fourier.xhp\" name=\"Fourier analysis\">Fourier Analysis</link></variable>" +msgstr "" + +#. EEBRe +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id1001240\n" +"help.text" +msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp>" +msgstr "" + +#. sG8zA +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id1000040\n" +"help.text" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Fourier Analysis</menuitem></variable>" +msgstr "" + +#. HpuG9 +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id1001270\n" +"help.text" +msgid "For more information on Fourier analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Fourier_analysis\" name=\"English Wikipedia: Fourier analysis\">corresponding Wikipedia article</link>." +msgstr "" + +#. VArYS +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id301561811172762\n" +"help.text" +msgid "<emph>Input range has label</emph>: Mark when the first row or column of the input array is actually a label and not part of the data analysis." +msgstr "" + +#. Gi5kk +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id741556228390897\n" +"help.text" +msgid "Input Range is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data." +msgstr "" + +#. GqXZr +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"hd_id211561811324208\n" +"help.text" +msgid "Options:" +msgstr "" + +#. 68RRB +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id631556228516997\n" +"help.text" +msgid "<emph>Inverse</emph>: When checked, calculates the inverse Discrete Fourier Transform." +msgstr "" + +#. MH9kg +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id811561732287508\n" +"help.text" +msgid "<emph>Polar</emph>: When checked, the results are in polar coordinates (magnitude, phase)." +msgstr "" + +#. peNbe +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id661561732521977\n" +"help.text" +msgid "<emph>Minimum magnitude for polar form output (in dB)</emph>: used only when output is in polar form. All frequency components with magnitude less than this value in decibels will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed." +msgstr "" + +#. 8pLcW +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id731561827207828\n" +"help.text" +msgid "The source data for this example is the same of the <link href=\"text/scalc/01/func_fourier.xhp\" name=\"Fourier function\">FOURIER function page</link>." +msgstr "" + +#. 4XJPB +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257279817\n" +"help.text" +msgid "Fourier Transform" +msgstr "" + +#. nfhVE +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id29062019125727379\n" +"help.text" +msgid "Fourier Transform" +msgstr "" + +#. G6aEG +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257276510\n" +"help.text" +msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgstr "" + +#. 5L22z +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257273433\n" +"help.text" +msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgstr "" + +#. Vyu9a +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257273688\n" +"help.text" +msgid "<emph>Real</emph>" +msgstr "" + +#. qEshW +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id290620191257276202\n" +"help.text" +msgid "<emph>Imaginary</emph>" +msgstr "" + +#. fJ6BG +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id481561825547527\n" +"help.text" +msgid "<emph>Magnitude</emph>" +msgstr "" + +#. XcXJz +#: statistics_fourier.xhp +msgctxt "" +"statistics_fourier.xhp\n" +"par_id751561825556834\n" +"help.text" +msgid "<emph>Phase</emph>" +msgstr "" + +#. Yo4ob +#: statistics_movingavg.xhp +msgctxt "" +"statistics_movingavg.xhp\n" +"tit\n" +"help.text" +msgid "Moving Average in Calc" +msgstr "" + +#. pgLeC +#: statistics_movingavg.xhp +msgctxt "" +"statistics_movingavg.xhp\n" "bm_id04001\n" "help.text" msgid "<bookmark_value>Analysis toolpack;moving average</bookmark_value><bookmark_value>moving average;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;moving average</bookmark_value>" -msgstr "<bookmark_value>Alat analisis;rata-rata bergerak</bookmark_value><bookmark_value>Rata-rata bergerak;Analisis toolpak</bookmark_value><bookmark_value>Statistik data;rata-rata bergerak</bookmark_value>" +msgstr "" -#. sbBFf -#: statistics.xhp +#. XUnST +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "hd_id1000130\n" "help.text" -msgid "Moving Average" -msgstr "Memindah Rata-rata" +msgid "<variable id=\"movingaverageh1\"><link href=\"text/scalc/01/statistics_movingavg.xhp\" name=\"Moving Average\">Moving Average</link></variable>" +msgstr "" -#. yBhLV -#: statistics.xhp +#. ghTMS +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002500\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/movingaveragedialog/MovingAverageDialog\">Calculates the moving average of a time series</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/movingaveragedialog/MovingAverageDialog\">Menghitung rata-rata bergerak dari deret waktu</ahelp>" +msgstr "" -#. sXEAs -#: statistics.xhp +#. yW3BR +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002510\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Moving Average</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih<emph> Data - Statistik - Rata-Rata Bergerak </emph> </variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Moving Average</menuitem></variable>" +msgstr "" -#. yEGoW -#: statistics.xhp +#. kn7s5 +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002520\n" "help.text" msgid "For more information on the moving average, refer to the <link href=\"https://en.wikipedia.org/wiki/Moving_average\" name=\"English Wikipedia: Moving average\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang moving average, lihat<link href=\"https://en.wikipedia.org/wiki/Moving_average\" name=\"English Wikipedia: Moving average\">artikel Wikipedia yang sesuai</link>." +msgstr "" -#. Si43s -#: statistics.xhp +#. eoQu3 +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "hd_id1000140\n" "help.text" msgid "Parameters" -msgstr "Parameter" +msgstr "" -#. 6LjdG -#: statistics.xhp +#. z4Wmd +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002530\n" "help.text" msgid "<emph>Interval</emph>: The number of samples used in the moving average calculation." -msgstr "<emph>Interval</emph>: Jumlah sampel yang digunakan dalam perhitungan rata-rata bergerak." +msgstr "" -#. CJRXM -#: statistics.xhp +#. ZTYni +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "hd_id1000171\n" "help.text" msgid "Results of the moving average:" -msgstr "Hasil dari rerata bergerak:" +msgstr "" -#. GNGxZ -#: statistics.xhp +#. GGAtW +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002540\n" "help.text" msgid "Column 1" -msgstr "Kolom" +msgstr "" -#. LRwyV -#: statistics.xhp +#. LDUuS +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002550\n" "help.text" msgid "Column 2" -msgstr "Kolom" +msgstr "" -#. T2NME -#: statistics.xhp +#. bJZmR +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002560\n" "help.text" msgid "#N/A" -msgstr "#N/A" +msgstr "" -#. yftCU -#: statistics.xhp +#. qn2Vi +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002570\n" "help.text" msgid "#N/A" -msgstr "#N/A" +msgstr "" -#. TEysC -#: statistics.xhp +#. bE5BK +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002800\n" "help.text" msgid "#N/A" -msgstr "#N/A" +msgstr "" -#. yrKbW -#: statistics.xhp +#. qTU2p +#: statistics_movingavg.xhp msgctxt "" -"statistics.xhp\n" +"statistics_movingavg.xhp\n" "par_id1002810\n" "help.text" msgid "#N/A" -msgstr "#N/A" - -#. CsQFD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"bm_id05001\n" -"help.text" -msgid "<bookmark_value>Analysis toolpack;t-test</bookmark_value><bookmark_value>Analysis toolpack;paired t-test</bookmark_value><bookmark_value>t-test;Analysis toolpack</bookmark_value><bookmark_value>paired t-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;paired t-test</bookmark_value>" -msgstr "<bookmark_value>Paket alat analisis;uji-t</bookmark_value><bookmark_value>Paket alat analisis;uji-t berpasangan</bookmark_value><bookmark_value>uji-t;Paket alat analisis</bookmark_value><bookmark_value>uji-t berpasangan;Paket alat analisis</bookmark_value><bookmark_value>Statistik data;uji-t berpasangan</bookmark_value>" - -#. SzpeD -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"hd_id1000150\n" -"help.text" -msgid "Paired t-test" -msgstr "Uji T Berpasangan" - -#. XwyAU -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1002820\n" -"help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the paired t-Test of two data samples.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Menghitung Uji-T berpasangan dari dua sampel data.</ahelp>" - -#. GGeBc -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1002830\n" -"help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Paired t-test</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih <emph>Data - Statistik - Uji-T Berpasangan</emph></variable>" +msgstr "" -#. Pa56H -#: statistics.xhp +#. 7EZAg +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002840\n" +"statistics_regression.xhp\n" +"tit\n" "help.text" -msgid "A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution." -msgstr "<emph> uji-t berpasangan</emph> adalah setiap uji hipotesis statistik yang mengikuti distribusi t milik siswa." +msgid "Regression Analysis" +msgstr "Analisis regresi" -#. UECyT -#: statistics.xhp +#. wDYsU +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002850\n" +"statistics_regression.xhp\n" +"bm_id2764278\n" "help.text" -msgid "For more information on paired t-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/T-test\" name=\"English Wikipedia: T-test\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang uji-t berpasangan, lihat <link href=\"https://en.wikipedia.org/wiki/T-test\" name=\"English Wikipedia: T-test\">artikel Wikipedia yang sesuai</link>." +msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value>" +msgstr "" -#. BDZik -#: statistics.xhp +#. UPKr7 +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000160\n" +"statistics_regression.xhp\n" +"hd_id1701201615033510\n" "help.text" -msgid "Data" -msgstr "Data" +msgid "<variable id=\"regressionanalysish1\"><link href=\"text/scalc/01/statistics_regression.xhp\" name=\"regression analysis\">Regression Analysis</link></variable>" +msgstr "" -#. gcjsZ -#: statistics.xhp +#. NFhSA +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002860\n" +"statistics_regression.xhp\n" +"par_id1001240\n" "help.text" -msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." -msgstr "<emph>Rentang 1 variabel</emph>: Referensi rentang seri data pertama yang dianalisis." +msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the regression analysis of a data set</ahelp>" +msgstr "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Menghasilkan analisis regresi dari pengaturan data</ahelp>" -#. YWrFc -#: statistics.xhp +#. ENJtD +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002870\n" +"statistics_regression.xhp\n" +"par_id1000040\n" "help.text" -msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." -msgstr "<emph>Rentang 2 Variabel</emph>: Referensi rentang seri data kedua untuk dianalisis." +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Regression</menuitem></variable>" +msgstr "" -#. JFPu9 -#: statistics.xhp +#. zADGk +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002880\n" +"statistics_regression.xhp\n" +"par_id1001270\n" "help.text" -msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." -msgstr "<emph>Hasil untuk</emph>: Referensi sel kiri atas kisaran tempat pengujian akan ditampilkan." +msgid "For more information on regression analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">corresponding Wikipedia article</link>." +msgstr "Untuk informasi lebih lanjut tentang analisis regresi, lihat tautan <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">artikel Wikipedia yang sesuai</link>." -#. vWS92 -#: statistics.xhp +#. rdATw +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000170\n" +"statistics_regression.xhp\n" +"hd_id1000070\n" "help.text" -msgid "Results for paired t-test:" -msgstr "Hasil dari uji t berpasangan:" +msgid "Output Regression Type" +msgstr "Jenis Regresi Keluaran" -#. L9Vxq -#: statistics.xhp +#. QMDBG +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002890\n" +"statistics_regression.xhp\n" +"par_id1001280\n" "help.text" -msgid "The following table shows the <emph>paired t-test</emph> for the data series above:" -msgstr "Tabel berikut menunjukkan <emph>uji-t berpasangan</emph> untuk seri data di atas:" +msgid "Set the regression type. Three types are available:" +msgstr "Setel jenis regresi. Tiga jenis tersedia:" -#. KvDmj -#: statistics.xhp +#. 7Avaz +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002900\n" +"statistics_regression.xhp\n" +"par_id1701201620334364\n" "help.text" -msgid "paired t-test" -msgstr "uji t berpasangan" +msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data." +msgstr "<emph> Regresi Lini </emph>: cari garis lurus dalam bentuk <item type=\"literal\"> y = ax + b </item>, di mana <item type=\"literal\"> a </item> adalah slope dan <item type=\"literal\"> b </item> adalah intersep yang paling sesuai dengan data." -#. T9BFU -#: statistics.xhp +#. B6dex +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002910\n" +"statistics_regression.xhp\n" +"par_id1701201620340168\n" "help.text" -msgid "Alpha" -msgstr "Alfa" +msgid "<emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type=\"literal\">y = a.ln(x) + b</item>, where <item type=\"literal\">a</item> is the slope, <item type=\"literal\">b</item> is the intercept and <item type=\"literal\">ln(x)</item> is the natural logarithm of <item type=\"literal\">x</item>, that best fits the data." +msgstr "<emph> Regresi logaritmik </emph>: temukan kurva logaritmik dalam bentuk <item type=\"literal\"> y = a.ln (x) + b </item>, di mana <item type=\"literal\"> a </item> adalah kemiringan, <item type=\"literal\"> b </item> adalah intersep dan <item type=\"literal\"> ln (x) </item> adalah logaritma natural dari <item type=\"literal\"> x </item>, yang paling cocok dengan data." -#. LAnve -#: statistics.xhp +#. txgoZ +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002930\n" +"statistics_regression.xhp\n" +"par_id1701201620340139\n" "help.text" -msgid "Hypothesized Mean Difference" -msgstr "Perbedaan Rerata Terhipotesakan" +msgid "<emph>Power regression</emph>: Find a power curve in the form of <item type=\"literal\">y = a.x^b</item>, where <item type=\"literal\">a</item> is the coefficient, <item type=\"literal\">b</item> is the power that best fits the data." +msgstr "<emph>Regresi pangkat</emph>: Temukan kurva pangkat dalam bentuk <item type=\"literal\">y = a.x^b</item>, dimana <item type=\"literal\">a</item> adalah koefisien, <item type=\"literal\">b</item> adalah pangkat yang paling cocok dengan data." -#. 6fWZ5 -#: statistics.xhp +#. EtPbr +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002950\n" +"statistics_regression.xhp\n" +"par_id1001310\n" "help.text" -msgid "Variable 1" -msgstr "Variabel 1" +msgid "The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below." +msgstr "Hasil dari tiga jenis<emph>analisis regresi</emph>pengukuran pada tabel di atas ditunjukkan di bawah ini." -#. EJLqE -#: statistics.xhp +#. iJ7yf +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002960\n" +"statistics_regression.xhp\n" +"par_id1701201618090526\n" "help.text" -msgid "Variable 2" -msgstr "Variabel 2" +msgid "Regression" +msgstr "Regresi" -#. MPnR3 -#: statistics.xhp +#. cSAoU +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1002970\n" +"statistics_regression.xhp\n" +"par_id1701201618090542\n" "help.text" -msgid "Mean" -msgstr "Rerata (mean)" +msgid "Regression Model" +msgstr "Model Regresi" -#. xmB6Y -#: statistics.xhp +#. YAGFi +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003000\n" +"statistics_regression.xhp\n" +"par_id1701201618090596\n" "help.text" -msgid "Variance" -msgstr "Varian" +msgid "Linear" +msgstr "Linear" -#. j5EJE -#: statistics.xhp +#. 2zcqS +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003030\n" +"statistics_regression.xhp\n" +"par_id1701201618090586\n" "help.text" -msgid "Observations" -msgstr "Observasi" +msgid "Logarithmic" +msgstr "Logaritmik" -#. TqdAS -#: statistics.xhp +#. QvaFq +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003060\n" +"statistics_regression.xhp\n" +"par_id1701201618090555\n" "help.text" -msgid "Pearson Correlation" -msgstr "Korelasi Pearson" +msgid "Power" +msgstr "Pangkat" -#. KRXGK -#: statistics.xhp +#. oHBnC +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003080\n" +"statistics_regression.xhp\n" +"par_id1701201618090553\n" "help.text" -msgid "Observed Mean Difference" -msgstr "Perbedaan Rerata Teramati" +msgid "R^2" +msgstr "R^2" -#. XqdB7 -#: statistics.xhp +#. egmFM +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003100\n" +"statistics_regression.xhp\n" +"par_id1701201618090595\n" "help.text" -msgid "Variance of the Differences" -msgstr "Variansi Perbedaan" +msgid "Standard Error" +msgstr "Kesalahan Standar" -#. LvHvG -#: statistics.xhp +#. woESA +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003120\n" +"statistics_regression.xhp\n" +"par_id1701201618090563\n" "help.text" -msgid "df" -msgstr "df" +msgid "Slope" +msgstr "Lereng" -#. fCMcg -#: statistics.xhp +#. qfNCA +#: statistics_regression.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003140\n" +"statistics_regression.xhp\n" +"par_id1701201618090642\n" "help.text" -msgid "t Stat" -msgstr "t Stat" +msgid "Intercept" +msgstr "Perpotongan" -#. LAg7e -#: statistics.xhp +#. u47eB +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003160\n" +"statistics_sampling.xhp\n" +"tit\n" "help.text" -msgid "P (T<=t) one-tail" -msgstr "P (T<=t) ekor satu" +msgid "Data Sampling in Calc" +msgstr "" -#. vqE6u -#: statistics.xhp +#. LSf66 +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003180\n" +"statistics_sampling.xhp\n" +"bm_id2764278\n" "help.text" -msgid "t Critical one-tail" -msgstr "t Kritis ekor satu" +msgid "<bookmark_value>Analysis toolpack;sampling</bookmark_value><bookmark_value>sampling;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;sampling</bookmark_value>" +msgstr "" -#. g2gAd -#: statistics.xhp +#. 4SPkL +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003200\n" +"statistics_sampling.xhp\n" +"hd_id1000020\n" "help.text" -msgid "P (T<=t) two-tail" -msgstr "P (T<=t) ekor dua" +msgid "<variable id=\"datasamplingh1\"><link href=\"text/scalc/01/statistics_sampling.xhp\" name=\"Sampling\">Sampling</link></variable>" +msgstr "" -#. 9dv9Z -#: statistics.xhp +#. 9XjLD +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003220\n" +"statistics_sampling.xhp\n" +"par_id1000030\n" "help.text" -msgid "t Critical two-tail" -msgstr "t Kritis ekor dua" +msgid "<ahelp hid=\"modules/scalc/ui/samplingdialog/SamplingDialog\">Create a table with data sampled from another table.</ahelp>" +msgstr "" -#. oA65G -#: statistics.xhp +#. vM6cz +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"bm_id05002\n" +"statistics_sampling.xhp\n" +"par_id1000040\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;F-test</bookmark_value><bookmark_value>F-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;F-test</bookmark_value>" -msgstr "<bookmark_value>Alat analisis;uji-F</bookmark_value><bookmark_value>Uji-F;Alat Analisis</bookmark_value><bookmark_value>Data statistik;Uji-F</bookmark_value>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Sampling</menuitem></variable>" +msgstr "" -#. ehPwx -#: statistics.xhp +#. MDjEn +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000180\n" +"statistics_sampling.xhp\n" +"par_id1000050\n" "help.text" -msgid "F-test" -msgstr "Uji-F" +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 "" -#. brHw9 -#: statistics.xhp +#. GRbRi +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003240\n" +"statistics_sampling.xhp\n" +"par_id1000060\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the F-Test of two data samples.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Menghitung Uji-F dari dua sampel data.</ahelp>" +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 "" -#. pbkFE -#: statistics.xhp +#. DmJMr +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003250\n" +"statistics_sampling.xhp\n" +"hd_id1000030\n" "help.text" -msgid "<variable id=\"sam02\">Choose <emph>Data - Statistics - F-test</emph></variable>" -msgstr "<variable id=\"sam02\">Pilih <emph>Data - Statistik - Uji-F</emph></variable>" +msgid "Sampling Method" +msgstr "" -#. Wjkbb -#: statistics.xhp +#. zDwkD +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003260\n" +"statistics_sampling.xhp\n" +"par_id1000070\n" "help.text" -msgid "A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis." -msgstr "<emph> Uji-F </emph> adalah setiap uji statistik berdasarkan pada distribusi-F di bawah hipotesis nol." +msgid "<emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way." +msgstr "" -#. o8Ex8 -#: statistics.xhp +#. AAvrF +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003270\n" +"statistics_sampling.xhp\n" +"par_id1000080\n" "help.text" -msgid "For more information on F-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/F-test\" name=\"English Wikipedia: F-test\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang uji-F, lihat <link href=\"https://en.wikipedia.org/wiki/F-test\" name=\"English Wikipedia: F-test\">artikel Wikipedia yang sesuai</link>." +msgid "<emph>Sample size</emph>: Number of lines sampled from the source table." +msgstr "" -#. NwkkV -#: statistics.xhp +#. hy48Z +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000190\n" +"statistics_sampling.xhp\n" +"par_id1000090\n" "help.text" -msgid "Data" -msgstr "Data" +msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>." +msgstr "" -#. 8yUF7 -#: statistics.xhp +#. i8TDF +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003280\n" +"statistics_sampling.xhp\n" +"par_id1000100\n" "help.text" -msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." -msgstr "<emph>Rentang 1 variabel</emph>: Referensi rentang seri data pertama yang dianalisis." +msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling." +msgstr "" -#. ZRSwx -#: statistics.xhp +#. NjytZ +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003290\n" +"statistics_sampling.xhp\n" +"par_id1000110\n" "help.text" -msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." -msgstr "<emph>Rentang 2 Variabel</emph>: Referensi rentang seri data kedua untuk dianalisis." +msgid "The following data will be used as example of source data table for sampling:" +msgstr "" -#. iGCgj -#: statistics.xhp +#. VR7DD +#: statistics_sampling.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003300\n" +"statistics_sampling.xhp\n" +"par_id1000510\n" "help.text" -msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." -msgstr "<emph>Hasil untuk</emph>: Referensi sel kiri atas kisaran tempat pengujian akan ditampilkan." +msgid "Sampling with a period of 2 will result in the following table:" +msgstr "" -#. BS5E6 -#: statistics.xhp +#. 7UA8A +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000200\n" +"statistics_test_chisqr.xhp\n" +"tit\n" "help.text" -msgid "Results for F-Test:" -msgstr "Hasil dari Tes F:" +msgid "Chi Square Statistics in Calc" +msgstr "" -#. fDAwv -#: statistics.xhp +#. hAnmA +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003310\n" +"statistics_test_chisqr.xhp\n" +"bm_id05004\n" "help.text" -msgid "The following table shows the <emph>F-Test</emph> for the data series above:" -msgstr "Tabel berikut menunjukkan <emph>Tes-F</emph> untuk seri data di atas:" +msgid "<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value><bookmark_value>Chi-square test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Chi-square test</bookmark_value>" +msgstr "" -#. FTLNF -#: statistics.xhp +#. ECMEg +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003320\n" +"statistics_test_chisqr.xhp\n" +"hd_id1000240\n" "help.text" -msgid "Ftest" -msgstr "Tes F" +msgid "<variable id=\"chisqtesth1\"><link href=\"text/scalc/01/statistics_test_chisqr.xhp\" name=\"Chi-square test\">Chi-square test</link></variable>" +msgstr "" -#. 5abPE -#: statistics.xhp +#. u5MGV +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003330\n" +"statistics_test_chisqr.xhp\n" +"par_id1003641\n" "help.text" -msgid "Alpha" -msgstr "Alfa" +msgid "<ahelp hid=\"modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog\">Calculates the Chi-square test of a data sample.</ahelp>" +msgstr "" -#. PC3Js -#: statistics.xhp +#. pdD2p +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003350\n" +"statistics_test_chisqr.xhp\n" +"par_id1003990\n" "help.text" -msgid "Variable 1" -msgstr "Variabel 1" +msgid "<variable id=\"sam02\">Choose <menuitem>Data - Statistics - Chi-square Test</menuitem></variable>" +msgstr "" -#. Fxv9b -#: statistics.xhp +#. V4PzH +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003360\n" +"statistics_test_chisqr.xhp\n" +"par_id1004000\n" "help.text" -msgid "Variable 2" -msgstr "Variabel 2" +msgid "For more information on chi-square tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Chi-square_test\" name=\"English Wikipedia: Chi-square_test\">corresponding Wikipedia article</link>." +msgstr "" -#. igFPM -#: statistics.xhp +#. 46RmG +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003370\n" +"statistics_test_chisqr.xhp\n" +"hd_id1000231\n" "help.text" -msgid "Mean" -msgstr "Rerata (mean)" +msgid "Results for Chi-square Test:" +msgstr "" -#. P7Dte -#: statistics.xhp +#. QHuAe +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003400\n" +"statistics_test_chisqr.xhp\n" +"par_id1004030\n" "help.text" -msgid "Variance" -msgstr "Varian" +msgid "Test of Independence (Chi-Square)" +msgstr "" -#. DDEUW -#: statistics.xhp +#. BzGNg +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003430\n" +"statistics_test_chisqr.xhp\n" +"par_id1004040\n" "help.text" -msgid "Observations" -msgstr "Observasi" +msgid "Alpha" +msgstr "" -#. GCVd2 -#: statistics.xhp +#. CRP8j +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003460\n" +"statistics_test_chisqr.xhp\n" +"par_id1004060\n" "help.text" msgid "df" -msgstr "df" - -#. e3MnX -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1003490\n" -"help.text" -msgid "F" -msgstr "F" - -#. 9iAny -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1003510\n" -"help.text" -msgid "P (F<=f) right-tail" -msgstr "P (F<=f) ekor kanan" +msgstr "" -#. Ew7mY -#: statistics.xhp +#. rcX5Y +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003530\n" +"statistics_test_chisqr.xhp\n" +"par_id1004080\n" "help.text" -msgid "F Critical right-tail" -msgstr "F Kritis ekor kanan" +msgid "P-value" +msgstr "" -#. 6CajG -#: statistics.xhp +#. oF79y +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003550\n" +"statistics_test_chisqr.xhp\n" +"par_id1004100\n" "help.text" -msgid "P (F<=f) left-tail" -msgstr "P (F<=f) ekor kiri" +msgid "Test Statistic" +msgstr "" -#. CTNrD -#: statistics.xhp +#. ykGTD +#: statistics_test_chisqr.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003570\n" +"statistics_test_chisqr.xhp\n" +"par_id1004120\n" "help.text" -msgid "F Critical left-tail" -msgstr "F Kritis ekor kiri" +msgid "Critical Value" +msgstr "" -#. dPGJc -#: statistics.xhp +#. SeEHX +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003590\n" +"statistics_test_f.xhp\n" +"tit\n" "help.text" -msgid "P two-tail" -msgstr "P ekor dua" +msgid "F Test Statistics in Calc" +msgstr "" -#. c7cBK -#: statistics.xhp +#. bWFPL +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003610\n" +"statistics_test_f.xhp\n" +"bm_id05002\n" "help.text" -msgid "F Critical two-tail" -msgstr "F Kritis ekor dua" +msgid "<bookmark_value>Analysis toolpack;F-test</bookmark_value><bookmark_value>F-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;F-test</bookmark_value>" +msgstr "" -#. DJhea -#: statistics.xhp +#. gZWPc +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"bm_id05003\n" +"statistics_test_f.xhp\n" +"hd_id1000180\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;Z-test</bookmark_value><bookmark_value>Z-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Z-test</bookmark_value>" -msgstr "<bookmark_value>Alat analisis, Tes-Z</bookmark_value><bookmark_value>Tes-Z; Analisis toolpak</bookmark_value><bookmark_value>Data statistik, Tes-Z</bookmark_value>" +msgid "<variable id=\"ftesth1\"><link href=\"text/scalc/01/statistics_test_f.xhp\" name=\"F-test\">F-test</link></variable>" +msgstr "" -#. mP5zB -#: statistics.xhp +#. qHRjW +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000210\n" +"statistics_test_f.xhp\n" +"par_id1003240\n" "help.text" -msgid "Z-test" -msgstr "Tes-Z" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the F-Test of two data samples.</ahelp>" +msgstr "" -#. VdKxp -#: statistics.xhp +#. ARt6p +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003640\n" +"statistics_test_f.xhp\n" +"par_id1003250\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/ztestdialog/ZTestDialog\">Calculates the z-Test of two data samples.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/ztestdialog/ZTestDialog\">Menghitung Tes-z dari dua sampel data.</ahelp>" +msgid "<variable id=\"sam02\">Choose <menuitem>Data - Statistics - F-test</menuitem></variable>" +msgstr "" -#. FpaeZ -#: statistics.xhp +#. FxKGF +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003650\n" +"statistics_test_f.xhp\n" +"par_id1003260\n" "help.text" -msgid "<variable id=\"sam02\">Choose <emph>Data - Statistics - Z-test</emph></variable>" -msgstr "<variable id=\"sam02\">Pilih <emph>Data - Statistik - Tes-Z</emph></variable>" +msgid "A <emph>F-test</emph> is any statistical test based on the F-distribution under the null hypothesis." +msgstr "" -#. G2Df9 -#: statistics.xhp +#. EGFSG +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003660\n" +"statistics_test_f.xhp\n" +"par_id1003270\n" "help.text" -msgid "For more information on Z-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Z-test\" name=\"English Wikipedia: Z-test\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang tes-Z, lihat <link href=\"https://en.wikipedia.org/wiki/Z-test\" name=\"English Wikipedia: Z-test\">artikel Wikipedia yang sesuai</link>." +msgid "For more information on F-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/F-test\" name=\"English Wikipedia: F-test\">corresponding Wikipedia article</link>." +msgstr "" -#. BcMk3 -#: statistics.xhp +#. GxHaD +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000220\n" +"statistics_test_f.xhp\n" +"hd_id1000190\n" "help.text" msgid "Data" -msgstr "Data" +msgstr "" -#. z9aEs -#: statistics.xhp +#. jtjaQ +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003670\n" +"statistics_test_f.xhp\n" +"par_id1003280\n" "help.text" msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." -msgstr "<emph>Rentang 1 variabel</emph>: Referensi rentang seri data pertama yang dianalisis." +msgstr "" -#. hAxVY -#: statistics.xhp +#. qzYBv +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003680\n" +"statistics_test_f.xhp\n" +"par_id1003290\n" "help.text" msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." -msgstr "<emph>Rentang 2 Variabel</emph>: Referensi rentang seri data kedua untuk dianalisis." +msgstr "" -#. e8JtG -#: statistics.xhp +#. MvvMT +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003690\n" +"statistics_test_f.xhp\n" +"par_id1003300\n" "help.text" msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." -msgstr "<emph>Hasil untuk</emph>: Referensi sel kiri atas kisaran tempat pengujian akan ditampilkan." +msgstr "" -#. R6V7y -#: statistics.xhp +#. Greqo +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000230\n" +"statistics_test_f.xhp\n" +"hd_id1000200\n" "help.text" -msgid "Results for z-Test:" -msgstr "Hasil dari Tes z:" +msgid "Results for F-Test:" +msgstr "" -#. D8FiS -#: statistics.xhp +#. XqyMa +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003700\n" +"statistics_test_f.xhp\n" +"par_id1003310\n" "help.text" -msgid "The following table shows the <emph>z-Test</emph> for the data series above:" -msgstr "Tabel berikut menunjukkan <emph>Uji-z</emph> untuk seri data di atas:" +msgid "The following table shows the <emph>F-Test</emph> for the data series above:" +msgstr "" -#. C8bSD -#: statistics.xhp +#. git3T +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003710\n" +"statistics_test_f.xhp\n" +"par_id1003320\n" "help.text" -msgid "z-test" -msgstr "Tes-z" +msgid "Ftest" +msgstr "" -#. MLZyG -#: statistics.xhp +#. WsA4s +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003720\n" +"statistics_test_f.xhp\n" +"par_id1003330\n" "help.text" msgid "Alpha" -msgstr "Alfa" - -#. uaG8z -#: statistics.xhp -msgctxt "" -"statistics.xhp\n" -"par_id1003740\n" -"help.text" -msgid "Hypothesized Mean Difference" -msgstr "Perbedaan Rerata Terhipotesakan" +msgstr "" -#. z8C94 -#: statistics.xhp +#. xj9Se +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003760\n" +"statistics_test_f.xhp\n" +"par_id1003350\n" "help.text" msgid "Variable 1" -msgstr "Variabel 1" +msgstr "" -#. d8qiE -#: statistics.xhp +#. p5piv +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003770\n" +"statistics_test_f.xhp\n" +"par_id1003360\n" "help.text" msgid "Variable 2" -msgstr "Variabel 2" +msgstr "" -#. Jj28P -#: statistics.xhp +#. YA2dy +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003780\n" +"statistics_test_f.xhp\n" +"par_id1003370\n" "help.text" -msgid "Known Variance" -msgstr "Variansi Yang Diketahui" +msgid "Mean" +msgstr "" -#. mCBCo -#: statistics.xhp +#. 8MXro +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003810\n" +"statistics_test_f.xhp\n" +"par_id1003400\n" "help.text" -msgid "Mean" -msgstr "Rerata (mean)" +msgid "Variance" +msgstr "" -#. AuNuX -#: statistics.xhp +#. W2J6x +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003840\n" +"statistics_test_f.xhp\n" +"par_id1003430\n" "help.text" msgid "Observations" -msgstr "Observasi" +msgstr "" -#. 9Kte4 -#: statistics.xhp +#. DqgMQ +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003870\n" +"statistics_test_f.xhp\n" +"par_id1003460\n" "help.text" -msgid "Observed Mean Difference" -msgstr "Perbedaan Rerata Teramati" +msgid "df" +msgstr "" -#. WXPWw -#: statistics.xhp +#. BJ3Vi +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003890\n" +"statistics_test_f.xhp\n" +"par_id1003490\n" "help.text" -msgid "z" -msgstr "z" +msgid "F" +msgstr "" -#. NYjYx -#: statistics.xhp +#. AasLh +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003900\n" +"statistics_test_f.xhp\n" +"par_id1003510\n" "help.text" -msgid "#DIV/0!" -msgstr "#DIV/0!" +msgid "P (F<=f) right-tail" +msgstr "" -#. etDij -#: statistics.xhp +#. FVAJa +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003910\n" +"statistics_test_f.xhp\n" +"par_id1003530\n" "help.text" -msgid "P (Z<=z) one-tail" -msgstr "P (Z<=z) ekor satu" +msgid "F Critical right-tail" +msgstr "" -#. HDtBQ -#: statistics.xhp +#. zBzCY +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003920\n" +"statistics_test_f.xhp\n" +"par_id1003550\n" "help.text" -msgid "#DIV/0!" -msgstr "#DIV/0!" +msgid "P (F<=f) left-tail" +msgstr "" -#. keob4 -#: statistics.xhp +#. LA56M +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003930\n" +"statistics_test_f.xhp\n" +"par_id1003570\n" "help.text" -msgid "z Critical one-tail" -msgstr "z Kritis ekor satu" +msgid "F Critical left-tail" +msgstr "" -#. KzE5V -#: statistics.xhp +#. 9ZNSy +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003950\n" +"statistics_test_f.xhp\n" +"par_id1003590\n" "help.text" -msgid "P (Z<=z) two-tail" -msgstr "P (Z<=z) ekor dua" +msgid "P two-tail" +msgstr "" -#. TsDyQ -#: statistics.xhp +#. dQ4WA +#: statistics_test_f.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003960\n" +"statistics_test_f.xhp\n" +"par_id1003610\n" "help.text" -msgid "#DIV/0!" -msgstr "#DIV/0!" +msgid "F Critical two-tail" +msgstr "" -#. huD6B -#: statistics.xhp +#. jMBzo +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003970\n" +"statistics_test_t.xhp\n" +"tit\n" "help.text" -msgid "z Critical two-tail" -msgstr "z Kritis ekor dua" +msgid "T Test Statistics in Calc" +msgstr "" -#. C98ER -#: statistics.xhp +#. cKb9k +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"bm_id05004\n" +"statistics_test_t.xhp\n" +"bm_id05001\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;Chi-square test</bookmark_value><bookmark_value>Chi-square test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Chi-square test</bookmark_value>" -msgstr "<bookmark_value>Alat analisis; Uji Chi-square</bookmark_value><bookmark_value>Uji Chi-square; Alat analisis</bookmark_value><bookmark_value>Statistik data, uji Chi-square</bookmark_value>" +msgid "<bookmark_value>Analysis toolpack;t-test</bookmark_value><bookmark_value>Analysis toolpack;paired t-test</bookmark_value><bookmark_value>t-test;Analysis toolpack</bookmark_value><bookmark_value>paired t-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;paired t-test</bookmark_value>" +msgstr "" -#. hBHDK -#: statistics.xhp +#. QWgi3 +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000240\n" +"statistics_test_t.xhp\n" +"hd_id1000150\n" "help.text" -msgid "Chi-square test" -msgstr "Tes chi-square" +msgid "<variable id=\"ttesth1\"><link href=\"text/scalc/01/statistics_test_t.xhp\" name=\"Paired t-test\">Paired t-test</link></variable>" +msgstr "" -#. uJFGU -#: statistics.xhp +#. TXtGV +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003641\n" +"statistics_test_t.xhp\n" +"par_id1002820\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog\">Calculates the Chi-square test of a data sample.</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/chisquaretestdialog/ChiSquareTestDialog\">Menghitung uji Chi-square dari sampel data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/ttestdialog/TTestDialog\">Calculates the paired t-Test of two data samples.</ahelp>" +msgstr "" -#. mkjok -#: statistics.xhp +#. EVZDy +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1003990\n" +"statistics_test_t.xhp\n" +"par_id1002830\n" "help.text" -msgid "<variable id=\"sam02\">Choose <emph>Data - Statistics - Chi-square Test</emph></variable>" -msgstr "<variable id=\"sam02\">Pilih<emph>Data - Statistik - Uji Chi-square </emph> </variable>" +msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Paired t-test</menuitem></variable>" +msgstr "" -#. AMY4A -#: statistics.xhp +#. 3ngCe +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004000\n" +"statistics_test_t.xhp\n" +"par_id1002840\n" "help.text" -msgid "For more information on chi-square tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Chi-square_test\" name=\"English Wikipedia: Chi-square_test\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang tes chi-square, lihat <link href=\"https://en.wikipedia.org/wiki/Chi-square_test\" name=\"English Wikipedia: Chi-square_test\">artikel Wikipedia yang sesuai</link>." +msgid "A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution." +msgstr "" -#. FYnfb -#: statistics.xhp +#. NE5Ro +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"hd_id1000231\n" +"statistics_test_t.xhp\n" +"par_id1002850\n" "help.text" -msgid "Results for Chi-square Test:" -msgstr "Hasil untuk Uji Chi-square:" +msgid "For more information on paired t-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/T-test\" name=\"English Wikipedia: T-test\">corresponding Wikipedia article</link>." +msgstr "" -#. iRDRE -#: statistics.xhp +#. BEkGF +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004030\n" +"statistics_test_t.xhp\n" +"hd_id1000160\n" "help.text" -msgid "Test of Independence (Chi-Square)" -msgstr "Uji Independensi (Chi-Square)" +msgid "Data" +msgstr "" -#. he69g -#: statistics.xhp +#. aU9k6 +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004040\n" +"statistics_test_t.xhp\n" +"par_id1002860\n" "help.text" -msgid "Alpha" -msgstr "Alfa" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." +msgstr "" -#. LuZZQ -#: statistics.xhp +#. 27zQ4 +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004060\n" +"statistics_test_t.xhp\n" +"par_id1002870\n" "help.text" -msgid "df" -msgstr "df" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgstr "" -#. AC5p4 -#: statistics.xhp +#. 8D2Gp +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004080\n" +"statistics_test_t.xhp\n" +"par_id1002880\n" "help.text" -msgid "P-value" -msgstr "Nilai-P" +msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." +msgstr "" -#. B9dja -#: statistics.xhp +#. KcmaB +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004100\n" +"statistics_test_t.xhp\n" +"hd_id1000170\n" "help.text" -msgid "Test Statistic" -msgstr "Statistik Uji" +msgid "Results for paired t-test:" +msgstr "" -#. MnuJ5 -#: statistics.xhp +#. egFAr +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004120\n" +"statistics_test_t.xhp\n" +"par_id1002890\n" "help.text" -msgid "Critical Value" -msgstr "Nilai Kritis" +msgid "The following table shows the <emph>paired t-test</emph> for the data series above:" +msgstr "" -#. fZBAh -#: statistics.xhp +#. rDVBE +#: statistics_test_t.xhp msgctxt "" -"statistics.xhp\n" -"par_id1004140\n" +"statistics_test_t.xhp\n" +"par_id1002900\n" "help.text" -msgid "<link href=\"text/scalc/01/statistics_regression.xhp#regressionanalysis\">Regression Analysis</link>" -msgstr "<link href=\"text/scalc/01/statistics_regression.xhp#regressionanalysis\">Analisis regresi</link>" +msgid "paired t-test" +msgstr "" -#. AXaMM -#: statistics_fourier.xhp +#. pFrdF +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"tit\n" +"statistics_test_t.xhp\n" +"par_id1002910\n" "help.text" -msgid "Fourier Analysis" +msgid "Alpha" msgstr "" -#. EV56D -#: statistics_fourier.xhp +#. da77D +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"hd_id431561808831965\n" +"statistics_test_t.xhp\n" +"par_id1002930\n" "help.text" -msgid "<variable id=\"fourieranalysysh1\"><link href=\"text/scalc/01/statistics_fourier.xhp\" name=\"Fourier analysis\">Fourier Analysis</link></variable>" +msgid "Hypothesized Mean Difference" msgstr "" -#. EEBRe -#: statistics_fourier.xhp +#. tJarn +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id1001240\n" +"statistics_test_t.xhp\n" +"par_id1002950\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp>" +msgid "Variable 1" msgstr "" -#. F2ncB -#: statistics_fourier.xhp +#. kfGaW +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"bm_id2764278\n" +"statistics_test_t.xhp\n" +"par_id1002960\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;Fourier analysis</bookmark_value><bookmark_value>Fourier analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Fourier analysis</bookmark_value>" +msgid "Variable 2" msgstr "" -#. se49E -#: statistics_fourier.xhp +#. ttThs +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id1000040\n" +"statistics_test_t.xhp\n" +"par_id1002970\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Fourier Analysis</emph></variable>" +msgid "Mean" msgstr "" -#. HpuG9 -#: statistics_fourier.xhp +#. G7NDq +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id1001270\n" +"statistics_test_t.xhp\n" +"par_id1003000\n" "help.text" -msgid "For more information on Fourier analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Fourier_analysis\" name=\"English Wikipedia: Fourier analysis\">corresponding Wikipedia article</link>." +msgid "Variance" msgstr "" -#. VArYS -#: statistics_fourier.xhp +#. AsmDu +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id301561811172762\n" +"statistics_test_t.xhp\n" +"par_id1003030\n" "help.text" -msgid "<emph>Input range has label</emph>: Mark when the first row or column of the input array is actually a label and not part of the data analysis." +msgid "Observations" msgstr "" -#. Gi5kk -#: statistics_fourier.xhp +#. MmDD2 +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id741556228390897\n" +"statistics_test_t.xhp\n" +"par_id1003060\n" "help.text" -msgid "Input Range is a 2 x N or N x 2 range representing an array of complex number to be transformed, where N is the length of the array. The array represents the real and imaginary parts of the data." +msgid "Pearson Correlation" msgstr "" -#. GqXZr -#: statistics_fourier.xhp +#. Nqq8i +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"hd_id211561811324208\n" +"statistics_test_t.xhp\n" +"par_id1003080\n" "help.text" -msgid "Options:" +msgid "Observed Mean Difference" msgstr "" -#. 68RRB -#: statistics_fourier.xhp +#. vDgsc +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id631556228516997\n" +"statistics_test_t.xhp\n" +"par_id1003100\n" "help.text" -msgid "<emph>Inverse</emph>: When checked, calculates the inverse Discrete Fourier Transform." +msgid "Variance of the Differences" msgstr "" -#. MH9kg -#: statistics_fourier.xhp +#. CFBrp +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id811561732287508\n" +"statistics_test_t.xhp\n" +"par_id1003120\n" "help.text" -msgid "<emph>Polar</emph>: When checked, the results are in polar coordinates (magnitude, phase)." +msgid "df" msgstr "" -#. peNbe -#: statistics_fourier.xhp +#. mAixM +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id661561732521977\n" +"statistics_test_t.xhp\n" +"par_id1003140\n" "help.text" -msgid "<emph>Minimum magnitude for polar form output (in dB)</emph>: used only when output is in polar form. All frequency components with magnitude less than this value in decibels will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed." +msgid "t Stat" msgstr "" -#. 8pLcW -#: statistics_fourier.xhp +#. utcA9 +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id731561827207828\n" +"statistics_test_t.xhp\n" +"par_id1003160\n" "help.text" -msgid "The source data for this example is the same of the <link href=\"text/scalc/01/func_fourier.xhp\" name=\"Fourier function\">FOURIER function page</link>." +msgid "P (T<=t) one-tail" msgstr "" -#. 4XJPB -#: statistics_fourier.xhp +#. 7mezL +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257279817\n" +"statistics_test_t.xhp\n" +"par_id1003180\n" "help.text" -msgid "Fourier Transform" +msgid "t Critical one-tail" msgstr "" -#. nfhVE -#: statistics_fourier.xhp +#. GdcRG +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id29062019125727379\n" +"statistics_test_t.xhp\n" +"par_id1003200\n" "help.text" -msgid "Fourier Transform" +msgid "P (T<=t) two-tail" msgstr "" -#. G6aEG -#: statistics_fourier.xhp +#. kh5E7 +#: statistics_test_t.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257276510\n" +"statistics_test_t.xhp\n" +"par_id1003220\n" "help.text" -msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgid "t Critical two-tail" msgstr "" -#. 5L22z -#: statistics_fourier.xhp +#. QA9fL +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257273433\n" +"statistics_test_z.xhp\n" +"tit\n" "help.text" -msgid "<emph>Input data range : $B$6:$C$40</emph>" +msgid "Z Test Statistics in Calc" msgstr "" -#. Vyu9a -#: statistics_fourier.xhp +#. EQw7L +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257273688\n" +"statistics_test_z.xhp\n" +"bm_id05003\n" "help.text" -msgid "<emph>Real</emph>" +msgid "<bookmark_value>Analysis toolpack;Z-test</bookmark_value><bookmark_value>Z-test;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;Z-test</bookmark_value>" msgstr "" -#. qEshW -#: statistics_fourier.xhp +#. XEQkC +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id290620191257276202\n" +"statistics_test_z.xhp\n" +"hd_id1000210\n" "help.text" -msgid "<emph>Imaginary</emph>" +msgid "<variable id=\"ztesth1\"><link href=\"text/scalc/01/statistics_test_z.xhp\" name=\"Z-test\">Z-test</link></variable>" msgstr "" -#. fJ6BG -#: statistics_fourier.xhp +#. vjPXp +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id481561825547527\n" +"statistics_test_z.xhp\n" +"par_id1003640\n" "help.text" -msgid "<emph>Magnitude</emph>" +msgid "<ahelp hid=\"modules/scalc/ui/ztestdialog/ZTestDialog\">Calculates the z-Test of two data samples.</ahelp>" msgstr "" -#. XcXJz -#: statistics_fourier.xhp +#. FeUKV +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id751561825556834\n" +"statistics_test_z.xhp\n" +"par_id1003650\n" "help.text" -msgid "<emph>Phase</emph>" +msgid "<variable id=\"sam02\">Choose <menuitem>Data - Statistics - Z-test</menuitem></variable>" msgstr "" -#. 7f8Bq -#: statistics_fourier.xhp +#. DrfAa +#: statistics_test_z.xhp msgctxt "" -"statistics_fourier.xhp\n" -"par_id14337286612130\n" +"statistics_test_z.xhp\n" +"par_id1003660\n" "help.text" -msgid "<link href=\"text/scalc/01/statistics.xhp#datasampling\">Sampling</link>, <link href=\"text/scalc/01/statistics.xhp#descriptivestatistics\">Descriptive Statistics</link>, <link href=\"text/scalc/01/statistics.xhp#anova\">Analysis of Variance (ANOVA)</link>, <link href=\"text/scalc/01/statistics.xhp#correlation\">Correlation</link>, <link href=\"text/scalc/01/statistics.xhp#covariance\">Covariance</link>, <link href=\"text/scalc/01/statistics.xhp#exponentialsmoothing\">Exponential Smoothing</link>, <link href=\"text/scalc/01/statistics.xhp#movingaverage\">Moving Average</link>, <link href=\"text/scalc/01/statistics.xhp#ttest\">Paired t-test</link>, <link href=\"text/scalc/01/statistics.xhp#ftest\">F-test</link>, <link href=\"text/scalc/01/statistics.xhp#ztest\">Z-test</link>, <link href=\"text/scalc/01/statistics.xhp#chisqtest\">Chi-square test</link>." +msgid "For more information on Z-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Z-test\" name=\"English Wikipedia: Z-test\">corresponding Wikipedia article</link>." msgstr "" -#. 7EZAg -#: statistics_regression.xhp +#. uj2zU +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"tit\n" +"statistics_test_z.xhp\n" +"hd_id1000220\n" "help.text" -msgid "Regression Analysis" -msgstr "Analisis regresi" +msgid "Data" +msgstr "" -#. UPKr7 -#: statistics_regression.xhp +#. G5qUC +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"hd_id1701201615033510\n" +"statistics_test_z.xhp\n" +"par_id1003670\n" "help.text" -msgid "<variable id=\"regressionanalysish1\"><link href=\"text/scalc/01/statistics_regression.xhp\" name=\"regression analysis\">Regression Analysis</link></variable>" +msgid "<emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze." msgstr "" -#. NFhSA -#: statistics_regression.xhp +#. 6sDZb +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001240\n" +"statistics_test_z.xhp\n" +"par_id1003680\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Produces the regression analysis of a data set</ahelp>" -msgstr "<ahelp hid=\"modules/scalc/ui/regressiondialog/RegressionDialog\">Menghasilkan analisis regresi dari pengaturan data</ahelp>" +msgid "<emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze." +msgstr "" -#. wDYsU -#: statistics_regression.xhp +#. SRfn5 +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"bm_id2764278\n" +"statistics_test_z.xhp\n" +"par_id1003690\n" "help.text" -msgid "<bookmark_value>Analysis toolpack;regression analysis</bookmark_value><bookmark_value>regression analysis;Analysis toolpack</bookmark_value><bookmark_value>Data statistics;regression analysis</bookmark_value>" +msgid "<emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed." msgstr "" -#. nCe3o -#: statistics_regression.xhp +#. WLqsj +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1000040\n" +"statistics_test_z.xhp\n" +"hd_id1000230\n" "help.text" -msgid "<variable id=\"sam01\">Choose <emph>Data - Statistics - Regression</emph></variable>" -msgstr "<variable id=\"sam01\">Pilih <emph>Data - Statistik - Regresi</emph></variable>" +msgid "Results for z-Test:" +msgstr "" -#. zADGk -#: statistics_regression.xhp +#. bS4Zx +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001270\n" +"statistics_test_z.xhp\n" +"par_id1003700\n" "help.text" -msgid "For more information on regression analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">corresponding Wikipedia article</link>." -msgstr "Untuk informasi lebih lanjut tentang analisis regresi, lihat tautan <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">artikel Wikipedia yang sesuai</link>." +msgid "The following table shows the <emph>z-Test</emph> for the data series above:" +msgstr "" -#. rdATw -#: statistics_regression.xhp +#. cyNij +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"hd_id1000070\n" +"statistics_test_z.xhp\n" +"par_id1003710\n" "help.text" -msgid "Output Regression Type" -msgstr "Jenis Regresi Keluaran" +msgid "z-test" +msgstr "" -#. QMDBG -#: statistics_regression.xhp +#. 2jGDY +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001280\n" +"statistics_test_z.xhp\n" +"par_id1003720\n" "help.text" -msgid "Set the regression type. Three types are available:" -msgstr "Setel jenis regresi. Tiga jenis tersedia:" +msgid "Alpha" +msgstr "" -#. 7Avaz -#: statistics_regression.xhp +#. S4FZC +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201620334364\n" +"statistics_test_z.xhp\n" +"par_id1003740\n" "help.text" -msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data." -msgstr "<emph> Regresi Lini </emph>: cari garis lurus dalam bentuk <item type=\"literal\"> y = ax + b </item>, di mana <item type=\"literal\"> a </item> adalah slope dan <item type=\"literal\"> b </item> adalah intersep yang paling sesuai dengan data." +msgid "Hypothesized Mean Difference" +msgstr "" -#. B6dex -#: statistics_regression.xhp +#. EyFTK +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201620340168\n" +"statistics_test_z.xhp\n" +"par_id1003760\n" "help.text" -msgid "<emph>Logarithmic regression</emph>: find a logarithmic curve in the form of <item type=\"literal\">y = a.ln(x) + b</item>, where <item type=\"literal\">a</item> is the slope, <item type=\"literal\">b</item> is the intercept and <item type=\"literal\">ln(x)</item> is the natural logarithm of <item type=\"literal\">x</item>, that best fits the data." -msgstr "<emph> Regresi logaritmik </emph>: temukan kurva logaritmik dalam bentuk <item type=\"literal\"> y = a.ln (x) + b </item>, di mana <item type=\"literal\"> a </item> adalah kemiringan, <item type=\"literal\"> b </item> adalah intersep dan <item type=\"literal\"> ln (x) </item> adalah logaritma natural dari <item type=\"literal\"> x </item>, yang paling cocok dengan data." +msgid "Variable 1" +msgstr "" -#. txgoZ -#: statistics_regression.xhp +#. yybKF +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201620340139\n" +"statistics_test_z.xhp\n" +"par_id1003770\n" "help.text" -msgid "<emph>Power regression</emph>: Find a power curve in the form of <item type=\"literal\">y = a.x^b</item>, where <item type=\"literal\">a</item> is the coefficient, <item type=\"literal\">b</item> is the power that best fits the data." -msgstr "<emph>Regresi pangkat</emph>: Temukan kurva pangkat dalam bentuk <item type=\"literal\">y = a.x^b</item>, dimana <item type=\"literal\">a</item> adalah koefisien, <item type=\"literal\">b</item> adalah pangkat yang paling cocok dengan data." +msgid "Variable 2" +msgstr "" -#. EtPbr -#: statistics_regression.xhp +#. zi3v9 +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1001310\n" +"statistics_test_z.xhp\n" +"par_id1003780\n" "help.text" -msgid "The results of the three types of <emph>regression analysis</emph> of the measurements in the table above are shown below." -msgstr "Hasil dari tiga jenis<emph>analisis regresi</emph>pengukuran pada tabel di atas ditunjukkan di bawah ini." +msgid "Known Variance" +msgstr "" -#. iJ7yf -#: statistics_regression.xhp +#. RozyW +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090526\n" +"statistics_test_z.xhp\n" +"par_id1003810\n" "help.text" -msgid "Regression" -msgstr "Regresi" +msgid "Mean" +msgstr "" -#. cSAoU -#: statistics_regression.xhp +#. fV5Cq +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090542\n" +"statistics_test_z.xhp\n" +"par_id1003840\n" "help.text" -msgid "Regression Model" -msgstr "Model Regresi" +msgid "Observations" +msgstr "" -#. YAGFi -#: statistics_regression.xhp +#. Nfz8K +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090596\n" +"statistics_test_z.xhp\n" +"par_id1003870\n" "help.text" -msgid "Linear" -msgstr "Linear" +msgid "Observed Mean Difference" +msgstr "" -#. 2zcqS -#: statistics_regression.xhp +#. MDCGb +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090586\n" +"statistics_test_z.xhp\n" +"par_id1003890\n" "help.text" -msgid "Logarithmic" -msgstr "Logaritmik" +msgid "z" +msgstr "" -#. QvaFq -#: statistics_regression.xhp +#. N35cE +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090555\n" +"statistics_test_z.xhp\n" +"par_id1003900\n" "help.text" -msgid "Power" -msgstr "Pangkat" +msgid "#DIV/0!" +msgstr "" -#. oHBnC -#: statistics_regression.xhp +#. BiBJi +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090553\n" +"statistics_test_z.xhp\n" +"par_id1003910\n" "help.text" -msgid "R^2" -msgstr "R^2" +msgid "P (Z<=z) one-tail" +msgstr "" -#. egmFM -#: statistics_regression.xhp +#. HqGPf +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090595\n" +"statistics_test_z.xhp\n" +"par_id1003920\n" "help.text" -msgid "Standard Error" -msgstr "Kesalahan Standar" +msgid "#DIV/0!" +msgstr "" -#. woESA -#: statistics_regression.xhp +#. 2NUBk +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090563\n" +"statistics_test_z.xhp\n" +"par_id1003930\n" "help.text" -msgid "Slope" -msgstr "Lereng" +msgid "z Critical one-tail" +msgstr "" -#. qfNCA -#: statistics_regression.xhp +#. WBGeU +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id1701201618090642\n" +"statistics_test_z.xhp\n" +"par_id1003950\n" "help.text" -msgid "Intercept" -msgstr "Perpotongan" +msgid "P (Z<=z) two-tail" +msgstr "" -#. ZAad5 -#: statistics_regression.xhp -#, fuzzy +#. TPsmf +#: statistics_test_z.xhp msgctxt "" -"statistics_regression.xhp\n" -"par_id14337286612130\n" +"statistics_test_z.xhp\n" +"par_id1003960\n" "help.text" -msgid "<link href=\"text/scalc/01/statistics.xhp#datasampling\">Sampling</link>, <link href=\"text/scalc/01/statistics.xhp#descriptivestatistics\">Descriptive Statistics</link>, <link href=\"text/scalc/01/statistics.xhp#anova\">Analysis of Variance (ANOVA)</link>, <link href=\"text/scalc/01/statistics.xhp#correlation\">Correlation</link>, <link href=\"text/scalc/01/statistics.xhp#covariance\">Covariance</link>, <link href=\"text/scalc/01/statistics.xhp#exponentialsmoothing\">Exponential Smoothing</link>, <link href=\"text/scalc/01/statistics.xhp#movingaverage\">Moving Average</link>, <link href=\"text/scalc/01/statistics.xhp#ttest\">Paired t-test</link>, <link href=\"text/scalc/01/statistics.xhp#ftest\">F-test</link>, <link href=\"text/scalc/01/statistics.xhp#ztest\">Z-test</link>, <link href=\"text/scalc/01/statistics.xhp#chisqtest\">Chi-square test</link>." -msgstr "<link href=\"text/scalc/01/statistics.xhp#datasampling\">Sampling</link>, <link href=\"text/scalc/01/statistics.xhp#descriptivestatistics\">Descriptive Statistics</link>, <link href=\"text/scalc/01/statistics.xhp#anova\">Analysis of Variance (ANOVA)</link>, <link href=\"text/scalc/01/statistics.xhp#correlation\">Correlation</link>, <link href=\"text/scalc/01/statistics.xhp#covariance\">Covariance</link>, <link href=\"text/scalc/01/statistics.xhp#exponentialsmoothing\">Exponential Smoothing</link>, <link href=\"text/scalc/01/statistics.xhp#movingaverage\">Moving Average</link>, <link href=\"text/scalc/01/statistics.xhp#ttest\">Paired t-test</link>, <link href=\"text/scalc/01/statistics.xhp#ftest\">F-test</link>, <link href=\"text/scalc/01/statistics.xhp#ztest\">Z-test</link>, <link href=\"text/scalc/01/statistics.xhp#chisqtest\">Chi-square test</link>." +msgid "#DIV/0!" +msgstr "" + +#. NCMYu +#: statistics_test_z.xhp +msgctxt "" +"statistics_test_z.xhp\n" +"par_id1003970\n" +"help.text" +msgid "z Critical two-tail" +msgstr "" #. bdLFh #: text2columns.xhp @@ -66985,14 +67038,14 @@ msgctxt "" msgid "<link href=\"text/scalc/01/text2columns.xhp\">Text to Columns</link>" msgstr "<link href=\"text/scalc/01/text2columns.xhp\">Teks ke Kolom</link>" -#. y8ix9 +#. pvPPw #: text2columns.xhp msgctxt "" "text2columns.xhp\n" "par_id655232\n" "help.text" -msgid "<variable id=\"text2columns\">Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells. </variable>" -msgstr "<variable id=\"text2columns\">Buka dialog Teks ke Kolom, di mana Anda memasukkan pengaturan untuk memperluas konten sel yang dipilih ke beberapa sel. </variable>" +msgid "<variable id=\"text2columns\">Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells.</variable>" +msgstr "" #. YwdL2 #: text2columns.xhp diff --git a/source/id/helpcontent2/source/text/scalc/02.po b/source/id/helpcontent2/source/text/scalc/02.po index 3eba8591deb..0b95370be33 100644 --- a/source/id/helpcontent2/source/text/scalc/02.po +++ b/source/id/helpcontent2/source/text/scalc/02.po @@ -4,8 +4,8 @@ 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: 2020-01-07 14:09+0100\n" -"PO-Revision-Date: 2020-02-01 14:32+0000\n" -"Last-Translator: Imanuel Ronaldo <imanuelronaldo@gmail.com>\n" +"PO-Revision-Date: 2020-03-29 19:16+0000\n" +"Last-Translator: Andika Triwidada <andika@gmail.com>\n" "Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc02/id/>\n" "Language: id\n" "MIME-Version: 1.0\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=n>1;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: Weblate 3.9.1\n" +"X-Generator: Weblate 3.10.3\n" "X-POOTLE-MTIME: 1550994672.000000\n" #. aSE5T @@ -320,7 +320,7 @@ msgctxt "" "tit\n" "help.text" msgid "Name Box" -msgstr "" +msgstr "Kotak Nama" #. JJA9o #: 06010000.xhp @@ -374,7 +374,7 @@ msgctxt "" "par_id3152596\n" "help.text" msgid "To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4. You can also enter full name of a sheet; the tooltip then changes to \"Go To Sheet\", and pressing Enter switches to that sheet." -msgstr "" +msgstr "Untuk melompat ke sel tertentu, atau untuk memilih suatu rentang sel, ketikkan referensi sel, atau referensi rentang sel dalam kotak ini, misalnya, F1, atau A1:C4. Anda juga dapat memasukkan nama lengkap lembar; tooltip kemudian berubah menjadi \"Ke Lembar\", dan menekan Enter untuk beralih ke lembar itu." #. VFke2 #: 06030000.xhp diff --git a/source/id/helpcontent2/source/text/scalc/04.po b/source/id/helpcontent2/source/text/scalc/04.po index 50e882eb374..66520b06d62 100644 --- a/source/id/helpcontent2/source/text/scalc/04.po +++ b/source/id/helpcontent2/source/text/scalc/04.po @@ -4,7 +4,7 @@ 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: 2020-02-17 12:22+0100\n" -"PO-Revision-Date: 2020-02-29 17:15+0000\n" +"PO-Revision-Date: 2020-03-28 17:49+0000\n" "Last-Translator: Imanuel Ronaldo <imanuelronaldo@gmail.com>\n" "Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc04/id/>\n" "Language: id\n" @@ -320,7 +320,7 @@ msgctxt "" "par_id851550311052582\n" "help.text" msgid "Selects all cells in the sheet." -msgstr "Pilih selurul sel pada sheet." +msgstr "Pilih seluruh sel pada sheet." #. dXFKv #: 01020000.xhp @@ -329,7 +329,7 @@ msgctxt "" "hd_id3143220\n" "help.text" msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left Arrow" -msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline> + Panah Kiri" +msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Left Arrow" #. LWDGG #: 01020000.xhp diff --git a/source/id/helpcontent2/source/text/scalc/05.po b/source/id/helpcontent2/source/text/scalc/05.po index b3114725bfa..11f8003a815 100644 --- a/source/id/helpcontent2/source/text/scalc/05.po +++ b/source/id/helpcontent2/source/text/scalc/05.po @@ -3,8 +3,8 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2020-02-27 14:31+0100\n" -"PO-Revision-Date: 2020-02-01 14:32+0000\n" +"POT-Creation-Date: 2020-03-31 10:35+0200\n" +"PO-Revision-Date: 2020-03-29 19:16+0000\n" "Last-Translator: Andika Triwidada <andika@gmail.com>\n" "Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc05/id/>\n" "Language: id\n" @@ -131,7 +131,7 @@ msgctxt "" "par_id3165767\n" "help.text" msgid "none" -msgstr "" +msgstr "tak ada" #. 6s9C6 #: 02140000.xhp @@ -140,7 +140,7 @@ msgctxt "" "par_id3169267\n" "help.text" msgid "This value is outside of limits valid for this format" -msgstr "" +msgstr "Nilai ini berada di luar batas valid untuk format ini" #. ApVjg #: 02140000.xhp @@ -428,7 +428,7 @@ msgctxt "" "par_id3146142\n" "help.text" msgid "519<br/>#VALUE!" -msgstr "" +msgstr "519<br/>#VALUE!" #. ESdqW #: 02140000.xhp @@ -437,7 +437,7 @@ msgctxt "" "par_id3155954\n" "help.text" msgid "No result (instead of Err:519 cell displays #VALUE!)" -msgstr "" +msgstr "Tak ada hasil (selain Err:519 sel menampilkan #VALUE!)" #. cf6oh #: 02140000.xhp @@ -473,7 +473,7 @@ msgctxt "" "par_id3153737\n" "help.text" msgid "Internal syntax error (instead of Err:521 cell displays #NULL!)" -msgstr "" +msgstr "Galat sintaksis internal (dari pada Err:521 sel menampilkan #NULL!)" #. AiUic #: 02140000.xhp @@ -482,7 +482,7 @@ msgctxt "" "par_id3155436\n" "help.text" msgid "No code or no result." -msgstr "" +msgstr "Tak ada kode atau tak ada hasil." #. SWNv6 #: 02140000.xhp @@ -527,7 +527,7 @@ msgctxt "" "par_id3153544\n" "help.text" msgid "524<br/>#REF!" -msgstr "" +msgstr "524<br/>#REF!" #. ioqDF #: 02140000.xhp @@ -536,7 +536,7 @@ msgctxt "" "par_id3154634\n" "help.text" msgid "invalid references (instead of Err:524 cell displays #REF!)" -msgstr "" +msgstr "Referensi tak valid (dari pada Err:524 sel menampilkan #REF!)" #. iGGQE #: 02140000.xhp @@ -563,7 +563,7 @@ msgctxt "" "par_id3148428\n" "help.text" msgid "invalid names (instead of Err:525 cell displays #NAME?)" -msgstr "" +msgstr "nama tak valid (ketimbang Err:525 sel menampilkan #NAME?)" #. pTzCU #: 02140000.xhp @@ -700,15 +700,6 @@ msgctxt "" msgid "Error: Array or matrix size" msgstr "Galat: Ukuran larik atau matriks" -#. EkQbK -#: 02140000.xhp -msgctxt "" -"02140000.xhp\n" -"par_id601549825744677\n" -"help.text" -msgid "-" -msgstr "-" - #. GXCEU #: 02140000.xhp msgctxt "" diff --git a/source/id/helpcontent2/source/text/scalc/guide.po b/source/id/helpcontent2/source/text/scalc/guide.po index 5bc72314247..1a5ec599805 100644 --- a/source/id/helpcontent2/source/text/scalc/guide.po +++ b/source/id/helpcontent2/source/text/scalc/guide.po @@ -3,9 +3,9 @@ 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: 2020-02-27 14:31+0100\n" -"PO-Revision-Date: 2020-02-01 14:32+0000\n" -"Last-Translator: artemtech <sofyanartem@gmail.com>\n" +"POT-Creation-Date: 2020-03-31 10:35+0200\n" +"PO-Revision-Date: 2020-04-02 15:16+0000\n" +"Last-Translator: Andika Triwidada <andika@gmail.com>\n" "Language-Team: Indonesian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/id/>\n" "Language: id\n" "MIME-Version: 1.0\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=2; plural=n>1;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: LibreOffice\n" +"X-Generator: Weblate 3.10.3\n" "X-POOTLE-MTIME: 1551149875.000000\n" #. NXy6S @@ -2471,7 +2471,7 @@ msgctxt "" "par_id3147383\n" "help.text" msgid "The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on <link href=\"text/shared/optionen/01060900.xhp\">Formula options page</link>." -msgstr "" +msgstr "Contoh berikut menggunakan sintaks rumus Calc. Ini juga memungkinkan untuk menggunakan sintaks rumus Excel A1 atau R1C1; Ini terkonfigurasi dalam <link href=\"text/shared/optionen/01060900.xhp\">Halaman opsi rumus</link>." #. mK8vG #: cellreferences.xhp @@ -8429,7 +8429,7 @@ msgctxt "" "par_id6478774\n" "help.text" msgid "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\"><alt id=\"alt_id1621753\">what-if sheet area</alt></image>" -msgstr "" +msgstr "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\"><alt id=\"alt_id1621753\">area sheet what-if</alt></image>" #. KavvR #: multioperation.xhp @@ -9158,7 +9158,7 @@ msgctxt "" "par_id891567607263849\n" "help.text" msgid "The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which is ignored for the SUM function." -msgstr "" +msgstr "Rumus <literal>=SUM(A1:A2)</literal>, mengembalikan nilai 101 bukan 201 karena konversi tidak terjadi dalam rentangan, hanya nilai skalar tunggal. Disini, '1e2 dianggap sebagai string yang mempunyai nilai 0 untuk fungsi SUM." #. hoF73 #: numbers_text.xhp @@ -11338,14 +11338,14 @@ msgctxt "" msgid "<bookmark_value>filters;defining advanced filters </bookmark_value><bookmark_value>advanced filters</bookmark_value><bookmark_value>defining; advanced filters</bookmark_value><bookmark_value>database ranges; advanced filters</bookmark_value>" msgstr "<bookmark_value>filter;menentukan filter lanjutan </bookmark_value><bookmark_value>filter lanjutan</bookmark_value><bookmark_value>menentukan; filter lanjutan</bookmark_value><bookmark_value>rentang basis data; filter lanjutan</bookmark_value>" -#. JC6fD +#. GS4TQ #: specialfilter.xhp msgctxt "" "specialfilter.xhp\n" "hd_id3148798\n" "help.text" -msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filter: Applying Advanced Filters</link> </variable>" -msgstr "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filter: Menerapkan Filter Lanjutan</link> </variable>" +msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filter: Applying Advanced Filters</link></variable>" +msgstr "" #. tYuAi #: specialfilter.xhp @@ -11797,6 +11797,168 @@ msgctxt "" msgid "Choose <emph>Data - Filter - Advanced Filter</emph>, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view." msgstr "Pilih <emph>Data - Filter - Filter Lanjutan</emph>, lalu pilih rentang A20:E22. Setelah Anda mengklik OK, hanya baris yang difilter yang akan ditampilkan. Baris lain akan disembunyikan dari tampilan." +#. jQ6bn +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"tit\n" +"help.text" +msgid "Using Subtotals Tool" +msgstr "" + +#. aKjYH +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"bm_id521585182060496\n" +"help.text" +msgid "<bookmark_value>subtotals;using subtotals tool</bookmark_value>" +msgstr "" + +#. 6JBG9 +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"hd_id631585177069332\n" +"help.text" +msgid "<variable id=\"subtotaltoolh1\"><link href=\"text/scalc/guide/subtotaltool.xhp\" name=\"Using Subtotal Tool\">Using Subtotal Tool</link></variable>" +msgstr "" + +#. rC9BC +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id301585177069332\n" +"help.text" +msgid "Calc offers the Subtotals tool as a more comprehensive alternative to the <link href=\"text/scalc/01/04060106.xhp#Section12\" name=\"subtotal\">SUBTOTAL function</link>. In contrast to SUBTOTAL, which only works on a single array, the Subtotals tool can create subtotals for up to three arrays arranged in labeled columns. It also groups subtotals by category and sorts them automatically, thereby eliminating the need to apply AutoFilters and filter categories by hand." +msgstr "" + +#. NEkbi +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"hd_id891585177511329\n" +"help.text" +msgid "Using the Subtotals tool" +msgstr "" + +#. kwLkR +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id91585177517697\n" +"help.text" +msgid "To insert subtotal values into a worksheet:" +msgstr "" + +#. DKZ3o +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id241585177550504\n" +"help.text" +msgid "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range." +msgstr "" + +#. owkFH +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id421585177574387\n" +"help.text" +msgid "Select <menuitem>Data > Subtotals</menuitem> from the Menu bar to open the Subtotals dialog." +msgstr "" + +#. AmnUD +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id41585177608508\n" +"help.text" +msgid "In the Group by drop-down list on the first Group page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column." +msgstr "" + +#. dq83u +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id451585177625978\n" +"help.text" +msgid "In the Calculate subtotals for box on the first Group page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals." +msgstr "" + +#. xFgAD +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id661585177644535\n" +"help.text" +msgid "In the Use function box on the first Group page, select a function to calculate the subtotals for the column selected in step 4." +msgstr "" + +#. EhUvq +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id351585177661529\n" +"help.text" +msgid "Repeat steps 4 and 5 to create subtotals for other columns on the first Group page." +msgstr "" + +#. aQRn7 +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id511585177679372\n" +"help.text" +msgid "You can create two more subtotal categories by using the second Group and third Group pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”." +msgstr "" + +#. AaCGA +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id301585177698777\n" +"help.text" +msgid "Click OK. Calc will add subtotal and grand total rows to your cell range." +msgstr "" + +#. iMTer +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"hd_id211585178799496\n" +"help.text" +msgid "Subtotal outline" +msgstr "" + +#. 35yNv +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id841585178819108\n" +"help.text" +msgid "When you use the Subtotals tool, Calc inserts an outline to the left of the row number column. This outline represents the hierarchical structure of your subtotals, and can be used to hide or show data at different levels in the hierarchy using the numbered column indicators at the top of the outline or the group indicators, denoted by plus <emph>(+)</emph> and minus <emph>(-)</emph> signs." +msgstr "" + +#. EhreW +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id371585181820075\n" +"help.text" +msgid "This feature is useful if you have many subtotals, as you can simply hide low-level details, such as individual entries, to produce a high-level summary of your data." +msgstr "" + +#. SEYEM +#: subtotaltool.xhp +msgctxt "" +"subtotaltool.xhp\n" +"par_id161585178829165\n" +"help.text" +msgid "To turn off outlines, select <menuitem>Data > Group and Outline > Remove Outline</menuitem> from the Menu bar. To reinstate them, select <menuitem>Data > Group and Outline > AutoOutline</menuitem>." +msgstr "" + #. oU9ew #: super_subscript.xhp msgctxt "" @@ -12416,7 +12578,7 @@ msgctxt "" "hd_id3149260\n" "help.text" msgid "Defining A Function Using %PRODUCTNAME Basic" -msgstr "Menentukan Fungsi Menggunakanc%PRODUCTNAME Dasar" +msgstr "Menentukan Fungsi Menggunakanc %PRODUCTNAME Basic" #. rA6xD #: userdefined_function.xhp @@ -12902,7 +13064,7 @@ msgctxt "" "par_id32898987\n" "help.text" msgid "Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information." -msgstr "" +msgstr "Nama tidak boleh dimulai dengan huruf C atau R diikuti dengan angka; juga karakter tunggal C dan R tidak diizinkan sebagai nama. Lihatlah fungsi ADDRESS untuk informasi lebih lanjut." #. ELFqL #: value_with_name.xhp |