Quote:
Originally Posted by HiFi
Your version of the chart has a rogue value of 79.52 in cell T56. That clearly shouldn't be there, download it again.
|
The "rogue value" is the sum Cells T22 to T55, and is a formula I placed in Cell T56 for my own use. The images are screen shots of the spreadsheet.
Quote:
Originally Posted by HiFi
All I can say is that 25.8+12.1+11.4+4.7+4.6+4.3+4.1+3.6+3.6+3.1+3+2.1+1 .9+1.7+1.6+1.6+1.1+1.1+8.6
adds up to 100.0% so the chart is not reporting those countries' internal education percentages, but their percentages in the world.
|
That is because you don't understand the spreadsheet. I can help you with the math, but I can't really help with reading and comprehending the English language.
If you understand what this says....
'Table A1.3a. Population with tertiary education (2009)
Then it is very, very easy to understand Table A1.3a.
I direct your attention to Cell S19. That is Age Group 25-64 Total Tertiary Education.
How many Americans ages 25-64 have Tertiary Education? The answer is in Cell S55 which clearly shows that 66,148,000 Americans ages 25-64 have tertiary education.
Who on this forum does not understand that?
What is the population of the united States? Approximately 315 Million people.
If 66,148,000 Americans have tertiary education, then what percent of the American population has tertiary education?
66,148,000 / 315,000,000 = 0.2099 * 100 = 20.99%
If we view the data in Cell T55 it shows 25.75%.
The discrepancy of ~4.75% is easily explained by the fact that we took the entire US population, instead of the US population ages 25-64.
Since the data is from Year 2009, we can get a better approximate by using data from the US Bureau of Labor Statistics, specifically LNU00000000 which is the Civilian non-Institutional Population Age 16 and Over.
That number is 235,801,000.....
66,148,000 / 235,801,000 = 0.2805 * 100 = 28.05%
If we removed those persons ages 16-24 from the population group, then we would reach the 25.75%
I show the math here, because you and so many others simply refuse to admit that the data in spreadsheet Column S is the number of people in each State ages 25-64 that have tertiary education.
Denmark: 835,000 Danes ages 25-64 have university education
France: 9,263,000 French ages 25-64 have university education
Germany: 11,271,000 Germans ages 25-64 have university education
Norway: 915,000 Norwegians ages 25-64 have university education
Spain: 7,844,000 Spaniards ages 25-64 have university education
Sweden: 1,592,000 Swedes ages 25-64 have university education
Britain: 11,992,000 Brits ages 25-64 have university education
America: 66,148,000 Americans ages 25-64 have university education
Who does not understand this incredibly simple data?
I have already proven that 25% of Americans age 25-64 have university education.
We know from our 6th Grade Math that 25% is same-same 1-in-4
Had any of you bothered to look at Cell T71, then you would have seen 179.52% which tells you what?
It tells you the OECD cherry-picked the data to get 100%, unless some want to make the ridiculous claim that 100% = 179.52%
Even worse than that, Cell S71 has the figure 258,876,000 so no matter how you look at it, Americans are educated at higher rates than any other State, in spite of the fact that education in the US "costs more" while education in other States is free.
For every 4 Brits or Germans who have a degree, 25 Americans have one.
You might want to consider that is part of the problem in the US --- you have way too many people attending university.
You need to cut that in half, and the best way to do that is for the "federal" government to stop interfering with the Laws of Economics by artificially suppressing interest rates for Student Loans, and the "federal" government needs to stop interfering with the Laws of Economics and quit guaranteeing and backing Student Loans.....because both actions....suppressing interest rates and backing Loans floods the Market with excess Capital in the form of Credit (cheap credit due to suppressed interest rates) .....and the result is Interest Inflation, where the cost of education artificially inflates, and it inflates faster than any other measure of Inflation.
The same thing happens in the Housing Market. Artificially depress mortgage interest rates, and then flood the Housing Market with Capital in the form of Credit (cheap credit since the interest rates are intentionally suppressed), which then causes the price of housing to artificially inflate...bubbles correct that kind of stupidity.
The education systems used by Britain, Germany, Romania, France, and such are superior in every way, shape and form.
In Germany, you track in the 6th Grade -- by testing. Pass the test and score high enough against your peers and you get into the College Track. If you don't, then you go into the Vocational Track.
In the 8th Grade you will test again. If you pass, and you score high enough against your peers, you get to go to Gymnasium --- the college track, but if you don't, then you go into one of the lower two vocational tracks.
You test again when you graduate at age 16. If you pass the test, and you score in the high upper percentiles, you get to go to college preparatory school.
If you were in the vocational track, and you passed the test, and scored high enough, you go to the upper vocational track --- skilled vocations -- and if not then your educational career is not officially over -- so enjoy your life scrubbing skid marks off of toilets.
Once you complete college preparatory school at 18, you will test again and if you pass the test, and you score in the upper percentiles, you can go to college -- practically for free (usually free in most cases).
If you didn't, then you might qualify for vocational training in an highly skilled field.
If you took the skilled vocational training, and you graduated, took the test and passed, plus scored in the upper percentiles -- and you would have about 22 years of age at that time, you might get lucky and get to go to college.
For everyone else, if they want to go to college, they'll have to come to the US.
That is what you need to start doing in the US.
Educationally...
Mircea