Find avg & Max for grades

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Param - 11 Mar 2006 14:51 GMT

I have range (A2:A35) for subject grades (A,B,C,D,E)
What I want to know, it is possible to find avg grade and max grade score by
student?

pls guide me.
TQ

Reply to this Message

Ardus Petus - 11 Mar 2006 15:17 GMT

Average: =CHAR(ROUND(AVERAGE(CODE(A2:A35)),0))
Max: =CHAR(MIN(CODE(A2:A35)))

Grades should be UPPERCASE

HTH
--
AP

> I have range (A2:A35) for subject grades (A,B,C,D,E)
> What I want to know, it is possible to find avg grade and max grade score by
> student?
>
> pls guide me.
> TQ

Reply to this Message

Ardus Petus - 11 Mar 2006 15:28 GMT

I forgot to point out these are array formulas, to be validated by
Ctrl+Shift+Enter

--
AP

> Average: =CHAR(ROUND(AVERAGE(CODE(A2:A35)),0))
> Max: =CHAR(MIN(CODE(A2:A35)))
[quoted text clipped - 12 lines]
> > pls guide me.
> > TQ

Reply to this Message

Param - 12 Mar 2006 20:15 GMT

Hi Mr.Ardus Petus,

solution that u provide really help me a lot. but i face new problem when i
enter - or x symbol. Actually i enter grade from range A to E. Beside that i
enter x if the student absent. - for not sitting the paper.
any idea?

> I forgot to point out these are array formulas, to be validated by
> Ctrl+Shift+Enter
[quoted text clipped - 19 lines]
> > > pls guide me.
> > > TQ

Reply to this Message

Peo Sjoblom - 12 Mar 2006 20:59 GMT

Something like

=CHAR(ROUND(AVERAGE(IF((CODE(A2:A10)>=65)*(CODE(A2:A10)<=69),CODE(A2:A10))),0))

array entered

Signature

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

> Hi Mr.Ardus Petus,
>
[quoted text clipped - 28 lines]
>> > > pls guide me.
>> > > TQ

Reply to this Message

Bob Phillips - 11 Mar 2006 15:21 GMT

The max grade is simple

=CHAR(MIN(IF(B1:B10="Bob",CODE(A1:A10))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Average is harder as what is the avearge of A and B, A, B, A+? I have
assumed down

=CHAR(ROUNDUP(AVERAGE(IF(B1:B10="Bob",MATCH(A1:A10,{"A","B","C","D","E"},0))
),0)+64)

also an array formula

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> I have range (A2:A35) for subject grades (A,B,C,D,E)
> What I want to know, it is possible to find avg grade and max grade score by
> student?
>
> pls guide me.
> TQ

Reply to this Message

Param - 16 Mar 2006 20:05 GMT

Hi, thanks for your tips. but i still not understand for what "bob" and why
there is two different range e.g B1:B10 and A1:A10.

my grade all at cell e.g A2:A35. (beside grade A,B,C,D,E there is also
simbol "-" and "x".
I try this:

> Average: =CHAR(ROUND(AVERAGE(CODE(A2:A35)),0))
> Max: =CHAR(MIN(CODE(A2:A35)))

work fine. But when i enter simbol "-" or "x" it show #value.

Pls show how to overcome this problem. TQ

> The max grade is simple
>
[quoted text clipped - 18 lines]
> > pls guide me.
> > TQ

Reply to this Message

Param - 17 Mar 2006 16:31 GMT

Pls I am waiting to know. Anyone pls reply
TQ in advance.

> I have range (A2:A35) for subject grades (A,B,C,D,E)
> What I want to know, it is possible to find avg grade and max grade score by
> student?
>
> pls guide me.
> TQ

Reply to this Message