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