Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On the OnlineReservations worksheet tab, in cell A5, use the Exponential cumulative probability distribution function to calculate the probability that the next online reservation will

On the OnlineReservations worksheet tab, in cell A5, use the Exponential cumulative probability distribution function to calculate the probability that the next online reservation will be made within two minutes.

AutoFill the function in A5 down through A34.

In cell D3, use the IFERROR, VLOOKUP, and RAND functions to estimate when the next online reservations will take place.

AutoFill the function in D3 down through D12 to estimate when the next 10 online reservations will take place.

In cell F2, create a formula that will calculate the probability of the next online reservation occurring within 12-20 minutes.

image text in transcribed

I just need help knowing what to type for the functions please.

SUM G H I J K L M N Online Reservations (in Minutes) 2 Mean 17.9 1 Next 10 Reservations Time (in minutes) Reservation next 12-20 minutes 4 Probability Minutes Online Reservations Reservation Revenue Documentation SUM G H I J K L M N Online Reservations (in Minutes) 2 Mean 17.9 1 Next 10 Reservations Time (in minutes) Reservation next 12-20 minutes 4 Probability Minutes Online Reservations Reservation Revenue Documentation

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

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

More Books

Students also viewed these Databases questions