{"id":2351,"date":"2025-10-23T12:23:33","date_gmt":"2025-10-23T11:23:33","guid":{"rendered":"https:\/\/wiskunst.nl\/?page_id=2351"},"modified":"2026-03-04T10:14:02","modified_gmt":"2026-03-04T09:14:02","slug":"excel-mlra","status":"publish","type":"page","link":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/","title":{"rendered":"Excel-MLRA"},"content":{"rendered":"

In de add-in Handigheidjes zit een wizard waarmee u Meervoudige Lineaire Regressie Analyse (MLRA) kunt uitvoeren.<\/h4>\n

Nu zit deze optie ook in Excel zelf maar er zijn twee grote verschillen. De functionaliteit in Excel is statisch. Dus als in uw data iets verandert dan moet u opnieuw de MLRA laten berekenen. De MLRA-functionaliteit in Handigheidjes is dynamisch. Verandert uw data dan verandert meteen de analyse.
\nIn de MLRA-functionaliteit van Handigheidjes zit ook de mogelijkheid om van uw analyse een zogenaamde UDF (User Defined Function) te maken waardoor u met nieuwe data meteen de resultaten kunt berekenen.<\/p>\n

\"De
De wizard voor Meervoudige Lineaire Regressie Analyse van HJGSoft Handigheidjes<\/figcaption><\/figure>\n

 <\/p>\n<\/div>\n

\"Voorbeeld
Voorbeeld functie Meervoudige Lineaire Regressie Analyse<\/figcaption><\/figure>\n

Opmerking<\/strong>: De verwijzingen naar HJGSoft zijn niet meer actief omdat HJGSoft niet meer actief is. Wellicht dat in de toekomst een deel van de functionaliteiten op deze site gepubliceerd gaat worden.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

In de add-in Handigheidjes zit een wizard waarmee u Meervoudige Lineaire Regressie Analyse (MLRA) kunt uitvoeren. Nu zit deze optie ook in Excel zelf maar er zijn twee grote verschillen. De functionaliteit in Excel is statisch. Dus als in uw data iets verandert dan moet u opnieuw de MLRA laten berekenen. De MLRA-functionaliteit in Handigheidjes […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2339,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/template-full-width.php","meta":{"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"class_list":["post-2351","page","type-page","status-publish","hentry"],"yoast_head":"\nExcel-MLRA - Wiskunst<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel-MLRA - Wiskunst\" \/>\n<meta property=\"og:description\" content=\"In de add-in Handigheidjes zit een wizard waarmee u Meervoudige Lineaire Regressie Analyse (MLRA) kunt uitvoeren. Nu zit deze optie ook in Excel zelf maar er zijn twee grote verschillen. De functionaliteit in Excel is statisch. Dus als in uw data iets verandert dan moet u opnieuw de MLRA laten berekenen. De MLRA-functionaliteit in Handigheidjes […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/\" \/>\n<meta property=\"og:site_name\" content=\"Wiskunst\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-04T09:14:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/MLRA_03-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"898\" \/>\n\t<meta property=\"og:image:height\" content=\"483\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/\",\"url\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/\",\"name\":\"Excel-MLRA - Wiskunst\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wiskunst.nl\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/MLRA_03-1.jpg\",\"datePublished\":\"2025-10-23T11:23:33+00:00\",\"dateModified\":\"2026-03-04T09:14:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wiskunst.nl\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/MLRA_03-1.jpg\",\"contentUrl\":\"https:\\\/\\\/wiskunst.nl\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/MLRA_03-1.jpg\",\"width\":898,\"height\":483},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/excel-mlra\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wiskunst.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HJGSoft\",\"item\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Handigheidjes\",\"item\":\"https:\\\/\\\/wiskunst.nl\\\/index.php\\\/hjgsoft\\\/excel-handigheidjes\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Excel-MLRA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wiskunst.nl\\\/#website\",\"url\":\"https:\\\/\\\/wiskunst.nl\\\/\",\"name\":\"Wiskunst\",\"description\":\"2\u221e\u2227>\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wiskunst.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel-MLRA - Wiskunst","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:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/","og_locale":"nl_NL","og_type":"article","og_title":"Excel-MLRA - Wiskunst","og_description":"In de add-in Handigheidjes zit een wizard waarmee u Meervoudige Lineaire Regressie Analyse (MLRA) kunt uitvoeren. Nu zit deze optie ook in Excel zelf maar er zijn twee grote verschillen. De functionaliteit in Excel is statisch. Dus als in uw data iets verandert dan moet u opnieuw de MLRA laten berekenen. De MLRA-functionaliteit in Handigheidjes […]","og_url":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/","og_site_name":"Wiskunst","article_modified_time":"2026-03-04T09:14:02+00:00","og_image":[{"width":898,"height":483,"url":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/MLRA_03-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/","url":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/","name":"Excel-MLRA - Wiskunst","isPartOf":{"@id":"https:\/\/wiskunst.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/#primaryimage"},"image":{"@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/#primaryimage"},"thumbnailUrl":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/MLRA_03-1.jpg","datePublished":"2025-10-23T11:23:33+00:00","dateModified":"2026-03-04T09:14:02+00:00","breadcrumb":{"@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/#primaryimage","url":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/MLRA_03-1.jpg","contentUrl":"https:\/\/wiskunst.nl\/wp-content\/uploads\/2025\/11\/MLRA_03-1.jpg","width":898,"height":483},{"@type":"BreadcrumbList","@id":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/excel-mlra\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wiskunst.nl\/"},{"@type":"ListItem","position":2,"name":"HJGSoft","item":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/"},{"@type":"ListItem","position":3,"name":"Excel Handigheidjes","item":"https:\/\/wiskunst.nl\/index.php\/hjgsoft\/excel-handigheidjes\/"},{"@type":"ListItem","position":4,"name":"Excel-MLRA"}]},{"@type":"WebSite","@id":"https:\/\/wiskunst.nl\/#website","url":"https:\/\/wiskunst.nl\/","name":"Wiskunst","description":"2\u221e\u2227>","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wiskunst.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"}]}},"_links":{"self":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/comments?post=2351"}],"version-history":[{"count":6,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2351\/revisions"}],"predecessor-version":[{"id":2546,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2351\/revisions\/2546"}],"up":[{"embeddable":true,"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/pages\/2339"}],"wp:attachment":[{"href":"https:\/\/wiskunst.nl\/index.php\/wp-json\/wp\/v2\/media?parent=2351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}