{"id":577,"date":"2023-07-29T11:03:43","date_gmt":"2023-07-29T11:03:43","guid":{"rendered":"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/"},"modified":"2023-07-29T11:03:43","modified_gmt":"2023-07-29T11:03:43","slug":"koefisien-variasi-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/","title":{"rendered":"Cara menghitung koefisien variasi di excel"},"content":{"rendered":"

<\/p>\n

\n

Koefisien variasi<\/strong> , sering disingkat CV, adalah cara mengukur penyebaran nilai dalam suatu kumpulan data relatif terhadap mean. Ini dihitung sebagai berikut:<\/span><\/p>\n

CV<\/strong> = \u03c3 \/ \u03bc<\/span><\/p>\n

Emas:<\/span><\/p>\n

\u03c3 = deviasi standar kumpulan data<\/span><\/p>\n

\u03bc = rata-rata kumpulan data<\/span><\/p>\n

Dalam bentuknya yang paling sederhana, koefisien variasi hanyalah rasio deviasi standar terhadap mean.<\/span><\/p>\n

Kapan koefisien variasi digunakan?<\/strong><\/span><\/h2>\n

Koefisien variasi sering digunakan untuk membandingkan variasi antara dua kumpulan data yang berbeda.<\/span><\/p>\n

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

Misalnya, seorang investor sedang mempertimbangkan untuk berinvestasi pada dua reksa dana berikut:<\/span><\/p>\n

Reksa Dana A: mean = 7%, standar deviasi = 12,4%<\/span><\/p>\n

UCITS B: rata-rata = 5%, standar deviasi = 8,2%<\/span><\/p>\n

Dengan menghitung koefisien variasi masing-masing dana, investor mencatat:<\/span><\/p>\n

CV reksa dana A = 12,4% \/ 7% = 1,77<\/strong><\/span><\/p>\n

CV Reksa Dana B = 8,2% \/ 5% = 1,64<\/strong><\/span><\/p>\n

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

Cara Menghitung Koefisien Variasi di Excel<\/strong><\/span><\/h2>\n

Tidak ada rumus bawaan di Excel untuk menghitung koefisien variasi kumpulan data, namun untungnya menghitungnya relatif mudah menggunakan beberapa rumus sederhana. Contoh berikut mengilustrasikan cara menghitung koefisien variasi untuk kumpulan data tertentu.<\/span><\/p>\n

Misalkan kita memiliki dataset berikut yang berisi hasil ujian 20 siswa:<\/span> <\/p>\n

\"Contoh<\/p>\n

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

Rata-rata: = RATA-RATA (A2:A21)<\/strong><\/span><\/p>\n

Deviasi standar: =STDEV(A2:A21)<\/strong><\/span> <\/p>\n

\"Menghitung<\/p>\n

Untuk menghitung koefisien variasi, kita membagi simpangan baku dengan mean:<\/span> <\/p>\n

\"Koefisien<\/p>\n

Koefisien variasinya ternyata 0,0864<\/strong> .<\/span><\/p>\n

Perhatikan bahwa kita juga bisa menggunakan rumus tunggal untuk menghitung CV:<\/span> <\/p>\n

\"Rumus<\/p>\n

Ini memberikan CV yang sama sebesar 0,0864<\/strong> .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Koefisien variasi , sering disingkat CV, adalah cara mengukur penyebaran nilai dalam suatu kumpulan data relatif terhadap mean. Ini dihitung sebagai berikut: CV = \u03c3 \/ \u03bc Emas: \u03c3 = deviasi standar kumpulan data \u03bc = rata-rata kumpulan data Dalam bentuknya yang paling sederhana, koefisien variasi hanyalah rasio deviasi standar terhadap mean. Kapan koefisien variasi […]<\/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 koefisien variasi di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung koefisien variasi di excel beserta contohnya.\" \/>\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-unggul\/\" \/>\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 Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung koefisien variasi di excel beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T11:03:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv0.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-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/\",\"name\":\"Cara menghitung koefisien variasi di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T11:03:43+00:00\",\"dateModified\":\"2023-07-29T11:03:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung koefisien variasi di excel beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung koefisien variasi 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 menghitung koefisien variasi di Excel - Statorials","description":"Penjelasan sederhana cara menghitung koefisien variasi di excel beserta contohnya.","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-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung koefisien variasi di Excel - Statorials","og_description":"Penjelasan sederhana cara menghitung koefisien variasi di excel beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-29T11:03:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cv0.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-unggul\/","url":"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/","name":"Cara menghitung koefisien variasi di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T11:03:43+00:00","dateModified":"2023-07-29T11:03:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung koefisien variasi di excel beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung koefisien variasi 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\/577"}],"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=577"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}