Microsoft Office Tutorials and References

In Depth Information

cumulative probabilities for a Poisson distribution with an average arrival rate of

4 (cell D5 value). Thus, the arithmetic
difference
between successive probability

values represents the probability of obtaining a speciļ¬c value. For example, the dif-

ference between 0.0183156 and 0.0915782 is 0.0732626, the probability of exactly

1 arrival for the Poisson distribution with an average arrival rate of 4 per unit of

time. Similarly, the difference between 0 and 0.0183156 is 0.0183156, which is the

probability of an outcome of exactly 0 arrivals. The numbers in cell F7 to F19 are

the number of arrivals that will be returned by a lookup process of random sam-

pling. Next we will discuss the details of the process of sampling through the use of

lookup functions.

8.3.4 VLOOKUP and HLOOKUP Functions

To demonstrate how we can use the table to sample the number of random arrivals

in a time period, let us turn our attention to cells E22 and E24 in Exhibit 8.10. These

two cells form the heart of the sampling process and rely on the
vertical
lookup func-

tion,
VLOOKUP(value_lookup, table_array, col_index_num)
. To understand the use

of the
VLOOKUP
and its closely related partner,
HLOOKUP
(horizontal lookup),

we introduce Exhibit 8.11.

Exhibit 8.11
VLOOKUP and HLOOKUP example

Search JabSto ::

Custom Search