{"id":2300,"date":"2023-07-22T21:15:09","date_gmt":"2023-07-22T21:15:09","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/"},"modified":"2023-07-22T21:15:09","modified_gmt":"2023-07-22T21:15:09","slug":"persentase-perubahan-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/","title":{"rendered":"Cara menghitung persentase perubahan di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Persentase perubahan<\/strong> nilai antara satu periode dengan periode lainnya dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Persentase perubahan = (Nilai <sub>2<\/sub> \u2013 Nilai <sub>1<\/sub> ) \/ Nilai <sub>1<\/sub> * 100<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, sebuah perusahaan memiliki 50 penjualan dalam satu bulan, lalu 56 penjualan pada bulan berikutnya. Kita dapat menggunakan rumus berikut untuk menghitung persentase perubahan penjualan dari bulan ke bulan:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Persentase perubahan = (Nilai <sub>2<\/sub> \u2013 Nilai <sub>1<\/sub> ) \/ Nilai <sub>1<\/sub> * 100<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase perubahan = (56 \u2013 50) \/ 50 * 100<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase perubahan = 12%<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa penjualan meningkat sebesar 12% dari bulan pertama ke bulan kedua.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase perubahan di Google Sheets, kita bisa menggunakan rumus berikut:<\/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\">to_percent<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">-<\/span> <span dir=\"auto\" style=\"color: #800080;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">\/ <span dir=\"auto\" style=\"color: #800080;\">A1<\/span><\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa rumus ini secara otomatis menampilkan hasilnya sebagai persentase menggunakan fungsi <strong>to_percent()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Persentase Perubahan di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan penjualan perusahaan tertentu selama 10 periode penjualan berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20914 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentagechange1.png\" alt=\"\" width=\"589\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung persentase perubahan penjualan antara periode pertama dan kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-20915\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentagechange2.png\" alt=\"perubahan persentase di Google Spreadsheet\" width=\"587\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret rumus ini ke setiap sel yang tersisa di kolom C untuk secara otomatis menghitung persentase perubahan penjualan antara setiap periode berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20916 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentagechange3.png\" alt=\"\" width=\"580\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Penjualan meningkat sebesar <strong>11%<\/strong> dari periode 1 ke periode 2.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan meningkat sebesar <strong>4%<\/strong> dari periode 2 ke periode 3.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan menurun sebesar <strong>1%<\/strong> antara periode 3 dan periode 4.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/statistik-deskriptif-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung statistik deskriptif di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung ringkasan lima digit di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Persentase perubahan nilai antara satu periode dengan periode lainnya dihitung sebagai berikut: Persentase perubahan = (Nilai 2 \u2013 Nilai 1 ) \/ Nilai 1 * 100 Misalnya, sebuah perusahaan memiliki 50 penjualan dalam satu bulan, lalu 56 penjualan pada bulan berikutnya. Kita dapat menggunakan rumus berikut untuk menghitung persentase perubahan penjualan dari bulan ke bulan: [&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 Menghitung Persentase Perubahan di Google Sheets (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persen perubahan 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\/persentase-perubahan-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Persentase Perubahan di Google Sheets (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persen perubahan di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T21:15:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentagechange1.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\/persentase-perubahan-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/\",\"name\":\"Cara Menghitung Persentase Perubahan di Google Sheets (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T21:15:09+00:00\",\"dateModified\":\"2023-07-22T21:15:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persen perubahan di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase perubahan di google sheets (dengan contoh)\"}]},{\"@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 Menghitung Persentase Perubahan di Google Sheets (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung persen perubahan 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\/persentase-perubahan-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Perubahan di Google Sheets (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung persen perubahan di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T21:15:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentagechange1.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\/persentase-perubahan-google-sheet\/","url":"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/","name":"Cara Menghitung Persentase Perubahan di Google Sheets (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T21:15:09+00:00","dateModified":"2023-07-22T21:15:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persen perubahan di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase perubahan di google sheets (dengan contoh)"}]},{"@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\/2300"}],"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=2300"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2300\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}