Microsoft Office Tutorials and References
In Depth Information
Is the number of successes in the sample; s in the equation.
Is the size of the sample; n in the equation.
Is the number of successes in the population; M in the equation.
Is the population size; N in the equation.
The equation for the hypergeometric distribution function is
The result in this
example is a 30%
probability that one of
the cards is an Ace.
INTERCEPT calculates the point at which a line will intersect the y-axis by using existing
x-values and y-values.
The INTERCEPT function will tell you the value of y when x is zero. Figure 11.22 shows an
The known values for the known data points; the dependent variable.
The known data points. If increments of time (years, quarters, months),
convert or substitute consecutive integers. The independent variable.