計算機語言 ( 大一 , 第二学期 )

1. 計算機語言 (大一, 第二学期) 福島康裕 助理教授, 環境系統工程研究室 email: fuku@mail.ncku.edu.tw, ext. 65838

2. Last Week’s Exercise • Why sort by GDP per capita? • Why calculate GDP? What is cumulative income?

3. Lorenz curve for global economy • Objective: To show how uneven our global economy is. • Ideal data? • Ask each 6.5 billion people how much income they have every year  impossible • Realistic data • Look at GDP of the country, and assume that everyone in a country has the same income. Each person’s income = GDP of his or her country / Population of his or her country = GDP per capita

4. Procedures • Sort by GDP per capita • Calculate GDP and its accumulation • We don’t want to have every 6.5 billion data on our excel sheet • We assumed everyone in a country has same income. Thanks to this assumption, we can add each person’s income (= GDP per capita) for each country by calculating GDP • Obtain accumulation of population • Normalize 2 and 3 • Plot in a scattergram • Calculate Gini’s coefficient

5. Gini’s coefficient • How can we calculate Gini’s coefficient? B Hints: - △OAB=0.5 - There are two parts inside △OAB. If we know one, we can calculate the other Which part? How? A O

6. Extracting data • Get the data that matches to our interest • Using “Auto Filter” • Using “Custom Auto Filter” EXAMPLE) Which are the countries that are 1% < r < 2% (population growth rate) in America or Europe ?

8. Custom Auto Filter

9. Auto Filter(GDP per capita  top ten) If you choose Europe, you can get EU countries that are in Top 10 in GDP per capita.

10. ●AND● = C ●OR ● = A+B+C A C B More complex query using Auto Filter • Benn’s Diagram : AND and OR 10,000 < GDP per capita < 20,000 AND? GDP per capita < 20,000 10,000 < GDP per capita OR?

11. Custom Auto Filter

12. Custom Auto Filter Dialog = : equals < : is greater than > : is less than ≦ : is greater than or equals to ≧ : is less than or equals to <> : does not equal

13. EXAMPLE) Which are the countries that are 1% < r < 2% (population growth rate) in America or Europe ?

14. EXAMPLE) Which are the countries that are 1% < r < 2% (population growth rate) in America or Europe ?

15. EXAMPLE) Which are the countries that are 1% < r < 2% (population growth rate) in America or Europe ?