{"id":4001,"date":"2023-07-14T06:05:22","date_gmt":"2023-07-14T06:05:22","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/"},"modified":"2023-07-14T06:05:22","modified_gmt":"2023-07-14T06:05:22","slug":"excel-temukan-y-intersepsi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/","title":{"rendered":"Cara menemukan perpotongan y pada grafik di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Perpotongan<\/strong> y pada suatu grafik menyatakan titik potong garis pada sumbu y ketika x sama dengan nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari perpotongan y suatu baris di Excel, kita dapat menggunakan fungsi <strong>INTERCEPT<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>INTERCEPT (diketahui_y, diketahui_x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>unknown_y&#8217;s<\/strong> : kisaran nilai y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>unknown_x&#8217;s<\/strong> : rentang nilai x<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi ini dalam praktiknya untuk menghitung perpotongan y pada bagan di Excel.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Buat datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data dengan dua variabel di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31998 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph1.jpg\" alt=\"\" width=\"441\" height=\"468\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung nilai Y asli<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, ketik rumus berikut ke dalam sel <strong>E1<\/strong> untuk menghitung intersep kumpulan data ini:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INTERCEPT( <span style=\"color: #3366ff;\">B2:B21<\/span> , <span style=\"color: #ff0000;\">A2:A21<\/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-32006 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/yint1.jpg\" alt=\"\" width=\"483\" height=\"521\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari outputnya terlihat bahwa titik potong y adalah <strong>12.46176<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Visualisasikan nilai Y asli<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk memvisualisasikan nilai intersep, kita dapat membuat plot sebar dan menambahkan garis tren.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot nilai dalam rentang <strong>A2:B21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Sisipkan Plot Sebar (X,Y)<\/strong> di grup <strong>Bagan<\/strong> dan klik opsi pertama untuk membuat Awan titik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13892 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignereg2.png\" alt=\"\" width=\"455\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul plot sebar berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31999 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph2.jpg\" alt=\"\" width=\"659\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya klik tanda plus berwarna hijau di pojok kanan atas plot, lalu klik tanda panah di samping <strong>Trendline<\/strong> dan klik <strong>More Options<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32007 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/yint2.jpg\" alt=\"\" width=\"680\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada panel <strong>Format Trendline<\/strong> yang muncul di sisi kanan layar, klik opsi <strong>Linear<\/strong> Trendline, lalu centang kotak di samping <strong>Show Equation on Chart<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32008 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/yint3.jpg\" alt=\"\" width=\"322\" height=\"654\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Garis tren linier dan persamaan garis tren linier akan ditampilkan pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32009 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/yint4.jpg\" alt=\"\" width=\"572\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat rumus garis tren linier:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 0,917x + 12,462<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya ketika x sama dengan nol, nilai taksiran y (yaitu intersep) adalah <strong>12.462<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita bayangkan garis tren linier memanjang ke kiri hingga mencapai sumbu y, maka memang terlihat garis tersebut akan melintasi sumbu y dengan nilai y = <strong>12,462<\/strong> .<\/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\/plot-sebar-matriks-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Matriks Scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/label-plot-sebar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Label ke Scatterplot Point di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-scatter-plot-beberapa-seri\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Scatter Plot dengan Beberapa Seri di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Perpotongan y pada suatu grafik menyatakan titik potong garis pada sumbu y ketika x sama dengan nol. Untuk mencari perpotongan y suatu baris di Excel, kita dapat menggunakan fungsi INTERCEPT . Fungsi ini menggunakan sintaks berikut: INTERCEPT (diketahui_y, diketahui_x) Emas: unknown_y&#8217;s : kisaran nilai y unknown_x&#8217;s : rentang nilai x Contoh berikut memperlihatkan cara menggunakan [&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 mencari perpotongan y suatu grafik di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari titik potong y pada grafik 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\/excel-temukan-y-intersepsi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mencari perpotongan y suatu grafik di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari titik potong y pada grafik garis di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T06:05:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph1.jpg\" \/>\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\/excel-temukan-y-intersepsi\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/\",\"name\":\"Cara mencari perpotongan y suatu grafik di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T06:05:22+00:00\",\"dateModified\":\"2023-07-14T06:05:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari titik potong y pada grafik garis di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menemukan perpotongan y pada grafik 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 mencari perpotongan y suatu grafik di Excel - Statologi","description":"Tutorial ini menjelaskan cara mencari titik potong y pada grafik 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\/excel-temukan-y-intersepsi\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mencari perpotongan y suatu grafik di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara mencari titik potong y pada grafik garis di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/","og_site_name":"Statorials","article_published_time":"2023-07-14T06:05:22+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/corrgraph1.jpg"}],"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\/excel-temukan-y-intersepsi\/","url":"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/","name":"Cara mencari perpotongan y suatu grafik di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T06:05:22+00:00","dateModified":"2023-07-14T06:05:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari titik potong y pada grafik garis di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-temukan-y-intersepsi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menemukan perpotongan y pada grafik 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\/4001"}],"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=4001"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4001\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}