A Robust Function to Return the Cumulative Density of Non-Central F Distributions in Microsoft Office Excel

Uloženo v:
Podrobná bibliografie
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