Find out the correct percentage (some values are unknown)

[mill99]

Hey guys,

I am tripping on this one and I reeeeeeally need your help.

Basically I would like to find out what some data mean in percentage terms. An exams gives your overall result as a percentage but it doesn't give the breakdown of the subject. In fact, there is a scale and results falls between the bands; it only says exceptional, good, borderline and weak.

Can anyone help me ? I tried to work on an Excel file, dividing the bands in 15, ie 100 (max), 85 (exceptional), 70 (good), 55 (borderline) and 40 (weak). Dividing the marks within each band so that there are five in each. Example 100 (max), 97, 94, 91, 88, 85 (borderline). However, it doesn't add up to the final result.

Perhaps it's really simple, but I can get my head around it.

Thanks heaps!

The real examples are here:

a)
http://1.bp.blogspot.com/_wg0bM4eIX...AAAHY/hHIqI1ZhD_A/s1600/StatementOfResult.jpg

--> Final result as you can see was 65/100

b)
http://www.google.com/imgres?q=camb...=96&start=0&ndsp=15&ved=1t:429,r:12,s:0,i:108

--> Final result 68/100

 

[Deleted member 4993]

Hey guys,

I am tripping on this one and I reeeeeeally need your help.

Basically I would like to find out what some data mean in percentage terms. An exams gives your overall result as a percentage but it doesn't give the breakdown of the subject. In fact, there is a scale and results falls between the bands; it only says exceptional, good, borderline and weak.

Can anyone help me ? I tried to work on an Excel file, dividing the bands in 15, ie 100 (max), 85 (exceptional), 70 (good), 55 (borderline) and 40 (weak). Dividing the marks within each band so that there are five in each. Example 100 (max), 97, 94, 91, 88, 85 (borderline). However, it doesn't add up to the final result.

Perhaps it's really simple, but I can get my head around it.

Thanks heaps!

The real examples are here:

a)
http://1.bp.blogspot.com/_wg0bM4eIX...AAAHY/hHIqI1ZhD_A/s1600/StatementOfResult.jpg

--> Final result as you can see was 65/100

b)
http://www.google.com/imgres?q=camb...=96&start=0&ndsp=15&ved=1t:429,r:12,s:0,i:108

--> Final result 68/100

There is no way to know for sure - and

why do you want to know?

If I assign 76, 74, 59, 59 and 58 for Listening, Understanding, Reading, etc. - I get an average of 65.2.

Close enough!!!

Please share your work with us,indicating exactly where you are stuck - so that we may know where to begin to help you.

 

[mill99]

Subhotosh Khan:

Thanks heaps for your answer Subhotosh Khan! Why do you say that there is no way to knowing for sure ? Also, would your math for example 2 as well ?

Denis:

Why are you saying that the two links are not helpful ? They are real examples and they are the only way to figure out the numbers, I assume.

If anyone can help me pleeeeeeease let me know

 

[mill99]

Also, how about if the five bands instead of being equal are logarithmic as suggested in the paper.
Ie:

Top-Exceptional 80-100
Exceptional-Good 75-79
Good-Borderline 60-74
Borderline-Weak 55-59
Weak-Below 0-54

 

[mill99]

Hey Jeff, you are right, my apologies.
All five papers carry the same weight. Each of them is worth 20% of the overall exam.
I suspect that every band is divided in four levels, except for the exceptional and above level which I think only has two levels.

After having look at different results I think the breakdown is something like this.

Any further thoughts or questions ?

	2	95	100
	1	88	94
Exceptional
	4	85	87
	3	82	84
	2	79	81
	1	76	78
Good
	4	72	75
	3	68	71
	2	64	67
	1	60	63
Borderline
	4	56	59
	3	52	55
	2	48	51
	1	45	47
Weak
	4	41	44