Fuentes de información (mayoritariamente en inglés) sobre estadísticas con Excel:
- General
- Temas
- Fundamentals of Statistics 2: The Normal Distribution
www.usablestats.com/tutorials/basicStats2 - Fundamentals of Statistics 3: Sampling
www.usablestats.com/tutorials/basicStats3 - Numeracy skills
libweb.surrey.ac.uk/library/skills/Number%20Skills%20Leicester/index.htm - Material docente de la Unidad de Bioestadística Clínica
www.hrc.es/bioest/M_docente.html#tema2 - Estadística Básica Edulcorada
bookdown.org/aquintela/EBE/
- Fundamentals of Statistics 2: The Normal Distribution
- 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.html - ANOVA 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.html - Running 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.html - Use 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
- Analysis of Variance – ANOVA in Excel
- CHI [incluido en Excel]
- Excel statistical functions: CHIINV
support.microsoft.com/en-us/kb/828313 - How 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.html - The Excel CHITEST Function
www.excelfunctions.net/Excel-Chitest-Function.html - Two-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
- Excel statistical functions: CHIINV
- F-TEST [incluido en Excel]
- F-Test
www.excel-easy.com/examples/f-test.html - F.TEST function
support.office.com/en-za/article/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7 - F.TEST function
support.office.com/en-sg/article/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12 - F 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/
- F-Test
- PEARSON [incluido en Excel]
- Calculate Pearson’s Correlation Using Microsoft Excel
www.stattutorials.com/EXCEL/EXCEL-pearson-correlation.html - Correlation
www.gifted.uconn.edu/siegle/research/correlation/excel.htm - Utexas
www.laits.utexas.edu/orkelm/excel/EXCEL/PEARSON.HTM - PEARSON function
support.office.com/en-sg/article/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1af - The Excel PEARSON Function
www.excelfunctions.net/Excel-Pearson-Function.html
- Calculate Pearson’s Correlation Using Microsoft Excel
- STDEV [incluido en Excel]
- STDEV function
support.office.com/en-au/article/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223f - Calculating the Mean and Standard Deviation with Excel
www.gifted.uconn.edu/siegle/research/normal/stdexcel.htm - Explaining Standard Deviation
www.spcforexcel.com/knowledge/basic-statistics/explaining-standard-deviation - Measures of Variability
www.real-statistics.com/descriptive-statistics/measures-variability/ - Statistics 1 – Averages, standard deviation and confidence
www.meadinkent.co.uk/excel-statistics1.htm - The Excel STDEV Function
www.excelfunctions.net/Excel-Stdev-Function.html - The Excel STDEV.S Function
www.excelfunctions.net/Excel-Stdev-S-Function.html - Understanding 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/
- STDEV function
- T-TEST [incluido en Excel]
- Paired t-test Using Microsoft Excel
www.stattutorials.com/EXCEL/EXCEL_TTEST2.html - Comparing Two Means: 2 Sample t-test
www.usablestats.com/tutorials/two - Samplett-Test
www.excel-easy.com/examples/t-test.html - T.TEST function
support.office.com/en-za/article/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055 - Two Sample (independent group) t-test Using Microsoft Excel
www.stattutorials.com/EXCEL/EXCEL_TTEST1.html - Two Sample t Test: unequal variances
www.real-statistics.com/students-t-distribution/two-sample-t-test-uequal-variances/
- Paired t-test Using Microsoft Excel
- 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-test - Running a Kruskal-Wallis test with XLSTAT
www.xlstat.com/en/learning-center/tutorials/running-a-kruskal-wallis-test-with-xlstat.html
- Kruskal-Wallis One-Way ANOVA in Excel with UNISTAT
- 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/
- Mann-Whitney U-value Calculator
- Wilcoxon Signed-Ranks Test
- Otros temas
- Excel and Quartiles
www.meadinkent.co.uk/excel-quartiles.htm - How to Calculate an Interquartile Mean in Excel
smallbusiness.chron.com/calculate-interquartile-mean-excel-37953.html - How to Find the IQR
www.wikihow.com/Find-the-IQR - Reliability
www.real-statistics.com/reliability/ - StatEL : Calculation of Sensitivity / Specificity
www.adscience.eu/uploads/ckfiles/files/html_files/StatEL/statel_sensitivity_specificity.htm - Diagnostic test evaluation
www.medcalc.org/calc/diagnostic_test.php - How to Calculate Sensitivity, Specificity, Positive Predictive Value, and Negative Predictive Value
www.wikihow.com/Calculate-Sensitivity,-Specificity,-Positive-Predictive-Value,-and-Negative-Predictive-Value - Running a sensitivity and specificity analysis with XLSTAT-Life
www.xlstat.com/en/learning-center/tutorials/sensitivity-and-specificity-analysis-with-xlstat-life.html
- Excel and Quartiles