CMPS 209 Lab Assignment 5, Fall 2013

1 m = 100 MALE Date Of Birth Height in cm BMI Age Height In m White, Danzel 28-Jan-1940 177 522 23.8 86 1.77 Jadaffi, Akim 3-Mar-1993 190.5 75 18.5 33 1.905 Daniel, Jacob 6-Jul-1985 179.25 740 19 41 1.7925 Diaz, Jorge 16-Jun-1985 171.25 303 21.6 41 1.7125 Smith, Kyle 22-Jan-1991 165.5 127 23.2 35 1.655 Biagis, John 2-Feb-1980 173 189 25.5 46 1.73 Santos, Carlos 5-Apr-1993 170.75 121 26.4 33 1.7075 Sosas, Fred 23-Aug-1990 157.25 762 27 36 1.5725 Harley, Jim 1-Feb-1981 168 466 31.4 45 1.68 Browns, Fredy 23-May-1995 169 265 23.3 31 1.69 Lock, Nicolas 17-Sep-1996 157.5 78 27.8 30 1.575 Hatt, Jerimiah 25-Oct-1996 177.5 272 33.1 30 1.775 Sarges, Tyrone 2-Nov-1958 164 578 22.7 68 1.64 Jang, Lin 21-Dec-1955 179.75 339 23.8 71 1.7975 Chavez, Juanita 21-Feb-1961 173 316 24.5 65 1.73 Chuanmin, Hu 1-May-1959 165.75 138 26.6 67 1.6575 Naik, Chandana 12-Oct-1961 163.5 638 27.1 65 1.635 Childs, Rony 25-Feb-1957 173.5 31 28.3 69 1.735 CHOL mg cm Weight Kg 75 67 Tallest Male 1.905 61 Average Height 1.71 63 4 64 76 2 77 67 89 67 69 104 61 77 73 73 72 85 Number of males born between 1/1/1980 and 1/1/1990 Number of males whose first name starts with F Tobacco and Alcohol Use in Children Movies in the 80s and 90s Movie year Relese date Company Length (min) Tobacco Use (s) 101 Dalmations 1996 11/27/1996 Disney 79 299 Aladdin 1992 11/25/1992 Disney 90 2 All Dogs Go to Heaven 1989 11/17/1989 MGM 89 205 All Dogs Go to Heaven 2 1996 3/29/1996 MGM 82 162 An American Tail 1986 11/21/1986 Universal 77 155 Anastasia 1997 11/21/1997 20th Century Fox 94 17 Balto 1995 12/22/1995 Universal 78 0 Cats Don't Dance 1997 3/28/1997 Warner Bros 75 91 Fievel Goes West 1991 11/22/1991 Universal 75 24 James and the Giant Peach 1996 4/12/1996 Disney 79 206 Little Mermaid 1989 11/17/1989 Disney 82 9 Once Upon a Forest 1993 6/18/1993 20th Century Fox 71 0 Pippi Longstocking 1997 8/22/1997 Warner Bros 102 91 Space Jam 1996 11/10/1996 Warner Bros 81 117 The Land Before Time 2 1994 12/12/1994 Universal 74 0 The secret of NIMH 1982 7/2/1982 MGM 83 0 The troll in Centrall Park 1994 10/7/1994 Warner Bros 76 1 Thumbelina 1994 3/30/1994 Warner Bros 86 6 We're Back: A Dinosaur Story 1993 11/24/1993 Universal 73 55 1 - How many movies are being considered? 2 - What is the percentage of movies produced by "MGM"? 3 - How many movies include Tobacco and Alcohol use? 4 - How many movies include Tobacco or Alcohol use? 5 - How many movies are produced by Universal between 1980 and 1995? (inclusively) 6 - What is the average use of tobacco by movies produced between 1980 and 1990? (inclusively) 7 - What is the average use of alcohol by "Disney" movies? 8 - What is the total length in seconds of use of Alcohol in movies produced by "Disney" and by "Universal"? 9 - What is the number of movies where percentage of tobacco and alcohol use is greater than 4%? 10 - What is the percentage of movies produced by "MGM" after year 1985? 11 - What is the total length of use of tobacco in "Disney" movies in the 90s? 12 - How many movies produced by companies other than "Warner Bros" show a tobaco use more than 30 seconds? 13 - How many movies have a composite name, formed at least of three words? 14 - What is the average length in minutes of movies released between 10/21/1993 and 1/1/1997 (exclusively) 15 - How many movies are released in the month of November? the 80s and 90s Alcohol Use (s) MONTHS 1min= 60 sec 51 4740.00 7% 11 3 5400.00 0% 11 73 5340.00 5% 11 72 4920.00 5% 3 74 4620.00 5% 11 39 5640.00 1% 11 0 4680.00 0% 12 0 4500.00 2% 3 28 4500.00 1% 11 38 4740.00 5% 4 0 4920.00 0% 11 0 4260.00 0% 6 0 6120.00 1% 8 0 4860.00 2% 11 0 4440.00 0% 12 0 4980.00 0% 7 0 4560.00 0% 10 5 5160.00 0% 3 0 4380.00 1% 11 19.00 16% 9.00 15.00 5.00 92.30 23.00 niversal"? 194.00 ? 5.00 11% 507.00 han 30 seconds? 6.00 11.00 xclusively) 78.70 9.00 Length (s) % of tobacco and alcohol use Employee Name Monthly Salary Margaret Parker $ 3,000.00 Carolyn Hernandez $ 2,500.00 Andrea Henderson $ 3,500.00 Sheldon Franklin $ 4,500.00 Velma Hart $ 4,300.00 Lila Hughes $ 2,600.00 Eleanor Wells $ 2,600.00 Carroll Soto $ 4,300.00 Arturo Harmon $ 5,000.00 Rosalie Hanson $ 4,000.00 Ruth Greene $ 4,300.00 Constance Lyons $ 3,500.00 Floyd Harrison $ 3,500.00 Courtney Robinson $ 3,600.00 Allan Lewis $ 6,200.00 Vickie Carson $ 6,100.00 Yvonne Harrison $ 6,100.00 Erma Cobb $ 4,500.00 Cornelius Carrol $ 3,500.00 Kurt Brady $ 2,500.00 Jermain Huff $ 10,000.00 Michelle Medina $ 8,500.00 Custom Salary Average $ 4,172.22 Normal Average $ 4,481.82 10 9 8 7 6 5 4 3 1 1 1 1 1 1 1 1 1024 512 256 128 64 32 16 8 59049 19683 6561 2187 729 243 81 27 1048576 262144 65536 16384 4096 1024 256 64 9765625 1953125 390625 78125 15625 3125 625 125 60466176 10077696 1679616 279936 46656 7776 1296 216 282475249 40353607 5764801 823543 117649 16807 2401 343 1073741824 134217728 16777216 2097152 262144 32768 4096 512 3486784401 387420489 43046721 4782969 531441 59049 6561 729 10000000000 1000000000 100000000 10000000 1000000 100000 10000 1000 2 1 1 1 1 4 2 2 9 3 3 16 4 4 25 5 5 36 6 6 49 7 7 64 8 8 81 9 9 100 10 10