Question

In: Math

****NEED TO KNOW HOW PROBLEM IS SET UP IN EXCEL*** During the period of time that...

  1. ****NEED TO KNOW HOW PROBLEM IS SET UP IN EXCEL***
  2. During the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes.
    1. Clearly state what the random variable in this problem is?
    2. What is an appropriate distribution to be used for this problem and why?
    3. What is the expected number of calls in one hour?
    4. What is the probability of receiving three calls in five minutes?
    5. What is the probability of receiving NO calls in a 10-minute period?
    6. What is the probability of receiving more than five calls in a 10-minute period?
    7. What is the probability of receiving less than seven calls in 15-minutes?
    8. What is the probability of receiving at least three but no more than 10 calls in 12 minutes?

Solutions

Expert Solution

a) =1 per two minute

b) poisson distribution is appropriate

P(x; μ) = (e) (μx) / x!

c) the expected number of occurence in one hour is the mean of two minutes multiplied by the number of period of 2 minutes

= 1*30=30

d)

the expected number of occurence in five minute is the mean of two minutes multiplied by the number of period of 2 minutes

= 1*2.5 = 2.5

evaluate the formula for x=3 and = 2.5

P(x; μ) = (e) (μx) / x!

P(3; 2.5) = (e-2.5) (2.53) / 3!

0.2138

e)

the expected number of occurence in ten minute is the mean of two minutes multiplied by the number of period of 2 minutes

= 1*5 = 5

evaluate the formula for x=0 and = 5

P(x; μ) = (e) (μx) / x!

P(0; 5) = (e-5) (50) / 0!

0.0067

f)

the expected number of occurence in ten minute is the mean of two minutes multiplied by the number of period of 2 minutes

= 1*5 = 5

evaluate the formula for x=5 and = 5

P(x; μ) = (e) (μx) / x!

P(0; 5) = 1-(e-5) (55) / 5!

0.8255

g)

the expected number of occurence in 15 minute is the mean of two minutes multiplied by the number of period of 2 minutes

= 1*7.5 = 7.5

evaluate the formula for x=7 and = 7.5

P(x; μ) = (e) (μx) / x!

P(0; 5) = (e-7.5) (7.57) / 7!

0.1456


Related Solutions

I need to know how to figure this problem by doing in excel. Hypertensive Status by...
I need to know how to figure this problem by doing in excel. Hypertensive Status by Clinical Trial Site--Observed: Site Hypertensive 1 2 3 Yes 17 23 35 No 83 77 65 Question: Data from 300 patients recruited for a clinical trial. The trial recruited patients from three different sites. Use this data to determine if there is a difference in the number of hypertensive patients across clinical sites. Interpret your results. Is the p-value calculated significant?
Need Instructions on how to complete with EXCEL.... Handwritten answer not adequate, need to know how...
Need Instructions on how to complete with EXCEL.... Handwritten answer not adequate, need to know how EXCEL can be used to solve this problem.... A process is in control and centered at nominal. Output from the process is normally distributed and the process capability index, Cp, equals 1.02. Determine the expected number of nonconforming units that will result from a production run of 20,000 units. Assume that all previously stated conditions regarding the process remain as described during the production...
Chapter 2 Mastery Problem The T – Accounts are set up for you in the excel...
Chapter 2 Mastery Problem The T – Accounts are set up for you in the excel spreadsheet. Hassan Rahim won a concession to rent bicycles in the local park during the summer. During the month of June, Hassan completed the following transactions for his bicycle rental business: Chart of Accounts Cash Hassan Rahim Capital Accounts Receivable Hassan Rahim, Withdrawals Supplies Rental Income Shed Wages Expense Bicycles Maintenance Expense Accounts Payable Repair Expense Concession Fee Expense June 2 Began business by...
Budgeting allows for a company to set parameters for operations during a specific time period. There...
Budgeting allows for a company to set parameters for operations during a specific time period. There are many uses for a budget within a company or department. Provide examples of how a budget might be used in business and how decision making is affected by the use of a budget.
**I need to know how to do it by had without a financial calculator or excel....
**I need to know how to do it by had without a financial calculator or excel. Unsure of what formula to use.** If a 4-year bond with a 7% coupon and a 10% yield to maturity is currently worth $904.90, how much will it be worth 1 year from now if interest rates are constant? A)$947.93 B) $925.39 C) $904.90 D)$1,000.00
I need to know how to do this IN EXCEL, please! Dennis wants to determine if...
I need to know how to do this IN EXCEL, please! Dennis wants to determine if the discount rate really makes any difference in the net present value of a project. He feels that if a project is acceptable at one rate of return, it will be acceptable at all rates of return. To explain why his thinking is incorrect, you are creating an example to illustrate your point. The cash flows you are using are as follows: time zero...
I know this is a long problem but I couldn't break it up because you need...
I know this is a long problem but I couldn't break it up because you need all the information. But it is only counted as one question on my homework. Fuming because you are stuck in traffic? Roadway congestion is a costly item, both in time wasted and fuel wasted. Let x represent the average annual hours per person spent in traffic delays and let y represent the average annual gallons of fuel wasted per person in traffic delays. A...
Unsure how to set this up properly in excel? Assignment #6 The Nimble Digits Division of...
Unsure how to set this up properly in excel? Assignment #6 The Nimble Digits Division of Block C Enterprises manufactures computer furniture and accessories.At the present time 15 different components are being produced.Each product is some combination of steel, plastic, wood, aluminum and formica.The availability of these component materials is 980 pounds of steel alloy, 400 sq ft of plastic, 600 bd ft of wood, 2500 pounds of aluminum, 1800 bd ft of Formica and labor is limited to 1000...
Unsure how to set this up properly in excel? Assignment #6 The Nimble Digits Division of...
Unsure how to set this up properly in excel? Assignment #6 The Nimble Digits Division of Block C Enterprises manufactures computer furniture and accessories.At the present time 15 different components are being produced.Each product is some combination of steel, plastic, wood, aluminum and formica.The availability of these component materials is 980 pounds of steel alloy, 400 sq ft of plastic, 600 bd ft of wood, 2500 pounds of aluminum, 1800 bd ft of Formica and labor is limited to 1000...
I need to know how to answer this question only in Excel. Please include instructions, screenshots,...
I need to know how to answer this question only in Excel. Please include instructions, screenshots, etc. in Excel which explain the process (formulas included). TropSun is a leading grower and distributer of fresh citrus products with three large citrus groves scattered around central Florida in the cities of Orlando, Eustis, and Winter Haven. TropSun currently has 275,000 bushels of citrus at the grove in Mt. Dora, 400,000 bushels at the groves in Eustis, and 300,000 bushels at the grove...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT