{"id":2285,"date":"2023-07-22T22:42:58","date_gmt":"2023-07-22T22:42:58","guid":{"rendered":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/"},"modified":"2023-07-22T22:42:58","modified_gmt":"2023-07-22T22:42:58","slug":"menyelesaikan-sistem-persamaan-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/","title":{"rendered":"Cara menyelesaikan sistem persamaan di excel (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Untuk menyelesaikan sistem persamaan di Excel, dapat menggunakan fungsi <strong>MMULT<\/strong> dan <strong>MINVERSE<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi ini untuk menyelesaikan beberapa sistem persamaan berbeda di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Memecahkan sistem persamaan dua variabel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai sistem persamaan berikut dan ingin menyelesaikan nilai x dan y:<\/span><\/p>\n<p> <span style=\"color: #000000;\">5x + 4 tahun = 35<\/span><\/p>\n<p> <span style=\"color: #000000;\">2x + 6 tahun = 36<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menyelesaikan sistem persamaan ini, pertama-tama kita bisa memasukkan nilai berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20781 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre1-1.png\" alt=\"\" width=\"542\" height=\"328\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita dapat menggunakan rumus berikut untuk menyelesaikan nilai x dan y:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MMULT(MINVERSE( <span style=\"color: #3366ff;\">A1:B2<\/span> ), <span style=\"color: #ff0000;\">C1:C2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel E1 lalu tekan CTRL + SHIFT + ENTER:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre2.png\" alt=\"\" width=\"541\" height=\"335\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai x adalah <strong>3<\/strong> dan nilai y adalah <strong>5<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menyelesaikan sistem persamaan dengan tiga variabel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai sistem persamaan berikut dan kita ingin menyelesaikan nilai x, y dan z:<\/span><\/p>\n<p> <span style=\"color: #000000;\">4x + 2y + 1z = 34<\/span><\/p>\n<p> <span style=\"color: #000000;\">3x + 5 tahun \u2013 2z = 41<\/span><\/p>\n<p> <span style=\"color: #000000;\">2x + 2a + 4z = 30<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menyelesaikan sistem persamaan ini, pertama-tama kita bisa memasukkan nilai berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20783 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre3.png\" alt=\"\" width=\"521\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita dapat menggunakan rumus berikut untuk menyelesaikan nilai x, y, dan z:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MMULT(MINVERSE( <span style=\"color: #3366ff;\">A1:C3<\/span> ), <span style=\"color: #ff0000;\">D1:D3<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel F1 lalu tekan CTRL+SHIFT+ENTER:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20784 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre4.png\" alt=\"\" width=\"517\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hal ini memberitahu kita bahwa nilai x adalah <strong>5<\/strong> , nilai y adalah <strong>6<\/strong> , dan nilai z adalah <strong>2<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Menyelesaikan sistem persamaan dengan empat variabel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai sistem persamaan berikut dan kita ingin menyelesaikan nilai w, x, y dan z:<\/span><\/p>\n<p> <span style=\"color: #000000;\">6w + 2x + 2y + 1z = 37<\/span><\/p>\n<p> <span style=\"color: #000000;\">2w + 1x + 1y + 0z = 14<\/span><\/p>\n<p> <span style=\"color: #000000;\">3s + 2x + 2a + 4z = 28<\/span><\/p>\n<p> <span style=\"color: #000000;\">2w + 0x + 5y + 5z = 28<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menyelesaikan sistem persamaan ini, pertama-tama kita bisa memasukkan nilai berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20785 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre5.png\" alt=\"\" width=\"509\" height=\"318\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita dapat menggunakan rumus berikut untuk menyelesaikan nilai w, x, y dan z:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MMULT(MINVERSE( <span style=\"color: #3366ff;\">A1:D4<\/span> ), <span style=\"color: #ff0000;\">E1:E4<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus ini di sel G1 lalu tekan CTRL + SHIFT + ENTER:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20786 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre6.png\" alt=\"\" width=\"582\" height=\"332\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai w adalah <strong>4<\/strong> , x adalah <strong>3<\/strong> , y adalah <strong>3<\/strong> , dan z adalah <strong>1<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/\" target=\"_blank\" rel=\"noopener\">Cara memplot persamaan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/normalisasi-data-excel\/\" target=\"_blank\" rel=\"noopener\">Cara normalisasi data di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menyesuaikan kurva di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Untuk menyelesaikan sistem persamaan di Excel, dapat menggunakan fungsi MMULT dan MINVERSE . Contoh berikut memperlihatkan cara menggunakan fungsi ini untuk menyelesaikan beberapa sistem persamaan berbeda di Excel. Contoh 1: Memecahkan sistem persamaan dua variabel Misalkan kita mempunyai sistem persamaan berikut dan ingin menyelesaikan nilai x dan y: 5x + 4 tahun = 35 2x [&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 menyelesaikan sistem persamaan di Excel (3 contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyelesaikan sistem persamaan di Excel, 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\/menyelesaikan-sistem-persamaan-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menyelesaikan sistem persamaan di Excel (3 contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyelesaikan sistem persamaan di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T22:42:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre1-1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/\",\"name\":\"Cara menyelesaikan sistem persamaan di Excel (3 contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T22:42:58+00:00\",\"dateModified\":\"2023-07-22T22:42:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyelesaikan sistem persamaan di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menyelesaikan sistem persamaan di excel (3 contoh)\"}]},{\"@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 menyelesaikan sistem persamaan di Excel (3 contoh) - Statologi","description":"Tutorial ini menjelaskan cara menyelesaikan sistem persamaan di Excel, 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\/menyelesaikan-sistem-persamaan-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menyelesaikan sistem persamaan di Excel (3 contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menyelesaikan sistem persamaan di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-22T22:42:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/resoudre1-1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/","url":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/","name":"Cara menyelesaikan sistem persamaan di Excel (3 contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T22:42:58+00:00","dateModified":"2023-07-22T22:42:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyelesaikan sistem persamaan di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menyelesaikan sistem persamaan di excel (3 contoh)"}]},{"@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\/2285"}],"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=2285"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2285\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}