Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 Aaron

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Principles And Applications

Authors: Hugh Coombs, D Ellis Jenkins, David Hobbs

1st Edition

1412908434, 978-1412908436

More Books

Students also viewed these Accounting questions