{"id":1271,"date":"2023-07-27T01:48:37","date_gmt":"2023-07-27T01:48:37","guid":{"rendered":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/"},"modified":"2023-07-27T01:48:37","modified_gmt":"2023-07-27T01:48:37","slug":"interpolasi-nilai-yang-hilang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/","title":{"rendered":"Cara menginterpolasi nilai yang hilang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Sering kali Anda memiliki satu atau lebih nilai yang hilang dalam rangkaian di Excel yang ingin Anda isi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara termudah untuk mengisi nilai yang hilang adalah dengan menggunakan fungsi <strong>Isi Seri<\/strong> di bagian <strong>Edit<\/strong> pada tab <strong>Beranda<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12509 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill1.png\" alt=\"Opsi pengisian seri di Excel\" width=\"484\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan dua contoh cara menggunakan fitur ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Isikan nilai yang hilang untuk tren linier<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut dengan beberapa nilai yang hilang di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12510 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill2.png\" alt=\"Interpolasi nilai yang hilang di Excel\" width=\"404\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita membuat grafik garis cepat dari data ini, kita akan melihat bahwa data tersebut tampak mengikuti tren linier:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12512 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill3.png\" alt=\"\" width=\"578\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengisi nilai yang hilang, kita dapat menyorot rentang yang dimulai sebelum dan sesudah nilai yang hilang, lalu klik <strong>Beranda &gt; Edit &gt; Isi &gt; Seri<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12513 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill4.png\" alt=\"Linear mengisi rangkaian di Excel\" width=\"536\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita membiarkan Type sebagai <strong>Linear<\/strong> , Excel akan menggunakan rumus berikut untuk menentukan nilai langkah yang akan digunakan untuk mengisi data yang hilang:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Langkah = (Akhir \u2013 Mulai) \/ (#Ob Hilang + 1)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, menentukan nilai langkah menjadi: (35-20) \/ (4+1) = <strong>3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita klik <strong>OK<\/strong> , Excel secara otomatis akan mengisi nilai yang hilang dengan menambahkan 3 pada setiap nilai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12514 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill5.png\" alt=\"\" width=\"474\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Isikan nilai yang hilang untuk tren pertumbuhan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut dengan beberapa nilai yang hilang di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12515 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill6.png\" alt=\"\" width=\"426\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita membuat grafik garis cepat dari data ini, kita akan melihat bahwa data tersebut tampak mengikuti tren eksponensial (atau &#8220;berkembang&#8221;):<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12516 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill7.png\" alt=\"\" width=\"536\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengisi nilai yang hilang, kita dapat menyorot rentang yang dimulai sebelum dan sesudah nilai yang hilang, lalu klik <strong>Beranda &gt; Edit &gt; Isi &gt; Seri<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12517 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill8.png\" alt=\"\" width=\"495\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita memilih Type as <strong>Growth<\/strong> dan mengklik kotak di sebelah <strong>Trend<\/strong> , Excel secara otomatis mengidentifikasi tren pertumbuhan dalam data dan mengisi nilai yang hilang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita mengklik <strong>OK<\/strong> , Excel mengisi nilai yang hilang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12518 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill9.png\" alt=\"Interpolasi nilai yang hilang di Excel\" width=\"551\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari grafik terlihat bahwa nilai yang dimasukkan cukup sesuai dengan tren umum data.<\/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>Sering kali Anda memiliki satu atau lebih nilai yang hilang dalam rangkaian di Excel yang ingin Anda isi. Cara termudah untuk mengisi nilai yang hilang adalah dengan menggunakan fungsi Isi Seri di bagian Edit pada tab Beranda . Tutorial ini memberikan dua contoh cara menggunakan fitur ini dalam praktik. Contoh 1: Isikan nilai yang hilang [&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 Interpolasi Nilai yang Hilang di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang dalam suatu rangkaian 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\/interpolasi-nilai-yang-hilang-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Interpolasi Nilai yang Hilang di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang dalam suatu rangkaian di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:48:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill1.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-nilai-yang-hilang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/\",\"name\":\"Cara Interpolasi Nilai yang Hilang di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T01:48:37+00:00\",\"dateModified\":\"2023-07-27T01:48:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang dalam suatu rangkaian di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menginterpolasi nilai yang hilang 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 Interpolasi Nilai yang Hilang di Excel - Statologi","description":"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang dalam suatu rangkaian 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\/interpolasi-nilai-yang-hilang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Interpolasi Nilai yang Hilang di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang dalam suatu rangkaian di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:48:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill1.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-nilai-yang-hilang-excel\/","url":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/","name":"Cara Interpolasi Nilai yang Hilang di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T01:48:37+00:00","dateModified":"2023-07-27T01:48:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang dalam suatu rangkaian di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menginterpolasi nilai yang hilang 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\/1271"}],"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=1271"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1271\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}