CMPS 209 Lab Assignment 3, Fall 2013

Name: Section: 12 ID Number: 201300759 AutoFill Table Current date and time: september 30th, 2013, 2:20pm Day of Week (no week ends) Days of Week Abbreviated Month Names Text Quarters Periods Time of day Start of Month A Series of Numbers Day of Week (no week ends) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday jad jamil Monday Tuesday Wednesday Thursday Friday Saturday Sunday Mon Tue Wed Thu Fri Sat Sun Jan Feb Mar Apr May Jun Jul Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Qtr1 Qtr2 Qtr3 Qtr4 Qtr1 Qtr2 Qtr3 1st period 2nd period 3rd period 4th period 5th period 6th period 7th period 8:15 AM 8:30 AM 8:45 AM 9:00 AM 9:15 AM 9:30 AM 9:45 AM 1-Oct-09 1-Nov-09 1-Dec-09 1-Jan-10 1-Feb-10 1-Mar-10 1-Apr-10 0 250 500 750 1000 1250 1500 Days of Week Month NamesText Quarters Periods Time of day Start of Month Mon Jan Section 1 Qtr1 1st period 8:15 AM 1-Oct-09 Tue Feb Section 2 Qtr2 2nd period 8:30 AM 1-Nov-09 Wed Mar Section 3 Qtr3 3rd period 8:45 AM 1-Dec-09 Thu Apr Section 4 Qtr4 4th period 9:00 AM 1-Jan-10 Fri May Section 5 Qtr1 5th period 9:15 AM 1-Feb-10 Sat Jun Section 6 Qtr2 6th period 9:30 AM 1-Mar-10 Sun Jul Section 7 Qtr3 7th period 9:45 AM 1-Apr-10 Mon Aug Section 8 Qtr4 8th period 10:00 AM 1-May-10 Monday Mon Aug Section 8 Qtr4 8th period 10:00 AM 1-May-10 1750 A Series of Numbers 0 250 500 750 1000 1250 1500 1750 Road Safety Name Age Gender years and months Joe Powards 18 M 0 year 2 months Large 2 Jennifer Hughes 25 F 8 years 0 month Small 3 Craig Diaz 63 M 46 years 0 month Large 0 Dennis Long 51 M 35 years 0 month Large 1 Sean Gray 19 M 2 years 4 months Average 0 Linda Richardson 51 F 30 years 0 month Average 2 Diana Price 64 F 35 years 0 month Small 0 Roy Patterson 51 M 34 years 0 month Average 0 Marie Ross 48 F 32 years 0 month Large 0 Nicholas Allen 39 M 11 years 0 month Large 0 Walter Stewart 24 M 3 years 0 month Small 0 Carol King 55 F 38 years 0 month Large 1 Daniel Kelly 18 M 0 year 5 months Small 0 Jeremy Flores 42 M 23 years 0 month Large 2 Judy Wilson 24 F 7 years 0 month Average 0 Mildred Parler 60 F 43 years 0 month Large 1 Ralph Alexander 23 M 5 years 0 month Large 2 Gregory Parker 20 M 3 years 0 month Small 2 Virginia Mitchell 22 F 4 years 0 month Small 2 From how long they had full driving license Actual Car Size Number of children under 5 afety As a number from 1 - 4, when buying a car how important is?? Cost Reliability Performance Fuel Safety Room 6 10 4 2 10 2 8 9 2 4 10 8 6 7 7 6 9 3 3 7 3 7 9 7 6 8 7 4 6 7 6 7 7 3 8 5 6 4 8 3 8 2 4 4 4 8 5 4 6 2 3 3 4 7 7 3 8 4 6 1 3 6 8 8 7 8 2 6 9 8 6 2 6 7 5 8 4 2 3 6 8 3 4 8 8 6 7 6 3 4 2 5 8 8 7 3 8 2 4 8 10 7 8 3 6 8 7 3 8 4 7 4 2 8 Road Safety Name Age Gender years and months Joe Powards 18 M 0 year 2 months Large 2 Jennifer Hughes 25 F 8 years 0 month Small 3 Craig Diaz 63 M 46 years 0 month Large 0 Dennis Long 51 M 35 years 0 month Large 1 Sean Gray 19 M 2 years 4 months Average 0 Linda Richardson 51 F 30 years 0 month Average 2 Diana Price 64 F 35 years 0 month Small 0 Roy Patterson 51 M 34 years 0 month Average 0 Marie Ross 48 F 32 years 0 month Large 0 Nicholas Allen 39 M 11 years 0 month Large 0 Walter Stewart 24 M 3 years 0 month Small 0 Carol King 55 F 38 years 0 month Large 1 Daniel Kelly 18 M 0 year 5 months Small 0 Jeremy Flores 42 M 23 years 0 month Large 2 Judy Wilson 24 F 7 years 0 month Average 0 Mildred Parler 60 F 43 years 0 month Large 1 Ralph Alexander 23 M 5 years 0 month Large 2 Gregory Parker 20 M 3 years 0 month Small 2 Virginia Mitchell 22 F 4 years 0 month Small 2 From how long they had full driving license Actual Car Size Number of children under 5 Safety As a number from 1 - 4, when buying a car how important is?? Cost Reliability Performance Fuel Safety Room 6 10 4 2 10 2 8 9 2 4 10 8 6 7 7 6 9 3 3 7 3 7 9 7 6 8 7 4 6 7 6 7 7 3 8 5 6 4 8 3 8 2 4 4 4 8 5 4 6 2 3 3 4 7 7 3 8 4 6 1 3 6 8 8 7 8 2 6 9 8 6 2 6 7 5 8 4 2 3 6 8 3 4 8 8 6 7 6 3 4 2 5 8 8 7 3 8 2 4 8 10 7 8 3 6 8 7 3 8 4 7 4 2 8 Name Age Gender From how long they had full driving license Craig Diaz 63 M 46 years 0 month Large Dennis Long 51 M 35 years 0 month Large Roy Patterson 51 M 34 years 0 month Average Nicholas Allen 39 M 11 years 0 month Large Jeremy Flores 42 M 23 years 0 month Large Actual Car Size Cost Reliability Performance Fuel Safety Room 0 6 7 7 6 9 3 5/29/1967 1 3 7 3 7 9 7 5/29/1978 4 4 4 4 8 5 4 5/29/1979 4 7 3 8 4 6 1 5/29/2002 2 3 6 8 3 4 8 5/29/1990 Number of children under 5 Date of getting the license Name Age Gender From how long they had full driving license Joe Powar 18 M 0 year 2 months Large Jennifer Hughes 25 F 8 years 0 month Small Linda Richardson 51 F 30 years 0 month Average Nicholas Allen 39 M 11 years 0 month Large Ralph Alexander 23 M 5 years 0 month Large Gregory Parker 20 M 3 years 0 month Small Virginia Mitchell 22 F 4 years 0 month Small Actual Car Size Cost Reliability Performance Fuel Safety Room 2 6 10 4 2 10 2 3/30/2013 3 8 9 2 4 10 8 5/29/2005 2 6 7 7 3 8 5 5/29/1983 4 7 3 8 4 6 1 5/29/2002 2 8 2 4 8 10 7 5/28/2008 2 8 3 6 8 7 3 5/29/2010 2 8 4 7 4 2 8 5/29/2009 Number of children under 5 Date of getting the license Name Age Gender From how long they had full driving license Joe Powar 18 M 0 year 2 months Large Mildred Parler 60 F 43 years 0 month Large Gregory Parker 20 M 3 years 0 month Small Actual Car Size Cost Reliability Performance Fuel Safety Room 2 6 10 4 2 10 2 3/30/2013 1 2 5 8 8 7 3 5/29/1970 2 8 3 6 8 7 3 5/29/2010 Number of children under 5 Date of getting the license Name Age Gender From how long they had full driving license years months Jennifer Hughes 25 F 8 years 0 month Small Craig Diaz 63 M 46 years 0 month Large Dennis Long 51 M 35 years 0 month Large Sean Gray 19 M 2 years 4 months Average Linda Richardson 51 F 30 years 0 month Average Diana Price 64 F 35 years 0 month Small Roy Patterson 51 M 34 years 0 month Average Marie Ross 48 F 32 years 0 month Large Nicholas Allen 39 M 11 years 0 month Large Walter Stewart 24 M 3 years 0 month Small Carol King 55 F 38 years 0 month Large Jeremy Flores 42 M 23 years 0 month Large Judy Wilson 24 F 7 years 0 month Average Mildred Parler 60 F 43 years 0 month Large Ralph Alexander 23 M 5 years 0 month Large Gregory Parker 20 M 3 years 0 month Small Virginia Mitchell 22 F 4 years 0 month Small Actual Car Size Cost Reliability Performance Fuel Safety Room 3 8 9 2 4 10 8 5/29/2005 0 6 7 7 6 9 3 5/29/1967 1 3 7 3 7 9 7 5/29/1978 0 6 8 7 4 6 7 1/29/2011 2 6 7 7 3 8 5 5/29/1983 0 6 4 8 3 8 2 5/29/1978 4 4 4 4 8 5 4 5/29/1979 0 6 2 3 3 4 7 5/29/1981 4 7 3 8 4 6 1 5/29/2002 0 3 6 8 8 7 8 5/29/2010 1 2 6 9 8 6 2 5/29/1975 2 3 6 8 3 4 8 5/29/1990 0 8 6 7 6 3 4 5/29/2006 1 2 5 8 8 7 3 5/29/1970 2 8 2 4 8 10 7 5/28/2008 2 8 3 6 8 7 3 5/29/2010 2 8 4 7 4 2 8 5/29/2009 Number of children under 5 Date of getting the license Name Age Gender From how long they had full driving license Joe Powar 18 M 0 year 2 months Large Jennifer Hughes 25 F 8 years 0 month Small Craig Diaz 63 M 46 years 0 month Large Dennis Long 51 M 35 years 0 month Large Linda Richardson 51 F 30 years 0 month Average Actual Car Size Cost Reliability Performance Fuel Safety Room 2 6 10 4 2 10 2 3/30/2013 3 8 9 2 4 10 8 5/29/2005 0 6 7 7 6 9 3 5/29/1967 1 3 7 3 7 9 7 5/29/1978 2 6 7 7 3 8 5 5/29/1983 Number of children under 5 Date of getting the license sum of safety and reliability 20 19 16 16 15 Name Age Gender From how long they had full driving license Craig Diaz 63 M 46 years 0 month Large Roy Patterson 51 M 34 years 0 month Average Carol King 55 F 38 years 0 month Large Mildred Parler 60 F 43 years 0 month Large Actual Car Size Cost Reliability Performance Fuel Safety Room 0 6 7 7 6 9 3 5/29/1967 4 4 4 4 8 5 4 5/29/1979 1 2 6 9 8 6 2 5/29/1975 1 2 5 8 8 7 3 5/29/1970 Number of children under 5 Date of getting the license Name Age Gender From how long they had full driving license Jennifer Hughes 25 F 8 years 0 month Small Sean Gray 19 M 2 years 4 months Average Walter Stewart 24 M 3 years 0 month Small Judy Wilson 24 F 7 years 0 month Average Ralph Alexander 23 M 5 years 0 month Large Gregory Parker 20 M 3 years 0 month Small Virginia Mitchell 22 F 4 years 0 month Small Actual Car Size Cost Reliability Performance Fuel Safety Room 3 8 9 2 4 10 8 5/29/2005 0 6 8 7 4 6 7 1/29/2011 0 3 6 8 8 7 8 5/29/2010 0 8 6 7 6 3 4 5/29/2006 2 8 2 4 8 10 7 5/28/2008 2 8 3 6 8 7 3 5/29/2010 2 8 4 7 4 2 8 5/29/2009 Number of children under 5 Date of getting the license Name Age Gender Cost Reliability Performance Joe Powar 18 M Large 2 6 10 4 Jennifer Hughes 25 F Small 3 8 9 2 Craig Diaz 63 M Large 0 6 7 7 Dennis Long 51 M Large 1 3 7 3 Sean Gray 19 M Average 0 6 8 7 Linda Richardson 51 F Average 2 6 7 7 Diana Price 64 F Small 0 6 4 8 Roy Patterson 51 M Average 0 4 4 4 Marie Ross 48 F Large 0 6 2 3 Nicholas Allen 39 M Large 0 7 3 8 Walter Stewart 24 M Small 0 3 6 8 Carol King 55 F Large 1 2 6 9 Daniel Kelly 18 M Small 0 6 7 5 Jeremy Flores 42 M Large 2 3 6 8 Judy Wilson 24 F Average 0 8 6 7 Mildred Parler 60 F Large 1 2 5 8 Ralph Alexander 23 M Large 2 8 2 4 Gregory Parker 20 M Small 2 8 3 6 Virginia Mitchell 22 F Small 2 8 4 7 Actual Car Size Number of children under 5 Fuel Safety Room 2 10 2 3/30/2013 4 10 8 5/29/2005 6 9 3 5/29/1967 7 9 7 5/29/1978 4 6 7 1/29/2011 3 8 5 5/29/1983 3 8 2 5/29/1978 8 5 4 5/29/1979 3 4 7 5/29/1981 4 6 1 5/29/2002 8 7 8 5/29/2010 8 6 2 5/29/1975 8 4 2 12/30/2012 3 4 8 5/29/1990 6 3 4 5/29/2006 8 7 3 5/29/1970 8 10 7 5/28/2008 8 7 3 5/29/2010 4 2 8 5/29/2009 Date of getting the license Name Age Gender Cost Reliability Performance Diana Price 64 F Small 0 6 4 8 Mildred Parler 60 F Large 1 2 5 8 Carol King 55 F Large 1 2 6 9 Linda Richardson 51 F Average 2 6 7 7 Marie Ross 48 F Large 0 6 2 3 Jennifer Hughes 25 F Small 3 8 9 2 Judy Wilson 24 F Average 0 8 6 7 Virginia Mitchell 22 F Small 2 8 4 7 Craig Diaz 63 M Large 0 6 7 7 Dennis Long 51 M Large 1 3 7 3 Roy Patterson 51 M Average 0 4 4 4 Jeremy Flores 42 M Large 2 3 6 8 Nicholas Allen 39 M Large 0 7 3 8 Walter Stewart 24 M Small 0 3 6 8 Ralph Alexander 23 M Large 2 8 2 4 Gregory Parker 20 M Small 2 8 3 6 Sean Gray 19 M Average 0 6 8 7 Joe Powar 18 M Large 2 6 10 4 Daniel Kelly 18 M Small 0 6 7 5 Actual Car Size Number of children under 5 Fuel Safety Room 3 8 2 5/29/1978 8 7 3 5/29/1970 8 6 2 5/29/1975 3 8 5 5/29/1983 3 4 7 5/29/1981 4 10 8 5/29/2005 6 3 4 5/29/2006 4 2 8 5/29/2009 6 9 3 5/29/1967 7 9 7 5/29/1978 8 5 4 5/29/1979 3 4 8 5/29/1990 4 6 1 5/29/2002 8 7 8 5/29/2010 8 10 7 5/28/2008 8 7 3 5/29/2010 4 6 7 1/29/2011 2 10 2 3/30/2013 8 4 2 12/30/2012 Date of getting the license Name Age Gender Cost Reliability Performance Jennifer Hughes 25 F Small 3 8 9 2 Diana Price 64 F Small 0 6 4 8 Daniel Kelly 18 M Small 0 6 7 5 Virginia Mitchell 22 F Small 2 8 4 7 Craig Diaz 63 M Large 0 6 7 7 Roy Patterson 51 M Average 0 4 4 4 Carol King 55 F Large 1 2 6 9 Mildred Parler 60 F Large 1 2 5 8 Joe Powar 18 M Large 2 6 10 4 Dennis Long 51 M Large 1 3 7 3 Sean Gray 19 M Average 0 6 8 7 Linda Richardson 51 F Average 2 6 7 7 Marie Ross 48 F Large 0 6 2 3 Nicholas Allen 39 M Large 0 7 3 8 Walter Stewart 24 M Small 0 3 6 8 Jeremy Flores 42 M Large 2 3 6 8 Judy Wilson 24 F Average 0 8 6 7 Ralph Alexander 23 M Large 2 8 2 4 Gregory Parker 20 M Small 2 8 3 6 Actual Car Size Number of children under 5 Fuel Safety Room 4 10 8 5/29/2005 3 8 2 5/29/1978 8 4 2 12/30/2012 4 2 8 5/29/2009 6 9 3 5/29/1967 8 5 4 5/29/1979 8 6 2 5/29/1975 8 7 3 5/29/1970 2 10 2 3/30/2013 7 9 7 5/29/1978 4 6 7 1/29/2011 3 8 5 5/29/1983 3 4 7 5/29/1981 4 6 1 5/29/2002 8 7 8 5/29/2010 3 4 8 5/29/1990 6 3 4 5/29/2006 8 10 7 5/28/2008 8 7 3 5/29/2010 Date of getting the license Name Age Gender Cost Reliability Performance Jennifer Hughes 25 F Small 3 8 9 2 Diana Price 64 F Small 0 6 4 8 Walter Stewart 24 M Small 0 3 6 8 Daniel Kelly 18 M Small 0 6 7 5 Gregory Parker 20 M Small 2 8 3 6 Virginia Mitchell 22 F Small 2 8 4 7 Sean Gray 19 M Average 0 6 8 7 Linda Richardson 51 F Average 2 6 7 7 Roy Patterson 51 M Average 0 4 4 4 Judy Wilson 24 F Average 0 8 6 7 Joe Powar 18 M Large 2 6 10 4 Craig Diaz 63 M Large 0 6 7 7 Dennis Long 51 M Large 1 3 7 3 Marie Ross 48 F Large 0 6 2 3 Nicholas Allen 39 M Large 0 7 3 8 Carol King 55 F Large 1 2 6 9 Jeremy Flores 42 M Large 2 3 6 8 Mildred Parler 60 F Large 1 2 5 8 Ralph Alexander 23 M Large 2 8 2 4 Actual Car Size Number of children under 5 Fuel Safety Room 4 10 8 5/29/2005 3 8 2 5/29/1978 8 7 8 5/29/2010 8 4 2 12/30/2012 8 7 3 5/29/2010 4 2 8 5/29/2009 4 6 7 1/29/2011 3 8 5 5/29/1983 8 5 4 5/29/1979 6 3 4 5/29/2006 2 10 2 3/30/2013 6 9 3 5/29/1967 7 9 7 5/29/1978 3 4 7 5/29/1981 4 6 1 5/29/2002 8 6 2 5/29/1975 3 4 8 5/29/1990 8 7 3 5/29/1970 8 10 7 5/28/2008 Date of getting the license Name Age Gender Cost Reliability Joe Powar 18 M Large 2 6 10 Daniel Kelly 18 M Small 0 6 7 Sean Gray 19 M Average 0 6 8 Walter Stewart 24 M Small 0 3 6 Gregory Parker 20 M Small 2 8 3 Virginia Mitchell 22 F Small 2 8 4 Ralph Alexander 23 M Large 2 8 2 Judy Wilson 24 F Average 0 8 6 Jennifer Hughes 25 F Small 3 8 9 Nicholas Allen 39 M Large 0 7 3 Jeremy Flores 42 M Large 2 3 6 Linda Richardson 51 F Average 2 6 7 Marie Ross 48 F Large 0 6 2 Roy Patterson 51 M Average 0 4 4 Dennis Long 51 M Large 1 3 7 Diana Price 64 F Small 0 6 4 Carol King 55 F Large 1 2 6 Mildred Parler 60 F Large 1 2 5 Craig Diaz 63 M Large 0 6 7 Actual Car Size Number of children under 5 Performance Fuel Safety Room 4 2 10 2 3/30/2013 5 8 4 2 12/30/2012 7 4 6 7 1/29/2011 8 8 7 8 5/29/2010 6 8 7 3 5/29/2010 7 4 2 8 5/29/2009 4 8 10 7 5/28/2008 7 6 3 4 5/29/2006 2 4 10 8 5/29/2005 8 4 6 1 5/29/2002 8 3 4 8 5/29/1990 7 3 8 5 5/29/1983 3 3 4 7 5/29/1981 4 8 5 4 5/29/1979 3 7 9 7 5/29/1978 8 3 8 2 5/29/1978 9 8 6 2 5/29/1975 8 8 7 3 5/29/1970 7 6 9 3 5/29/1967 Date of getting the license