Using Jupyter Notebook my friends...

I give upvote once done. Thank you very much!

Write codes in Jupyter notebook as required by the problems. Copy both code and output as screen grab or screen shot and paste them here. Be sure to apply the necessary customizations. 1 Import 'degrees-women-usa.csv'. Plot the % degrees awarded to women yearly in Math and Statistics and Physical Sciences on the same axis. Code and Output 2 Using the previous import, prepare a 2x2 subplot to visualize the % degrees awarded to women yearly in Health Professions (red), Education (blue), Public Administration (yellow) and Art and Performance (yellow). Code and Output 3 Import weather.csv. Plot the maximum, minimum and average temperatures on a single axis. Code and Output 4 Using the weather dataset, zoom in on the average temperature for the entire month of August, year 2010. Plot this data. Code and Output 5 Import auto.csv. Plot the acceleration as a function of weight. Code and Output 6 Using the auto dataset, visualize the distribution of the origin of the cars. Code and Output count plot showing the number of cylinders grouped by origin. Use horizontal bars for the 7 Using the auto dataset, create count plot. Code and Output 8 Using the auto dataset, prepare side-by-side plots of the number of cylinders (x-axis) vs power (y-axis). Use a strip plot on the left side and a box plot on the right side. Code and Output 9 Import gm_2008.csv. Visualize the CO2 emissions as a function of the population. Code and Output 10 Improve the previous visualization by grouping the data based on region. Code and Output = 5 HOME degrees-women-usa- Excel FILE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Normal Bad Good Neutral X Cut Be Copy Format Painter Clipboard Calibri 11 - A A Wrap Text General BIU.. A. E Merge & Center - % Paste & Conditional Format as Check Cell Formatting Table Explanatory... input Linked Cell Font Alignment Number Styles A1 > fo Year 40.9 46.2 A B D E F G H K N o P Q R s T 1 l Year Agricultur Architectu Art and De Biology Business Communi Computer Education Engineeris English Foreign La Health Pre Math and Physical S Psycholog Public Adi Social Sciences and History 2 1970 4.229798 11.92101 59.7 29.08836 9.064439 35.3 13.6 74.53533 0.8 65.57092 73.8 77.1 38 13.8 44.4 68.4 36.8 3 3 1971 5.452797 12.00311 24137 12.00311 59.9 29.3944 9.503187 35.5 13.6 9.1492 1 64.55649 73.9 75.5 39 14.9 46.2 65.5 36.2 4 1972 7.42071 13.21459 60.4 29.81022 10.55896 36.6 14.9 73.55452 1.2 63.66426 74.6 76.9 40.2 14.8 47.6 62.6 36.1 5 1973 9.653602 14.79161 60.2 31.14791 12.8046 38.4 16.4 73.50181 1.6 62.9415 74.9 77.4 16.5 50.4 64.3 36.4 6 6 1974 14.07462 17.44469 61.9 32.99618 16.20485 40.5 18.9 73.33681 2.2 62.41341 75.3 77.9 41.8 18.2 52.6 66.1 37.3 7 7 1975 18.33316 19.13405 60.9 34.4499 19.68625 41.5 19.8 72.80185 3.2 61.64721 75 78.9 40.7 19.1 54.5 63 37.7 8 8 1976 22.25276 21.39449 61.3 36.07287 23.43004 44.3 23.9 72.16652 4.5 62.14819 74.4 79.2 41.5 20 56.9 65.6 39.2 9 1977 24.64018 23.74054 62 38.33139 27.16343 46.9 25.7 72.45639 6.8 62.72307 74.3 80.5 41.1 21.3 59 69.3 40.5 10 1978 27.14619 25.84924 62.5 40.1125 30.52752 49.9 28.1 73.19282 8.4 63.61912 74.3 81.9 41.6 22.5 61.3 71.5 41.8 11 1979 29.63337 27.77048 63.2 42.06555 33.62163 52.3 30.2 73.82114 9.4 65.08839 74.2 82.3 42.3 23.7 63.3 73.3 43.6 12 1980 30.75939 28.08038 63.4 43.99926 36.76573 54.7 32.5 74.98103 10.3 65.28413 74.1 83.5 42.8 24.6 65.1 14.0 44.2 13 1981 31.31866 29.84169 63.3 45.24951 39.26623 56.4 34.8 75.84512 11.6 65.83832 73.9 3. 84.1 43.2 25.7 66.9 74.7 44.6 14 1982 32.63666 34.81625 63.1 45.96734 41.94937 58 2010 36.3 75.84365 12.4 65.84735 72.7 84,4 44 27.3 67.5 76.8 44.6 15 1983 31.63535 35.82626 62.4 46.71313 43.54207 58.6 37.1 75.9506 13.1 65.91838 71.8 84.6 44.3 27.6 67.9 76.1 44.1 16 1984 31.09295 35.45308 62.1 47.66908 45.12403 59.1 36.8 75.86912 13.5 65.74986 72.1 85.1 46.2 28 68.2 75.9 44.1 17 1985 31.37966 36.13335 61.8 47.90988 45.74778 59 35.7 75.92344 13.5 65.7982 70.8 85.3 46.5 27.5 69 75 43.8 18 1986 31.19872 37.24022 62.1 48.30068 46.53292 60 34.7 76.14302 13.9 65.98256 71.2 85.7 46.7 28.4 69 75.7 44 19 1987 31.48643 38.73068 61.7 50.20988 46.69047 60.2 32.4 76.96309 14 66.70603 72 85.5 46.5 30.4 70.1 76.4 43.9 20 1988 31.08509 39.39891 61.7 50.09981 46.76483 60.4 30.8 77.62766 13.9 67.1445 72.3 85.2 29.7 70.9 75.6 44.4 21 1989 31.6124 39.09654 62 50.77472 46.78156 60.5 29.9 78.11192 14.1 67.01707 72.4 84.6 46.2 31.3 71.6 76 44.2 22 1990 32.70344 40.82405 62.6 50.81809 47.20085 60.8 29.4 78.86686 14.1 66.9219 71.2 83.9 47.3 31.6 72.6 77.6 45.1 23 1991 34.71184 33.67988 62.1 51.46881 47.22432 60.8 28.7 78.99125 14 66.24147 71.1 83.5 47 32.6 73.2 78.2 45.5 24 1992 33.93166 35.20236 61 51.34974 47.2194 59.7 28.2 78.43518 14.5 65.62246 71 83 47.4 32.6 73.2 77.3 45.8 25 1993 34.94683 35.77716 2. FO 60.2 51.12484 47.63933 58.7 28.5 77.26731 14.9 65.73095 70 82.4 46.4 33.6 73.1 78 46.1 26 1994 36.03267 34.43353 59.4 52.24622 47.98392 58.1 CO 28.5 75.81493 15.7 65.64198 69.1 24 47 yo 81.8 34.8 72.9 78.8 46.8 Aca 27 1995 36.84481 36.06322 59.2 52.5994 48.57318 58.8 27.5 75.12526 16.2 65.93695 69.6 81.5 46.1 35.9 73 789 78.8 47.9 28 1996 38.96977 35.92649 58.6 53.78988 48.64739 58.7 27.1 75.0352 16.7 66.43778 69.7 81.3 46.4 37.3 73.9 79.8 48.7 29 1997 40.68568 35.10193 58.7 54.99947 48.56105 60 26.8 75.1637 17 66.78636 70 81.9 47 38.3 74.4 81 49.2 30 1998 41.9124 41.9124 37.59854 59.1 56.35125 49.25852 60 27 75.48616 17.8 67.25545 70.1 82.1 48.3 39.7 75.1 81.3 50.5 31 1999 42.8872 38.63153 59.2 58.22882 49.81021 61.2 28.1 75.83816 18.6 67.82022 70.9 83.5 47.8 40.2 76.5 81.1 51.2 2000 45.05777 40.02358 59.2 59.38986 49.80362 61.9 27.7 76.69214 18.4 68.36599 70.9 83.5 48.2 41 77.5 81.1 51.8 33 2001 45.86602 40.69028 59.4 60.71233 50.27514 63 27.6 77.37523 19 68.57852 71.2 85.1 47 42.2 77.5 80.9 51.7 34 2002 47.13466 41.13295 60.9 61.89513 50.55233 63.7 27 78.64424 18.7 68.82996 70.5 85.8 45.7 41.1 77.7 81.3 51.5 35 2003 47.93519 42.75854 61.1 62.16946 50.3456 64.6 25.1 78.54495 18.8 68.89449 70.6 86.5 46 41.7 77.8 81.5 50.9 36 2004 47.88714 43.46649 61.3 61.91459 49.95089 64.2 22.2 78.65075 18.2 68.45473 70.8 86.5 44.7 42.1 77.8 80.7 50.5 37 2005 47.67275 43.10037 61.4 61.50098 49.79185 63.4 20.6 29.06712 17.9 68.57122 69.9 86 45.1 41.6 77.5 81.2 50 38 2006 46.7903 44.49933 61.6 60.17284 49.21091 63 18.6 78.68631 16.8 68.29759 69.6 85.9 44.1 40.8 77.4 81.2 49.8 39 2007 47.60503 43.10046 61.4 59.41199 49.00046 62.5 17.6 78.72141 16.8 67.87492 70.2 85.4 44.1 40.7 77.1 82.1 49.3 degrees-women-usa + READY 32 weather.ce ? General Bad Good Neutral Calculation RLE HOME INSERI PAGE LAYOUT FORMULAS DATA REVEW VIEW X. Cut Cli AA Wrap Test Copy Paste BIU. A == EE Merge Center Format Painter Cipboard Fort Alignment A1 STATION * Ex Autos 03 Normal Coritional Formats Check Cell Formatting Table Explanatory Input Linked Cell Note Insert Odete Format Clear Sort Find & File Select Number Styles Cels Editing 7 1 WTOS AR K WT04 1 WTOS M WTOG N WTOZ Q WTIC 5 WT13 U WT15 X V v WTIG W WT17 WT14 1 AA WT22 WTO2 WTOS WTOS WT11 WT18 WT19 WT21 1 1 1 2 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 B C 1 STATION DATE TAVG 2 USWOOL *** 3 USW00016 MARCH 4 USWOOL SusWooo! 6 USW001WARA 7 USWOOO1 8 USWU0014 WITH 9 USWO0014 MATT 10 USW0001 11 USW0001 ARAU 12 USWOOOL! 13 USWOOOTIT 14 USW00011 PRAHA 15 USW00014 H 16 USWOOOL 17 USWOO014 TTT 1B USWOO NAS 19 USW0001 20 USWOCORK A 21 usWO0014 22 USW0001 HAAR 23 USW00012 24 USWOOC 25 USW00014 26 USW00014 ARHAN 27 USW00014 ARAW 23 USWOOOH 29 USW00014 30 USWOO014 RAR 31 USW0004 ARHI 32 USWOOO 33 uswO0012 34 USW0001 RAAH 35 USW00012 A 35 USW00014 37 USWOOO 38 USWOO HARA 39 USW00014 A weather F F G G H TMIN TMAX AWND WSF2 WTOI 44 35 5. 8.9 35.1 36 28 44 9.4 14.1 49 44 52 0.92 2/ 42 29 45 G.SE 16.1 36 28 43 7.83 17 30 25 35 8.72 15 23 20 37 8.72 22.9 32 34 6.04 17 31 28 34 6.04 15 37 31 42 6.71 17 34 20 28 3.37 20.2 2a 29 37 7.01 10.1 46 33 59 6.49 30 48 32 62 17.9 40 ze 20 22 0.71 17.9 27 23 30 13.42 25.1 . 22 15 29 13.87 25.) 11 6 15 14.09 22 10 3 3.20 20.2 24 18 29 9.4 21 11 3 18 12.08 21 12 -2 27 8.72 22 17 > 20 20.84 45 14 4 23 11.41 19.9 21 15 27 8.72 19.9 23 17 29 13.2 25.9 12 6 18 15.43 12 2 22 8.95 21.9 19 2 36 1.25 10.1 29 8.72 16.1 24 16 21 11.42 za 22 9 36 2.01 6 25 11 38 8.05 16. 30 23 36 9.62 15 34 21 20 13.2 22 41 31 SC 10.51 19.9 37 29 45 11.18 21 40 52 3.58 8.9 2 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 BEADS F m -- auto(1) - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 ' Wrap Text General Normal Paste * Cut De Copy Format Painter Clipboard BIU A Merge & Center % 000 100.0 Exp Conditional Format as Check Cell Formatting - Table Font Alignment To Number A1 - : fax mpg B G M N O P Icyl origin A 1 mpg 2 18 3 9 4 36.1 5 18.5 6 34.3 displ hp 6 250 8 304 71 US 4 91 6 250 4 97 7 32.9 4 119 4 108 32.2 22 4 15 8 8 9 10 11 12 13 121 302 302 8 17 44 24.5 4 97 151 4 14 4 135 32 14 15 8 16 15 8 8 351 400 307 17 13 36 4 79 31 4 18 19 20 21 22 D E F weight accel yr 88 3139 14.5 193 4732 18.5 60 1800 16.4 98 3525 19 78 2188 15.8 100 2615 14.8 75 2265 15.2 76 2511 18 130 4295 14.9 140 3449 10.5 52 2130 24.6 88 2740 16 84 2295 11.6 148 4657 13.5 150 3761 9.5 130 4098 14 58 1825 18.6 82 2720 19.4 65 21 110 2720 13.5 95 3264 16 110 3907 21 140 4141 14 170 3563 10 78 2592 18.5 90 2265 15.5 96 2665 95 2372 15 110 3039 15 75 17.5 132 2910 11.4 150 3892 12.5 83 2639 17 85 3465 16.6 86 2464 15.5 75 2158 15.5 140 4638 16 139 3205 11.2 H 1 name color ford must red 70 US hi 1200d green 78 Asia honda civiblue 77 US ford grana red 80 Europe audi 4000 blue 81 Asia datsun 201 blue 80 Asia toyota cor blue 72 Europe volkswage blue 77 US mercury c green 70 US ford torini green 82 Europe vw pickup blue 77 US pontiac su blue 82 US dodge ran blue 75 US ford Itd green 70 US chevrolet green 72 US chevrolet green 77 Europe renault 5 (blue 82 US chevy 5-10 blue 74 Asia toyota cor blue 77 Asia mazda rx- black 75 US plymouth red 75 US buick centred 74 US ford gran green 70 US dodge chagreen 75 US pontiac as blue 73 Europe fiat 124 sp blue 82 Asia toyota cel blue 70 Asia toyota cor blue 75 US buick skyt red 80 Asia mazda 62 blue 80 Asia datsun 281 red 72 US amc mata green 75 US ford pinto blue 81 US chrysler le red 76 Europe fiat 131 blue 73 Europe opel mant blue 74 US ford gran green 78 US ford futur green 119 71 80 K L size marker 27.37034 0 62.19951 o 9x 34.51563 0 13.29818 5 18.99507 x 14.25063 x 17.51422 s 51.24174 0 33.04334 o 12.6025 s 20.85444 0 14.63063 0 60.24347 0 39.292 0 46.6489 0 9.251736 s 20.551110 9.3636 x 20.55111 x 29.5936 0 42.4018 0 47.633 0 35.2638 0 18.6624 0 14.250635 19.7284 x 15.62884 x 25.65423 o 17.94934 x 23.5225 x 42.07684 o 19.34534 o 33.35063 0 16.86471 s 12.93601 s 59.7529 0 28.5334 o 4 32 21.5 19 1836 3 6 225 23 6 231 17 16 24 8 25 15 8 4 302 383 140 26 23 26 4 27 28 98 144 4 13.9 32 24 29 4 113 6 231 4 120 2542 30 31 32 33 34 6 168 21 31.3 32.7 15 23 17.6 28 8 4 35 6 304 140 225 107 116 302 36 4 24 4 37 38 39 14 8 18.1 8 302 auto(1) READY 5 gm 2008 - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 -A A El Wrap Text General Bad Paste * Cut BE Copy - Format Painter Clipboard BIU. > A Merge & Center % 0.00 000 Normal Conditional Format as Check Cell Formatting Table Explanator Font Alignment Number A1 > fx population M N O B D E F G H 1 K L 1 populatio fertility HIV CO2 BMI male GDP BMI_fema life child_mor Region 2 34811059 2.73 0.1 3.328945 24.5962 12314 129.9049 75.3 29.5 Middle East & North Africa 3 19842251 6.43 2 1.474353 22.25083 7103 130.1247 58.3 192 Sub-Saharan Africa 4 40381860 2.24 0.5 4.78517 27.5017 14646 118.8915 75.5 15.4 America 5 2975029 1.4 0.1 1.804106 25.35542 7383 132.8108 72.5 20 Europe & Central Asia 6 21370348 1.96 0.1 18.01631 27.56373 41312 117.3755 81.5 5.2 East Asia & Pacific & 7 8331465 1.41 0.3 8.18316 26.46741 43952 124.1394 80.4 4.6 Europe & Central Asia 8 8868713 1.99 0.1 5.109538 25.65117 14365 128.6024 70.6 43.3 Europe & Central Asia 9 348587 1.89 3.1 3.131921 27.24594 24373 124.3862 72.2 14.5 America 10 1.48E+08 2.38 0.06 0.319161 20.39742 2265 125.0307 68.4 55.9 South Asia 11 277315 1.83 1.3 6.008279 26.38439 16075 126.394 75.3 15.4 America 12 9526453 1.42 0.2 6.488174 26.16443 14488 129.7968 70.1 7.2 Europe & Central Asia 13 10779155 1.82 0.2 9.797337 26.75915 41641 121.8227 79.4 4.7 Europe & Central Asia 14 306165 2.91 2.4 1.360126 27.02255 8293 120.9224 70.7 20.1 America 15 8973525 5.27 1.2 0.537539 22.41835 1646 130.2723 63.2 116.3 Sub-Saharan Africa 16 694990 2.51 0.2 0.60121 22.8218 5663 125.1258 67.6 48.1 South Asia 17 9599916 3.48 0.2 1.431829 24.43335 5066 122.4155 70.9 52 America 18 1967866 2.86 24.9 2.547205 22.12984 13858 133.1307 61.2 63.8 Sub-Saharan Africa 19 1.95E+08 1.9 0.45 2.023773 25.78623 13906 124.8745 73.9 18.6 America 20 7513646 1.43 0.1 6.690139 26.54286 15368 128.4721 73.2 13.7 Europe & Central Asia 21 14709011 6.04 1.2 0.109419 21.27157 1358 130.6651 59.4 130.4 Sub-Saharan Africa 22 8821795 6.48 3.5 0.031389 21.50291 723 134.1955 57.4 108.6 Sub-Saharan Africa 23 13933660 3.05 0.6 0.287547 20.80496 2442 117.5528 66.2 51.5 East Asia & Pacific 24 19570418 5.17 5.3 0.295542 23.68173 2571 127.2823 56.6 113.8 Sub-Saharan Africa 25 33363256 1.68 0.2 16.3504 27.4521 41468 118.0571 80.7 5.8 America 26 11139740 6.81 3.4 0.047839 21.48569 1753 127.864 54.8 168 Sub-Saharan Africa 27 16645940 1.89 0.4 4.240259 27.01542 18698 125.5417 78.9 8.9 America 28 44901660 2.43 0.5 1.476092 24.94041 10489 124.0235 75.1 19.7 America 29 665414 5.05 0.06 0.178853 22.06131 1440 132.1354 62.6 91.2 Sub-Saharan Africa - 30 3832771 5.1 3.5 0.38422 21.87134 5022 131.6935 58.6 72.6 Sub-Saharan Africa 31 4429506 1.91 0.3 1.911933 26.47897 12219 121.35 79.7 10.3 America 32 19261647 4.91 3.7 0.361897 22.56469 2854 131.5237 55.9 116.9 Sub-Saharan Africa 33 4344151 1.43 0.06 5.287903 26.59629 21873 130.3921 76.5 5.9 Europe & Central Asia 34 11290239 1.5 0.1 2.701777 25.06867 17765 126.0594 77.8 6.3 America 35 5495302 1.89 0.2 8.541508 26.13287 45017 119.5815 78.7 4.3 Europe & Central Asia 36 809639 3.76 2.6 0.6128 23.38403 2502 129.3376 61 81 Middle East & North Africa 37 14447600 2.73 0.4 2.110518 25.58841 9244 122.9864 74 26.8 America 38 78976122 2.95 0.06 2.512394 26.73243 9974 125.0931 70.1 31.4 Middle East & North Africa 39 6004199 2.32 0.8 1.067765 26.36751 7450 119.9321 74.1 21.6 America gm 2008 READY Write codes in Jupyter notebook as required by the problems. Copy both code and output as screen grab or screen shot and paste them here. Be sure to apply the necessary customizations. 1 Import 'degrees-women-usa.csv'. Plot the % degrees awarded to women yearly in Math and Statistics and Physical Sciences on the same axis. Code and Output 2 Using the previous import, prepare a 2x2 subplot to visualize the % degrees awarded to women yearly in Health Professions (red), Education (blue), Public Administration (yellow) and Art and Performance (yellow). Code and Output 3 Import weather.csv. Plot the maximum, minimum and average temperatures on a single axis. Code and Output 4 Using the weather dataset, zoom in on the average temperature for the entire month of August, year 2010. Plot this data. Code and Output 5 Import auto.csv. Plot the acceleration as a function of weight. Code and Output 6 Using the auto dataset, visualize the distribution of the origin of the cars. Code and Output count plot showing the number of cylinders grouped by origin. Use horizontal bars for the 7 Using the auto dataset, create count plot. Code and Output 8 Using the auto dataset, prepare side-by-side plots of the number of cylinders (x-axis) vs power (y-axis). Use a strip plot on the left side and a box plot on the right side. Code and Output 9 Import gm_2008.csv. Visualize the CO2 emissions as a function of the population. Code and Output 10 Improve the previous visualization by grouping the data based on region. Code and Output = 5 HOME degrees-women-usa- Excel FILE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Normal Bad Good Neutral X Cut Be Copy Format Painter Clipboard Calibri 11 - A A Wrap Text General BIU.. A. E Merge & Center - % Paste & Conditional Format as Check Cell Formatting Table Explanatory... input Linked Cell Font Alignment Number Styles A1 > fo Year 40.9 46.2 A B D E F G H K N o P Q R s T 1 l Year Agricultur Architectu Art and De Biology Business Communi Computer Education Engineeris English Foreign La Health Pre Math and Physical S Psycholog Public Adi Social Sciences and History 2 1970 4.229798 11.92101 59.7 29.08836 9.064439 35.3 13.6 74.53533 0.8 65.57092 73.8 77.1 38 13.8 44.4 68.4 36.8 3 3 1971 5.452797 12.00311 24137 12.00311 59.9 29.3944 9.503187 35.5 13.6 9.1492 1 64.55649 73.9 75.5 39 14.9 46.2 65.5 36.2 4 1972 7.42071 13.21459 60.4 29.81022 10.55896 36.6 14.9 73.55452 1.2 63.66426 74.6 76.9 40.2 14.8 47.6 62.6 36.1 5 1973 9.653602 14.79161 60.2 31.14791 12.8046 38.4 16.4 73.50181 1.6 62.9415 74.9 77.4 16.5 50.4 64.3 36.4 6 6 1974 14.07462 17.44469 61.9 32.99618 16.20485 40.5 18.9 73.33681 2.2 62.41341 75.3 77.9 41.8 18.2 52.6 66.1 37.3 7 7 1975 18.33316 19.13405 60.9 34.4499 19.68625 41.5 19.8 72.80185 3.2 61.64721 75 78.9 40.7 19.1 54.5 63 37.7 8 8 1976 22.25276 21.39449 61.3 36.07287 23.43004 44.3 23.9 72.16652 4.5 62.14819 74.4 79.2 41.5 20 56.9 65.6 39.2 9 1977 24.64018 23.74054 62 38.33139 27.16343 46.9 25.7 72.45639 6.8 62.72307 74.3 80.5 41.1 21.3 59 69.3 40.5 10 1978 27.14619 25.84924 62.5 40.1125 30.52752 49.9 28.1 73.19282 8.4 63.61912 74.3 81.9 41.6 22.5 61.3 71.5 41.8 11 1979 29.63337 27.77048 63.2 42.06555 33.62163 52.3 30.2 73.82114 9.4 65.08839 74.2 82.3 42.3 23.7 63.3 73.3 43.6 12 1980 30.75939 28.08038 63.4 43.99926 36.76573 54.7 32.5 74.98103 10.3 65.28413 74.1 83.5 42.8 24.6 65.1 14.0 44.2 13 1981 31.31866 29.84169 63.3 45.24951 39.26623 56.4 34.8 75.84512 11.6 65.83832 73.9 3. 84.1 43.2 25.7 66.9 74.7 44.6 14 1982 32.63666 34.81625 63.1 45.96734 41.94937 58 2010 36.3 75.84365 12.4 65.84735 72.7 84,4 44 27.3 67.5 76.8 44.6 15 1983 31.63535 35.82626 62.4 46.71313 43.54207 58.6 37.1 75.9506 13.1 65.91838 71.8 84.6 44.3 27.6 67.9 76.1 44.1 16 1984 31.09295 35.45308 62.1 47.66908 45.12403 59.1 36.8 75.86912 13.5 65.74986 72.1 85.1 46.2 28 68.2 75.9 44.1 17 1985 31.37966 36.13335 61.8 47.90988 45.74778 59 35.7 75.92344 13.5 65.7982 70.8 85.3 46.5 27.5 69 75 43.8 18 1986 31.19872 37.24022 62.1 48.30068 46.53292 60 34.7 76.14302 13.9 65.98256 71.2 85.7 46.7 28.4 69 75.7 44 19 1987 31.48643 38.73068 61.7 50.20988 46.69047 60.2 32.4 76.96309 14 66.70603 72 85.5 46.5 30.4 70.1 76.4 43.9 20 1988 31.08509 39.39891 61.7 50.09981 46.76483 60.4 30.8 77.62766 13.9 67.1445 72.3 85.2 29.7 70.9 75.6 44.4 21 1989 31.6124 39.09654 62 50.77472 46.78156 60.5 29.9 78.11192 14.1 67.01707 72.4 84.6 46.2 31.3 71.6 76 44.2 22 1990 32.70344 40.82405 62.6 50.81809 47.20085 60.8 29.4 78.86686 14.1 66.9219 71.2 83.9 47.3 31.6 72.6 77.6 45.1 23 1991 34.71184 33.67988 62.1 51.46881 47.22432 60.8 28.7 78.99125 14 66.24147 71.1 83.5 47 32.6 73.2 78.2 45.5 24 1992 33.93166 35.20236 61 51.34974 47.2194 59.7 28.2 78.43518 14.5 65.62246 71 83 47.4 32.6 73.2 77.3 45.8 25 1993 34.94683 35.77716 2. FO 60.2 51.12484 47.63933 58.7 28.5 77.26731 14.9 65.73095 70 82.4 46.4 33.6 73.1 78 46.1 26 1994 36.03267 34.43353 59.4 52.24622 47.98392 58.1 CO 28.5 75.81493 15.7 65.64198 69.1 24 47 yo 81.8 34.8 72.9 78.8 46.8 Aca 27 1995 36.84481 36.06322 59.2 52.5994 48.57318 58.8 27.5 75.12526 16.2 65.93695 69.6 81.5 46.1 35.9 73 789 78.8 47.9 28 1996 38.96977 35.92649 58.6 53.78988 48.64739 58.7 27.1 75.0352 16.7 66.43778 69.7 81.3 46.4 37.3 73.9 79.8 48.7 29 1997 40.68568 35.10193 58.7 54.99947 48.56105 60 26.8 75.1637 17 66.78636 70 81.9 47 38.3 74.4 81 49.2 30 1998 41.9124 41.9124 37.59854 59.1 56.35125 49.25852 60 27 75.48616 17.8 67.25545 70.1 82.1 48.3 39.7 75.1 81.3 50.5 31 1999 42.8872 38.63153 59.2 58.22882 49.81021 61.2 28.1 75.83816 18.6 67.82022 70.9 83.5 47.8 40.2 76.5 81.1 51.2 2000 45.05777 40.02358 59.2 59.38986 49.80362 61.9 27.7 76.69214 18.4 68.36599 70.9 83.5 48.2 41 77.5 81.1 51.8 33 2001 45.86602 40.69028 59.4 60.71233 50.27514 63 27.6 77.37523 19 68.57852 71.2 85.1 47 42.2 77.5 80.9 51.7 34 2002 47.13466 41.13295 60.9 61.89513 50.55233 63.7 27 78.64424 18.7 68.82996 70.5 85.8 45.7 41.1 77.7 81.3 51.5 35 2003 47.93519 42.75854 61.1 62.16946 50.3456 64.6 25.1 78.54495 18.8 68.89449 70.6 86.5 46 41.7 77.8 81.5 50.9 36 2004 47.88714 43.46649 61.3 61.91459 49.95089 64.2 22.2 78.65075 18.2 68.45473 70.8 86.5 44.7 42.1 77.8 80.7 50.5 37 2005 47.67275 43.10037 61.4 61.50098 49.79185 63.4 20.6 29.06712 17.9 68.57122 69.9 86 45.1 41.6 77.5 81.2 50 38 2006 46.7903 44.49933 61.6 60.17284 49.21091 63 18.6 78.68631 16.8 68.29759 69.6 85.9 44.1 40.8 77.4 81.2 49.8 39 2007 47.60503 43.10046 61.4 59.41199 49.00046 62.5 17.6 78.72141 16.8 67.87492 70.2 85.4 44.1 40.7 77.1 82.1 49.3 degrees-women-usa + READY 32 weather.ce ? General Bad Good Neutral Calculation RLE HOME INSERI PAGE LAYOUT FORMULAS DATA REVEW VIEW X. Cut Cli AA Wrap Test Copy Paste BIU. A == EE Merge Center Format Painter Cipboard Fort Alignment A1 STATION * Ex Autos 03 Normal Coritional Formats Check Cell Formatting Table Explanatory Input Linked Cell Note Insert Odete Format Clear Sort Find & File Select Number Styles Cels Editing 7 1 WTOS AR K WT04 1 WTOS M WTOG N WTOZ Q WTIC 5 WT13 U WT15 X V v WTIG W WT17 WT14 1 AA WT22 WTO2 WTOS WTOS WT11 WT18 WT19 WT21 1 1 1 2 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 B C 1 STATION DATE TAVG 2 USWOOL *** 3 USW00016 MARCH 4 USWOOL SusWooo! 6 USW001WARA 7 USWOOO1 8 USWU0014 WITH 9 USWO0014 MATT 10 USW0001 11 USW0001 ARAU 12 USWOOOL! 13 USWOOOTIT 14 USW00011 PRAHA 15 USW00014 H 16 USWOOOL 17 USWOO014 TTT 1B USWOO NAS 19 USW0001 20 USWOCORK A 21 usWO0014 22 USW0001 HAAR 23 USW00012 24 USWOOC 25 USW00014 26 USW00014 ARHAN 27 USW00014 ARAW 23 USWOOOH 29 USW00014 30 USWOO014 RAR 31 USW0004 ARHI 32 USWOOO 33 uswO0012 34 USW0001 RAAH 35 USW00012 A 35 USW00014 37 USWOOO 38 USWOO HARA 39 USW00014 A weather F F G G H TMIN TMAX AWND WSF2 WTOI 44 35 5. 8.9 35.1 36 28 44 9.4 14.1 49 44 52 0.92 2/ 42 29 45 G.SE 16.1 36 28 43 7.83 17 30 25 35 8.72 15 23 20 37 8.72 22.9 32 34 6.04 17 31 28 34 6.04 15 37 31 42 6.71 17 34 20 28 3.37 20.2 2a 29 37 7.01 10.1 46 33 59 6.49 30 48 32 62 17.9 40 ze 20 22 0.71 17.9 27 23 30 13.42 25.1 . 22 15 29 13.87 25.) 11 6 15 14.09 22 10 3 3.20 20.2 24 18 29 9.4 21 11 3 18 12.08 21 12 -2 27 8.72 22 17 > 20 20.84 45 14 4 23 11.41 19.9 21 15 27 8.72 19.9 23 17 29 13.2 25.9 12 6 18 15.43 12 2 22 8.95 21.9 19 2 36 1.25 10.1 29 8.72 16.1 24 16 21 11.42 za 22 9 36 2.01 6 25 11 38 8.05 16. 30 23 36 9.62 15 34 21 20 13.2 22 41 31 SC 10.51 19.9 37 29 45 11.18 21 40 52 3.58 8.9 2 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 BEADS F m -- auto(1) - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 ' Wrap Text General Normal Paste * Cut De Copy Format Painter Clipboard BIU A Merge & Center % 000 100.0 Exp Conditional Format as Check Cell Formatting - Table Font Alignment To Number A1 - : fax mpg B G M N O P Icyl origin A 1 mpg 2 18 3 9 4 36.1 5 18.5 6 34.3 displ hp 6 250 8 304 71 US 4 91 6 250 4 97 7 32.9 4 119 4 108 32.2 22 4 15 8 8 9 10 11 12 13 121 302 302 8 17 44 24.5 4 97 151 4 14 4 135 32 14 15 8 16 15 8 8 351 400 307 17 13 36 4 79 31 4 18 19 20 21 22 D E F weight accel yr 88 3139 14.5 193 4732 18.5 60 1800 16.4 98 3525 19 78 2188 15.8 100 2615 14.8 75 2265 15.2 76 2511 18 130 4295 14.9 140 3449 10.5 52 2130 24.6 88 2740 16 84 2295 11.6 148 4657 13.5 150 3761 9.5 130 4098 14 58 1825 18.6 82 2720 19.4 65 21 110 2720 13.5 95 3264 16 110 3907 21 140 4141 14 170 3563 10 78 2592 18.5 90 2265 15.5 96 2665 95 2372 15 110 3039 15 75 17.5 132 2910 11.4 150 3892 12.5 83 2639 17 85 3465 16.6 86 2464 15.5 75 2158 15.5 140 4638 16 139 3205 11.2 H 1 name color ford must red 70 US hi 1200d green 78 Asia honda civiblue 77 US ford grana red 80 Europe audi 4000 blue 81 Asia datsun 201 blue 80 Asia toyota cor blue 72 Europe volkswage blue 77 US mercury c green 70 US ford torini green 82 Europe vw pickup blue 77 US pontiac su blue 82 US dodge ran blue 75 US ford Itd green 70 US chevrolet green 72 US chevrolet green 77 Europe renault 5 (blue 82 US chevy 5-10 blue 74 Asia toyota cor blue 77 Asia mazda rx- black 75 US plymouth red 75 US buick centred 74 US ford gran green 70 US dodge chagreen 75 US pontiac as blue 73 Europe fiat 124 sp blue 82 Asia toyota cel blue 70 Asia toyota cor blue 75 US buick skyt red 80 Asia mazda 62 blue 80 Asia datsun 281 red 72 US amc mata green 75 US ford pinto blue 81 US chrysler le red 76 Europe fiat 131 blue 73 Europe opel mant blue 74 US ford gran green 78 US ford futur green 119 71 80 K L size marker 27.37034 0 62.19951 o 9x 34.51563 0 13.29818 5 18.99507 x 14.25063 x 17.51422 s 51.24174 0 33.04334 o 12.6025 s 20.85444 0 14.63063 0 60.24347 0 39.292 0 46.6489 0 9.251736 s 20.551110 9.3636 x 20.55111 x 29.5936 0 42.4018 0 47.633 0 35.2638 0 18.6624 0 14.250635 19.7284 x 15.62884 x 25.65423 o 17.94934 x 23.5225 x 42.07684 o 19.34534 o 33.35063 0 16.86471 s 12.93601 s 59.7529 0 28.5334 o 4 32 21.5 19 1836 3 6 225 23 6 231 17 16 24 8 25 15 8 4 302 383 140 26 23 26 4 27 28 98 144 4 13.9 32 24 29 4 113 6 231 4 120 2542 30 31 32 33 34 6 168 21 31.3 32.7 15 23 17.6 28 8 4 35 6 304 140 225 107 116 302 36 4 24 4 37 38 39 14 8 18.1 8 302 auto(1) READY 5 gm 2008 - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 -A A El Wrap Text General Bad Paste * Cut BE Copy - Format Painter Clipboard BIU. > A Merge & Center % 0.00 000 Normal Conditional Format as Check Cell Formatting Table Explanator Font Alignment Number A1 > fx population M N O B D E F G H 1 K L 1 populatio fertility HIV CO2 BMI male GDP BMI_fema life child_mor Region 2 34811059 2.73 0.1 3.328945 24.5962 12314 129.9049 75.3 29.5 Middle East & North Africa 3 19842251 6.43 2 1.474353 22.25083 7103 130.1247 58.3 192 Sub-Saharan Africa 4 40381860 2.24 0.5 4.78517 27.5017 14646 118.8915 75.5 15.4 America 5 2975029 1.4 0.1 1.804106 25.35542 7383 132.8108 72.5 20 Europe & Central Asia 6 21370348 1.96 0.1 18.01631 27.56373 41312 117.3755 81.5 5.2 East Asia & Pacific & 7 8331465 1.41 0.3 8.18316 26.46741 43952 124.1394 80.4 4.6 Europe & Central Asia 8 8868713 1.99 0.1 5.109538 25.65117 14365 128.6024 70.6 43.3 Europe & Central Asia 9 348587 1.89 3.1 3.131921 27.24594 24373 124.3862 72.2 14.5 America 10 1.48E+08 2.38 0.06 0.319161 20.39742 2265 125.0307 68.4 55.9 South Asia 11 277315 1.83 1.3 6.008279 26.38439 16075 126.394 75.3 15.4 America 12 9526453 1.42 0.2 6.488174 26.16443 14488 129.7968 70.1 7.2 Europe & Central Asia 13 10779155 1.82 0.2 9.797337 26.75915 41641 121.8227 79.4 4.7 Europe & Central Asia 14 306165 2.91 2.4 1.360126 27.02255 8293 120.9224 70.7 20.1 America 15 8973525 5.27 1.2 0.537539 22.41835 1646 130.2723 63.2 116.3 Sub-Saharan Africa 16 694990 2.51 0.2 0.60121 22.8218 5663 125.1258 67.6 48.1 South Asia 17 9599916 3.48 0.2 1.431829 24.43335 5066 122.4155 70.9 52 America 18 1967866 2.86 24.9 2.547205 22.12984 13858 133.1307 61.2 63.8 Sub-Saharan Africa 19 1.95E+08 1.9 0.45 2.023773 25.78623 13906 124.8745 73.9 18.6 America 20 7513646 1.43 0.1 6.690139 26.54286 15368 128.4721 73.2 13.7 Europe & Central Asia 21 14709011 6.04 1.2 0.109419 21.27157 1358 130.6651 59.4 130.4 Sub-Saharan Africa 22 8821795 6.48 3.5 0.031389 21.50291 723 134.1955 57.4 108.6 Sub-Saharan Africa 23 13933660 3.05 0.6 0.287547 20.80496 2442 117.5528 66.2 51.5 East Asia & Pacific 24 19570418 5.17 5.3 0.295542 23.68173 2571 127.2823 56.6 113.8 Sub-Saharan Africa 25 33363256 1.68 0.2 16.3504 27.4521 41468 118.0571 80.7 5.8 America 26 11139740 6.81 3.4 0.047839 21.48569 1753 127.864 54.8 168 Sub-Saharan Africa 27 16645940 1.89 0.4 4.240259 27.01542 18698 125.5417 78.9 8.9 America 28 44901660 2.43 0.5 1.476092 24.94041 10489 124.0235 75.1 19.7 America 29 665414 5.05 0.06 0.178853 22.06131 1440 132.1354 62.6 91.2 Sub-Saharan Africa - 30 3832771 5.1 3.5 0.38422 21.87134 5022 131.6935 58.6 72.6 Sub-Saharan Africa 31 4429506 1.91 0.3 1.911933 26.47897 12219 121.35 79.7 10.3 America 32 19261647 4.91 3.7 0.361897 22.56469 2854 131.5237 55.9 116.9 Sub-Saharan Africa 33 4344151 1.43 0.06 5.287903 26.59629 21873 130.3921 76.5 5.9 Europe & Central Asia 34 11290239 1.5 0.1 2.701777 25.06867 17765 126.0594 77.8 6.3 America 35 5495302 1.89 0.2 8.541508 26.13287 45017 119.5815 78.7 4.3 Europe & Central Asia 36 809639 3.76 2.6 0.6128 23.38403 2502 129.3376 61 81 Middle East & North Africa 37 14447600 2.73 0.4 2.110518 25.58841 9244 122.9864 74 26.8 America 38 78976122 2.95 0.06 2.512394 26.73243 9974 125.0931 70.1 31.4 Middle East & North Africa 39 6004199 2.32 0.8 1.067765 26.36751 7450 119.9321 74.1 21.6 America gm 2008 READY