{"id":4047,"date":"2023-07-13T23:11:27","date_gmt":"2023-07-13T23:11:27","guid":{"rendered":"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/"},"modified":"2023-07-13T23:11:27","modified_gmt":"2023-07-13T23:11:27","slug":"carilah-perpotongan-dua-garis-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/","title":{"rendered":"Cara mencari perpotongan dua garis di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mencari titik potong dua garis lurus di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Temukan nilai X dari persimpangan:<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=(INTERCEPT(y2,x2)-INTERCEPT(y1,x1))\/(SLOPE(y1,x1)-SLOPE(y2,x2))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mengasumsikan bahwa <strong>x1<\/strong> dan <strong>x2<\/strong> mewakili array nilai x untuk setiap baris dan <strong>y1<\/strong> dan <strong>y2<\/strong> mewakili array nilai y untuk setiap baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda menemukan nilai x ini, Anda dapat memasukkan nilai tersebut ke dalam rumus ini untuk mencari nilai y dari perpotongan tersebut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Temukan nilai Y dari persimpangan:<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SLOPE(y1,x1)*x_intercept+INTERCEPT(y1,x1)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai untuk setiap baris<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan koordinat (x, y) dari dua garis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32306 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int1.png\" alt=\"\" width=\"459\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Temukan nilai X dari persimpangan tersebut<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya ketikkan rumus berikut pada sel <strong>H2<\/strong> untuk mencari nilai x dari titik potong tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=(INTERCEPT( <span style=\"color: #3366ff;\">E3:E6<\/span> , <span style=\"color: #ff0000;\">D3:D6<\/span> )-INTERCEPT( <span style=\"color: #800080;\">B3:B6<\/span> , <span style=\"color: #008000;\">A3:A6<\/span> ))\/(SLOPE( <span style=\"color: #800080;\">B3:B6<\/span> , <span style=\"color: #008000;\">A3:A6<\/span> )-SLOPE( <span style=\"color: #3366ff;\">E3:E6<\/span> , <span style=\"color: #ff0000;\">D3:D6<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32308 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int2.png\" alt=\"\" width=\"651\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai x dari perpotongan tersebut ternyata <strong>1,5<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Temukan nilai Y dari persimpangan tersebut<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut pada sel <strong>H3<\/strong> untuk mencari nilai y dari perpotongan tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SLOPE( <span style=\"color: #3366ff;\">B3:B6<\/span> , <span style=\"color: #ff0000;\">A3:A6<\/span> )* <span style=\"color: #800080;\">H2<\/span> +INTERCEPT( <span style=\"color: #3366ff;\">B3:B6<\/span> , <span style=\"color: #ff0000;\">A3:A6<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32309\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int3.png\" alt=\"temukan perpotongan dua garis di Excel\" width=\"625\" height=\"488\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai y dari perpotongan tersebut ternyata adalah <strong>3<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Visualisasikan titik persimpangan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jika kita menggambar setiap garis pada jalur yang sama di Excel, kita melihat bahwa titik potongnya memang berada pada koordinat (x, y) dari <strong>(1.5, 3)<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32310 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int4.png\" alt=\"\" width=\"604\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini mewakili titik pada plot di mana dua garis berpotongan.<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menyelesaikan Persamaan Kuadrat di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menyelesaikan sistem persamaan di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan perpotongan y pada grafik di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mencari titik potong dua garis lurus di Excel: Temukan nilai X dari persimpangan: =(INTERCEPT(y2,x2)-INTERCEPT(y1,x1))\/(SLOPE(y1,x1)-SLOPE(y2,x2)) Rumus ini mengasumsikan bahwa x1 dan x2 mewakili array nilai x untuk setiap baris dan y1 dan y2 mewakili array nilai y untuk setiap baris. Setelah Anda menemukan nilai x ini, Anda dapat memasukkan nilai [&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 Menemukan Perpotongan Dua Garis di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari perpotongan dua garis di Excel, dengan contoh langkah demi langkah.\" \/>\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\/carilah-perpotongan-dua-garis-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menemukan Perpotongan Dua Garis di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari perpotongan dua garis di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T23:11:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int1.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\/carilah-perpotongan-dua-garis-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/\",\"name\":\"Cara Menemukan Perpotongan Dua Garis di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T23:11:27+00:00\",\"dateModified\":\"2023-07-13T23:11:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari perpotongan dua garis di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencari perpotongan dua garis di excel\"}]},{\"@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 Menemukan Perpotongan Dua Garis di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara mencari perpotongan dua garis di Excel, dengan contoh langkah demi langkah.","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\/carilah-perpotongan-dua-garis-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menemukan Perpotongan Dua Garis di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mencari perpotongan dua garis di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T23:11:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int1.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\/carilah-perpotongan-dua-garis-excel\/","url":"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/","name":"Cara Menemukan Perpotongan Dua Garis di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T23:11:27+00:00","dateModified":"2023-07-13T23:11:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari perpotongan dua garis di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/carilah-perpotongan-dua-garis-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencari perpotongan dua garis di excel"}]},{"@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\/4047"}],"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=4047"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4047\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}