{"id":56118,"date":"2020-04-22T09:09:44","date_gmt":"2020-04-22T08:09:44","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=56118"},"modified":"2020-04-18T09:21:14","modified_gmt":"2020-04-18T08:21:14","slug":"normaalverdeling-tekenen-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/normaalverdeling-tekenen-in-excel\/","title":{"rendered":"Normaalverdeling tekenen in Excel"},"content":{"rendered":"<p>V. Hoe krijg ik een normaalverdeling in Excel? Ik krijg steeds iets heel anders dan een Gausscurve.<\/p>\n<p>A. Een normaalverdeling is geen frequentieverdeling. Een frequentieverdeling is de echte verdeling van hoe dikwijls elementen voorkomen, terwijl een normaalverdeling een hypothetische verdeling is, berekend op basis van het gemiddelde en de standaarddeviatie. Bijvoorbeeld, deze set van examenresultaten:<\/p>\n<p>14<br \/>\n12<br \/>\n14<br \/>\n12<br \/>\n15<br \/>\n10<br \/>\n8<br \/>\n4<br \/>\n20<br \/>\n17<br \/>\n15<br \/>\n14<br \/>\n13<br \/>\n24<br \/>\n14<br \/>\n16<br \/>\n12<br \/>\n13<br \/>\n10<br \/>\n11<br \/>\n14<br \/>\n10<br \/>\n9<br \/>\n8<br \/>\n14<br \/>\n11<\/p>\n<p>De frequentie ziet er zo uit:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-56119\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/frequentieverdeling.png\" alt=\"\" width=\"480\" height=\"289\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/frequentieverdeling.png 480w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/frequentieverdeling-300x181.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/p>\n<p>Maar de normaalverdeling geeft dit:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-56120\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/normaalverdeling.png\" alt=\"\" width=\"480\" height=\"289\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/normaalverdeling.png 480w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/normaalverdeling-300x181.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/p>\n<p>Deze laatste is berekend met<\/p>\n<pre>=NORM.VERD.N(H3,$D$2,$D$3,ONWAAR)<\/pre>\n<p>waarbij<\/p>\n<ul>\n<li>H3: opeenvolgende waarden van 0 tot 20, met zelfgekozen interval (ik heb .5 genomen)<\/li>\n<li>D2: het gemiddelde van de hele reeks<\/li>\n<li>D3: de standaarddeviatie van de hele reeks<\/li>\n<\/ul>\n<p>Je kan <a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/04\/normaalverdeling.xlsx\">hier<\/a> mijn Excel bestand downloaden.<\/p>\n<p>Zie ook:<\/p>\n<p><em>NORM.VERD.N, functie &#8211; Office-ondersteuning<\/em><br \/>\n<a href=\"https:\/\/support.office.com\/nl-nl\/article\/norm-verd-functie-edb1cc14-a21c-4e53-839d-8082074c9f8d\" rel=\"nofollow\">https:\/\/support.office.com\/nl-nl\/article\/norm-verd-functie-edb1cc14-a21c-4e53-839d-8082074c9f8d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Hoe krijg ik een normaalverdeling in Excel? Ik krijg steeds iets heel anders dan een Gausscurve. A. Een normaalverdeling is geen frequentieverdeling. Een frequentieverdeling is de echte verdeling van hoe dikwijls elementen voorkomen, terwijl een normaalverdeling een hypothetische verdeling is, berekend op basis van het gemiddelde en de standaarddeviatie.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":1588,"footnotes":""},"categories":[539,464,54,375,10],"tags":[],"class_list":["post-56118","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-ebp","category-excel","category-excel-office-2010","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 22:47:30","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/56118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=56118"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/56118\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=56118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=56118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=56118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}