My Math Forum  

Go Back   My Math Forum > College Math Forum > Abstract Algebra

Abstract Algebra Abstract Algebra Math Forum


Thanks Tree1Thanks
  • 1 Post By romsek
Reply
 
LinkBack Thread Tools Display Modes
May 16th, 2017, 12:08 PM   #1
Newbie
 
Joined: May 2017
From: Denmark

Posts: 2
Thanks: 0

Cool Ranking values

This probably requires very simple math but my math knowledge is a bit limited

I need to rank countries according to their educational level. I want to know their relative position, so what I did was:
(country w/ worst education level - country x)/(country w/ the worst level - country w/ the best level)

Now my problem is that I would like to reward countries that, even if they do not have the best educational levels, they have an upward trend over the years (in the last 5 years, they have many more graduates than they had before) and likewise penalize countries that havent really evolved through time. How can I do this mathematically speaking?!

Thank you
Martaneves is offline  
 
May 16th, 2017, 01:17 PM   #2
Senior Member
 
romsek's Avatar
 
Joined: Sep 2015
From: CA

Posts: 1,202
Thanks: 613

find the regression line for each countries levels for the past 5 yrs.

The larger the slope of the regression line the better the trend in educational levels.

You can easily do this in Excel. Are you using softare for this?
Thanks from Martaneves
romsek is offline  
May 17th, 2017, 02:13 AM   #3
Newbie
 
Joined: May 2017
From: Denmark

Posts: 2
Thanks: 0

Hi Romsek,

No actually I already have the data. I have it for 2015 and 2005. So basically some countries had a huge increase in the % of population with tertiary education and others stayed virtually the same.
My question is more about how to normalize my values. I want to rate countries according to their total %of tertiary education graduates in 2015 - so that they will range from a score of 0 to a score of 1 ( through this equation : (country w/ worst education level - country x)/(country w/ the worst level - country w/ the best level).
I just would like to add some value to the country if there was an increase in the number of graduates, ten years apart.
Almost as a dummy variable:
Increase - 1
No increase - 0

How can I introduce this so that my values still range from 0 to 1, according to countries' relative position?!
Martaneves is offline  
Reply

  My Math Forum > College Math Forum > Abstract Algebra

Tags
ranking, values



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ranking Probabilities JeffM Advanced Statistics 3 June 14th, 2012 07:24 PM
Help with Poker ranking system hhsmithy Advanced Statistics 0 July 18th, 2011 01:26 AM
Ranking SidT New Users 7 May 30th, 2010 01:32 AM
Help to create ranking formula! demec Real Analysis 2 November 29th, 2009 11:59 AM
Ranking Probabilities JeffM Algebra 1 January 1st, 1970 12:00 AM





Copyright © 2017 My Math Forum. All rights reserved.