USE EXCEL TO ANSWER THE FOLLOWING QUESTIONS

Q1: Assume a survey by Moodle Team collected data on average hours spent studying on Moodle for 10 EC203 students before the Final Exam.

Year Sugar Exports Year Sugar Exports Year Sugar Exports 1980 10048 1991 10003 2002 9954 1981 10050 1992 9998 2003 9949 1982 10046 1993 9995 2004 9944 1983 10042 1994 9990 2005 9939 1984 10040 1995 9985 2006 9934 1985 10032 1996 9980 2007 9929 1986 10034 1997 9975 1987 10026 1998 9971 1988 10021 1999 9966 1989 10013 2000 9961 1990 10008 2001 9959Day James Peter Chris Susan Jessica Chathy Ryan Melina Eric Monday 5.48 4.82 5.19 6.22 4.70 5.07 7.42 6.84 6.91 Tuesday 6.21 5.63 5.70 3.85 5.21 5.61 9.06 6.42 6.82 Wednesday 7.15 6.57 6.64 3.79 6.15 6.55 7.66 7.08 7.15 Thursday 5.22 4.56 4.93 5.96 4.44 4.81 10.73 8.09 8.49 Friday 6.83 6.17 6.54 7.57 6.05 6.42 8.99 8.41 8.48 Saturday 8.04 7.46 7.53 9.68 7.04 7.44 10.29 9.71 9.78 Sunday 16.76 6.1 10.47 7.5 8.98 9.35 12.61 9.97 10.37