{"id":53534,"date":"2018-11-13T12:33:29","date_gmt":"2018-11-13T11:33:29","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=53534"},"modified":"2025-06-02T08:00:47","modified_gmt":"2025-06-02T07:00:47","slug":"welke-x-waarde-hoort-bij-een-bepaalde-y","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/welke-x-waarde-hoort-bij-een-bepaalde-y\/","title":{"rendered":"Welke X waarde hoort bij een bepaalde Y?"},"content":{"rendered":"<p><span class=\"mceItemHidden\">V.<\/span><span class=\"mceItemHidden\"> Ik heb hier een grafiek van metingen.<\/span><span class=\"mceItemHidden\"> Hoe weet ik welke X waarde <\/span><span class=\"mceItemHidden\">(meetpunt)<\/span><span class=\"mceItemHidden\"> hoort bij een bepaalde Y waarde <\/span><span class=\"mceItemHidden\">(gemeten waarde)<\/span><span class=\"mceItemHidden\">?<\/span><\/p>\n<p><span class=\"mceItemHidden\">A.<\/span><\/p>\n<ul>\n<li><span class=\"mceItemHidden\">Je kan dat visualiseren <\/span><span class=\"mceItemHidden\">(tonen)<\/span><span class=\"mceItemHidden\"> door de lijn van die Y waarde te tekenen.<\/span><span class=\"mceItemHidden\"> Maak een kolom bij,<\/span><span class=\"mceItemHidden\"> plaats daarin telkens die Y waarde,<\/span><span class=\"mceItemHidden\"> en maak een gecombineerde grafiek.<\/span><\/li>\n<li><span class=\"mceItemHidden\">D<\/span><span class=\"mceItemHidden\">e applicatie <a href=\"https:\/\/automeris.io\/WebPlotDigitizer\/\">WebPlotDigitizer<\/a><\/span><span class=\"mceItemHidden\"> kan <\/span><span class=\"mceItemHidden\"> een grafiek kan analyseren<\/span><span class=\"mceItemHidden\">\u00c2\u00a0 <\/span> <span class=\"mceItemHidden\">om X <\/span><span class=\"mceItemHidden\">te <\/span>vinden bij e<span class=\"mceItemHidden\">en <\/span><span class=\"mceItemHidden\">gegeven <\/span>Y.<\/li>\n<li><span class=\"mceItemHidden\">Je kan dat berekenen met de functie die verschijnt bij de trendlijn die je aan Excel kan vragen.<\/span><\/li>\n<li>Je kan dat berekenen met de <a href=\"https:\/\/support.office.com\/nl-nl\/article\/snijpunt-functie-2a9b74e2-9d47-4772-b663-3bca70bf63ef?ocmsassetID=HP010342626&amp;CorrelationId=2fd6869f-4c56-45af-ba5d-24ea75d12ec1&amp;ui=nl-NL&amp;rs=nl-NL&amp;ad=NL\">functie SNIJPUNT<\/a>.<\/li>\n<li>Of met de solver van Excel. Vraag de vergelijking van de trendlijn (je kan die laten weergeven). Je kan <a href=\"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=56476\">van die functie een nulpunt vragen<\/a>.<\/li>\n<\/ul>\n<p><span class=\"mceItemHidden\">Meer info:<\/span><\/p>\n<p><a href=\"https:\/\/www.quora.com\/How-do-I-find-the-corresponding-value-for-a-given-data-and-graph-in-Excel\"><span class=\"mceItemHidden\">https:<\/span><span class=\"mceItemHidden\">\/<\/span><span class=\"mceItemHidden\">\/www.quora.com\/How-do-I-find-the-corresponding-value-for-a-given-data-and-graph-in-Excel<\/span><\/a><\/p>\n<p><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-to-get-x-and-y-of-any-point-in-plot-for-excel\/d3ee6973-324b-4ec6-abb9-cc8d0dc50910\"><span class=\"mceItemHidden\">https:<\/span><span class=\"mceItemHidden\">\/<\/span><span class=\"mceItemHidden\">\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-to-get-x-and-y-of-any-point-in-plot-for-excel\/d3ee6<\/span><span class=\"mceItemHidden\">9<\/span><span class=\"mceItemHidden\">7<\/span><span class=\"mceItemHidden\">3<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">3<\/span><span class=\"mceItemHidden\">2<\/span><span class=\"mceItemHidden\">4b-<\/span><span class=\"mceItemHidden\">4ec6<\/span><span class=\"mceItemHidden\">-abb9<\/span><span class=\"mceItemHidden\">-cc8d0dc5<\/span><span class=\"mceItemHidden\">0<\/span><span class=\"mceItemHidden\">9<\/span><span class=\"mceItemHidden\">1<\/span><span class=\"mceItemHidden\">0<\/span><\/a><\/p>\n<p><em>How to Interpolate in Excel<\/em><br \/>\n<a href=\"https:\/\/www.makeuseof.com\/excel-interpolate\/\" rel=\"nofollow\">https:\/\/www.makeuseof.com\/excel-interpolate\/<\/a><\/p>\n<p><span class=\"mceItemHidden\">Ook nuttig:<\/span><span class=\"mceItemHidden\"> deze vier <\/span><span class=\"mceItemHidden\">Excel functies:<\/span><\/p>\n<p><em><span class=\"mceItemHidden\">GROEI <\/span><\/em><span class=\"mceItemHidden\">&#8211;<\/span><br \/>\n<a href=\"https:\/\/support.office.com\/nl-nl\/article\/groei-functie-541a91dc-3d5e-437d-b156-21324e68b80d?ui=nl-NL&amp;rs=nl-NL&amp;ad=NL\"><span class=\"mceItemHidden\">https:<\/span><span class=\"mceItemHidden\">\/<\/span><span class=\"mceItemHidden\">\/support.office.com\/nl-nl\/article\/groei-functie-<\/span><span class=\"mceItemHidden\">5<\/span><span class=\"mceItemHidden\">4<\/span><span class=\"mceItemHidden\">1a9<\/span><span class=\"mceItemHidden\">1dc-<\/span><span class=\"mceItemHidden\">3d5e-<\/span><span class=\"mceItemHidden\">4<\/span><span class=\"mceItemHidden\">3<\/span><span class=\"mceItemHidden\">7d-b1<\/span><span class=\"mceItemHidden\">5<\/span><span class=\"mceItemHidden\">6<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">2<\/span><span class=\"mceItemHidden\">1<\/span><span class=\"mceItemHidden\">3<\/span><span class=\"mceItemHidden\">2<\/span><span class=\"mceItemHidden\">4e6<\/span><span class=\"mceItemHidden\">8b8<\/span><span class=\"mceItemHidden\">0d?ui=nl-NL&amp;rs=nl-NL&amp;ad=NL<\/span><\/a><br \/>\n<em><span class=\"mceItemHidden\">TREND <\/span><\/em><br \/>\n<em><span class=\"mceItemHidden\">LIJNSCH <\/span><\/em><span class=\"mceItemHidden\">(voor lineaire evoluties)<\/span> <span class=\"mceItemHidden\">&#8211;<\/span><a href=\"https:\/\/support.office.com\/nl-nl\/article\/lijnsch-functie-84d7d0d9-6e50-4101-977a-fa7abf772b6d\"><span class=\"mceItemHidden\"> https:<\/span><span class=\"mceItemHidden\">\/<\/span><span class=\"mceItemHidden\">\/support.office.com\/nl-nl\/article\/lijnsch-functie-<\/span><span class=\"mceItemHidden\">8<\/span><span class=\"mceItemHidden\">4d7d0d9<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">6e5<\/span><span class=\"mceItemHidden\">0<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">4<\/span><span class=\"mceItemHidden\">1<\/span><span class=\"mceItemHidden\">0<\/span><span class=\"mceItemHidden\">1<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">9<\/span><span class=\"mceItemHidden\">7<\/span><span class=\"mceItemHidden\">7a-fa7abf7<\/span><span class=\"mceItemHidden\">7<\/span><span class=\"mceItemHidden\">2b6d<\/span><\/a><br \/>\n<em><span class=\"mceItemHidden\">LOGSCH <\/span><\/em><span class=\"mceItemHidden\">(voor logaritmische evoluties)<\/span> <span class=\"mceItemHidden\">&#8211;<\/span><a href=\"https:\/\/support.office.com\/nl-nl\/article\/logsch-functie-f27462d8-3657-4030-866b-a272c1d18b4b?ui=nl-NL&amp;rs=nl-NL&amp;ad=NL\"><span class=\"mceItemHidden\"> https:<\/span><span class=\"mceItemHidden\">\/<\/span><span class=\"mceItemHidden\">\/support.office.com\/nl-nl\/article\/logsch-functie-f2<\/span><span class=\"mceItemHidden\">7<\/span><span class=\"mceItemHidden\">4<\/span><span class=\"mceItemHidden\">6<\/span><span class=\"mceItemHidden\">2d8<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">3<\/span><span class=\"mceItemHidden\">6<\/span><span class=\"mceItemHidden\">5<\/span><span class=\"mceItemHidden\">7<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">4<\/span><span class=\"mceItemHidden\">0<\/span><span class=\"mceItemHidden\">3<\/span><span class=\"mceItemHidden\">0<\/span><span class=\"mceItemHidden\">&#8211;<\/span><span class=\"mceItemHidden\">8<\/span><span class=\"mceItemHidden\">6<\/span><span class=\"mceItemHidden\">6b-a2<\/span><span class=\"mceItemHidden\">7<\/span><span class=\"mceItemHidden\">2c1d1<\/span><span class=\"mceItemHidden\">8b4b?ui=nl-NL&amp;rs=nl-NL&amp;ad=NL<\/span><\/a><\/p>\n<p>En: als je vertrekt van een functie in plaats van een grafiek, kan Onenote je helpen. Zie het stukje Oplossen voor Y in <em>Grafieken tekenen van wiskundige vergelijkingen in OneNote voor Windows 10<\/em><br \/>\n<a href=\"https:\/\/support.office.com\/nl-nl\/article\/grafieken-tekenen-van-wiskundige-vergelijkingen-in-onenote-voor-windows-10-1e88ceb1-7849-4f73-b63e-42eae0cfce41\">https:\/\/support.office.com\/nl-nl\/article\/grafieken-tekenen-van-wiskundige-vergelijkingen-in-onenote-voor-windows-10-1e88ceb1-7849-4f73-b63e-42eae0cfce41<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb hier een grafiek van metingen. Hoe weet ik welke X waarde (meetpunt) hoort bij een bepaalde Y waarde (gemeten waarde)? A. Je kan dat visualiseren (tonen) door de lijn van die Y waarde te tekenen. Maak een kolom bij, plaats daarin telkens die Y waarde, en maak<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":189,"footnotes":""},"categories":[539,464,54,558,79,10],"tags":[],"class_list":["post-53534","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-ebp","category-excel","category-metingen","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 21:29:26","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\/53534","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=53534"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/53534\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=53534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=53534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=53534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}