{"id":1813,"date":"2023-11-03T02:39:17","date_gmt":"2023-11-03T02:39:17","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/"},"modified":"2023-12-06T05:56:13","modified_gmt":"2023-12-06T05:56:13","slug":"variatiecoefficient","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/","title":{"rendered":"Hoe bereken ik de variatieco\u00ebffici\u00ebnt (cv)?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3565729342\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Om de variatieco\u00ebffici\u00ebnt in Excel te berekenen, moet u een combinatie van de functies STDEV.P en AVERAGE gebruiken.<\/p><p> In deze formule helpt STDEV.P u de standaardafwijking te bepalen, terwijl de gemiddelde functie u helpt het gemiddelde van de gegevenspunten te bepalen.<\/p><p> Uiteindelijk moet je de standaarddeviatie delen door het gemiddelde om de variatieco\u00ebffici\u00ebnt te krijgen.<\/p><p> De variatie van de co\u00ebffici\u00ebnt is een maatstaf voor de spreiding (variabiliteit) van de gegevens rond het gemiddelde. Hoe hoger de variatieco\u00ebffici\u00ebnt, hoe groter de mate van spreiding van het gemiddelde van de gegevenspunten.<\/p><p> Je kunt ook zeggen dat het hetzelfde is als het delen van de standaarddeviatie door het gemiddelde van de gegevens.<\/p><p> In het volgende voorbeeld heeft u de volgende gegevens met 7 verschillende gegevenspunten en nu moet u de CV (variatieco\u00ebffici\u00ebnt) voor deze gegevenspunten berekenen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69525\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"data-met-verschillende-datapunten\" width=\"462\" height=\"262\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om de variatieco\u00ebffici\u00ebnt in Excel te berekenen <\/h2><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69526\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-calculer-la-variation-du-coefficient.png\" sizes=\"auto, \" srcset=\"\" alt=\"berekeningsco\u00ebffici\u00ebnt-variatie\" width=\"581\" height=\"246\"><\/figure><\/div><ol type=\"1\"><li> Voer eerst STDEV.P in cel F1 in, verwijs naar het bereik A1 tot en met E1 en sluit de functie.<\/li><li> Voer daarna de divisie-operator in.<\/li><li> Voer vervolgens de gemiddelde functie in na deze delingsoperator.<\/li><li> Zie nu bereik A1 tot E1.<\/li><li> Voer aan het einde de afsluitende haakjes in en druk op Enter om het resultaat te krijgen.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=STDEV.P(A1:E1)\/AVERAGE(A1:E1)<\/code><\/pre><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> u moet de celnotatie wijzigen in een percentagenotatie.<\/p><p> Om deze formule te begrijpen, moeten we deze formule in twee delen verdelen, zoals ik al eerder zei. In het eerste deel hebben we dus de STDEV.P-functie die de standaardafwijking berekent, waarbij logische waarden en lege cellen worden genegeerd. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69527\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-diviser-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"deel de formule\" width=\"603\" height=\"264\"><\/figure><\/div><p> En in het tweede deel hebben we de gemiddelde functie die het gemiddelde van de datapunten berekent. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69528\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-moyenne-en-deuxieme-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"gemiddelde-functie-in-het-tweede-deel\" width=\"674\" height=\"246\"><\/figure><\/div><p> Als je 2,82842712474619 deelt door 63, krijg je uiteindelijk 0,04, en als je het omzet naar een percentage, krijg je 4%. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Haal het Excel-bestand op<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/variation-du-coefficient.xlsx\" rel=\"nofollow\">Downloaden<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/maximaal-als\/\">MAX ALS in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/rapport\/\">Bereken snel de verhouding in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/laagste-waarde\/\">Zoek de laagste waarde uit een lijst met getallen (N)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kleinste-waarde-2\/\">Zoek de kleinste waarde in een celbereik (kleinste getal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/nde-wortel-2\/\">Bereken de n-de wortel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1813","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Hoe bereken ik de variatieco\u00ebffici\u00ebnt (CV) in Excel?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u in Excel een formule schrijft waarmee u de variatieco\u00ebffici\u00ebnt kunt vinden\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe bereken ik de variatieco\u00ebffici\u00ebnt (CV) in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u in Excel een formule schrijft waarmee u de variatieco\u00ebffici\u00ebnt kunt vinden\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:56:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/\",\"name\":\"\u25b7 Hoe bereken ik de variatieco\u00ebffici\u00ebnt (CV) in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\",\"datePublished\":\"2023-11-03T02:39:17+00:00\",\"dateModified\":\"2023-12-06T05:56:13+00:00\",\"description\":\"In deze zelfstudie leert u hoe u in Excel een formule schrijft waarmee u de variatieco\u00ebffici\u00ebnt kunt vinden\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe bereken ik de variatieco\u00ebffici\u00ebnt (cv)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe bereken ik de variatieco\u00ebffici\u00ebnt (CV) in Excel?","description":"In deze zelfstudie leert u hoe u in Excel een formule schrijft waarmee u de variatieco\u00ebffici\u00ebnt kunt vinden","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:\/\/exceladvisor.org\/nl\/variatiecoefficient\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe bereken ik de variatieco\u00ebffici\u00ebnt (CV) in Excel?","og_description":"In deze zelfstudie leert u hoe u in Excel een formule schrijft waarmee u de variatieco\u00ebffici\u00ebnt kunt vinden","og_url":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:56:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/","url":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/","name":"\u25b7 Hoe bereken ik de variatieco\u00ebffici\u00ebnt (CV) in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png","datePublished":"2023-11-03T02:39:17+00:00","dateModified":"2023-12-06T05:56:13+00:00","description":"In deze zelfstudie leert u hoe u in Excel een formule schrijft waarmee u de variatieco\u00ebffici\u00ebnt kunt vinden","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-avec-differents-points-de-donnees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/variatiecoefficient\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe bereken ik de variatieco\u00ebffici\u00ebnt (cv)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1813"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1813\/revisions"}],"predecessor-version":[{"id":3040,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1813\/revisions\/3040"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}