{"id":51458,"date":"2017-06-14T16:48:17","date_gmt":"2017-06-14T15:48:17","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=51458"},"modified":"2018-04-23T07:31:10","modified_gmt":"2018-04-23T06:31:10","slug":"grafische-voorstelling-van-verbanden-tussen-reeksen-van-gegevens","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/grafische-voorstelling-van-verbanden-tussen-reeksen-van-gegevens\/","title":{"rendered":"Grafische voorstelling van verbanden tussen reeksen van gegevens"},"content":{"rendered":"<p>In Excel kan je\u00c2\u00a0verbanden tussen gegevens visueel voorstellen door een trendlijn. Dat gaat zo:<\/p>\n<ul>\n<li>de eerste reeks gegevens zet je in de eerste kolom<\/li>\n<li>de tweede reeks gegevens zet je in de tweede kolom<\/li>\n<li>je maakt een spreidingsgrafiek met punten<\/li>\n<li>je voegt een\u00c2\u00a0trendlijn toe<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51460\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/visualisatie-verbanden-1-300x134.png\" alt=\"\" width=\"300\" height=\"134\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/visualisatie-verbanden-1-300x134.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/visualisatie-verbanden-1.png 721w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<\/ul>\n<p>Bij die trendlijn kan je instellen of ze\u00c2\u00a0exponentieel, lineair, logaritmisch, of variabel moet zijn,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51459\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/visualisatie-verbanden-2-120x300.png\" alt=\"\" width=\"120\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/visualisatie-verbanden-2-120x300.png 120w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/06\/visualisatie-verbanden-2.png 288w\" sizes=\"auto, (max-width: 120px) 100vw, 120px\" \/><\/p>\n<p>en je kan bepalen of er een vergelijking voor die trendlijn kan getoond worden &#8211; dat is dan het mathematisch verband tussen die gegevens.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel kan je\u00c2\u00a0verbanden tussen gegevens visueel voorstellen door een trendlijn. Dat gaat zo: de eerste reeks gegevens zet je in de eerste kolom de tweede reeks gegevens zet je in de tweede kolom je maakt een spreidingsgrafiek met punten je voegt een\u00c2\u00a0trendlijn toe Bij die trendlijn kan je instellen<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10,"footnotes":""},"categories":[464,54,375,366,79,10],"tags":[],"class_list":["post-51458","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-grafieken","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 20:25: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\/51458","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=51458"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51458\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=51458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=51458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=51458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}