{"id":1059,"date":"2023-07-27T19:54:29","date_gmt":"2023-07-27T19:54:29","guid":{"rendered":"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/"},"modified":"2023-07-27T19:54:29","modified_gmt":"2023-07-27T19:54:29","slug":"koefisien-variasi-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/","title":{"rendered":"Cara menghitung koefisien variasi di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Koefisien variasi<\/strong> , sering disingkat <em>CV<\/em> , adalah cara mengukur penyebaran nilai dalam kumpulan data relatif terhadap mean. Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">CV = \u03c3 \/ \u03bc<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03c3 :<\/strong> deviasi standar kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc:<\/strong> rata-rata kumpulan data<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Sederhananya, koefisien variasi hanyalah rasio deviasi standar terhadap mean.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Kapan menggunakan koefisien variasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Koefisien variasi sering digunakan untuk membandingkan variasi antara dua kumpulan data yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di dunia nyata, ini sering digunakan di bidang keuangan untuk membandingkan rata-rata pengembalian yang diharapkan dari suatu investasi dengan deviasi standar yang diharapkan dari investasi tersebut. Hal ini memungkinkan investor untuk membandingkan tradeoff risiko-pengembalian antar investasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, seorang investor sedang mempertimbangkan untuk berinvestasi pada dua reksa dana berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Reksa Dana A: mean = 7%, standar deviasi = 12,4%<\/span><\/p>\n<p> <span style=\"color: #000000;\">UCITS B: rata-rata = 5%, standar deviasi = 8,2%<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan menghitung koefisien variasi masing-masing dana, investor mencatat:<\/span><\/p>\n<p> <span style=\"color: #000000;\">CV reksa dana A = 12,4% \/ 7% = <strong>1,77<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">CV Reksa Dana B = 8,2% \/ 5% = <strong>1,64<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena Reksa Dana B memiliki koefisien variasi yang lebih rendah, maka Reksa Dana B memberikan imbal hasil rata-rata yang lebih baik dibandingkan dengan standar deviasi.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Koefisien Variasi di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tidak ada fungsi bawaan di Google Spreadsheet untuk menghitung koefisien variasi kumpulan data, tetapi penghitungannya relatif mudah menggunakan rumus sederhana.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang berisi 20 nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10915 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cvfeuilles1-1.png\" alt=\"\" width=\"456\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung koefisien variasi kumpulan data ini, Anda hanya perlu mengetahui dua angka: mean dan deviasi standar. Ini dapat dihitung menggunakan rumus berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10916 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cvfeuilles2.png\" alt=\"\" width=\"489\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung koefisien variasi, kita membagi simpangan baku dengan mean:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10917 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cvfeuilles3.png\" alt=\"Koefisien variasi di Google Sheets\" width=\"539\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koefisien variasinya ternyata <strong>0,0864<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Koefisien Variasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/koefisien-variasi-spss\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Koefisien Variasi di SPSS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Koefisien variasi , sering disingkat CV , adalah cara mengukur penyebaran nilai dalam kumpulan data relatif terhadap mean. Ini dihitung sebagai berikut: CV = \u03c3 \/ \u03bc Emas: \u03c3 : deviasi standar kumpulan data \u03bc: rata-rata kumpulan data Sederhananya, koefisien variasi hanyalah rasio deviasi standar terhadap mean. Kapan menggunakan koefisien variasi Koefisien variasi sering digunakan [&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 Koefisien Variasi di Google Sheets<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung koefisien variasi suatu dataset di Google Sheets.\" \/>\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\/koefisien-variasi-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 Koefisien Variasi di Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung koefisien variasi suatu dataset di Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T19:54:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cvfeuilles1-1.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\/koefisien-variasi-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/\",\"name\":\"Cara Menghitung Koefisien Variasi di Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T19:54:29+00:00\",\"dateModified\":\"2023-07-27T19:54:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung koefisien variasi suatu dataset di Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung koefisien variasi di google sheets\"}]},{\"@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 Koefisien Variasi di Google Sheets","description":"Penjelasan sederhana tentang cara menghitung koefisien variasi suatu dataset di Google Sheets.","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\/koefisien-variasi-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Koefisien Variasi di Google Sheets","og_description":"Penjelasan sederhana tentang cara menghitung koefisien variasi suatu dataset di Google Sheets.","og_url":"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-27T19:54:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cvfeuilles1-1.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\/koefisien-variasi-lembar-google\/","url":"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/","name":"Cara Menghitung Koefisien Variasi di Google Sheets","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T19:54:29+00:00","dateModified":"2023-07-27T19:54:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung koefisien variasi suatu dataset di Google Sheets.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/koefisien-variasi-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung koefisien variasi di google sheets"}]},{"@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\/1059"}],"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=1059"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1059\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}