A taxicab company operates one vehicle during the 9:00 A.M. to 5:00 P.M. period. The demand for taxi follows the distribution shown: Time between Calls (Minutes) Probability 20 25 30 0.43 40 0.14 0.22 0.17 0.04 The distribution of time to complete a service is as follows: Service Time (Minute) Probability 0.15 10 15 0.40 20 0.07 25 0.03 0.35 Using EXCEL simulate for 90 customers, Calculate waiting times of the customers. 35
A taxicab company operates one vehicle during the 9:00 A.M. to 5:00 P.M. period. The demand for taxi follows the distribution shown: Time between Calls (Minutes) Probability 20 25 30 0.43 40 0.14 0.22 0.17 0.04 The distribution of time to complete a service is as follows: Service Time (Minute) Probability 0.15 10 15 0.40 20 0.07 25 0.03 0.35 Using EXCEL simulate for 90 customers, Calculate waiting times of the customers. 35
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
Related questions
Question
I need the answer as soon as possible
![please answer this using EXCELOO
A taxicab company operates one vehicle during the 9:00 A.M. to 5:00 P.M. period. The
demand for taxi follows the distribution shown:
Time between Calls
(Minutes)
Probability
20
25
30
0.43
35
40
0.04
0.14 0.22
0.17
The distribution of time to complete a service is as follows:
Service Time
(Minute)
Probability 0.1
10
15
0.40
20
0.07
25
0.03
0.35
Using EXCEL simulate for 90 customers, Calculate waiting times of the customers.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb5646be2-7a95-4576-8dc9-52640561076c%2F2e29e824-bb80-42b4-b247-edcf466297f7%2F2w7dg9s_processed.jpeg&w=3840&q=75)
Transcribed Image Text:please answer this using EXCELOO
A taxicab company operates one vehicle during the 9:00 A.M. to 5:00 P.M. period. The
demand for taxi follows the distribution shown:
Time between Calls
(Minutes)
Probability
20
25
30
0.43
35
40
0.04
0.14 0.22
0.17
The distribution of time to complete a service is as follows:
Service Time
(Minute)
Probability 0.1
10
15
0.40
20
0.07
25
0.03
0.35
Using EXCEL simulate for 90 customers, Calculate waiting times of the customers.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781337282291/9781337282291_smallCoverImage.gif)
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781305115545/9781305115545_smallCoverImage.gif)
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781337282291/9781337282291_smallCoverImage.gif)
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781305115545/9781305115545_smallCoverImage.gif)
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
![College Algebra](https://www.bartleby.com/isbn_cover_images/9781938168383/9781938168383_smallCoverImage.gif)
![PREALGEBRA](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)