My Math Forum Ranking values

 Abstract Algebra Abstract Algebra Math Forum

 May 16th, 2017, 12:08 PM #1 Newbie   Joined: May 2017 From: Denmark Posts: 2 Thanks: 0 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
 May 16th, 2017, 01:17 PM #2 Senior Member     Joined: Sep 2015 From: USA Posts: 2,429 Thanks: 1314 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
 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?!

 Tags ranking, values

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post JeffM Advanced Statistics 3 June 14th, 2012 07:24 PM hhsmithy Advanced Statistics 0 July 18th, 2011 01:26 AM SidT New Users 7 May 30th, 2010 01:32 AM demec Real Analysis 2 November 29th, 2009 10:59 AM JeffM Algebra 1 December 31st, 1969 04:00 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top