{"id":47436,"date":"2015-04-01T14:13:55","date_gmt":"2015-04-01T13:13:55","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=47436"},"modified":"2025-12-24T10:21:56","modified_gmt":"2025-12-24T09:21:56","slug":"excellente-statistiek","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/excellente-statistiek\/","title":{"rendered":"EXCELlente statistiek"},"content":{"rendered":"<p>Excel bevat behoorlijk wat tools om aan ernstige statistiek te doen. In deze post wil ik wat inspiratie geven.<\/p>\n<ul>\n<li><strong>Algemeen<br \/>\n<\/strong><a href=\"http:\/\/www.real-statistics.com\" rel=\"nofollow\">http:\/\/www.real-statistics.com<\/a><br \/>\n<a href=\"http:\/\/www.excelfunctions.net\" rel=\"nofollow\">http:\/\/www.excelfunctions.net<\/a><br \/>\n<a href=\"http:\/\/www.excel-easy.com\/\" rel=\"nofollow\">http:\/\/www.excel-easy.com\/<\/a><br \/>\n<a href=\"http:\/\/www.statisticshowto.com\/\" rel=\"nofollow\">http:\/\/www.statisticshowto.com\/<\/a><br \/>\n<a href=\"http:\/\/www.stattutorials.com\/\" rel=\"nofollow\">http:\/\/www.stattutorials.com\/<\/a><br \/>\n<a href=\"http:\/\/www.usablestats.com\/\" rel=\"nofollow\">http:\/\/www.usablestats.com\/<\/a><br \/>\n<a href=\"http:\/\/www.socscistatistics.com\/\" rel=\"nofollow\">http:\/\/www.socscistatistics.com\/<\/a><br \/>\n<a href=\"http:\/\/www.r-tutor.com\/\" rel=\"nofollow\">http:\/\/www.r-tutor.com\/<\/a><\/li>\n<li><strong>Topics<br \/>\n<\/strong>Fundamentals of Statistics 2: The Normal Distribution<br \/>\n<a href=\"http:\/\/www.usablestats.com\/tutorials\/basicStats2Fundamentals\" rel=\"nofollow\">http:\/\/www.usablestats.com\/tutorials\/basicStats2Fundamentals<\/a> of Statistics 3: Sampling<br \/>\n<a href=\"http:\/\/www.usablestats.com\/tutorials\/basicStats3Numeracy\" rel=\"nofollow\">http:\/\/www.usablestats.com\/tutorials\/basicStats3Numeracy<\/a> skills<br \/>\n<a href=\"http:\/\/libweb.surrey.ac.uk\/library\/skills\/Number%20Skills%20Leicester\/index.htm\" rel=\"nofollow\">http:\/\/libweb.surrey.ac.uk\/library\/skills\/Number%20Skills%20Leicester\/index.htm<\/a><\/li>\n<li><strong>ANOVA<br \/>\n<\/strong>Analysis of Variance &#8211; ANOVA in Excel<br \/>\n<a href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/anova\/One-way\" rel=\"nofollow\">http:\/\/www.qimacros.com\/hypothesis-testing\/anova\/One-way<\/a> Analysis of Variance (ANOVA)<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/Anova\" rel=\"nofollow\">http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/Anova<\/a><br \/>\n<a href=\"http:\/\/www.excel-easy.com\/examples\/anova.html\" rel=\"nofollow\">http:\/\/www.excel-easy.com\/examples\/anova.html<\/a><br \/>\nANOVA in Excel: A Walkthrough of Excel&#8217;s Variance Analysis Tool<br \/>\n<a href=\"https:\/\/blog.udemy.com\/anova-excel\/How\" rel=\"nofollow\">https:\/\/blog.udemy.com\/anova-excel\/How<\/a> to Perform Analyses of Variance in Excel<br \/>\n<a href=\"http:\/\/www.dummies.com\/how-to\/content\/how-to-perform-analyses-of-variance-in-excel.htmlRunning\" rel=\"nofollow\">http:\/\/www.dummies.com\/how-to\/content\/how-to-perform-analyses-of-variance-in-excel.htmlRunning<\/a> a one-way ANOVA followed by multiple comparisons tests with XLSTAT<br \/>\n<a href=\"http:\/\/www.xlstat.com\/en\/learning-center\/tutorials\/running-a-one-way-anova-followed-by-multiple-comparisons-tests-with-xlstat.htmlUse\" rel=\"nofollow\">http:\/\/www.xlstat.com\/en\/learning-center\/tutorials\/running-a-one-way-anova-followed-by-multiple-comparisons-tests-with-xlstat.htmlUse<\/a> the Analysis ToolPak to perform complex data analysis<br \/>\n<a href=\"https:\/\/support.office.com\/en-SG\/article\/use-the-analysis-toolpak-to-perform-complex-data-analysis-b0f0a249-11af-4570-a9cc-becfa6bc0c31\" rel=\"nofollow\">https:\/\/support.office.com\/en-SG\/article\/use-the-analysis-toolpak-to-perform-complex-data-analysis-b0f0a249-11af-4570-a9cc-becfa6bc0c31<\/a><\/li>\n<li><strong>Boxplot &amp; whisker<br \/>\n<\/strong>Box-and-Whisker Charts for Excel<br \/>\n<a href=\"http:\/\/www.dummies.com\/how-to\/content\/boxandwhisker-charts-for-excel.htmlEen\" rel=\"nofollow\">http:\/\/www.dummies.com\/how-to\/content\/boxandwhisker-charts-for-excel.htmlEen<\/a> verticale boxplot bouwen<br \/>\n<a href=\"http:\/\/www.exceltekstenuitleg.nl\/uploads\/5\/1\/6\/5\/5165009\/bonushoofdstuk_boxplots_verticaal.pdfExcel\" rel=\"nofollow\">http:\/\/www.exceltekstenuitleg.nl\/uploads\/5\/1\/6\/5\/5165009\/bonushoofdstuk_boxplots_verticaal.pdfExcel<\/a> Box and Whisker Diagrams (Box Plots)<br \/>\n<a href=\"http:\/\/peltiertech.com\/excel-box-and-whisker-diagrams-box-plots\/How\" rel=\"nofollow\">http:\/\/peltiertech.com\/excel-box-and-whisker-diagrams-box-plots\/How<\/a> to make Box plots in Excel [Dashboard Essentials]<br \/>\n<a href=\"http:\/\/chandoo.org\/wp\/2012\/07\/31\/excel-box-plot-tutorial\/\" rel=\"nofollow\">http:\/\/chandoo.org\/wp\/2012\/07\/31\/excel-box-plot-tutorial\/<\/a><\/li>\n<li><strong>CHI<\/strong> \u00c2\u00a0[inbegrepen in Excel]<br \/>\nExcel statistical functions: CHIINV<br \/>\n<a href=\"http:\/\/support.microsoft.com\/en-us\/kb\/828313\" rel=\"nofollow\">http:\/\/support.microsoft.com\/en-us\/kb\/828313<\/a><br \/>\nHow to Calculate a Chi Square P Value Excel<br \/>\n<a href=\"http:\/\/www.statisticshowto.com\/calculate-chi-square-p-value-excel\/\" rel=\"nofollow\">http:\/\/www.statisticshowto.com\/calculate-chi-square-p-value-excel\/<\/a><br \/>\nIndependence Testing<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"GHr9gMwtWr\"><p><a href=\"http:\/\/www.real-statistics.com\/chi-square-and-f-distributions\/independence-testing\/\">Independence Testing<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" title=\"&#8220;Independence Testing&#8221; &#8212; Real Statistics Using Excel\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"http:\/\/www.real-statistics.com\/chi-square-and-f-distributions\/independence-testing\/embed\/#?secret=GHr9gMwtWr\" data-secret=\"GHr9gMwtWr\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\nThe Excel CHISQ.TEST Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Chisq-Test-Function.htmlThe\" rel=\"nofollow\">http:\/\/www.excelfunctions.net\/Excel-Chisq-Test-Function.htmlThe<\/a> Excel CHITEST Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Chitest-Function.htmlTwo-Sample\" rel=\"nofollow\">http:\/\/www.excelfunctions.net\/Excel-Chitest-Function.htmlTwo-Sample<\/a> t-Test Assuming Equal Variances in Excel<br \/>\n<a href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/t-test-two-sample\/Values\" rel=\"nofollow\">http:\/\/www.qimacros.com\/hypothesis-testing\/t-test-two-sample\/Values<\/a> of the Chi-square distribution<br \/>\n<a href=\"http:\/\/www.statlect.com\/chi_square_distribution_values.htm\" rel=\"nofollow\">http:\/\/www.statlect.com\/chi_square_distribution_values.htm<\/a><\/li>\n<li><strong>F-TEST<\/strong>\u00c2\u00a0\u00c2\u00a0[inbegrepen in Excel]<br \/>\nF-Test<br \/>\n<a href=\"http:\/\/www.excel-easy.com\/examples\/f-test.html\" rel=\"nofollow\">http:\/\/www.excel-easy.com\/examples\/f-test.html<\/a><br \/>\nF.TEST function<br \/>\n<a href=\"https:\/\/support.office.com\/en-za\/article\/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7\" rel=\"nofollow\">https:\/\/support.office.com\/en-za\/article\/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7<\/a><br \/>\nF.TEST function<br \/>\n<a href=\"https:\/\/support.office.com\/en-sg\/article\/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12\" rel=\"nofollow\">https:\/\/support.office.com\/en-sg\/article\/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12<\/a><br \/>\nF test two sample for variances Excel 2013<br \/>\n<a href=\"http:\/\/www.statisticshowto.com\/run-f-test-two-sample-variances-excel-2013\/F-Tests\" rel=\"nofollow\">http:\/\/www.statisticshowto.com\/run-f-test-two-sample-variances-excel-2013\/F-Tests<\/a> Determine if Variances are the Same or Different<br \/>\n<a href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/f-test-two-sample\/\" rel=\"nofollow\">http:\/\/www.qimacros.com\/hypothesis-testing\/f-test-two-sample\/<\/a><\/li>\n<li><strong>Jaccard<\/strong><br \/>\nExcel VBA: Weighted Jaccard Similarity (Fuzzy Lookup) &#8211; Stack Overflow<br \/>\n<a href=\"https:\/\/stackoverflow.com\/questions\/43239800\/excel-vba-weighted-jaccard-similarity-fuzzy-lookup\" rel=\"nofollow\">https:\/\/stackoverflow.com\/questions\/43239800\/excel-vba-weighted-jaccard-similarity-fuzzy-lookup<\/a><br \/>\nJaccard Index \/ Similarity Coefficient &#8211; Statistics How To<br \/>\n<a href=\"https:\/\/www.statisticshowto.datasciencecentral.com\/jaccard-index\/\" rel=\"nofollow\">https:\/\/www.statisticshowto.datasciencecentral.com\/jaccard-index\/<\/a><\/li>\n<li><strong>KAPPA<\/strong><br \/>\nCalculate Kappa with Excel<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"gkMaxYAsYl\"><p><a href=\"http:\/\/investexcel.net\/calculating-kappa-with-excel\/\">Calculate Kappa with Excel<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" title=\"&#8220;Calculate Kappa with Excel&#8221; &#8212; Invest Excel\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"http:\/\/investexcel.net\/calculating-kappa-with-excel\/embed\/#?secret=gkMaxYAsYl\" data-secret=\"gkMaxYAsYl\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\nKappa and Weighted-Kappa<br \/>\n<a href=\"http:\/\/analyse-it.com\/docs\/220\/standard\/kappa_inter-rater_agreement.htm\" rel=\"nofollow\">http:\/\/analyse-it.com\/docs\/220\/standard\/kappa_inter-rater_agreement.htm<\/a><\/li>\n<li><strong>Kolmogorov-Smirnov<br \/>\n<\/strong>Kolmogorov-Smirnov Test in Excel using the QI Macros<br \/>\n<a href=\"https:\/\/www.qimacros.com\/hypothesis-testing\/kolmogorov-smirnov-statistic-excel\/Kolmogorov-Smirnov\" rel=\"nofollow\">https:\/\/www.qimacros.com\/hypothesis-testing\/kolmogorov-smirnov-statistic-excel\/Kolmogorov-Smirnov<\/a> Test for Normality<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"zVBnkyXedk\"><p><a href=\"http:\/\/www.real-statistics.com\/tests-normality-and-symmetry\/statistical-tests-normality-symmetry\/kolmogorov-smirnov-test\/\">Kolmogorov-Smirnov Test for Normality<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" title=\"&#8220;Kolmogorov-Smirnov Test for Normality&#8221; &#8212; Real Statistics Using Excel\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"http:\/\/www.real-statistics.com\/tests-normality-and-symmetry\/statistical-tests-normality-symmetry\/kolmogorov-smirnov-test\/embed\/#?secret=zVBnkyXedk\" data-secret=\"zVBnkyXedk\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\nKolmogorov-Smirnov Tests in Excel with UNISTAT<br \/>\n<a href=\"https:\/\/www.unistat.com\/632\/\" rel=\"nofollow\">https:\/\/www.unistat.com\/632\/<\/a><\/li>\n<li><strong>Morisita<\/strong><br \/>\nMorisita Index &#8211; Statistics How To<br \/>\n<a href=\"https:\/\/www.statisticshowto.datasciencecentral.com\/morisita-index\/\" rel=\"nofollow\">https:\/\/www.statisticshowto.datasciencecentral.com\/morisita-index\/<\/a><\/li>\n<\/ul>\n<ul>\n<li><strong>PEARSON<\/strong> \u00c2\u00a0[inbegrepen in Excel]<br \/>\nCalculate Pearson&#8217;s Correlation Using Microsoft Excel<br \/>\n<a href=\"http:\/\/www.stattutorials.com\/EXCEL\/EXCEL-pearson-correlation.html\" rel=\"nofollow\">http:\/\/www.stattutorials.com\/EXCEL\/EXCEL-pearson-correlation.html<\/a><br \/>\nCorrelation<br \/>\n<a href=\"http:\/\/www.gifted.uconn.edu\/siegle\/research\/correlation\/excel.htm\" rel=\"nofollow\">http:\/\/www.gifted.uconn.edu\/siegle\/research\/correlation\/excel.htm<\/a><br \/>\nUtexas<br \/>\n<a href=\"http:\/\/www.laits.utexas.edu\/orkelm\/excel\/EXCEL\/PEARSON.HTM\" rel=\"nofollow\">http:\/\/www.laits.utexas.edu\/orkelm\/excel\/EXCEL\/PEARSON.HTM<\/a><br \/>\nPEARSON function<br \/>\n<a href=\"https:\/\/support.office.com\/en-sg\/article\/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1afThe\" rel=\"nofollow\">https:\/\/support.office.com\/en-sg\/article\/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1afThe<\/a> Excel PEARSON Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Pearson-Function.HTML\" rel=\"nofollow\">http:\/\/www.excelfunctions.net\/Excel-Pearson-Function.HTML<\/a><\/li>\n<li><strong>Skew &amp; Kurtosis<\/strong><br \/>\nKURTOSIS, functie<br \/>\n<a href=\"https:\/\/support.office.com\/nl-be\/article\/KURTOSIS-functie-bc3a265c-5da4-4dcb-b7fd-c237789095ab?ui=fr-FR&#038;rs=nl-BE&#038;ad=BE\" rel=\"nofollow\">https:\/\/support.office.com\/nl-be\/article\/KURTOSIS-functie-bc3a265c-5da4-4dcb-b7fd-c237789095ab?ui=fr-FR&#038;rs=nl-BE&#038;ad=BE<\/a><br \/>\nKurtosis in Excel (KURT) &#8211; <a href=\"http:\/\/www.macroption.com\/kurtosis-excel-kurt\/\" rel=\"nofollow\">http:\/\/www.macroption.com\/kurtosis-excel-kurt\/<\/a><br \/>\nSKEW function &#8211; <a href=\"https:\/\/support.office.com\/en-sg\/article\/SKEW-function-bdf49d86-b1ef-4804-a046-28eaea69c9fa?CorrelationId=004b5b3a-0052-4aa0-8e7d-9075e4844ac0&#038;ui=en-US&#038;rs=en-SG&#038;ad=SG\" rel=\"nofollow\">https:\/\/support.office.com\/en-sg\/article\/SKEW-function-bdf49d86-b1ef-4804-a046-28eaea69c9fa?CorrelationId=004b5b3a-0052-4aa0-8e7d-9075e4844ac0&#038;ui=en-US&#038;rs=en-SG&#038;ad=SG<\/a><\/li>\n<li><strong>Sorensen (overlap)<\/strong><br \/>\nS\u00c3\u00b8rensen Similarity Index &#8211; Formula<br \/>\n<a href=\"http:\/\/www.liquisearch.com\/s%C3%B8rensen_similarity_index\/formula\" rel=\"nofollow\">http:\/\/www.liquisearch.com\/s%C3%B8rensen_similarity_index\/formula<\/a><br \/>\nS\u00c3\u00b8rensen-\u201cDice coefficient &#8211; Wikipedia<br \/>\n<a href=\"https:\/\/en.wikipedia.org\/wiki\/S%C3%B8rensen%E2%80%93Dice_coefficient\" rel=\"nofollow\">https:\/\/en.wikipedia.org\/wiki\/S%C3%B8rensen%E2%80%93Dice_coefficient<\/a><\/li>\n<li><strong>STDEV<\/strong> \u00c2\u00a0[inbegrepen in Excel]<br \/>\nSTDEV function<br \/>\n<a href=\"https:\/\/support.office.com\/en-au\/article\/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223f\" rel=\"nofollow\">https:\/\/support.office.com\/en-au\/article\/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223f<\/a><br \/>\nCalculating the Mean and Standard Deviation with Excel<br \/>\n<a href=\"http:\/\/www.gifted.uconn.edu\/siegle\/research\/normal\/stdexcel.htm\" rel=\"nofollow\">http:\/\/www.gifted.uconn.edu\/siegle\/research\/normal\/stdexcel.htm<\/a><br \/>\nExplaining Standard Deviation<br \/>\n<a href=\"http:\/\/www.spcforexcel.com\/knowledge\/basic-statistics\/explaining-standard-deviation\" rel=\"nofollow\">http:\/\/www.spcforexcel.com\/knowledge\/basic-statistics\/explaining-standard-deviation<\/a><br \/>\nMeasures of Variability<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/descriptive-statistics\/measures-variability\/Statistics\" rel=\"nofollow\">http:\/\/www.real-statistics.com\/descriptive-statistics\/measures-variability\/Statistics<\/a> 1 &#8211; Averages, standard deviation and confidence<br \/>\n<a href=\"http:\/\/www.meadinkent.co.uk\/excel-statistics1.htmThe\" rel=\"nofollow\">http:\/\/www.meadinkent.co.uk\/excel-statistics1.htmThe<\/a> Excel STDEV Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Stdev-Function.html\" rel=\"nofollow\">http:\/\/www.excelfunctions.net\/Excel-Stdev-Function.html<\/a><br \/>\nThe Excel STDEV.S Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Stdev-S-Function.html\" rel=\"nofollow\">http:\/\/www.excelfunctions.net\/Excel-Stdev-S-Function.html<\/a><br \/>\nUnderstanding Standard Deviationhttp:\/\/datapigtechnologies.com\/blog\/index.php\/understanding-standard-deviation-2\/<br \/>\nWhich Standard Deviation to use in Excel: STDEV to STDEV.P<br \/>\n<a href=\"http:\/\/www.statisticshowto.com\/which-standard-deviation-to-use-in-excel\/\" rel=\"nofollow\">http:\/\/www.statisticshowto.com\/which-standard-deviation-to-use-in-excel\/<\/a><\/li>\n<li><strong>T-TEST<\/strong> \u00c2\u00a0[inbegrepen in Excel]<br \/>\nPaired t-test Using Microsoft Excel<br \/>\n<a href=\"http:\/\/www.stattutorials.com\/EXCEL\/EXCEL_TTEST2.htmlComparing\" rel=\"nofollow\">http:\/\/www.stattutorials.com\/EXCEL\/EXCEL_TTEST2.htmlComparing<\/a> Two Means: 2 Sample t-test<br \/>\n<a href=\"http:\/\/www.usablestats.com\/tutorials\/twoSamplett-Test\" rel=\"nofollow\">http:\/\/www.usablestats.com\/tutorials\/twoSamplett-Test<\/a><br \/>\n<a href=\"http:\/\/www.excel-easy.com\/examples\/t-test.htmlT.TEST\" rel=\"nofollow\">http:\/\/www.excel-easy.com\/examples\/t-test.htmlT.TEST<\/a> function<br \/>\n<a href=\"https:\/\/support.office.com\/en-za\/article\/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055Two\" rel=\"nofollow\">https:\/\/support.office.com\/en-za\/article\/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055Two<\/a> Sample (independent group) t-test Using Microsoft Excel<br \/>\n<a href=\"http:\/\/www.stattutorials.com\/EXCEL\/EXCEL_TTEST1.htmlTwo\" rel=\"nofollow\">http:\/\/www.stattutorials.com\/EXCEL\/EXCEL_TTEST1.htmlTwo<\/a> Sample t Test: unequal variances<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/students-t-distribution\/two-sample-t-test-uequal-variances\/\" rel=\"nofollow\">http:\/\/www.real-statistics.com\/students-t-distribution\/two-sample-t-test-uequal-variances\/<\/a><\/li>\n<li><strong>KRUSKAL<\/strong> \u00c2\u00a0[inbegrepen in Excel]<br \/>\nKruskal-Wallis One-Way ANOVA in Excel with UNISTAT<br \/>\n<a href=\"https:\/\/www.unistat.com\/651\/Kruskal-Wallis\" rel=\"nofollow\">https:\/\/www.unistat.com\/651\/Kruskal-Wallis<\/a> Test<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"apT9NbcDQe\"><p><a href=\"http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/kruskal-wallis-test\/\">Kruskal-Wallis Test<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" title=\"&#8220;Kruskal-Wallis Test&#8221; &#8212; Real Statistics Using Excel\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/kruskal-wallis-test\/embed\/#?secret=apT9NbcDQe\" data-secret=\"apT9NbcDQe\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\nKruskal-Wallis Test<br \/>\n<a href=\"http:\/\/www.r-tutor.com\/elementary-statistics\/non-parametric-methods\/kruskal-wallis-test\" rel=\"nofollow\">http:\/\/www.r-tutor.com\/elementary-statistics\/non-parametric-methods\/kruskal-wallis-test<\/a><br \/>\nRunning a Kruskal-Wallis test with XLSTAT<br \/>\n<a href=\"http:\/\/www.xlstat.com\/en\/learning-center\/tutorials\/running-a-kruskal-wallis-test-with-xlstat.html\" rel=\"nofollow\">http:\/\/www.xlstat.com\/en\/learning-center\/tutorials\/running-a-kruskal-wallis-test-with-xlstat.html<\/a><\/li>\n<li><strong>Mann-Whitney<br \/>\n<\/strong>Mann-Whitney U-value Calculator<br \/>\n<a href=\"http:\/\/www.socscistatistics.com\/tests\/mannwhitney\/Mann-Whitney\" rel=\"nofollow\">http:\/\/www.socscistatistics.com\/tests\/mannwhitney\/Mann-Whitney<\/a> Test for Independent Samples<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/non-parametric-tests\/mann-whitney-test\/\" rel=\"nofollow\">http:\/\/www.real-statistics.com\/non-parametric-tests\/mann-whitney-test\/<\/a><\/li>\n<li><strong>Wilcoxon Signed-Ranks Test<\/strong><br \/>\n<a href=\"http:\/\/www.real-statistics.com\/non-parametric-tests\/wilcoxon-signed-ranks-test\/\" rel=\"nofollow\">http:\/\/www.real-statistics.com\/non-parametric-tests\/wilcoxon-signed-ranks-test\/<\/a><\/li>\n<li><strong>Andere topics<br \/>\n<\/strong>Excel and Quartiles<br \/>\n<a href=\"http:\/\/www.meadinkent.co.uk\/excel-quartiles.htmHow\" rel=\"nofollow\">http:\/\/www.meadinkent.co.uk\/excel-quartiles.htmHow<\/a> to Calculate an Interquartile Mean in Excel<br \/>\n<a href=\"http:\/\/smallbusiness.chron.com\/calculate-interquartile-mean-excel-37953.htmlHow\" rel=\"nofollow\">http:\/\/smallbusiness.chron.com\/calculate-interquartile-mean-excel-37953.htmlHow<\/a> to Find the IQR<br \/>\n<a href=\"http:\/\/www.wikihow.com\/Find-the-IQRReliability\" rel=\"nofollow\">http:\/\/www.wikihow.com\/Find-the-IQRReliability<\/a><br \/>\n<a href=\"http:\/\/www.real-statistics.com\/reliability\/StatEL\" rel=\"nofollow\">http:\/\/www.real-statistics.com\/reliability\/StatEL<\/a> : Calculation of Sensitivity \/ Specificity<br \/>\n<a href=\"http:\/\/www.adscience.eu\/uploads\/ckfiles\/files\/html_files\/StatEL\/statel_sensitivity_specificity.htmDiagnostic\" rel=\"nofollow\">http:\/\/www.adscience.eu\/uploads\/ckfiles\/files\/html_files\/StatEL\/statel_sensitivity_specificity.htmDiagnostic<\/a> test evaluation<br \/>\n<a href=\"http:\/\/www.medcalc.org\/calc\/diagnostic_test.phpHow\" rel=\"nofollow\">http:\/\/www.medcalc.org\/calc\/diagnostic_test.phpHow<\/a> to Calculate Sensitivity, Specificity, Positive Predictive Value, and Negative Predictive Value<br \/>\n<a href=\"http:\/\/www.wikihow.com\/Calculate-Sensitivity,-Specificity,-Positive-Predictive-Value,-and-Negative-Predictive-ValueRunning\" rel=\"nofollow\">http:\/\/www.wikihow.com\/Calculate-Sensitivity,-Specificity,-Positive-Predictive-Value,-and-Negative-Predictive-ValueRunning<\/a> a sensitivity and specificity analysis with XLSTAT-Life<br \/>\n<a href=\"http:\/\/www.xlstat.com\/en\/learning-center\/tutorials\/sensitivity-and-specificity-analysis-with-xlstat-life.htmlSimilarity\/Dissimilarity\" rel=\"nofollow\">http:\/\/www.xlstat.com\/en\/learning-center\/tutorials\/sensitivity-and-specificity-analysis-with-xlstat-life.htmlSimilarity\/Dissimilarity<\/a> matrices (correlation-\u00a6) | Statistical Software for Excel<br \/>\n<a href=\"https:\/\/www.xlstat.com\/en\/solutions\/features\/correlations-and-similarity-dissimilarity-matrix\" rel=\"nofollow\">https:\/\/www.xlstat.com\/en\/solutions\/features\/correlations-and-similarity-dissimilarity-matrix<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel bevat behoorlijk wat tools om aan ernstige statistiek te doen. In deze post wil ik wat inspiratie geven. Algemeen http:\/\/www.real-statistics.com http:\/\/www.excelfunctions.net http:\/\/www.excel-easy.com\/ http:\/\/www.statisticshowto.com\/ http:\/\/www.stattutorials.com\/ http:\/\/www.usablestats.com\/ http:\/\/www.socscistatistics.com\/ http:\/\/www.r-tutor.com\/ Topics Fundamentals of Statistics 2: The Normal Distribution http:\/\/www.usablestats.com\/tutorials\/basicStats2Fundamentals of Statistics 3: Sampling http:\/\/www.usablestats.com\/tutorials\/basicStats3Numeracy skills http:\/\/libweb.surrey.ac.uk\/library\/skills\/Number%20Skills%20Leicester\/index.htm ANOVA Analysis of Variance &#8211; ANOVA<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[464,54,375,10,391],"tags":[],"class_list":["post-47436","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-office","category-office-2013"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 13:24:49","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\/47436","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=47436"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/47436\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=47436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=47436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=47436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}