Assingment 3.xlsx - Sorted List 16-ARID-4278 188 13 223 203 24 205 16 118 27 205 94 47 215 222 115 51 85 229 106 111 113 41 123 209 6 The data for

# Assingment 3.xlsx - Sorted List 16-ARID-4278 188 13 223 203...

• 60

This preview shows page 1 - 7 out of 60 pages.

Sorted List The data for infant mo 16-ARID-4278 16-ARID-4278 Country Name Step1 188 6 Korea, Rep. Select 25 countries ac 13 13 Luxembourg Step 2 223 16 Barbados Looking at this list you 203 24 Step 3 24 27 To plot Box Plot you h 205 41 You task is to interpre 16 47 Step 4 118 51 Draw the graph for on 27 85 Step 5 205 94 Find Minimum Maxim 94 106 Step 6 47 111 Find Average, Medain 215 113 Step 7 222 115 Draw the graph for on 115 118 51 123 85 188 229 203 106 205 111 205 113 209 41 215 123 222 209 223 6 229 Timor-Leste
ortality of different coutires of the world from year 1991 to 2014 is given in sheet DATA1 and DATA2. ccording to countries assign to you. The country no is given against your registration no in sheet Registration. F u have to select these coutries from the main data sheets which are DATA1 and DATA2. For this registration no have to copy the data of you selected countries (Step 2) to sheet Box Plot for year 2005 to 2014. it will automati et you resutls. nly four counties from your alloted list with respect to time and interpret the graph mum Q3 Median and Q1 and draw the graph over time for your selected coutries list and interpret the graph. T n, IQR and SD of and draw the graph over time for your selected coutries list and interpret the graph. The exam nly four counties from your alloted list and Pakistan with respect to time and interpret the graph. Example is gi
For example for 16-ARID-4278 the list of 25 coutries is given in column A o the coutries are atically draw boxplot for your data. The example is given in sheet Graph1. mple is given in Sheet GRAPH2 iven in sheet GRAPH3
No 1 2 3 4 5 6 7 8 9 Country N AfghanistaAlbania Algeria Andorra Angola Antigua anArab WorldArgentina Armenia 1991 118.3 33.7 38.8 7.0 133.5 22.6 56.2 23.6 40.6 1992 114.4 32.5 38.1 6.5 133.5 21.5 54.6 22.8 38.8 1993 110.9 31.4 37.5 6.1 133.4 20.3 53.2 22.1 37.0 1994 107.7 30.3 36.9 5.6 133.2 19.2 51.8 21.4 35.3 1995 105.0 29.1 36.3 5.2 132.8 18.0 50.5 20.8 33.7 1996 102.7 27.9 35.7 5.0 132.3 17.1 49.2 20.2 32.1 1997 100.7 26.8 35.1 4.6 131.5 16.2 47.9 19.6 30.6 1998 98.9 25.5 34.7 4.3 130.6 15.3 46.6 19.1 29.2 1999 97.2 24.4 34.4 4.1 129.5 14.5 45.4 18.5 27.9 2000 95.4 23.2 33.9 3.9 128.3 13.8 44.1 18.0 26.6 2001 93.4 22.1 33.3 3.7 126.9 13.0 42.9 17.6 25.3 2002 91.2 21.0 32.4 3.5 125.5 12.3 41.7 17.1 24.2 2003 89.0 20.0 31.3 3.3 124.1 11.7 40.5 16.6 23.0 2004 86.7 19.1 30.1 3.2 122.8 11.0 39.2 16.0 21.9 2005 84.4 18.3 28.8 3.1 121.2 10.4 38.1 15.3 20.8 2006 82.3 17.4 27.6 2.9 119.4 9.8 36.9 14.6 19.8 2007 80.4 16.7 26.4 2.8 117.1 9.2 35.7 14.1 18.8 2008 78.6 16.0 25.3 2.7 114.7 8.8 34.5 13.7 17.9 2009 76.8 15.4 24.3 2.6 112.2 8.2 33.4 13.4 17.0 2010 75.1 14.8 23.5 2.5 109.6 7.7 32.3 13.0 16.1 2011 73.4 14.3 22.8 2.4 106.8 7.2 31.2 12.7 15.3 2012 71.7 13.8 22.4 2.3 104.1 6.8 30.3 12.3 14.6 2013 69.9 13.3 22.1 2.2 101.4 6.4 29.5 11.9 13.8 2014 68.1 12.9 22.0 2.1 98.8 6.1 28.7 11.5 13.2
10 11 12 13 14 15 16 17 18 19 Australia Austria AzerbaijanBahamas, Bahrain BangladeshBarbados Belarus Belgium Belize 7.1 7.6 75.7 18.8 19.3 95.8 15.4 13.5 8.0 30.4 6.7 7.1 76.0 18.0 18.7 92.1 14.9 13.6 7.6 28.8 6.3 6.7 76.2 17.2 17.9 88.3 14.5 13.8 7.2 27.4 6.0 6.2 76.1 16.3 16.8 84.6 14.1 14.1 6.8 26.1 5.7 5.7 75.2 15.6 15.5 81.0 14.0 14.4 6.3 25.1 5.6 5.3 73.6 14.8 14.2 77.4 13.9 14.4 5.9 24.1 5.4 5.0 71.2 14.1 13.1 74.0 14.0 14.2 5.5 23.3 5.3 4.8 68.1 13.6 12.1 70.6 14.2 13.6 5.2 22.5 5.3 4.7 64.5 13.2 11.4 67.4 14.5 12.6 4.9 21.8 5.1 4.6 60.6 13.0 10.9 64.4 14.8 11.4 4.8 21.1 5.0 4.5 56.8 12.9 10.5 61.4 15.1 10.3 4.6 20.5 5.0 4.4 53.1 12.8 10.2 58.6 15.3 9.3 4.4 19.9 4.9 4.3 49.7 12.7 9.9 55.9 15.3 8.6 4.2 19.4 4.9 4.1 46.7 12.7 9.6 53.4 15.3 7.9 4.2 18.9 4.8 4.0 44.0 12.6 9.3 50.8 15.1 7.4 4.1 18.5 4.7 4.0 41.5 12.5 9.0 48.4 14.9 6.8 4.0 18.0 4.5 3.8 39.3 12.2 8.5 45.9 14.5 6.2 3.9 17.6 4.4 3.8 37.3 11.9 8.1 43.6 14.2 5.6 3.8 17.2 4.2 3.7 35.5 11.7 7.6 41.3 13.9 5.1 3.7 16.7 4.1 3.6 33.9 11.4 7.1 39.2 13.6 4.7 3.6 16.3 3.8 3.4 32.5 11.1 6.7 37.2 13.3 4.3 3.5 15.9 3.6 3.3 31.2 10.9 6.3 35.3 13.0 4.0 3.5 15.5 3.4 3.2 30.0 10.5 5.9 33.5 12.7 3.8 3.4 15.1 3.2 3.0 28.9 10.2 5.6 32.1 12.3 3.5 3.4 14.6
20 21 22 23 24 25 26 27 28 29 Benin Bhutan Bolivia Bosnia andBotswana Brazil Brunei DarBulgaria Burkina Fa Burundi 105.6 89.6 82.9 15.1 42.9 48.9 9.2 18.8 102.3 104.5 103.2 85.9 80.2 14.7 44.2 46.8 9.0 19.1 102.4 104.8 100.9 82.4 77.5 14.2 45.7 44.6 8.8 19.2 102.4 104.8 98.9 78.8 74.8 12.9 47.3 42.2 8.5 19.3 102.1 104.3 97.2 75.3 72.2 12.3 48.9 39.7 8.3 19.4 101.4 103.2 95.6 71.8 69.5 11.0 50.2 37.2 8.1 19.5 100.5 101.7 94.2 68.4 66.8 10.1 51.3 34.8 7.9 19.4 99.4 100.0 92.7 65.2 64.1 9.3 52.0 32.4 7.8 19.2 98.3 97.9 91.1 62.0 61.4 8.6 53.1 30.2 7.6 18.6 97.3 95.7 89.3 59.0 58.8 7.9 52.4 28.1 7.6 17.9 96.2 93.4 87.4 56.1 56.2 7.5 51.4 26.1 7.5 17.1 95.0 91.0