Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Help me with Excel, please?

Pipe DreamerPipe Dreamer Registered User regular
edited January 2009 in Help / Advice Forum
I'm working as a TA and it's the end of term, so this means happy fun time with grade calculation. What I have now is an Excel file of the student's assignment scores. The professor wants me to drop each student's lowest score, then average the rest. As I am in charge of roughly 180 students, I really do not want to do this by hand.

Is there a function that could automate this process? I've taken a cursory look through the list, but nothing seemed promising.

Pipe Dreamer on

Posts

  • OrogogusOrogogus San DiegoRegistered User regular
    edited January 2009
    Put something like this at the bottom of each column?

    =(SUM(range)-MIN(range))/(COUNT(range)-1)

    Orogogus on
  • rocketshipreadyrocketshipready Registered User regular
    edited January 2009
    Might be overly complicated, but I think this would work

    =(SUM([range])-MIN([range]))/(COUNT([range])-1)

    Edit: beat, but confired

    rocketshipready on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum