Question: Please help me with the formulas for the below: 1) In cell H2, use the Poisson cumulative probability distribution function to calculate the probability of

Please help me with the formulas for the below:

1) In cell H2, use the Poisson cumulative probability distribution function to calculate the probability of having 50 or fewer reservations.

2)In cells K3:K7 use the RAND function to generate five random probabilities

3)In cell L3 use the IFERROR and VLOOKUP functions to estimate the number of online reservations that will occur in each of the next five days.

Please help me with the formulas for the below:

126 A D F M H Probability Week 1 # of Reservations 99 K Estimated Reservations Random Reservations 2 1 2 2 3 4 5 6 Reservations 50 55 60 65 3 4 76 79 92 96 96 5 B Revenue $19,630.76 $21,374.15 $16,899.54 $16.244.54 $16,013.05 $9,738.56 $20,761.91 $18,817.44 $16,799.44 $16.534.88 $14,033.58 $12,854.07 70 C Moving Average #N/A #N/A $19,301.48 $18,172.74 $16,385.71 $13,998.72 $15,504.51 $16,439.30 $18,792.93 $17,383.92 $15,789.30 $14,474.18 6 7 7 8 9 75 80 85 90 107 78 92 84 109 7 8 9 10 11 12 13 14 15 16 17 18 19 E Date 1/6/2017 1/7/2017 1/8/2017 1/9/2017 1/10/2017 1/11/2017 1/12/2017 1/13/2017 1/14/2017 1/15/2017 1/16/2017 1/17/2017 1/18/2017 1/19/2017 1/20/2017 1/21/2017 1/22/2017 1/23/2017 1/24/2017 1/25/2017 1/26/2017 1/27/2017 10 11 12 81 83 97 96 95 100 105 110 115 120 125 130 135 140 145 150 99 80 95 20 21 22 87 80 104 93 23 24 25 Mean 91 26 27 Online Reservations Reservation Revenue Documentation 126 A D F M H Probability Week 1 # of Reservations 99 K Estimated Reservations Random Reservations 2 1 2 2 3 4 5 6 Reservations 50 55 60 65 3 4 76 79 92 96 96 5 B Revenue $19,630.76 $21,374.15 $16,899.54 $16.244.54 $16,013.05 $9,738.56 $20,761.91 $18,817.44 $16,799.44 $16.534.88 $14,033.58 $12,854.07 70 C Moving Average #N/A #N/A $19,301.48 $18,172.74 $16,385.71 $13,998.72 $15,504.51 $16,439.30 $18,792.93 $17,383.92 $15,789.30 $14,474.18 6 7 7 8 9 75 80 85 90 107 78 92 84 109 7 8 9 10 11 12 13 14 15 16 17 18 19 E Date 1/6/2017 1/7/2017 1/8/2017 1/9/2017 1/10/2017 1/11/2017 1/12/2017 1/13/2017 1/14/2017 1/15/2017 1/16/2017 1/17/2017 1/18/2017 1/19/2017 1/20/2017 1/21/2017 1/22/2017 1/23/2017 1/24/2017 1/25/2017 1/26/2017 1/27/2017 10 11 12 81 83 97 96 95 100 105 110 115 120 125 130 135 140 145 150 99 80 95 20 21 22 87 80 104 93 23 24 25 Mean 91 26 27 Online Reservations Reservation Revenue Documentation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1.1 Consider the regression results given in Table 1.2. (a) Suppose you want to test the hypothesis that the true or population regression coeffi cient of the education variable is 1. How would you...

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

please answer in excel thank you. Question Set 1. You are an inventory management consultant. You have been hired by Walmart to help optimize inventory management for their Dairy department. Your...

please show excel formulas! ternet can contain viruses. Unless you need to edit. It's safer to stay in Protected View. Enable Editing because your Office product is inactive. To use for free, sign in...

Questions Question Set 1. You are an inventory management consultant. You have been hired by Walmart to help optimize inventory management for their Dairy department. Your immediate task is building...

Please show excel formulas! Question Set 1. You are an inventory management consultant. You have been hired by Walmart to help optimize inventory management for their Dairy department. Your immediate...

Question Set 1. You are an inventory management consultant. You have been hired by Costco to help optimize inventory management for their Poultry department. Your immediate task is building a Monte...

Please solve all parts and provide excel formulas. Thank you in advance! Questions Question Set 1. You are an inventory management consultant. You have been hired by Walmart to help optimize...

Please show excel formulas Question Set 1. You are an inventory management consultant. You have been hired by Walmart to help optimize inventory management for their Dairy department. Your immediate...

please show excel formulas with all work given Question Set 1. You are an inventory management consultant. You have been hired by Walmart to help optimize inventory management for their Dairy...

Please include all formulas on excel and answer each question detailed. Will rate. Question Set 1. You are an inventory management consultant. You have been hired by Costco to help optimize inventory...

The Laplace transform function representing the output voltage of a network is expressed as, determine the value of vo(t) at t = 100ms. a. 0.64V b. 0.45V c. 0.33V d.0.24V V,(s) s(s + 10)(s + 20) 120

You, CPA, work as a consultant on various engagements. Your client, Over The Edge Ltd. (OTE), has grown from a small custom snowboard manufacturer servicing the local market to a multinational...

Expenses that are incurred in operating the enterprise increase owner's equity. Group of answer choices True False

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...