Question
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. |
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
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