Difference between revisions of "Manuals/calci/HYPGEOMDIST"

From ZCubes Wiki
Jump to navigation Jump to search
 
(24 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''<div style="font-size:30px">'''HYPGEOMDIST(n1,n2,n3,n4)'''</div><br/>
+
<div style="font-size:20px">'''HYPGEOMDIST (sample_s,number_sample,population_s,number_population,cumulative)'''</div><br/>
*<math>n1</math> is the sample's success.
+
*<math>samples</math> is the sample's success.
*<math>n2</math> is the sample's size.
+
*<math>number sample</math> is the sample's size.
*<math>n3</math> is population's success
+
*<math>population s</math> is population's success.
*<math>n4</math> is the population size.
+
*<math>number population</math> is the population size.
 +
**HYPGEOMDIST(),returns the hypergeometric distribution.
 +
 
 
==Description==
 
==Description==
"This function gives the result of Hypergeometric distribution.
+
*This function gives the result of Hypergeometric Distribution.
This distribution  is a discrete probability distribution which is contrast to the binomial distribution.  
+
*This distribution  is a discrete probability distribution which is contrast to the binomial distribution.  
A hypergeometric random variable is the number of successes that result from a hypergeometric experiment.  
+
*A Hypergeometric random variable is the number of successes that result from a Hypergeometric experiment.  
The probability distribution of a hypergeometric random variable is called a hypergeometric distribution.
+
*The probability distribution of a Hypergeometric random variable is called a Hypergeometric Distribution.
In  HYPGEOMDIST(n1,n2,n3,n4) where n1 is thenumber of items in the Sample  that are classified as successes.  
+
*In  HYPGEOMDIST (sample_s,number_sample,population_s,number_population,cumulative) where samples is the number of items in the Sample  that are classified as successes.  
n2 is the total number of items in the sample.
+
*<math>number sample</math> is the total number of items in the sample.
n3 is thenumber of items in the population  that are classified as successes and n4 is the total number of items in the sample.  
+
*<math>populations</math> is the number of items in the population  that are classified as successes and <math>numberpopulation</math> is the total number of items in the sample.  
The following conditions are applied to the Hypergeometric distribution:  
+
*The following conditions are applied to the Hypergeometric distribution:  
1.This distribution is applies to sampling without replacement from a finite population whose elements can be classified into two categories like success or Failure.
+
1.This distribution is applies to sampling without replacement from a finite population whose elements can be
2.The population or set to be sampled consists of N individuals, objects,or elements  
+
classified into two categories like Success or Failure.
3.Each individual can be  success (S) or a failure (F),
+
2.The population or set to be sampled consists of N individuals, objects,or elements  
and there areM successes in the population.
+
3.Each individual can be  success (S) or a failure (F), and there are M successes in the population.
4. A sample of n individuals is selected without replacement in such a way that each subset of size n is equally likely to be chosen. The Hyper geometric probability distribution is:  
+
4.A sample of <math>n</math> individuals is selected without replacement in such a way that each subset of  
P(X=x)=h(x;n,M,N)=(M          (N-M
+
  size <math>n</math> is equally likely to be chosen.
                                    x)          n-x)        /(N   
+
*The Hyper geometric probability distribution is:
                                                                      n)  for x is an integer satisfying  max(0, n-N+M)<=x<=min(n,M). where x is sample's success.n is the sample's size.M is population's success and N is the population size. Here we can give any positive real numbers. Suppose we are assigning any decimals numbers it will change in to Integers. This function will give result as error when 1. Any one of the argument is nonnumeric.
+
<math>\frac{\binom{m}{x}  \binom{N-M}{n-x}}{\binom{m}{x}}</math>
2.n1<0 or n1 is greater than the smaller value of n2 or n3.
+
for <math>x</math> is an integer satisfying  <math>max(0, n-N+M)<=x<=min(n,M)</math>. where <math>x</math> is sample's success.
3.n1 is less than the bigger of 0 or(n2-n4+n3)
+
*<math>n</math> is the sample's size.
4. n2<=0 or n2>n4
+
*<math>M</math> is population's success and <math>N</math> is the population size.  
5.n3<=0 or  n3>n4 or n4<=0"
+
*Here we can give any positive real numbers.  
 +
*Suppose we are assigning any decimals numbers it will change in to Integers.  
 +
*This function will give result as error when  
 +
1.Any one of the argument is non-numeric.
 +
2.<math>samples < 0</math> or samples is greater than the smaller value of numbersample or populations.
 +
3.<math>samples</math> is less than the bigger of 0 or(numbersample-numberpopulation+populations)
 +
4.<math>numbersample \le 0</math> or <math>numbersample>numberpopulation</math>
 +
5.<math>populations \le 0</math> or  <math>populations>numberpopulation</math> or <math>numberpopulation \le 0</math>
 +
 
 +
==ZOS==
 +
*The syntax is to calculate HYPGEOMDIST in ZOS is <math>HYPGEOMDIST (sample s,number sample,population s,number population,cumulative)
 +
</math>
 +
**<math>sample s</math> is the sample's success.
 +
**<math>number sample</math> is the sample's size.
 +
**<math>population s</math> is population's success.
 +
**<math>number population</math> is the population size.
 +
*For e.g.,HYPGEOMDIST(2..3,6..7,9..10,20)
 +
 
 +
{{#ev:youtube|fui0xWgBO4g|280|center|Hyper-geometric Distribution}}
  
 
==Examples==
 
==Examples==
  
Draw 6 cards from a deck without replacement.
+
#Draw 6 cards from a deck without replacement.What is the probability of getting two hearts?
What is the probability of getting two hearts?
+
Here M = 13 number of hearts
Here M = 13 number of hearts
+
N = 52 total number of cards
N = 52 total number of cards
+
so N-M= 52-13= 39 and  
so N-M= 52-13= 39 and  
+
x=2,n=6 so n-x=6-2=4
x=2,n=6 so n-x=6-2=4
+
=HYPGEOMDIST(2,6,13,52)=0.315129882
HYPGEOMDIST(2,6,13,52)=0.315129882
+
#42 balls are numbered 1 - 42.You select six numbers between 1 and 42. What is the probability that they contain (i)match 3, (ii) match 4
2.42 balls are numbered 1 - 42.
+
(i)Here M= 6,N=42,x=3and n=6
You select six numbers between 1 and 42. What is the probability that they contain
+
HYPGEOMDIST(3,6,6,42)=0.02722185
(i)match 3?
+
(ii)Here M= 6,N=42,x=4and n=6
(ii) match 4?
+
HYPGEOMDIST(4,6,6,42)=0.001801446
(i)Here M= 6,N=42,x=3and n=6
+
 
HYPGEOMDIST(3,6,6,42)=0.02722185
+
==Related Videos==
(ii)Here M= 6,N=42,x=4and n=6
+
 
HYPGEOMDIST(4,6,6,42)=0.001801446
+
{{#ev:youtube|NMeVWPdo7e4|280|center|Hyper-Geometric Distribution}}
3.
 
  
 
==See Also==
 
==See Also==
Line 49: Line 68:
 
*[[Manuals/calci/COMBIN  | COMBIN ]]
 
*[[Manuals/calci/COMBIN  | COMBIN ]]
 
*[[Manuals/calci/FACT  | FACT ]]
 
*[[Manuals/calci/FACT  | FACT ]]
 
  
 
==References==
 
==References==
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient| Correlation]
+
[http://en.wikipedia.org/wiki/Hypergeometric_distribution| Hypergeometric Distribution]
(ar1,ar2)'''</div><br/>
 
*<math>ar1</math> and <math>ar2 </math> are the set of values.
 
==Description==
 
*This function gives the correlation coefficient of the 1st set(<math>ar1</math>) of values and 2nd set(<math>ar2</math>) of values.
 
*Correlation is a statistical technique which shows the relation of strongly paired variables. 
 
*For example, test average and study time are related; those who spending more time to study will get high marks and Average will go down for those who spend less time for studies.
 
*There are  different correlation techniques to measure the Degree of Correlation.
 
*The most common of these is the Pearson Correlation Coefficient  denoted by <math>r_xy</math>.
 
*The main result of a correlation is called the Correlation Coefficient(<math>r</math>)which  ranges from -1 to +1.
 
*The <math>r</math> value is positive i.e +1  when the two set values increase together then it is the perfect Positive Correlation.
 
*The <math>r</math> value is negative i.e. (-1)  when one value decreases as the other increases then it is called Negative Correlation.
 
*Suppose the <math>r</math> value is 0 then there is no correlation (the values don't seem linked at all).
 
*If we have a series of <math>n</math> measurements of <math>X</math> and <math>Y</math> written as <math>xi</math> and <math>yi</math> where <math>i = 1, 2,...n</math> then the Sample Correlation Coefficient is:
 
<math>CORREL(X,Y)= r_{xy}= \frac{\sum_{i=1}^n (xi-\bar x)(yi-\bar y)}{\sqrt{ \sum_{i=1}^n (xi-\bar x)^2 \sum{i=1}^n (yi-\bar y)^2}}</math>
 
*<math>\bar x</math> and <math>\bar y</math> are the sample means of <math>X</math> and <math>Y</math>.
 
*This function will give the result as error when
 
1.<math>ar1</math> and <math>ar2</math> are non-numeric or different number of data points.
 
2.<math>ar1</math> or <math>ar2</math> is empty
 
3.The denominator value is zero.
 
*Suppose <math>ar1</math> and <math>ar2</math> contains any text, logical values, or empty cells, like that values are ignored.
 
  
==Examples==
 
  
#Find the correlation coefficients for X and Y values are given below :X={1,2,3,4,5};  Y={11,22,34,43,56}
 
=CORREL(A4:A8,B4:B8)=0.99890610723867
 
#The following table gives the math scores and times taken to run 100 m for 10 friends:SCORE(X)={52,25,35,90,76,40}; TIME TAKEN(Y)={11.3,12.9,11.9,10.2,11.1,12.5}
 
=CORREL(A5:A10,B5:B10)= -0.93626409417769
 
#Find the correlation coefficients for X and Y values are given below :X={-4,11,34,87};Y={9,2,59,24}
 
=CORREL(A1:A4,B1:B4)=0.353184665607273
 
  
==See Also==
+
*[[Z_API_Functions | List of Main Z Functions]]
*[[Manuals/calci/COVAR  | COVAR ]]
 
*[[Manuals/calci/FISHER  | FISHER ]]
 
  
 
+
*[[ Z3 |   Z3 home ]]
==References==
 
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient| Correlation]
 

Latest revision as of 17:19, 7 August 2018

HYPGEOMDIST (sample_s,number_sample,population_s,number_population,cumulative)


  • is the sample's success.
  • is the sample's size.
  • is population's success.
  • is the population size.
    • HYPGEOMDIST(),returns the hypergeometric distribution.

Description

  • This function gives the result of Hypergeometric Distribution.
  • This distribution is a discrete probability distribution which is contrast to the binomial distribution.
  • A Hypergeometric random variable is the number of successes that result from a Hypergeometric experiment.
  • The probability distribution of a Hypergeometric random variable is called a Hypergeometric Distribution.
  • In HYPGEOMDIST (sample_s,number_sample,population_s,number_population,cumulative) where samples is the number of items in the Sample that are classified as successes.
  • is the total number of items in the sample.
  • is the number of items in the population that are classified as successes and is the total number of items in the sample.
  • The following conditions are applied to the Hypergeometric distribution:
1.This distribution is applies to sampling without replacement from a finite population whose elements can be
classified into two categories like Success or Failure.
2.The population or set to be sampled consists of N individuals, objects,or elements 
3.Each individual can be  success (S) or a failure (F), and there are M successes in the population.
4.A sample of  individuals is selected without replacement in such a way that each subset of 
  size  is equally likely to be chosen.
  • The Hyper geometric probability distribution is:

for is an integer satisfying . where is sample's success.

  • is the sample's size.
  • is population's success and is the population size.
  • Here we can give any positive real numbers.
  • Suppose we are assigning any decimals numbers it will change in to Integers.
  • This function will give result as error when
1.Any one of the argument is non-numeric.
2. or samples is greater than the smaller value of numbersample or populations.
3. is less than the bigger of 0 or(numbersample-numberpopulation+populations)
4. or 
5. or   or 

ZOS

  • The syntax is to calculate HYPGEOMDIST in ZOS is
    • is the sample's success.
    • is the sample's size.
    • is population's success.
    • is the population size.
  • For e.g.,HYPGEOMDIST(2..3,6..7,9..10,20)
Hyper-geometric Distribution

Examples

  1. Draw 6 cards from a deck without replacement.What is the probability of getting two hearts?
Here M = 13 number of hearts
N = 52 total number of cards
so N-M= 52-13= 39 and 
x=2,n=6 so n-x=6-2=4
=HYPGEOMDIST(2,6,13,52)=0.315129882
  1. 42 balls are numbered 1 - 42.You select six numbers between 1 and 42. What is the probability that they contain (i)match 3, (ii) match 4
(i)Here M= 6,N=42,x=3and n=6
HYPGEOMDIST(3,6,6,42)=0.02722185
(ii)Here M= 6,N=42,x=4and n=6
HYPGEOMDIST(4,6,6,42)=0.001801446

Related Videos

Hyper-Geometric Distribution

See Also

References

Hypergeometric Distribution