+ Reply to Thread
Results 1 to 4 of 4

pass fail

  1. #1
    Tricia
    Guest

    pass fail

    Hi how would I set up a column to give the average of pass to fail rate?
    i.e. if A1 > 50 then put pass in C3 else put fail then give the average of
    passes to fails in cell C20 if there were 19 rows?

    Thanks Tricia



  2. #2
    Tricia
    Guest

    Re: pass fail


    "Tricia" <tricialal2000@yahoo.co.uk> wrote in message
    news:%23ZecUkv$EHA.2572@tk2msftngp13.phx.gbl...
    > Hi how would I set up a column to give the average of pass to fail rate?
    > i.e. if A1 > 50 then put pass in C3 else put fail then give the average of
    > passes to fails in cell C20 if there were 19 rows?
    >
    > Thanks Tricia


    Hi in cells C1:C125 I have

    =IF(A1>50,"pass","fail")
    to
    =IF(A125>50,"pass","fail")
    how do I get an average of the cells C1:C125

    Thanks Tricia



  3. #3
    JulieD
    Guest

    Re: pass fail

    Hi Tricia

    (is this homework? - sounds like the sort of problem i set as a revision
    exercise)

    however, i'm not exactly sure what an an average of passes to fails is but
    i'm guessing that the COUNTIF function is the way to go. - if this is
    homework stop reading now and go try it



    number of passes
    =COUNTIF(C1:C19,"pass")

    number of fails
    =COUNTIF(C1:C19,"fail")

    Cheers
    JulieD

    "Tricia" <tricialal2000@yahoo.co.uk> wrote in message
    news:%23FD2a2v$EHA.4092@TK2MSFTNGP09.phx.gbl...
    >
    > "Tricia" <tricialal2000@yahoo.co.uk> wrote in message
    > news:%23ZecUkv$EHA.2572@tk2msftngp13.phx.gbl...
    >> Hi how would I set up a column to give the average of pass to fail rate?
    >> i.e. if A1 > 50 then put pass in C3 else put fail then give the average
    >> of passes to fails in cell C20 if there were 19 rows?
    >>
    >> Thanks Tricia

    >
    > Hi in cells C1:C125 I have
    >
    > =IF(A1>50,"pass","fail")
    > to
    > =IF(A125>50,"pass","fail")
    > how do I get an average of the cells C1:C125
    >
    > Thanks Tricia
    >




  4. #4
    JE McGimpsey
    Guest

    Re: pass fail

    what do you mean "average of passes to fails"?

    There will be a single discrete number of passes, and a single discrete
    number of failures. What is there to average?

    If you mean the *ratio* of passes to fails, assuming

    C1: =IF(A1>50,"pass","fail"), or

    C1: =IF(A1="","",IF(A1>50,"pass","fail"))

    Then

    C20: =COUNTIF(C1:C19,"pass")/COUNTIF(C1:C19,"fail")

    or if you mean the ratio of passes to total attempts:

    C20: =COUNTIF(C1:C19,"pass")/SUM(COUNTIF(C1:C19,{"pass","fail"}))



    In article <#ZecUkv$EHA.2572@tk2msftngp13.phx.gbl>,
    "Tricia" <tricialal2000@yahoo.co.uk> wrote:

    > Hi how would I set up a column to give the average of pass to fail rate?
    > i.e. if A1 > 50 then put pass in C3 else put fail then give the average of
    > passes to fails in cell C20 if there were 19 rows?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1