please answer question 8. please give me the instruction on how to do it in excel . data is below.

Year	Female	Male
1987	941	882
1988	954	881
1989	986	887
1990	1035	905
1991	1097	928
1992	1147	961
1993	1182	985
1994	1208	994
1995	1223	995
1996	1255	993
1997	1290	998
1998	1304	994
1999	1330	993
2000	1369	1016
2001	1391	1025
2002	1441	1053
2003	1517	1104
2004	1603	1152
2005	1666	1185
2006	1760	1220
2007	1796	1240

please just do a line chart to compare both male and female and paste the line chart here. thanks!

at least one university will make her an offer? (c)What is the probability that she receives no offer? 7. (6 pts) A standard admissions test was given at three locations. One thousand students took the test at location A, 400 students at location B, and 600 students at location C. The percentages of students from locations A, B, and C who passed the test were 65%, 75%, and 85%, respectively. One student is selected at random from among those who took the test. (a)What is the probability that the selected student passed the test? (3pts) (b)if the selected student did not pass the test, what is the probability that the student took the test at location A? (3pts) 8. (5 pts)The number of earned degrees(thousands) for males and females is listed in the worksheet Q8 for the years from 1987 to 2006. Use an appropriate graph for both sets of data. What do the graphs tell you? 9. (12 pts) Are the marks received in a course related to the amount of time spend studying the subject? To analyze this mysterious possibility, a student took a random sample of ten students who had enrolled in an accounting class last semester. He asked each to report his or her mark in