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 – ANOVA in Excel
http://www.qimacros.com/hypothesis-testing/anova/One-way Analysis of Variance (ANOVA)
http://www.real-statistics.com/one-way-analysis-of-variance-anova/Anova
http://www.excel-easy.com/examples/anova.html
ANOVA in Excel: A Walkthrough of Excel’s Variance Analysis Tool
https://blog.udemy.com/anova-excel/How to Perform Analyses of Variance in Excel
http://www.dummies.com/how-to/content/how-to-perform-analyses-of-variance-in-excel.htmlRunning a one-way ANOVA followed by multiple comparisons tests with XLSTAT
http://www.xlstat.com/en/learning-center/tutorials/running-a-one-way-anova-followed-by-multiple-comparisons-tests-with-xlstat.htmlUse the Analysis ToolPak to perform complex data analysis
https://support.office.com/en-SG/article/use-the-analysis-toolpak-to-perform-complex-data-analysis-b0f0a249-11af-4570-a9cc-becfa6bc0c31 - Boxplot & whisker
Box-and-Whisker Charts for Excel
http://www.dummies.com/how-to/content/boxandwhisker-charts-for-excel.htmlEen verticale boxplot bouwen
http://www.exceltekstenuitleg.nl/uploads/5/1/6/5/5165009/bonushoofdstuk_boxplots_verticaal.pdfExcel Box and Whisker Diagrams (Box Plots)
http://peltiertech.com/excel-box-and-whisker-diagrams-box-plots/How to make Box plots in Excel [Dashboard Essentials]
http://chandoo.org/wp/2012/07/31/excel-box-plot-tutorial/ - CHI Â [inbegrepen in Excel]
Excel statistical functions: CHIINV
http://support.microsoft.com/en-us/kb/828313
How to Calculate a Chi Square P Value Excel
http://www.statisticshowto.com/calculate-chi-square-p-value-excel/
Independence Testing
The Excel CHISQ.TEST Function
http://www.excelfunctions.net/Excel-Chisq-Test-Function.htmlThe Excel CHITEST Function
http://www.excelfunctions.net/Excel-Chitest-Function.htmlTwo-Sample t-Test Assuming Equal Variances in Excel
http://www.qimacros.com/hypothesis-testing/t-test-two-sample/Values of the Chi-square distribution
http://www.statlect.com/chi_square_distribution_values.htm - F-TESTÂ Â [inbegrepen in Excel]
F-Test
http://www.excel-easy.com/examples/f-test.html
F.TEST function
https://support.office.com/en-za/article/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7
F.TEST function
https://support.office.com/en-sg/article/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12
F test two sample for variances Excel 2013
http://www.statisticshowto.com/run-f-test-two-sample-variances-excel-2013/F-Tests Determine if Variances are the Same or Different
http://www.qimacros.com/hypothesis-testing/f-test-two-sample/ - Jaccard
Excel VBA: Weighted Jaccard Similarity (Fuzzy Lookup) – Stack Overflow
https://stackoverflow.com/questions/43239800/excel-vba-weighted-jaccard-similarity-fuzzy-lookup
Jaccard Index / Similarity Coefficient – Statistics How To
https://www.statisticshowto.datasciencecentral.com/jaccard-index/ - KAPPA
Calculate Kappa with Excel
How to Calculate Kappa with Excel
https://www.ehow.com/how_8574521_calculate-kappa-excel.html
Kappa and Weighted-Kappa
http://analyse-it.com/docs/220/standard/kappa_inter-rater_agreement.htm - Kolmogorov-Smirnov
Kolmogorov-Smirnov Test in Excel using the QI Macros
https://www.qimacros.com/hypothesis-testing/kolmogorov-smirnov-statistic-excel/Kolmogorov-Smirnov Test for Normality
Kolmogorov-Smirnov Tests in Excel with UNISTAT
https://www.unistat.com/632/ - Morisita
Morisita Index – Statistics How To
https://www.statisticshowto.datasciencecentral.com/morisita-index/
- PEARSON Â [inbegrepen in Excel]
Calculate Pearson’s Correlation Using Microsoft Excel
http://www.stattutorials.com/EXCEL/EXCEL-pearson-correlation.html
Correlation
http://www.gifted.uconn.edu/siegle/research/correlation/excel.htm
Utexas
http://www.laits.utexas.edu/orkelm/excel/EXCEL/PEARSON.HTM
PEARSON function
https://support.office.com/en-sg/article/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1afThe Excel PEARSON Function
http://www.excelfunctions.net/Excel-Pearson-Function.HTML - Skew & Kurtosis
KURTOSIS, functie
https://support.office.com/nl-be/article/KURTOSIS-functie-bc3a265c-5da4-4dcb-b7fd-c237789095ab?ui=fr-FR&rs=nl-BE&ad=BE
Kurtosis in Excel (KURT) – http://www.macroption.com/kurtosis-excel-kurt/
SKEW function – https://support.office.com/en-sg/article/SKEW-function-bdf49d86-b1ef-4804-a046-28eaea69c9fa?CorrelationId=004b5b3a-0052-4aa0-8e7d-9075e4844ac0&ui=en-US&rs=en-SG&ad=SG - Sorensen (overlap)
Sørensen Similarity Index – Formula
http://www.liquisearch.com/s%C3%B8rensen_similarity_index/formula
Sørensen-“Dice coefficient – Wikipedia
https://en.wikipedia.org/wiki/S%C3%B8rensen%E2%80%93Dice_coefficient - STDEV Â [inbegrepen in Excel]
STDEV function
https://support.office.com/en-au/article/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223f
Calculating the Mean and Standard Deviation with Excel
http://www.gifted.uconn.edu/siegle/research/normal/stdexcel.htm
Explaining Standard Deviation
http://www.spcforexcel.com/knowledge/basic-statistics/explaining-standard-deviation
Measures of Variability
http://www.real-statistics.com/descriptive-statistics/measures-variability/Statistics 1 – Averages, standard deviation and confidence
http://www.meadinkent.co.uk/excel-statistics1.htmThe Excel STDEV Function
http://www.excelfunctions.net/Excel-Stdev-Function.html
The Excel STDEV.S Function
http://www.excelfunctions.net/Excel-Stdev-S-Function.html
Understanding Standard Deviationhttp://datapigtechnologies.com/blog/index.php/understanding-standard-deviation-2/
Which Standard Deviation to use in Excel: STDEV to STDEV.P
http://www.statisticshowto.com/which-standard-deviation-to-use-in-excel/ - T-TEST Â [inbegrepen in Excel]
Paired t-test Using Microsoft Excel
http://www.stattutorials.com/EXCEL/EXCEL_TTEST2.htmlComparing Two Means: 2 Sample t-test
http://www.usablestats.com/tutorials/twoSamplett-Test
http://www.excel-easy.com/examples/t-test.htmlT.TEST function
https://support.office.com/en-za/article/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055Two Sample (independent group) t-test Using Microsoft Excel
http://www.stattutorials.com/EXCEL/EXCEL_TTEST1.htmlTwo Sample t Test: unequal variances
http://www.real-statistics.com/students-t-distribution/two-sample-t-test-uequal-variances/ - KRUSKAL Â [inbegrepen in Excel]
Kruskal-Wallis One-Way ANOVA in Excel with UNISTAT
https://www.unistat.com/651/Kruskal-Wallis Test
Kruskal-Wallis Test
http://www.r-tutor.com/elementary-statistics/non-parametric-methods/kruskal-wallis-test
Running a Kruskal-Wallis test with XLSTAT
http://www.xlstat.com/en/learning-center/tutorials/running-a-kruskal-wallis-test-with-xlstat.html - Mann-Whitney
Mann-Whitney U-value Calculator
http://www.socscistatistics.com/tests/mannwhitney/Mann-Whitney Test for Independent Samples
http://www.real-statistics.com/non-parametric-tests/mann-whitney-test/ - Wilcoxon Signed-Ranks Test
http://www.real-statistics.com/non-parametric-tests/wilcoxon-signed-ranks-test/ - Andere topics
Excel and Quartiles
http://www.meadinkent.co.uk/excel-quartiles.htmHow to Calculate an Interquartile Mean in Excel
http://smallbusiness.chron.com/calculate-interquartile-mean-excel-37953.htmlHow to Find the IQR
http://www.wikihow.com/Find-the-IQRReliability
http://www.real-statistics.com/reliability/StatEL : Calculation of Sensitivity / Specificity
http://www.adscience.eu/uploads/ckfiles/files/html_files/StatEL/statel_sensitivity_specificity.htmDiagnostic test evaluation
http://www.medcalc.org/calc/diagnostic_test.phpHow to Calculate Sensitivity, Specificity, Positive Predictive Value, and Negative Predictive Value
http://www.wikihow.com/Calculate-Sensitivity,-Specificity,-Positive-Predictive-Value,-and-Negative-Predictive-ValueRunning a sensitivity and specificity analysis with XLSTAT-Life
http://www.xlstat.com/en/learning-center/tutorials/sensitivity-and-specificity-analysis-with-xlstat-life.htmlSimilarity/Dissimilarity matrices (correlation-¦) | Statistical Software for Excel
https://www.xlstat.com/en/solutions/features/correlations-and-similarity-dissimilarity-matrix