Weighted percentage WITHOUT TOTAL KNOWN (ie scaling the weights)

Therush2

New Member
Joined
Nov 12, 2014
Messages
2
Kind of a wierd concept, I can appreciate that.

But, what I'm look for is to do with grades.
For example, one exam is worth 10% of the year and you scored 80/100 and a 2nd exam is worth 40% of the year and you scored 75/100. You haven't done the rest of the exams worth the remaining 50% of the year. WHAT IS THE CURRENT PERCENTAGE MARK?

Because you've only done 50% of the total exams, I would have to SCALE up the ratios: ie make it as if the 50% already done is the whole year by disregarding the 50% not done.

So it would be total weight of exams already completed, which is 50% (10%+40%), then 100%/(50%) which gives me 2. Then multiply both the current weights by the scale: 2 . Then recalculate percentage with NEW weights.

There must be an easier/simpler way of doing this, surely?

Any help is very much appreciated! Thank you!!

:)
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,215,331
Messages
6,124,311
Members
449,152
Latest member
PressEscape

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top