{"id":4126,"date":"2023-07-13T10:21:17","date_gmt":"2023-07-13T10:21:17","guid":{"rendered":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/"},"modified":"2023-07-13T10:21:17","modified_gmt":"2023-07-13T10:21:17","slug":"perkalian-matriks-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/","title":{"rendered":"Cara melakukan perkalian matriks di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>MMULT<\/strong> di Google Sheets untuk melakukan perkalian matriks.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>MMULT(matriks1, matriks2)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>matriks1<\/strong> , <strong>matriks2<\/strong> : Dua matriks yang ingin dikalikan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi <strong>MMULT<\/strong> untuk melakukan perkalian matriks berikut di Google Spreadsheet:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">(2\u00d72) kali (2\u00d72) perkalian matriks<\/span><\/li>\n<li> <span style=\"color: #000000;\">(2\u00d72) kali (2\u00d73) perkalian matriks<\/span><\/li>\n<li> <span style=\"color: #000000;\">(3\u00d73) kali (3\u00d72) perkalian matriks<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <strong>Contoh 1: perkalian matriks (2\u00d72) dengan (2\u00d72).<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara mengalikan matriks (2 \u00d7 2) dengan matriks (2 \u00d7 2) lainnya di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32813\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mmat1.png\" alt=\"Perkalian matriks 2x2 kali 2x2 di Google Sheets\" width=\"637\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami mengetikkan rumus berikut ke dalam sel <strong>G2<\/strong> untuk melakukan perkalian matriks ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MMULT( <span style=\"color: #ff6600;\">A2:B3<\/span> , <span style=\"color: #800080;\">D2:E3<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut adalah rumus sebenarnya yang digunakan Google Sheets untuk melakukan perkalian matriks ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32798 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matr1.png\" alt=\"\" width=\"525\" height=\"97\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan matriks 2\u00d72 berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32799 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matr2.png\" alt=\"\" width=\"191\" height=\"87\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> Pengantar Perkalian Matriks (2\u00d72) dengan (2\u00d72)<\/span><\/p>\n<h2> <strong>Contoh 2: perkalian matriks (2 \u00d7 2) dengan (2 \u00d7 3).<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara mengalikan matriks (2 \u00d7 2) dengan matriks (2 \u00d7 3) di Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32814\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mmat2.png\" alt=\"Perkalian matriks 2x2 kali 2x3 di Google Sheets\" width=\"630\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami mengetikkan rumus berikut ke dalam sel <strong>H2<\/strong> untuk melakukan perkalian matriks ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MMULT( <span style=\"color: #ff6600;\">A2:B3<\/span> , <span style=\"color: #800080;\">D2:F3<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut adalah rumus sebenarnya yang digunakan Google Sheets untuk melakukan perkalian matriks ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32802 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matr3.png\" alt=\"\" width=\"496\" height=\"91\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan matriks 2&#215;3 berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32803 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matr4.png\" alt=\"\" width=\"237\" height=\"85\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> Pengenalan perkalian matriks (2\u00d72) dengan (2\u00d73)<\/span><\/p>\n<h2> <strong>Contoh 3: perkalian matriks (3 \u00d7 3) dengan (3 \u00d7 2).<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara mengalikan matriks (3 \u00d7 3) dengan matriks (3 \u00d7 2) di Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32815\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mmat3.png\" alt=\"Perkalian matriks 3x3 kali 3x2 di Google Sheets\" width=\"607\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami mengetikkan rumus berikut ke dalam sel <strong>H2<\/strong> untuk melakukan perkalian matriks ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MMULT( <span style=\"color: #ff6600;\">A2:C4<\/span> , <span style=\"color: #800080;\">E2:F4<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut adalah rumus sebenarnya yang digunakan Google Sheets untuk melakukan perkalian matriks ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32805 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matr5.png\" alt=\"\" width=\"491\" height=\"116\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan matriks 3&#215;2 berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32806 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matr6.png\" alt=\"\" width=\"236\" height=\"111\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> Pengantar Perkalian Matriks (3\u00d73) dengan (3\u00d72)<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>MMULT<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/3094292?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kalikan-jika-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi MULTIPLY IF di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan konstanta di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi MMULT di Google Sheets untuk melakukan perkalian matriks. Fungsi ini menggunakan sintaks dasar berikut: MMULT(matriks1, matriks2) Emas: matriks1 , matriks2 : Dua matriks yang ingin dikalikan. Contoh berikut menunjukkan cara menggunakan fungsi MMULT untuk melakukan perkalian matriks berikut di Google Spreadsheet: (2\u00d72) kali (2\u00d72) perkalian matriks (2\u00d72) kali (2\u00d73) perkalian matriks [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara melakukan perkalian matriks di Google Sheets - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan perkalian matriks di Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan perkalian matriks di Google Sheets - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan perkalian matriks di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T10:21:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mmat1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/\",\"name\":\"Cara melakukan perkalian matriks di Google Sheets - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T10:21:17+00:00\",\"dateModified\":\"2023-07-13T10:21:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan perkalian matriks di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan perkalian matriks di google sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara melakukan perkalian matriks di Google Sheets - Statologi","description":"Tutorial ini menjelaskan cara melakukan perkalian matriks di Google Sheets, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan perkalian matriks di Google Sheets - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan perkalian matriks di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-13T10:21:17+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mmat1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/","url":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/","name":"Cara melakukan perkalian matriks di Google Sheets - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T10:21:17+00:00","dateModified":"2023-07-13T10:21:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan perkalian matriks di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perkalian-matriks-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan perkalian matriks di google sheets"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4126"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4126"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4126\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}