Question

In: Statistics and Probability

Show me how it is done in Excel if possible: A store has one counter. The...

Show me how it is done in Excel if possible:

A store has one counter. The probability of inter-arrival time (in min) and service time (in min.) of customers are given in the following table.

Distribution of time between Arrival

Interarrival time(min)

Probability

Cumulative Probability

Random Digit

Assignment

1

0.13

2

0.15

3

0.03

4

0.17

5

0.06

6

0.14

7

0.15

8

0.09

9

0.19

10

0.08

Distribution of Service-Time

Service Time(min)

Probability

Cumulative Probability

Random Digit

Assignment

1

0.05

2

0.10

3

0.20

4

0.30

5

0.25

6

0.10

Solutions

Expert Solution

The table for interarrival time is as follows

THe cumulative Probability is obtained by just summing the Proababilities till that value

For example cumulative probability of Interval time 2 mins = 0.13 + 0.15 = 0.28

For example cumulative probability of Interval time 3 mins = 0.13 + 0.15 + 0.03 = 0.31

Likewise the other values are calculated and shown in the above image

For random digit assignment, the steps are as follows

Step 1 : In the cell G5, type the formula =RAND()

Step 2 : Drag the formula from G5 to G14. Now we will have random decimal numbers in cells G5 to G14

Step 3: Now go to Cell F5. Type the formula  =RANK.EQ(G5,$G$5:$G$14)

Step 2 : Drag the formula from F5 to F14. Now we will have random digits assigned in cells F5 to F14

We combine the RAND() and RANK.EQ() formulas to ge tthe random digits

The table for service time is as follows

The cumulative Probability is obtained by just summing the Proababilities till that value

For example cumulative probability of service time 2 mins = 0.05 + 0.1 = 0.15

For example cumulative probability of Interval time 3 mins = 0.05 + 0.1 + 0.2 = 0.35

Likewise the other values are calculated and shown in the above image

For random digit assignment, the steps are as follows

Step 1 : In the cell G5, type the formula =RAND()

Step 2 : Drag the formula from G5 to G10. Now we will have random decimal numbers in cells G5 to G10

Step 3: Now go to Cell F5. Type the formula  =RANK.EQ(G5,$G$5:$G$10)

Step 2 : Drag the formula from F5 to F10. Now we will have random digits assigned in cells F5 to F10

We combine the RAND() and RANK.EQ() formulas to ge tthe random digits


Related Solutions

Please show me how to do the following in excel. An additional "show formulas" would also...
Please show me how to do the following in excel. An additional "show formulas" would also be helpful. NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates that new project will require $7,500 in inventory, and result in a $7,500 increase in accounts receivable and a $5,000 increase in accounts payable. The latter...
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
In a grocery store, there is one cashier counter. Customers arrive at the cashier counter according...
In a grocery store, there is one cashier counter. Customers arrive at the cashier counter according to a Poisson process. The arrival rate is 30 customers per hour. The service time is exponentially distributed. The mean service time is 1 minute 30 seconds. What is the expected waiting time?
Please show how it would be done on EXCEL gilmore, Inc., just paid a dividend of...
Please show how it would be done on EXCEL gilmore, Inc., just paid a dividend of $2.35 per share on its stock. The dividends are expected to grow at a constant rate of 4.1 percent per year, indefinitely. If investors require a return of 10.4 percent on this stock. What is the current price? What will the price be in three years? and in fifteen years?
Hello! Can you show me how to this problem by hand? No Excel please! An organization...
Hello! Can you show me how to this problem by hand? No Excel please! An organization is considering the purchase of new machines to automatically conduct some quality control tasks. The machines are expected to save production cost which is given below as Annual Income. The machines are expected to be part of the production process for 5 years. The company has a minimum attractive rate of return (MARR) of 5.4%. The following data is available for these new machines:...
please show me how to do this using excel and its functions A proposed overseas expansion...
please show me how to do this using excel and its functions A proposed overseas expansion has the following cash flows:             Year                                                    Cash Flow                 0                                                           -$200         1 50     2    60           3 70                    4                                                    200 Calculate the payback, the internal rate of return, the NPV, the profitability index, and the modified IRR at a cost of capital of 10%.
Please show me how to do this by using excel and its functions Mrs. Dawn Chorus,...
Please show me how to do this by using excel and its functions Mrs. Dawn Chorus, founder and president of United Bird Seed, is wondering whether the company should make its first public sale of common stock and, if so, at what price. The company’s financial plan suggests rapid growth over the next three years but only moderate growth afterwards. Forecasted dividends per share are as follows: Year                1                      2                      3                      4                      5                        $1.00            $1.20             $1.44  ...
Can you show me how to use Excel to do the calculations? Sam Strother and Shawna...
Can you show me how to use Excel to do the calculations? Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Insurance Company and co-directors of the company’s pension fund management division. An important new client, the North-Western Municipal Alliance, has requested that Mutual of Seattle present an investment seminar to the mayors of the represented cities, and Strother and Tibbs, who will make the actual presentation, have asked you to help them by answering the following...
Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes...
Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes snowplowing equipment. The company buys the engines from a 3rd party vendor – Marshall Engines. Astro Winter has the following production schedule for February, March, April, and May: February – 60; March – 85; April 100; May – 120. Marshall Engines makes and delivers the products to Astro Winter during the month the engines are due. Marshall Engines can only manufacture 40 engines in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT