A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel
Gespeichert in:
| Titel: | A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel |
|---|---|
| Sprache: | English |
| Autoren: | Nelson, James Byron |
| Quelle: | Psicologica: International Journal of Methodology and Experimental Psychology. 2016 37(1):61-83. |
| Verfügbarkeit: | University of Valencia. Dept. Metodologia, Facultad de Psicologia, Avda. Blasco Ibanez 21, 46010 Valencia, Spain. Tel: +34-96-386-4100; Web site: http://www.uv.es/revispsi/ |
| Peer Reviewed: | Y |
| Page Count: | 23 |
| Publikationsdatum: | 2016 |
| Publikationsart: | Journal Articles Reports - Descriptive |
| Descriptors: | Spreadsheets, Technology Uses in Education, Computation, Effect Size, Intervals, Evaluation, Probability |
| ISSN: | 0211-2159 |
| Abstract: | The manuscript presents a Visual Basic[superscript R] for Applications function that operates within Microsoft Office Excel[superscript R] to return the area below the curve for a given F within a specified non-central F distribution. The function will be of use to Excel users without programming experience wherever a non-central F distribution is required, such as conducting power analyses for analysis of variance designs and constructing confidence intervals on effect sizes. Tests show the function to produce results comparable to those obtained with the commercial software SPSS and the popular free R environment for statistical computing. Spreadsheets for use in Excel and OpenOffice Calc® are included with example usages. |
| Abstractor: | As Provided |
| Number of References: | 15 |
| Entry Date: | 2016 |
| Dokumentencode: | EJ1090072 |
| Datenbank: | ERIC |
| Abstract: | The manuscript presents a Visual Basic[superscript R] for Applications function that operates within Microsoft Office Excel[superscript R] to return the area below the curve for a given F within a specified non-central F distribution. The function will be of use to Excel users without programming experience wherever a non-central F distribution is required, such as conducting power analyses for analysis of variance designs and constructing confidence intervals on effect sizes. Tests show the function to produce results comparable to those obtained with the commercial software SPSS and the popular free R environment for statistical computing. Spreadsheets for use in Excel and OpenOffice Calc® are included with example usages. |
|---|---|
| ISSN: | 0211-2159 |