Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    A stats question (Any)

    I have got a set of marking Grids produced in Excel by my College and have had to mark recent examinations. I have run through about 20 students not taking note of the scores but then realised that one smart Alec ( one of my students I found later <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) got full marks. One problem when I looked up at this score it only stated 90%, aahhah i exclainmed the College have made a mistake.

    I wanted to tell my students thier "unofficial" scores and not being a stats kind of person I though I would give them a rough score to get them off my back and weight the scores.

    So my question: If the top student got 90% I can weight his score by multiplying his score by 100/90 . What about the people who got say 76%, do I multiply their score by 100/76?

    Be gentle, it's Friday afternoon and my head is not made for statistics so laymens language please!!!
    Jerry

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A stats question (Any)

    What you do to the Top Student, you must do to ALL others.
    =90*100/90
    and
    =76*100/90
    etc
    Regards,
    Rudi

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A stats question (Any)

    Thanks Rudi

    I realised too late.

    If I did 76*(100/76) the student would have got 100%!!!!

    Well I suppose that is one way of guaranteeing all my students pass <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Jerry

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A stats question (Any)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> When can I join your classes! <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Regards,
    Rudi

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A stats question (Any)

    It's now Saturday, so all "gentle" clauses have become null and void. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    It might be worth checking out information on standard scores and similar, if you want to do this more rigorously (not hard at all in Excel).

    Alan

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A stats question (Any)

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Alan, now in My Favourites
    Jerry

Posting Permissions

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