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




Custom Search