3_Excel_Problem_Set - year 1991 1992 1993 1994 1995 1996...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: year 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 College Plans No College Plans 89.9 83.9 93.1 87.7 92.4 85.8 94.1 89.4 92.6 84 91.6 86.2 88.4 80.7 85.3 82.2 84.5 72.3 85 77.9 83.5 72.7 76.9 69 71.8 59.5 6.69 8.7 100 90 80 70 60 0.88 0.87 Percentage of Students Concerned About Crime 50 40 30 20 10 0 19 100 90 80 70 60 50 40 30 20 10 0 1990 College Plans Linear Regression for College Plans No College Plans Linear Regression for No College Plans Concerned About Crime 1995 Year 2000 2005 Year 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 College Plans No College Plans 28.5 28.7 25.8 31 26.9 27.3 29.5 29.7 28.9 29.4 27.8 28.1 29.3 26.6 33 32.2 34.5 32.4 34.1 33.5 34.9 29 40.2 36 40 43.1 0.92 0.68 Chart Title 50 45 40 35 30 Percentage of Students that feel law enforcment is doing a good job 25 20 15 10 5 0 1990 2000 2010 Year College Plans No College Plans College Plans No College Plans 010 28.5 25.8 26.9 29.5 28.9 27.8 29.3 33 34.5 34.1 34.9 40.2 40 4.73 89.9 93.1 92.4 94.1 92.6 91.6 88.4 85.3 84.5 85 83.5 76.9 71.8 6.69 0.95 1.34 100 90 80 70 60 Axis Title 50 40 30 20 10 0 24 26 28 30 32 34 36 38 40 42 Axis Title Column B Linear Regression for Column B 28.7 31 27.3 29.7 29.4 28.1 26.6 32.2 32.4 33.5 29 36 43.1 4.42 83.9 87.7 85.8 89.4 84 86.2 80.7 82.2 72.3 77.9 72.7 69 59.5 8.7 0.8 100 90 80 70 60 Axis Title Column B Linear Regression for Column B 50 40 30 20 10 0 25 30 35 Axis Title 40 42 1.57 Column Q Linear Regression for Column Q Linear Regression for Column Q 35 40 45 Title ...
View Full Document

This homework help was uploaded on 02/01/2009 for the course PAM 210 taught by Professor Abdus,s. during the Spring '08 term at Cornell University (Engineering School).

Ask a homework question - tutors are online