{"id":3262,"date":"2023-07-18T10:01:27","date_gmt":"2023-07-18T10:01:27","guid":{"rendered":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/"},"modified":"2023-07-18T10:01:27","modified_gmt":"2023-07-18T10:01:27","slug":"interpolasi-nilai-yang-hilang-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/","title":{"rendered":"Cara menginterpolasi nilai yang hilang di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Sering kali Anda memiliki satu atau lebih nilai yang hilang dalam rangkaian Google Spreadsheet yang ingin Anda isi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menginterpolasi nilai yang hilang dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data di Google Spreadsheet yang berisi nilai yang hilang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27654 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-interpolees1.jpg\" alt=\"\" width=\"521\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung nilai langkah<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus berikut untuk menentukan nilai langkah mana yang akan digunakan untuk mengisi data yang hilang:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Langkah<\/strong> = (Akhir \u2013 Mulai) \/ (#Pengamatan yang hilang + 1)<\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kami akan menghitung nilai langkah sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Langkah = (35 \u2013 20) \/ (4 \u2013 1) = <strong>3<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D1<\/strong> untuk menghitung nilai ini secara otomatis:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A13<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">-<\/span> <span dir=\"auto\" style=\"color: #800080;\">A8<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">\/<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">COUNTBLANK<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #008080;\">A9:A12<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">+<\/span> <span class=\"number\" dir=\"auto\">1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/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-27655 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpoler-les-feuilles2.jpg\" alt=\"\" width=\"483\" height=\"510\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Interpolasi Nilai yang Hilang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menambahkan nilai langkah ke nilai yang hilang, dimulai dengan nilai pertama yang hilang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27656 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpoler-les-feuilles3.jpg\" alt=\"\" width=\"390\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel kosong yang tersisa:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27657 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpoler-les-feuilles4.jpg\" alt=\"\" width=\"376\" height=\"516\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Lihat nilai yang diinterpolasi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat membuat diagram garis untuk melihat apakah nilai yang diinterpolasi tampaknya cocok dengan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk melakukannya, sorot sel <strong>A2:A21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, pilih <strong>Line Chart<\/strong> sebagai <strong>Chart Type<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Akan muncul grafik garis berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27658 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpoler-les-feuilles5.jpg\" alt=\"\" width=\"579\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai yang diinterpolasi tampaknya sangat cocok dengan tren kumpulan data.<\/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> <a href=\"https:\/\/statorials.org\/id\/google-sheet-beberapa-garis-tren\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan beberapa garis tren ke grafik di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-garis-vertikal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis vertikal ke grafik di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-rata-rata-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis rata-rata ke grafik di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sering kali Anda memiliki satu atau lebih nilai yang hilang dalam rangkaian Google Spreadsheet yang ingin Anda isi. Contoh langkah demi langkah berikut menunjukkan cara menginterpolasi nilai yang hilang dalam praktiknya. Langkah 1: Buat datanya Pertama, mari buat kumpulan data di Google Spreadsheet yang berisi nilai yang hilang: Langkah 2: Hitung nilai langkah Selanjutnya kita [&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 menginterpolasi nilai yang hilang di Google Spreadsheet \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang di Google Sheets, 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-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menginterpolasi nilai yang hilang di Google Spreadsheet \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T10:01:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-interpolees1.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=\"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-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/\",\"name\":\"Cara menginterpolasi nilai yang hilang di Google Spreadsheet \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T10:01:27+00:00\",\"dateModified\":\"2023-07-18T10:01:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menginterpolasi nilai yang hilang di google spreadsheet\"}]},{\"@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 menginterpolasi nilai yang hilang di Google Spreadsheet \u2013 Statologi","description":"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang di Google Sheets, 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-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menginterpolasi nilai yang hilang di Google Spreadsheet \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-18T10:01:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-interpolees1.jpg"}],"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-lembar-google\/","url":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/","name":"Cara menginterpolasi nilai yang hilang di Google Spreadsheet \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T10:01:27+00:00","dateModified":"2023-07-18T10:01:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menginterpolasi nilai yang hilang di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menginterpolasi nilai yang hilang di google spreadsheet"}]},{"@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\/3262"}],"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=3262"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3262\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}