{"id":1231,"date":"2024-03-15T12:28:47","date_gmt":"2024-03-15T12:28:47","guid":{"rendered":"https:\/\/hlrnet.com\/sites\/ebp\/?page_id=1231"},"modified":"2025-04-29T12:11:12","modified_gmt":"2025-04-29T12:11:12","slug":"estadistica-excelente-y-casera","status":"publish","type":"page","link":"https:\/\/hlrnet.com\/sites\/ebp\/estadistica-excelente-y-casera\/","title":{"rendered":"Estad\u00edstica EXCELente (y casera)"},"content":{"rendered":"<p>Fuentes de informaci\u00f3n (mayoritariamente en ingl\u00e9s) sobre estad\u00edsticas con Excel:<\/p>\n<ul>\n<li><strong>General<br \/>\n<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/www.real-statistics.com\" rel=\"nofollow\">www.real-statistics.com<\/a><\/li>\n<li><a href=\"http:\/\/www.excelfunctions.net\" rel=\"nofollow\">www.excelfunctions.net<\/a><\/li>\n<li><a href=\"http:\/\/www.excel-easy.com\/\" rel=\"nofollow\">www.excel-easy.com\/<\/a><\/li>\n<li><a href=\"http:\/\/www.statisticshowto.com\/\" rel=\"nofollow\">www.statisticshowto.com\/<\/a><\/li>\n<li><a href=\"http:\/\/www.stattutorials.com\/\" rel=\"nofollow\">www.stattutorials.com\/<\/a><\/li>\n<li><a href=\"http:\/\/www.socscistatistics.com\/\" rel=\"nofollow\">www.socscistatistics.com\/<\/a><\/li>\n<li><a href=\"http:\/\/www.r-tutor.com\/\" rel=\"nofollow\">www.r-tutor.com\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Temas<\/strong>\n<ul>\n<li>Material docente de la Unidad de Bioestad\u00edstica Cl\u00ednica<br \/>\n<a class=\"autohyperlink\" href=\"http:\/\/www.hrc.es\/bioest\/M_docente.html#tema2\">www.hrc.es\/bioest\/M_docente.html#tema2<\/a><\/li>\n<li>Estad\u00edstica B\u00e1sica Edulcorada<br \/>\n<a class=\"autohyperlink\" href=\"https:\/\/bookdown.org\/aquintela\/EBE\/\">bookdown.org\/aquintela\/EBE\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>ANOVA<\/strong>\n<ul>\n<li>Analysis of Variance \u2013 ANOVA in Excel<br \/>\n<a href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/anova\/\" rel=\"nofollow\">www.qimacros.com\/hypothesis-testing\/anova\/<\/a><\/li>\n<li>One-way Analysis of Variance (ANOVA)<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/\" rel=\"nofollow\">www.real-statistics.com\/one-way-analysis-of-variance-anova\/<\/a><\/li>\n<li>Anova<br \/>\n<a href=\"http:\/\/www.excel-easy.com\/examples\/anova.html\" rel=\"nofollow\">www.excel-easy.com\/examples\/anova.html<\/a><\/li>\n<li>ANOVA in Excel: A Walkthrough of Excel\u2019s Variance Analysis Tool<br \/>\n<a href=\"https:\/\/blog.udemy.com\/anova-excel\/\" rel=\"nofollow\">blog.udemy.com\/anova-excel\/<\/a><\/li>\n<li>How 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.html\" rel=\"nofollow\">www.dummies.com\/how-to\/content\/how-to-perform-analyses-of-variance-in-excel.html<\/a><\/li>\n<li>Running 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.html\" rel=\"nofollow\">www.xlstat.com\/en\/learning-center\/tutorials\/running-a-one-way-anova-followed-by-multiple-comparisons-tests-with-xlstat.html<\/a><\/li>\n<li>Use 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\">support.office.com\/en-SG\/article\/use-the-analysis-toolpak-to-perform-complex-data-analysis-b0f0a249-11af-4570-a9cc-becfa6bc0c31<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>CHI\u00a0\u00a0<\/strong>[incluido en\u00a0Excel]\n<ul>\n<li>Excel statistical functions: CHIINV<br \/>\n<a href=\"http:\/\/support.microsoft.com\/en-us\/kb\/828313\" rel=\"nofollow\">support.microsoft.com\/en-us\/kb\/828313<\/a><\/li>\n<li>How to Calculate a Chi Square P Value Excel<br \/>\n<a href=\"http:\/\/www.statisticshowto.com\/calculate-chi-square-p-value-excel\/\" rel=\"nofollow\">www.statisticshowto.com\/calculate-chi-square-p-value-excel\/<\/a><\/li>\n<li>Independence Testing<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/chi-square-and-f-distributions\/independence-testing\/\" rel=\"nofollow\">www.real-statistics.com\/chi-square-and-f-distributions\/independence-testing\/<\/a><\/li>\n<li>The Excel CHISQ.TEST Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Chisq-Test-Function.html\" rel=\"nofollow\">www.excelfunctions.net\/Excel-Chisq-Test-Function.html<\/a><\/li>\n<li>The Excel CHITEST Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Chitest-Function.html\" rel=\"nofollow\">www.excelfunctions.net\/Excel-Chitest-Function.html<\/a><\/li>\n<li>Two-Sample t-Test Assuming Equal Variances in Excel<br \/>\n<a class=\"autohyperlink\" href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/t-test-two-sample\/\">www.qimacros.com\/hypothesis-testing\/t-test-two-sample\/<\/a><\/li>\n<li>Values of the Chi-square distribution<br \/>\n<a href=\"http:\/\/www.statlect.com\/chi_square_distribution_values.htm\" rel=\"nofollow\">www.statlect.com\/chi_square_distribution_values.htm<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>F-TEST\u00a0<\/strong>\u00a0[incluido en Excel]\n<ul>\n<li>F-Test<br \/>\n<a href=\"http:\/\/www.excel-easy.com\/examples\/f-test.html\" rel=\"nofollow\">www.excel-easy.com\/examples\/f-test.html<\/a><\/li>\n<li>F.TEST function<br \/>\n<a href=\"https:\/\/support.office.com\/en-za\/article\/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7\" rel=\"nofollow\">support.office.com\/en-za\/article\/FTEST-function-100a59e7-4108-46f8-8443-78ffacb6c0a7<\/a><\/li>\n<li>F.TEST function<br \/>\n<a href=\"https:\/\/support.office.com\/en-sg\/article\/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12\" rel=\"nofollow\">support.office.com\/en-sg\/article\/FTEST-function-04435ed3-d558-48e4-9636-38ae6d677f12<\/a><\/li>\n<li>F test two sample for variances Excel 2013<br \/>\n<a class=\"autohyperlink\" href=\"http:\/\/www.statisticshowto.com\/run-f-test-two-sample-variances-excel-2013\/\">www.statisticshowto.com\/run-f-test-two-sample-variances-excel-2013\/<\/a><\/li>\n<li>F-Tests Determine if Variances are the Same or Different<br \/>\n<a href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/f-test-two-sample\/\" rel=\"nofollow\">www.qimacros.com\/hypothesis-testing\/f-test-two-sample\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>PEARSON<\/strong>\u00a0[incluido en Excel]\n<ul>\n<li>Calculate Pearson\u2019s Correlation Using Microsoft Excel<br \/>\n<a href=\"http:\/\/www.stattutorials.com\/EXCEL\/EXCEL-pearson-correlation.html\" rel=\"nofollow\">www.stattutorials.com\/EXCEL\/EXCEL-pearson-correlation.html<\/a><\/li>\n<li>Correlation<br \/>\n<a href=\"http:\/\/www.gifted.uconn.edu\/siegle\/research\/correlation\/excel.htm\" rel=\"nofollow\">www.gifted.uconn.edu\/siegle\/research\/correlation\/excel.htm<\/a><\/li>\n<li>Utexas<br \/>\n<a href=\"http:\/\/www.laits.utexas.edu\/orkelm\/excel\/EXCEL\/PEARSON.HTM\" rel=\"nofollow\">www.laits.utexas.edu\/orkelm\/excel\/EXCEL\/PEARSON.HTM<\/a><\/li>\n<li>PEARSON function<br \/>\n<a href=\"https:\/\/support.office.com\/en-sg\/article\/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1af\" rel=\"nofollow\">support.office.com\/en-sg\/article\/PEARSON-function-22f752ac-ad5a-4f1f-a2cf-1ef7ed96e1af<\/a><\/li>\n<li>The Excel PEARSON Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Pearson-Function.html\" rel=\"nofollow\">www.excelfunctions.net\/Excel-Pearson-Function.html<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>STDEV<\/strong> [incluido en Excel]\n<ul>\n<li>STDEV function<br \/>\n<a href=\"https:\/\/support.office.com\/en-au\/article\/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223f\" rel=\"nofollow\">support.office.com\/en-au\/article\/STDEV-function-a0179959-f6e4-47ec-8818-a0b43026223f<\/a><\/li>\n<li>Calculating the Mean and Standard Deviation with Excel<br \/>\n<a href=\"http:\/\/www.gifted.uconn.edu\/siegle\/research\/normal\/stdexcel.htm\" rel=\"nofollow\">www.gifted.uconn.edu\/siegle\/research\/normal\/stdexcel.htm<\/a><\/li>\n<li>Explaining Standard Deviation<br \/>\n<a href=\"http:\/\/www.spcforexcel.com\/knowledge\/basic-statistics\/explaining-standard-deviation\" rel=\"nofollow\">www.spcforexcel.com\/knowledge\/basic-statistics\/explaining-standard-deviation<\/a><\/li>\n<li>Measures of Variability<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/descriptive-statistics\/measures-variability\/\" rel=\"nofollow\">www.real-statistics.com\/descriptive-statistics\/measures-variability\/<\/a><\/li>\n<li>Statistics 1 \u2013 Averages, standard deviation and confidence<br \/>\n<a href=\"http:\/\/www.meadinkent.co.uk\/excel-statistics1.htm\" rel=\"nofollow\">www.meadinkent.co.uk\/excel-statistics1.htm<\/a><\/li>\n<li>The Excel STDEV Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Stdev-Function.html\" rel=\"nofollow\">www.excelfunctions.net\/Excel-Stdev-Function.html<\/a><\/li>\n<li>The Excel STDEV.S Function<br \/>\n<a href=\"http:\/\/www.excelfunctions.net\/Excel-Stdev-S-Function.html\" rel=\"nofollow\">www.excelfunctions.net\/Excel-Stdev-S-Function.html<\/a><\/li>\n<li>Understanding Standard Deviation<br \/>\n<a class=\"autohyperlink\" href=\"http:\/\/datapigtechnologies.com\/blog\/index.php\/understanding-standard-deviation-2\/\">datapigtechnologies.com\/blog\/index.php\/understanding-standard-deviation-2\/<\/a><\/li>\n<li>Which Standard Deviation to use in Excel: STDEV to STDEV.P<br \/>\n<a class=\"autohyperlink\" href=\"http:\/\/www.statisticshowto.com\/which-standard-deviation-to-use-in-excel\/\">www.statisticshowto.com\/which-standard-deviation-to-use-in-excel\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>T-TEST<\/strong> \u00a0[incluido en Excel]\n<ul>\n<li>Paired t-test Using Microsoft Excel<br \/>\n<a href=\"http:\/\/www.stattutorials.com\/EXCEL\/EXCEL_TTEST2.html\" rel=\"nofollow\">www.stattutorials.com\/EXCEL\/EXCEL_TTEST2.html<\/a><\/li>\n<li>Samplett-Test<br \/>\n<a href=\"http:\/\/www.excel-easy.com\/examples\/t-test.html\" rel=\"nofollow\">www.excel-easy.com\/examples\/t-test.html<\/a><\/li>\n<li>T.TEST function<br \/>\n<a href=\"https:\/\/support.office.com\/en-za\/article\/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055\" rel=\"nofollow\">support.office.com\/en-za\/article\/TTEST-function-d4e08ec3-c545-485f-962e-276f7cbed055<\/a><\/li>\n<li>Two Sample (independent group) t-test Using Microsoft Excel<br \/>\n<a href=\"http:\/\/www.stattutorials.com\/EXCEL\/EXCEL_TTEST1.html\" rel=\"nofollow\">www.stattutorials.com\/EXCEL\/EXCEL_TTEST1.html<\/a><\/li>\n<li>Two 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\">www.real-statistics.com\/students-t-distribution\/two-sample-t-test-uequal-variances\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>KRUSKAL<\/strong> \u00a0[incluido en Excel]\n<ul>\n<li>Kruskal-Wallis One-Way ANOVA in Excel with UNISTAT<br \/>\n<a href=\"https:\/\/www.unistat.com\/651\/\" rel=\"nofollow\">www.unistat.com\/651\/<\/a><\/li>\n<li>Kruskal-Wallis Test<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/kruskal-wallis-test\/\" rel=\"nofollow\">www.real-statistics.com\/one-way-analysis-of-variance-anova\/kruskal-wallis-test\/<\/a><\/li>\n<li>Kruskal-Wallis Test<br \/>\n<a href=\"http:\/\/www.r-tutor.com\/elementary-statistics\/non-parametric-methods\/kruskal-wallis-test\" rel=\"nofollow\">www.r-tutor.com\/elementary-statistics\/non-parametric-methods\/kruskal-wallis-test<\/a><\/li>\n<li>Running 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\">www.xlstat.com\/en\/learning-center\/tutorials\/running-a-kruskal-wallis-test-with-xlstat.html<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Mann-Whitney<\/strong>*\n<ul>\n<li>Mann-Whitney U-value Calculator<br \/>\n<a href=\"http:\/\/www.socscistatistics.com\/tests\/mannwhitney\/\" rel=\"nofollow\">www.socscistatistics.com\/tests\/mannwhitney\/<\/a><\/li>\n<li>Mann-Whitney Test for Independent Samples<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/non-parametric-tests\/mann-whitney-test\/\" rel=\"nofollow\">www.real-statistics.com\/non-parametric-tests\/mann-whitney-test\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Wilcoxon Signed-Ranks Test<\/strong>\n<ul>\n<li><a href=\"http:\/\/www.real-statistics.com\/non-parametric-tests\/wilcoxon-signed-ranks-test\/\">www.real-statistics.com\/non-parametric-tests\/wilcoxon-signed-ranks-test\/<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Otros temas<br \/>\n<\/strong><\/p>\n<ul>\n<li>Excel and Quartiles<br \/>\n<a href=\"http:\/\/www.meadinkent.co.uk\/excel-quartiles.htm\" rel=\"nofollow\">www.meadinkent.co.uk\/excel-quartiles.htm<\/a><\/li>\n<li>How to Calculate an Interquartile Mean in Excel<br \/>\n<a href=\"http:\/\/smallbusiness.chron.com\/calculate-interquartile-mean-excel-37953.html\" rel=\"nofollow\">smallbusiness.chron.com\/calculate-interquartile-mean-excel-37953.html<\/a><\/li>\n<li>How to Find the IQR<br \/>\n<a href=\"http:\/\/www.wikihow.com\/Find-the-IQR\" rel=\"nofollow\">www.wikihow.com\/Find-the-IQR<\/a><\/li>\n<li>Reliability<br \/>\n<a href=\"http:\/\/www.real-statistics.com\/reliability\/\" rel=\"nofollow\">www.real-statistics.com\/reliability\/<\/a><\/li>\n<li>StatEL : Calculation of Sensitivity \/ Specificity<br \/>\n<a href=\"http:\/\/www.adscience.eu\/uploads\/ckfiles\/files\/html_files\/StatEL\/statel_sensitivity_specificity.htm\" rel=\"nofollow\">www.adscience.eu\/uploads\/ckfiles\/files\/html_files\/StatEL\/statel_sensitivity_specificity.htm<\/a><\/li>\n<li>Diagnostic test evaluation<br \/>\n<a href=\"http:\/\/www.medcalc.org\/calc\/diagnostic_test.php\" rel=\"nofollow\">www.medcalc.org\/calc\/diagnostic_test.php<\/a><\/li>\n<li>How 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-Value\" rel=\"nofollow\">www.wikihow.com\/Calculate-Sensitivity,-Specificity,-Positive-Predictive-Value,-and-Negative-Predictive-Value<\/a><\/li>\n<li>Running 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.html\" rel=\"nofollow\">www.xlstat.com\/en\/learning-center\/tutorials\/sensitivity-and-specificity-analysis-with-xlstat-life.html<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Fuentes de informaci\u00f3n (mayoritariamente en ingl\u00e9s) sobre estad\u00edsticas con Excel: General <a href=\"http:\/\/www.real-statistics.com\" class=\"autohyperlink\">www.real-statistics.com<\/a> <a href=\"http:\/\/www.excelfunctions.net\" class=\"autohyperlink\">www.excelfunctions.net<\/a> <a href=\"http:\/\/www.excel-easy.com\/\" class=\"autohyperlink\">www.excel-easy.com\/<\/a> <a href=\"http:\/\/www.statisticshowto.com\/\" class=\"autohyperlink\">www.statisticshowto.com\/<\/a> <a href=\"http:\/\/www.stattutorials.com\/\" class=\"autohyperlink\">www.stattutorials.com\/<\/a> <a href=\"http:\/\/www.socscistatistics.com\/\" class=\"autohyperlink\">www.socscistatistics.com\/<\/a> <a href=\"http:\/\/www.r-tutor.com\/\" class=\"autohyperlink\">www.r-tutor.com\/<\/a> Temas Material docente de la Unidad de Bioestad\u00edstica Cl\u00ednica www.hrc.es\/bioest\/M_docente.html#tema2 Estad\u00edstica B\u00e1sica Edulcorada <a href=\"http:\/\/bookdown.org\/aquintela\/EBE\/\" class=\"autohyperlink\">bookdown.org\/aquintela\/EBE\/<\/a> ANOVA Analysis of Variance \u2013 ANOVA in Excel <a href=\"http:\/\/www.qimacros.com\/hypothesis-testing\/anova\/\" class=\"autohyperlink\">www.qimacros.com\/hypothesis-testing\/anova\/<\/a> One-way Analysis of Variance (ANOVA) <a href=\"http:\/\/www.real-statistics.com\/one-way-analysis-of-variance-anova\/\" class=\"autohyperlink\">www.real-statistics.com\/one-way-analysis-of-variance-anova\/<\/a> Anova <a href=\"http:\/\/www.excel-easy.com\/examples\/anova.html\" class=\"autohyperlink\">www.excel-easy.com\/examples\/anova.html<\/a> ANOVA<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"class_list":["post-1231","page","type-page","status-publish","hentry"],"publishpress_future_action":{"enabled":false,"date":"2026-05-04 06:22:16","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/pages\/1231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/comments?post=1231"}],"version-history":[{"count":14,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/pages\/1231\/revisions"}],"predecessor-version":[{"id":1411,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/pages\/1231\/revisions\/1411"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/media?parent=1231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}