The second image is the sample data and could you explain the way that I could do in Excel? (As I have to submit the excel file) Thanksss a lot.

7. [20marks] Consider an online tutoring platform that connects high school students, who seek help on English or Mathematics, to a network of teachers. On the platform, there are three teachers, two of whom are English majored and the third one is Mathematics majored. Each teacher can answer one question at a time. The questions are handled on a first-come, first-served basis. It would be preferable to have the teacher who is majored in the same subject to answer the question. If none of the teachers majoring in that subject is available, a teacher of a different major can help answer the question, but the time to come up with the answer is expected to be longer. Suppose that at t = 0, it is 00:00 and there is no question from students so far. A scenario of the times that the questions are posted and the durations for the teachers to answer the questions (dependent on the major of the teacher) for the first 1000 students is provided on worksheet 07 of Assignmentl-Data.xlsx. The time unit used in the data is minute. Assume that the questions are handled immediately whenever a teacher is available. What is the average waiting time for a question to be answered (from the time the question is posted to the time the teacher finishes the answer)? Question Subject Time posted at Duration to answer this question by a teacher of the same subject Duration to answer this question by a teacher of a different subject 1 Mathemat 0.352055491 1.482394984 1.787102147 2 English 0.683299959 2.232252555 2.754677857 3 Mathemat 3.396027997 1.686519189 2.180588208 4 English 3.933810853 1.915424061 2.896836821 5 English 4.017814248 1.606342993 1.610667126 6 English 4.731527819 3.072068209 3.420144004 7 English 5.005832099 2.21614268 2.857173324 8 English 7.792940491 1.685997094 2.411517224 9 English 8.416023792 1.841301231 2.202998484 10 English 11.30874445 1.425122799 2.253870746 11 Mathemat 11.6507784 2.286868482 2.853261821 12 English 11.80592216 1.424777607 2.292313035 13 English 12.22329539 2.148824424 3.122261442 14 English 12.24574465 1.683300907 2.043105882 15 English 13.23001299 1.266250108 1.863569342 16 Mathemat 13.88851824 1.975768698 2.830905297 17 English 15.05620548 2.2330788 2.236961006 18 English 15.22662011 2.139041622 2.374138474 19 Mathemat 15.45126869 1.764897758 2.605695484 20 English 15.93186566 1.349039782 2.042042082 21 English 16.35486469 1.558650169 2.539428502 22 Mathemat 16.72830162 1.710810595 2.366568477 23 English 17.20619152 2.099315796 2.099459851 24 English 17.51272663 2.013839999 2.117017823 25 English 17.91324831 1.783242614 2.690657064 26 English 20.93995165 2.333692235 3.175341708 27 English 21.50671905 1.664074289 1.913719475 28 Mathemat 21.93094186 2.716699284 3.097665373 29 English 24.23884138 2.477858038 2.988683 30 English 24.83981274 1.679673573 2.653381726 31 English 25.04542241 1.90232037 2.532379378 32 English 25.13638662 1.408097949 1.894506827 Ariore Aaron 7. [20marks] Consider an online tutoring platform that connects high school students, who seek help on English or Mathematics, to a network of teachers. On the platform, there are three teachers, two of whom are English majored and the third one is Mathematics majored. Each teacher can answer one question at a time. The questions are handled on a first-come, first-served basis. It would be preferable to have the teacher who is majored in the same subject to answer the question. If none of the teachers majoring in that subject is available, a teacher of a different major can help answer the question, but the time to come up with the answer is expected to be longer. Suppose that at t = 0, it is 00:00 and there is no question from students so far. A scenario of the times that the questions are posted and the durations for the teachers to answer the questions (dependent on the major of the teacher) for the first 1000 students is provided on worksheet 07 of Assignmentl-Data.xlsx. The time unit used in the data is minute. Assume that the questions are handled immediately whenever a teacher is available. What is the average waiting time for a question to be answered (from the time the question is posted to the time the teacher finishes the answer)? Question Subject Time posted at Duration to answer this question by a teacher of the same subject Duration to answer this question by a teacher of a different subject 1 Mathemat 0.352055491 1.482394984 1.787102147 2 English 0.683299959 2.232252555 2.754677857 3 Mathemat 3.396027997 1.686519189 2.180588208 4 English 3.933810853 1.915424061 2.896836821 5 English 4.017814248 1.606342993 1.610667126 6 English 4.731527819 3.072068209 3.420144004 7 English 5.005832099 2.21614268 2.857173324 8 English 7.792940491 1.685997094 2.411517224 9 English 8.416023792 1.841301231 2.202998484 10 English 11.30874445 1.425122799 2.253870746 11 Mathemat 11.6507784 2.286868482 2.853261821 12 English 11.80592216 1.424777607 2.292313035 13 English 12.22329539 2.148824424 3.122261442 14 English 12.24574465 1.683300907 2.043105882 15 English 13.23001299 1.266250108 1.863569342 16 Mathemat 13.88851824 1.975768698 2.830905297 17 English 15.05620548 2.2330788 2.236961006 18 English 15.22662011 2.139041622 2.374138474 19 Mathemat 15.45126869 1.764897758 2.605695484 20 English 15.93186566 1.349039782 2.042042082 21 English 16.35486469 1.558650169 2.539428502 22 Mathemat 16.72830162 1.710810595 2.366568477 23 English 17.20619152 2.099315796 2.099459851 24 English 17.51272663 2.013839999 2.117017823 25 English 17.91324831 1.783242614 2.690657064 26 English 20.93995165 2.333692235 3.175341708 27 English 21.50671905 1.664074289 1.913719475 28 Mathemat 21.93094186 2.716699284 3.097665373 29 English 24.23884138 2.477858038 2.988683 30 English 24.83981274 1.679673573 2.653381726 31 English 25.04542241 1.90232037 2.532379378 32 English 25.13638662 1.408097949 1.894506827 Ariore Aaron