Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with this excel project . This project requires applications of the logic functions, IF and VLOOKUP, to a random simulation. Using a probability

image text in transcribed

Need help with this excel project

image text in transcribed
. This project requires applications of the logic functions, IF and VLOOKUP, to a random simulation. Using a probability distribution to determine the number of cars that will arrive at an exit every minute, students have to determine the appropriate number of toll booths to build. They must factor in cost, back-up, and revenue generated in making their decision. This project epitomizes the "informed decision making" that we strive to cultivate in the QR class. Students definitely are wowed by the ability of a spreadsheet to simulate this real world scenario. The model we create is relatively simple, yet powerful enough to help us generate insights into the amount of back-up we can expect for different numbers of toll booths. Number of Booths Constructed Bins Cutoffs Outputs Number of Cars Processed in 1 minute per booth 0_12 0 Number of Cars Processed in 1 minute total .12 49 0.12 49..80 0.49 29 8.94 0.8 94 1 0.94 34 9 Minutes New Arrivals Total Cars Departures Back-up Back up Number of Backup Cars 10 30 Minutes Screenshots from Microsoft@ Excel@. Used by permission of Microsoft Corporation

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

Entropy And Diversity The Axiomatic Approach

Authors: Tom Leinster

1st Edition

1108962173, 9781108962179

More Books

Students also viewed these Mathematics questions