A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel
Uloženo v:
| Název: | A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel |
|---|---|
| Jazyk: | English |
| Autoři: | Nelson, James Byron |
| Zdroj: | Psicologica: International Journal of Methodology and Experimental Psychology. 2016 37(1):61-83. |
| Dostupnost: | 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 |
| Datum vydání: | 2016 |
| Druh dokumentu: | Journal Articles Reports - Descriptive |
| Descriptors: | Spreadsheets, Technology Uses in Education, Computation, Effect Size, Intervals, Evaluation, Probability |
| ISSN: | 0211-2159 |
| Abstrakt: | 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 |
| Přístupové číslo: | EJ1090072 |
| Databáze: | ERIC |
| FullText | Text: Availability: 0 CustomLinks: – Url: https://eric.ed.gov/contentdelivery/servlet/ERICServlet?accno=EJ1090072 Name: ERIC Full Text Category: fullText Text: Full Text from ERIC |
|---|---|
| Header | DbId: eric DbLabel: ERIC An: EJ1090072 AccessLevel: 3 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 0 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel – Name: Language Label: Language Group: Lang Data: English – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Nelson%2C+James+Byron%22">Nelson, James Byron</searchLink> – Name: TitleSource Label: Source Group: Src Data: <searchLink fieldCode="SO" term="%22Psicologica%3A+International+Journal+of+Methodology+and+Experimental+Psychology%22"><i>Psicologica: International Journal of Methodology and Experimental Psychology</i></searchLink>. 2016 37(1):61-83. – Name: Avail Label: Availability Group: Avail Data: 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/ – Name: PeerReviewed Label: Peer Reviewed Group: SrcInfo Data: Y – Name: Pages Label: Page Count Group: Src Data: 23 – Name: DatePubCY Label: Publication Date Group: Date Data: 2016 – Name: TypeDocument Label: Document Type Group: TypDoc Data: Journal Articles<br />Reports - Descriptive – Name: Subject Label: Descriptors Group: Su Data: <searchLink fieldCode="DE" term="%22Spreadsheets%22">Spreadsheets</searchLink><br /><searchLink fieldCode="DE" term="%22Technology+Uses+in+Education%22">Technology Uses in Education</searchLink><br /><searchLink fieldCode="DE" term="%22Computation%22">Computation</searchLink><br /><searchLink fieldCode="DE" term="%22Effect+Size%22">Effect Size</searchLink><br /><searchLink fieldCode="DE" term="%22Intervals%22">Intervals</searchLink><br /><searchLink fieldCode="DE" term="%22Evaluation%22">Evaluation</searchLink><br /><searchLink fieldCode="DE" term="%22Probability%22">Probability</searchLink> – Name: ISSN Label: ISSN Group: ISSN Data: 0211-2159 – Name: Abstract Label: Abstract Group: Ab Data: 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. – Name: AbstractInfo Label: Abstractor Group: Ab Data: As Provided – Name: Ref Label: Number of References Group: RefInfo Data: 15 – Name: DateEntry Label: Entry Date Group: Date Data: 2016 – Name: AN Label: Accession Number Group: ID Data: EJ1090072 |
| PLink | https://erproxy.cvtisr.sk/sfx/access?url=https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=EJ1090072 |
| RecordInfo | BibRecord: BibEntity: Languages: – Text: English PhysicalDescription: Pagination: PageCount: 23 StartPage: 61 Subjects: – SubjectFull: Spreadsheets Type: general – SubjectFull: Technology Uses in Education Type: general – SubjectFull: Computation Type: general – SubjectFull: Effect Size Type: general – SubjectFull: Intervals Type: general – SubjectFull: Evaluation Type: general – SubjectFull: Probability Type: general Titles: – TitleFull: A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Nelson, James Byron IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 01 Type: published Y: 2016 Identifiers: – Type: issn-print Value: 0211-2159 Numbering: – Type: volume Value: 37 – Type: issue Value: 1 Titles: – TitleFull: Psicologica: International Journal of Methodology and Experimental Psychology Type: main |
| ResultId | 1 |