Reference no: EM131105996
You can easily generate random numbers in a spreadsheet that have an exponential distribution with a given mean. For example, to generate 200 such numbers from an exponential distribution with λ = 1/3, enter the formula = - 3*LN(RAND()) in cell A4 and copy it to the range A5:A203. Then select the A4:A203 range, choose the Copy command, and choose the Paste Special command with the Values option. (This freezes the random numbers, so that they don't change each time the spreadsheet recalculates.) Explore the properties of these numbers as follows.
a. Find the average of the 200 numbers with the AVERAGE function. What theoretical value should this average be close to?
b. Find the standard deviation of the 200 numbers with the STDEV function. What theoretical value should this standard deviation be close to?
c. Create a histogram of the random numbers, using about 15 categories, each of length 1, where the first category extends from 0 to 1. Does the histogram have the shape you would expect?
d. Suppose you collected the data in column A by timing arrivals at a store. The value in cell A4 is the time (in minutes) until the first arrival, the value in cell A5 is the time between the first and second arrivals, the value in cell A6 is the time between the second and third arrivals, and so on. How might you convince yourself that the interarrival times for this store are indeed exponentially distributed? What is your best guess for the arrival rate (customers per minute)?
|
What are the general rules for measuring and recognizing
: What are the general rules for measuring and recognizing gain or loss by both the debtor and the creditor in an impairment?
|
|
Do exponentially distributed random numbers
: Do exponentially distributed random numbers have the memoryless property? Here is one way to find out. Generate many exponentially distributed random numbers with mean 3, using the formula in the previous problem.
|
|
What component of this comes from combustion of octane
: Select a passenger car and calculate the efficiency of the vehicle in converting chemical energy from combustion into kinetic energy.
|
|
Particular type of skilled labor
: In the short run, a particular type of skilled labor is the only variable factor used by a firm. The manager of the firm has estimated that the marginal product of labor is given by MPL = a - b L, where a and b are numbers to be specified below.
|
|
Generate random numbers in a spreadsheet
: You can easily generate random numbers in a spreadsheet that have an exponential distribution with a given mean. For example, to generate 200 such numbers from an exponential distribution with λ = 1/3, enter the formula = - 3*LN(RAND()) in cell A4..
|
|
Annual growth rate would be less than 10%. true or false
: If a firm's earnings per share grew from $1 to $2 over a 10-year period, the total growth would be 100%, but the annual growth rate would be less than 10%. True or false? Explain.
|
|
Question regarding the total revenue from sales
: Currently, P = $15 and I = $25,000. Based on this information, if you decide to increase the price by 10%, your total revenue from sales will
|
|
The exponential distribution and a poisson process
: Explain the basic relationship between the exponential distribution and a Poisson process. Also, explain how the exponential distribution and the Poisson distribution are fundamentally different.
|
|
What type of concessions might a creditor grant
: What type of concessions might a creditor grant the debtor in a troubled-debt situation?
|