Fuentes de información (en inglés) sobre estadísticas con Excel:
- General
www.real-statistics.com
www.excelfunctions.net
www.excel-easy.com/
www.statisticshowto.com/
www.stattutorials.com/
www.socscistatistics.com/
www.r-tutor.com/ - Temas
Numeracy skills
libweb.surrey.ac.uk/library/skills/Number%20Skills%20Leicester/index.htm - ANOVA
Analysis of Variance – ANOVA in Excel
www.qimacros.com/hypothesis-testing/anova/One-way Analysis of Variance (ANOVA)
www.real-statistics.com/one-way-analysis-of-variance-anova/Anova
www.excel-easy.com/examples/anova.htmlANOVA in Excel: A Walkthrough of Excel’s Variance Analysis Tool
blog.udemy.com/anova-excel/How to Perform Analyses of Variance in Excel
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
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
support.office.com/en-SG/article/use-the-analysis-toolpak-to-perform-complex-data-analysis-b0f0a249-11af-4570-a9cc-becfa6bc0c31 - CHI [incluido en Excel]Excel statistical functions: CHIINV
support.microsoft.com/en-us/kb/828313How to Calculate a Chi Square P Value Excel
www.statisticshowto.com/calculate-chi-square-p-value-excel/Independence Testing
www.real-statistics.com/chi-square-and-f-distributions/independence-testing/The Excel CHISQ.TEST Function
www.excelfunctions.net/Excel-Chisq-Test-Function.htmlThe Excel CHITEST Function
www.excelfunctions.net/Excel-Chitest-Function.htmlTwo-Sample t-Test Assuming Equal Variances in Excel
www.qimacros.com/hypothesis-testing/t-test-two-sample/Values of the Chi-square distribution
www.statlect.com/chi_square_distribution_values.htm - F-TEST [incluido en Excel]F-Test
www.excel-easy.com/examples/f-test.htmlF.TEST function
support.office.com/en-za/article/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7F.TEST function
support.office.com/en-sg/article/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12F test two sample for variances Excel 2013
www.statisticshowto.com/run-f-test-two-sample-variances-excel-2013/F-Tests Determine if Variances are the Same or Different
www.qimacros.com/hypothesis-testing/f-test-two-sample/ - PEARSON [incluido en Excel]Calculate Pearson’s Correlation Using Microsoft Excel
www.stattutorials.com/EXCEL/EXCEL-pearson-correlation.htmlCorrelation
www.gifted.uconn.edu/siegle/research/correlation/excel.htmUtexas
www.laits.utexas.edu/orkelm/excel/EXCEL/PEARSON.HTMPEARSON function
support.office.com/en-sg/article/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1afThe Excel PEARSON Function
www.excelfunctions.net/Excel-Pearson-Function.html - STDEV [incluido en Excel]STDEV function
support.office.com/en-au/article/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223fCalculating the Mean and Standard Deviation with Excel
www.gifted.uconn.edu/siegle/research/normal/stdexcel.htmExplaining Standard Deviation
www.spcforexcel.com/knowledge/basic-statistics/explaining-standard-deviationMeasures of Variability
www.real-statistics.com/descriptive-statistics/measures-variability/Statistics 1 – Averages, standard deviation and confidence
www.meadinkent.co.uk/excel-statistics1.htmThe Excel STDEV Function
www.excelfunctions.net/Excel-Stdev-Function.htmlThe Excel STDEV.S Function
www.excelfunctions.net/Excel-Stdev-S-Function.htmlUnderstanding Standard Deviation
datapigtechnologies.com/blog/index.php/understanding-standard-deviation-2/
Which Standard Deviation to use in Excel: STDEV to STDEV.P
www.statisticshowto.com/which-standard-deviation-to-use-in-excel/ - T-TEST [incluido en Excel]Paired t-test Using Microsoft Excel
www.stattutorials.com/EXCEL/EXCEL_TTEST2.html
t-Test
www.excel-easy.com/examples/t-test.htmlT.TEST function
support.office.com/en-za/article/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055Two Sample (independent group) t-test Using Microsoft Excel
www.stattutorials.com/EXCEL/EXCEL_TTEST1.htmlTwo Sample t Test: unequal variances
www.real-statistics.com/students-t-distribution/two-sample-t-test-uequal-variances/ - KRUSKAL [incluido en Excel]Kruskal-Wallis One-Way ANOVA in Excel with UNISTAT
www.unistat.com/651/Kruskal-Wallis Test
www.real-statistics.com/one-way-analysis-of-variance-anova/kruskal-wallis-test/Kruskal-Wallis Test
www.r-tutor.com/elementary-statistics/non-parametric-methods/kruskal-wallis-testRunning a Kruskal-Wallis test with XLSTAT
www.xlstat.com/en/learning-center/tutorials/running-a-kruskal-wallis-test-with-xlstat.html - Mann-Whitney*Mann-Whitney U-value Calculator
www.socscistatistics.com/tests/mannwhitney/Mann-Whitney Test for Independent Samples
www.real-statistics.com/non-parametric-tests/mann-whitney-test/ - Otros temasExcel and Quartiles
www.meadinkent.co.uk/excel-quartiles.htmHow to Calculate an Interquartile Mean in Excel
smallbusiness.chron.com/calculate-interquartile-mean-excel-37953.htmlHow to Find the IQR
www.wikihow.com/Find-the-IQRReliability
www.real-statistics.com/reliability/StatEL : Calculation of Sensitivity / Specificity
www.adscience.eu/uploads/ckfiles/files/html_files/StatEL/statel_sensitivity_specificity.htmDiagnostic test evaluation
www.medcalc.org/calc/diagnostic_test.phpHow to Calculate Sensitivity, Specificity, Positive Predictive Value, and Negative Predictive Value
www.wikihow.com/Calculate-Sensitivity,-Specificity,-Positive-Predictive-Value,-and-Negative-Predictive-ValueRunning a sensitivity and specificity analysis with XLSTAT-Life
www.xlstat.com/en/learning-center/tutorials/sensitivity-and-specificity-analysis-with-xlstat-life.html
También interesante: el manual de las funciones estadísticas de LibreOffice en help.libreoffice.org/Calc/Statistical_Functions_Part_One/es