Buddhism Worksheet - Excel by ixv20242

VIEWS: 31 PAGES: 1146

More Info
									   International organisations such as the United Nations, Oxfam
and Christian Aid regularly use national statistics to identify how best
to help countries in need.
   This task will show you how to form hypotheses about the
relationships between different statistics.
   All the data in the task was taken from the 2006 update of the CIA
World Factbook at www.cia.gov/cia/publications/factbook/




   GDP per Capita: Gross Domestic           Life Expectancy: The average life in
Product per head. The average amount           years of a person in a particular
 of money made per person, per year.                       country.
 how best



 f the CIA



                      Literacy: The ability to read and




 he average life in
n in a particular
                      The 20 Most Populated Countries in the World
                                         Annual
                                                                       Life
                       Population       Average       Literacy
    Country                                                        Expectancy
                        (million)        Growth         (%)
                                                                     (years)
                                        (million)
China                      1,298          10.4            91             72
India                      1,065          16.3            59             64
USA                         293            2.8            97             77
Indonesia                   238            2.8           87.9            69
Brazil                      184            2.2           86.1            71
Pakistan                    159            3.7           45.7            62
Russian
                            143            -0.7           99             66
Federation
Bangladesh                  141             2.9           43             62
Nigeria                     135              3            68             50
Japan                       127             0.3           99             81
Mexico                      105             1.5           92             75
Philippines                 86              1.5           92             69
Germany                     82               0            99             79
Viet Nam                    82               1            90             70
Egypt                       76              1.2           58             70
Iran                        69              1.1           79             69
Turkey                      69               1           86.5            72
Ethiopia                    68              1.5           43             41
Thailand                    65              0.8           93             71
United Kingdom              60              0.1           99             78

STARTER ACTIVITY
The table above shows national statistics for the 20 most populated countries in the world.
Hover your mouse over cells B2-H2 to find out what the data means.
Look at cells C15 and F5. Think about why the data highlighted is particularly interesting.
Look at the data and change the colour of any other cells that you think contain particularly interesting data.
Countries in the World
                      GDP per
                                       Continent      Main Religion
                     Capita ($)

                        5,000              Asia          Daoism
                        2,900              Asia           Hindu
                        37,000        North America     Protestant
                        3,200              Asia          Muslim
                        7,600         South America   Roman Catholic
                        2,100              Asia          Muslim
                         8,900             Asia       Russian Orthodox
                        1,900              Asia          Muslim
                         900              Africa         Muslim
                        28,200             Asia         Buddhism
                        9,000         North America   Roman Catholic
                        4,600              Asia       Roman Catholic
                        27,600           Europe         Protestant
                        2,500              Asia         Buddhism
                        4,000             Africa         Muslim
                        7,000              Asia          Muslim
                        6,700              Asia          Muslim
                         700              Africa         Muslim
                        7,400              Asia         Buddhism
                        28,000           Europe         Protestant


ated countries in the world.

 is particularly interesting.
ou think contain particularly interesting data.
                                         Keywords:
                                Life
                 Literacy                hypothesis: An idea that I wish to prove or disprove b
    Country                 Expectancy
                   (%)                   analysing the data.
                              (years)    correlation: A relationship between two or more sets
China              91          72
                                         I want to prove the hypothesis that there is a
India              59          64
                                         (relationship) between literacy and
USA                97          77
                                         you live in a country where most people can read and
Indonesia         87.9         69
                                         you will probably live a longer life. If you live in a cou
Brazil            86.1         71        where less people can read and write, you will proba
Pakistan          45.7         62        shorter life.
Russian
                   99          66
Federation                               Look at the data and highlight a few rows that prove t
Bangladesh         43          62        hypothesis.
Nigeria            68          50
Japan              99          81        Look Chart 1 and Chart 2 to view the scatter chart th
Mexico             92          75        data produces. Is the hypothesis true?
Philippines        92          69
Germany            99          79
Viet Nam           90          70
Egypt              58          70
Iran               79          69
Turkey            86.5         72
Ethiopia           43          41
Thailand           93          71
United Kingdom     99          78
 idea that I wish to prove or disprove by

elationship between two or more sets of data.

he hypothesis that there is a correlation
                and life expectancy. i.e. if
                   people can read and write
               life. If you live in a country
ple can read and write, you will probably live a


 and highlight a few rows that prove this


           to view the scatter chart that the
Is the hypothesis true?
90


            What is
80
         missing on this
             chart?
70



60



50



40                                        If you drew a straight line
                                          which roughly followed the
                                          path of the dots, which way
30                                        would it go?
                                          1. Top left to bottom right
                                          2. Bottom left to top right
20



10



 0
     0     20              40   60   80                  100            120
                                            Correlation between life expectancy and literacy

                         85
                                      If you live in a country where
                                        most people can read, will
                         80           you probably live a long life?

                         75



                         70
Life exectancy (years)




                         65



                         60


                                                                                   The trendline goes:
                         55
                                                                                   2. bottom left to top right

                         50                                                        What does this mean?
                                          LOOK!
                                    Axes scaled to hide
                         45        blank space on chart


                         40
                              40       50                 60           70          80                 90         100
                                                                   Literacy (%)
Charts 1 and 2 display the same data, but Chart 2 shows the data more clearly.
Click back on charts 1 and 2 to answer the following questions:
Type your answers in the yellow boxes.

1. List 3 ways in which Chart 2 is clearer than Chart 1.




2. Does Chart 2 support the hypothesis that there is a correlation between life expectancy and literacy?


3. Explain your reason for your answer to question 2.




4. Identify the names of two countries that do not support the hypothesis. Explain why you chose them.




    Extension Question.
5. International Aid Organisations such as the United Nations, Oxfam and Christian Aid use statistics like
The data shows them how best to help less developed countries. Looking at the results of Chart 2,
what is a clear way that they can improve the quality of people's lives?
etween life expectancy and literacy?




hesis. Explain why you chose them.




m and Christian Aid use statistics like Sheet 1.
ooking at the results of Chart 2,
              The 20 Most Populated Countries in the World
                                        Annual
                                                                GDP per
                       Population      Average      Literacy
     Country                                                     Capita
                        (million)       Growth        (%)
                                                                  ($)
                                       (million)
China                     1,298          10.4           91         5,000
India                     1,065          16.3           59         2,900
USA                        293            2.8           97        37,000
Indonesia                  238            2.8          87.9        3,200
Brazil                     184            2.2          86.1        7,600
Russian
Federation                 143            -0.7          99         8,900
Pakistan                   159            3.7          45.7        2,100
Bangladesh                 141            2.9           43         1,900
Japan                      127            0.3           99        28,200
Nigeria                    135             3            68          900
Mexico                     105            1.5           92         9,000
Germany                    82              0            99        27,600
Viet Nam                   82              1            90         2,500
Philippines                86             1.5           92         4,600
Iran                       69             1.1           79         7,000
Egypt                      76             1.2           58         4,000
Turkey                     69              1           86.5        6,700
Ethiopia                   68             1.5           43          700
Thailand                   65             0.8           93         7,400
United Kingdom             60             0.1           99        28,000
2. Choose one of your hypotheses (not the example). Create a scatter chart with the data.
Hint: Use the Ctrl key to help you select columns that are not next to each other.
3. Ensure that your chart is as clear as Chart 2.
Hint: Double click the X axis and then select scale to change the minimum number on the axis.
es in the World
                         Life       1. Look at the data in the table
                     Expectancy     again. Think of two other
                                    possible hypotheses, showing
                       (years)
                                    relationships between two
                           72       columns of data. Type your
                           64       hypotheses in the yellow box
                           77       below.
                           69
                           71

                           66
                           62
                           62
                           81
                           50
                           75
                           79
                           70
                           69
                           69
                           70
                           72
                           41
                           71
                           78
 e a scatter chart with the data.
ot next to each other.

e the minimum number on the axis.
Country            Continent         Main Religion                    Continents
China                  Asia             Daoism                   Africa
India                  Asia              Hindu                   Asia
USA               North America        Protestant                Europe
Indonesia              Asia             Muslim                   North America
Brazil            South America      Roman Catholic              South America
Russian
Federation              Asia         Russian Orthodox
Pakistan                Asia              Muslim                   Main Religions
Bangladesh              Asia             Muslim                  Daoism
Japan                   Asia            Buddhism                 Hindu
Nigeria                Africa            Muslim                  Protestant
Mexico             North America      Roman Catholic             Muslim
Germany               Europe            Protestant               Roman Catholic
Viet Nam                Asia            Buddhism                 Russian Orthodox
Philippines            Asia           Roman Catholic
Iran                   Asia              Muslim                    Look at the Continents
Egypt                  Africa            Muslim                    the main table are in each continent.
Turkey                 Asia              Muslim
                                                                   Click in cell F3. It contains a
Ethiopia               Africa             Muslim                   first part is a range of cells to examine
Thailand                Asia             Buddhism                  criteria to look for - in this case the cell
United                                                             Africa.
Kingdom               Europe             Protestant
                                                                   Hint: COUNTIF looks for cells within the ra
TASK: =COUNTIF(B$3:B$22,E3)                                        and returns the number it finds.
1. Amend the formula from F3 and use it in cell F10 so that it     The $ fixes the row of the cell reference, so
counts the number of countries that have Daoism as their           transferred without that part changing.
main religion.
2. Complete the Main Religions table.
3. Produce a chart from the Main Religions table.
                     Number of Countries
                                             3
                                            12
                                             2
                                             2
                                             1


                     Number of Countries




          Continents table above. It counts how many countries from
e main table are in each continent.

              . It contains a COUNTIF formula, which has 2 parts. The
            range of cells to examine - B3:B22. The second part is the
       to look for - in this case the cell E3, which contains the word


                looks for cells within the range that match the criteria,
nd returns the number it finds.
     fixes the row of the cell reference, so that the formula can be
ansferred without that part changing.

								
To top