{"id":2291,"date":"2023-07-22T22:06:58","date_gmt":"2023-07-22T22:06:58","guid":{"rendered":"https:\/\/statorials.org\/id\/cagr-lembar-google\/"},"modified":"2023-07-22T22:06:58","modified_gmt":"2023-07-22T22:06:58","slug":"cagr-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cagr-lembar-google\/","title":{"rendered":"Cara menghitung cagr di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"

<\/p>\n

\n

Akronim CAGR<\/strong> adalah singkatan dari tingkat pertumbuhan tahunan gabungan<\/strong> , yang merupakan rata-rata tingkat pertumbuhan pendapatan tahunan selama periode waktu tertentu.<\/span><\/p>\n

Rumus untuk menghitung CAGR adalah:<\/span><\/p>\n

CAGR = (nilai masa depan \/ nilai sekarang) 1\/periode<\/sup> \u2013 1<\/span><\/p>\n

Contoh berikut menunjukkan dua cara yang setara untuk menghitung CAGR di Google Spreadsheet.<\/span><\/p>\n

Metode 1: Hitung CAGR secara manual<\/strong><\/span><\/h3>\n

Kita dapat menggunakan rumus berikut untuk menghitung CAGR secara manual di Google Sheets:<\/span><\/p>\n

 =<\/span> (<\/span> ENDING_VALUE<\/span> \/ STARTING_VALUE<\/span><\/span> )<\/span> ^<\/span> (<\/span> 1<\/span> \/<\/span> PERIODS<\/span> )<\/span> -<\/span> 1<\/span>\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini untuk menghitung CAGR untuk investasi yang dimulai pada $1.000 dan berakhir pada $5.000 setelah 9 periode investasi:<\/span> <\/p>\n
\"Rumus<\/p>\n
 CAGR-nya adalah 19,58%<\/strong> . Ini mewakili tingkat pertumbuhan tahunan gabungan dari investasi selama 9 periode investasi ini.<\/span><\/p>\n
 Kami dapat memastikan bahwa jawaban ini benar dengan menghitung pertumbuhan investasi awal sebesar $1.000 jika tumbuh secara konsisten sebesar 19,58% setiap tahun selama 9 tahun:<\/span> <\/p>\n
\"\"<\/p>\n
 Metode 2: Hitung CAGR menggunakan fungsi RRI<\/strong><\/span><\/h3>\n
 Cara lain untuk menghitung CAGR di Google Sheets adalah dengan menggunakan fungsi RRI<\/strong> , yang menggunakan sintaks berikut:<\/span><\/p>\n
 RRI (jumlah periode, nilai awal, nilai akhir)<\/strong><\/span><\/p>\n
 Tangkapan layar berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya:<\/span> <\/p>\n
\"Fungsi<\/p>\n
 CAGR-nya adalah 19,58%<\/strong> .<\/span><\/p>\n
 Ini cocok dengan nilai yang kita hitung secara manual menggunakan metode sebelumnya.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara Menghitung Rata-Rata Pergerakan Eksponensial di Google Spreadsheet
 Cara Membuat Matriks Korelasi di Google Sheets<\/a>
 Cara menemukan baris yang paling sesuai di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Akronim CAGR adalah singkatan dari tingkat pertumbuhan tahunan gabungan , yang merupakan rata-rata tingkat pertumbuhan pendapatan tahunan selama periode waktu tertentu. Rumus untuk menghitung CAGR adalah: CAGR = (nilai masa depan \/ nilai sekarang) 1\/periode \u2013 1 Contoh berikut menunjukkan dua cara yang setara untuk menghitung CAGR di Google Spreadsheet. Metode 1: Hitung CAGR secara […]<\/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":"\nCara Menghitung CAGR di Google Sheets (Langkah demi Langkah) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung CAGR (tingkat pertumbuhan tahunan gabungan) di Google Spreadsheet, 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\/cagr-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung CAGR di Google Sheets (Langkah demi Langkah) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung CAGR (tingkat pertumbuhan tahunan gabungan) di Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cagr-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T22:06:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cagr1.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\/cagr-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/cagr-lembar-google\/\",\"name\":\"Cara Menghitung CAGR di Google Sheets (Langkah demi Langkah) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T22:06:58+00:00\",\"dateModified\":\"2023-07-22T22:06:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung CAGR (tingkat pertumbuhan tahunan gabungan) di Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cagr-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cagr-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cagr-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung cagr di google spreadsheet (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":"Cara Menghitung CAGR di Google Sheets (Langkah demi Langkah) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghitung CAGR (tingkat pertumbuhan tahunan gabungan) di Google Spreadsheet, 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\/cagr-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung CAGR di Google Sheets (Langkah demi Langkah) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghitung CAGR (tingkat pertumbuhan tahunan gabungan) di Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/cagr-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-22T22:06:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cagr1.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\/cagr-lembar-google\/","url":"https:\/\/statorials.org\/id\/cagr-lembar-google\/","name":"Cara Menghitung CAGR di Google Sheets (Langkah demi Langkah) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T22:06:58+00:00","dateModified":"2023-07-22T22:06:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung CAGR (tingkat pertumbuhan tahunan gabungan) di Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cagr-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cagr-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cagr-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung cagr di google spreadsheet (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\/2291"}],"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=2291"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2291\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}