{"id":4048,"date":"2023-07-13T22:55:43","date_gmt":"2023-07-13T22:55:43","guid":{"rendered":"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/"},"modified":"2023-07-13T22:55:43","modified_gmt":"2023-07-13T22:55:43","slug":"temukan-perpotongan-dua-garis-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/","title":{"rendered":"Cara mencari perpotongan dua garis di google sheets"},"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 Google Sheets:<\/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-32315 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int11.png\" alt=\"\" width=\"565\" height=\"418\" 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 <b>B10<\/b> untuk mencari nilai x dari titik potong tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=(INTERCEPT( <span style=\"color: #ff6600;\">E3:E6<\/span> , <span style=\"color: #800080;\">D3:D6<\/span> )-INTERCEPT( <span style=\"color: #008080;\">B3:B6<\/span> , <span style=\"color: #ff0000;\">A3:A6<\/span> ))\/(SLOPE( <span style=\"color: #008080;\">B3:B6<\/span> , <span style=\"color: #ff0000;\">A3:A6<\/span> )-SLOPE( <span style=\"color: #ff6600;\">E3:E6<\/span> , <span style=\"color: #800080;\">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-32317 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int12.png\" alt=\"\" width=\"585\" height=\"462\" 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 di sel <b>B11<\/b> untuk mencari nilai y dari perpotongan tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SLOPE( <span style=\"color: #ff6600;\">B3:B6<\/span> , <span style=\"color: #800080;\">A3:A6<\/span> )* <span style=\"color: #008080;\">B10<\/span> +INTERCEPT( <span style=\"color: #ff6600;\">B3:B6<\/span> , <span style=\"color: #800080;\">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=\" wp-image-32318 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int13.png\" alt=\"\" width=\"552\" height=\"486\" 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 menelusuri setiap garis pada lintasan yang sama, 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-32319 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int14.png\" alt=\"\" width=\"559\" height=\"529\" 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 Google Spreadsheet:<\/span><\/p>\n<p> Cara memplot persamaan di Google Spreadsheet<br \/> <a href=\"https:\/\/statorials.org\/id\/kemiringan-tren-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Kemiringan Garis Tren di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/penyesuaian-kurva-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan pencocokan kurva di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mencari titik potong dua garis lurus di Google Sheets: 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 [&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 Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan perpotongan dua garis di Google Sheets, 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\/temukan-perpotongan-dua-garis-google-sheet\/\" \/>\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 Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan perpotongan dua garis di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T22:55:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int11.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\/temukan-perpotongan-dua-garis-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/\",\"name\":\"Cara Menemukan Perpotongan Dua Garis di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T22:55:43+00:00\",\"dateModified\":\"2023-07-13T22:55:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan perpotongan dua garis di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencari perpotongan dua garis 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 Menemukan Perpotongan Dua Garis di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menemukan perpotongan dua garis di Google Sheets, 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\/temukan-perpotongan-dua-garis-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menemukan Perpotongan Dua Garis di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menemukan perpotongan dua garis di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-13T22:55:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int11.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\/temukan-perpotongan-dua-garis-google-sheet\/","url":"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/","name":"Cara Menemukan Perpotongan Dua Garis di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T22:55:43+00:00","dateModified":"2023-07-13T22:55:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan perpotongan dua garis di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/temukan-perpotongan-dua-garis-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencari perpotongan dua garis 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\/4048"}],"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=4048"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4048\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}