{"id":1270,"date":"2023-07-27T01:53:58","date_gmt":"2023-07-27T01:53:58","guid":{"rendered":"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/"},"modified":"2023-07-27T01:53:58","modified_gmt":"2023-07-27T01:53:58","slug":"interpolasi-linier-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/","title":{"rendered":"Interpolasi linier di excel: contoh langkah demi langkah"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Interpolasi<\/strong> adalah proses memperkirakan nilai suatu fungsi yang tidak diketahui antara dua nilai yang diketahui.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Diberikan dua nilai yang diketahui (x <sub>1<\/sub> , y <sub>1<\/sub> ) dan (x <sub>2<\/sub> , y <sub>2<\/sub> ), kita dapat memperkirakan nilai y untuk suatu titik x menggunakan rumus berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = kamu <sub>1<\/sub> + (xx <sub>1<\/sub> )(kamu <sub>2<\/sub> -kamu <sub>1<\/sub> )\/(x <sub>2<\/sub> -x <sub>1<\/sub> )<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menggunakan interpolasi linier untuk mencari nilai y yang tidak diketahui berdasarkan nilai x di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Interpolasi linier di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12500 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intlineaire1.png\" alt=\"\" width=\"355\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita membuat grafik singkat datanya, tampilannya akan seperti ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12501 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intlineaire2.png\" alt=\"Interpolasi linier di Excel\" width=\"552\" height=\"431\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari nilai y yang terkait dengan nilai x baru sebesar <strong>13<\/strong> . Kita dapat melihat bahwa kita <em>mengukur<\/em> nilai y untuk nilai x sebesar 12 dan 14, tetapi tidak untuk nilai x sebesar 13.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk melakukan interpolasi linier di Excel untuk mencari perkiraan nilai y:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 13px;\"> <strong>= <span style=\"color: #3366ff;\">FORECAST<\/span> (NewX, <span style=\"color: #993300;\">OFFSET<\/span> (KnownY, <span style=\"color: #ff6600;\">MATCH<\/span> (NewX,KnownX,1)-1,0,2), <span style=\"color: #993300;\">OFFSET<\/span> (KnownX, <span style=\"color: #ff6600;\">MATCH<\/span> (NewX,KnownX,1)-1,0,2))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan fungsi ini untuk memperkirakan nilai y yang terkait dengan nilai x 13:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12503 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int3lineaire.png\" alt=\"Contoh Excel Interpolasi Linier\" width=\"671\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Estimasi nilai y ternyata <strong>33,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita menambahkan titik (13, 33.5) ke plot kita, sepertinya fungsinya cukup cocok:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12504 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/int4lineaire.png\" alt=\"Contoh interpolasi linier\" width=\"495\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus ini untuk memperkirakan nilai y dari setiap nilai x hanya dengan mengganti <strong>NewX<\/strong> dalam rumus tersebut dengan nilai x baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa agar fungsi ini berfungsi, nilai X yang baru harus berada dalam rentang nilai X yang ada.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan lebih banyak tutorial Excel di sini .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Interpolasi adalah proses memperkirakan nilai suatu fungsi yang tidak diketahui antara dua nilai yang diketahui. Diberikan dua nilai yang diketahui (x 1 , y 1 ) dan (x 2 , y 2 ), kita dapat memperkirakan nilai y untuk suatu titik x menggunakan rumus berikut: kamu = kamu 1 + (xx 1 )(kamu 2 -kamu [&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>Interpolasi linier di Excel: contoh langkah demi langkah - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan interpolasi linier 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\/interpolasi-linier-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Interpolasi linier di Excel: contoh langkah demi langkah - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan interpolasi linier di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:53:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intlineaire1.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\/interpolasi-linier-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/\",\"name\":\"Interpolasi linier di Excel: contoh langkah demi langkah - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T01:53:58+00:00\",\"dateModified\":\"2023-07-27T01:53:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan interpolasi linier di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Interpolasi linier di excel: contoh langkah demi langkah\"}]},{\"@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":"Interpolasi linier di Excel: contoh langkah demi langkah - Statologi","description":"Tutorial ini menjelaskan cara melakukan interpolasi linier 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\/interpolasi-linier-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Interpolasi linier di Excel: contoh langkah demi langkah - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan interpolasi linier di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:53:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intlineaire1.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\/interpolasi-linier-excel\/","url":"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/","name":"Interpolasi linier di Excel: contoh langkah demi langkah - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T01:53:58+00:00","dateModified":"2023-07-27T01:53:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan interpolasi linier di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/interpolasi-linier-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/interpolasi-linier-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Interpolasi linier di excel: contoh langkah demi langkah"}]},{"@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\/1270"}],"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=1270"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1270\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}