One of my new found skills is cutting numbers 30 different ways using Excel. Por ejemplo, err, uh for example I just finished my Spanish exam.
How did it go?
How should I answer that … firing up excel I first created a 2 way sensitivity analysis around what this grade could be and what that would mean for my next test grade. But, first I built a model of my grades – something simple – Grade, percentage of total, weighted average and the sum of those points.
Good stuff – thank you MBA.
Next I decided that the worst case scenario would be 30%, best 55%, and most likely – 44%. Then using goal seek, I found the totals for the next exam. Thanks to the 73.5% on the first exam, even my worst case scenario shows to get a 51% in the class (D equals done here folks) that I’ll need a 50% on the final exam. Very, very doable.
Now, if I was so inclined I could then use @Risk to see if I took my test 1000 or 10,000 (how much fun would that be?) what my average grade would be given certain circumstances. Hell if I get idle fingers later maybe, just maybe … no.
Ahh, the joys of an MBE so many ways to cut the information but I still can’t see into the future.
PS – no none of those grades are disappointing to me. The listening part was a farking nightmare (-35 points off the top), which gave me a top score of 65 so a 55 would mean I only missed 10 points from the max possible.