Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want to know only method of excel calculation. Thanks. 7. [20marks] Consider an online tutoring platform that connects high school students, who seek help
I want to know only method of excel calculation. Thanks.
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 AaronStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started