стр. 39 |

Figure 126: Exponential Cumulative Density Function (CDF)

EXPONDIST (0.2, 10, TRUE) equals 0.864665 while EXPONDIST (0.2, 10,

FALSE) equals 1.353353

Further detail is beyond the scope of this book.

136

Chapter 7: Probabiity Density Functions & Confidence Intervals

7.7.D FISHER DENSITY FUNCTION

This topic is beyond the scope of this book.

7.7.E POISSON DENSITY FUNCTION

This Density Function is used for predicting the number of events вЂ˜XвЂ™

occurring over a specific time.

PDF:

POISSON (x, expected value, false) probability of values taking the value X

CDF:

POISSON (x, expected value, true) probability of values lying to the left of X

Further detail is beyond the scope of this book.

7.7.F WEIBULL DENSITY FUNCTION

PDF:

WEIBULL (x, a, b, false) probability of values taking the value X

CDF:

WEIBULL (x, a, b, true) probability of values lying to the left of X

Further detail is beyond the scope of this book.

137

Statistical Analysis with Excel

7.7.G DISCRETE PROBABILITIESвЂ” BINOMIAL, HYPERGEOMETRIC &

NEGATIVE BINOMIAL

This topic is beyond the scope and aim of this book.

Binomial Density Function

This function is used to ascertain the probability of obtaining a вЂњheadвЂќ in a

coin toss. X can take only two discrete values. Further detail is beyond

the scope of this book.

Hypergeometric Density Function

The Density Function captures event probabilities in problems of

sampling without replacement. The sample is taken from a discrete finite

population like a deck of cards. Further detail is beyond the scope of this

book.

Negative Binomial

This function measures the probability of вЂњnumber of coin tosses before

first or Kth heads (in a coin toss).вЂќ

138

Chapter 7: Probabiity Density Functions & Confidence Intervals

LIST OF DENSITY FUNCTION

7.8

Table 25: PDF and CDF functions

Information

Is there a required by Other information requirements

function that all functions

Is there an

does the

option to

Degrees of freedom

Value (s)

converse of

request the

Function

for which

this mapping

cumulative

Std Dev

the

and, if so, the

стр. 39 |