A Discreet Distribution is a distribution constructed from a random variable produced by non-negative whole numbers. MEAN or AVERAGE is nothing but Expected Value of a Discreet Distribution.
The MEAN of any discreet distribution is calculated by taking the sum of product of values and their probability of occurrence.In the below example, number of Diabetics out of 5 people chosen randomly and probability of number of Diabetics in the sample.
MEAN of this discreet distribution is calculated using inbuilt function SUMPRODUCT as shown below. SUMPRODUCT takes two arguments, ARRAY1 and ARRAY2.
"=SUMPRODUCT(C2:C8,D2:D8)"
The mean or the expected value of the above discreet distribution is 1.14.
0 comments:
Post a Comment