Difference between revisions of "Manuals/calci/PROB"

From ZCubes Wiki
Jump to navigation Jump to search
Line 18: Line 18:
  
 
==Examples==
 
==Examples==
−
x        pr
+
1.
−
0       0.3
+
{| class="wikitable"
−
1      0.5
+
|+Spreadsheet
−
2      0.2
+
|-
−
=PROB(A2:A4,B2:B4,1) = 0.5
+
! !! A !! B !! C !! D!! E
−
=PROB(A2:A4,B2:B4,1,3) = 0.7
+
|-
−
x        pr
+
! 1
−
1         0.2
+
| 0 || 1 || 2
−
2        0.2
+
|-
−
3        0.1
+
! 2
−
4        0.5
+
| 0.3 || 0.5 || 0.2  
−
=PROB(C1:C4,D1:D4,2) = 0.2
+
|}
−
=PROB(C1:C4,D1:D4,2,4) = 0.8
+
=PROB(A1:C1,A2:C2,1) = 0.5
−
x    pr
+
=PROB(A1:C1,A2:C2,1,3) = 0.7
−
0   0.3
+
 
−
1    0.7
+
2.
−
2    0.1
+
{| class="wikitable"
−
=PROB(A1:A3,B1:B3,2) = NAN
+
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D
 +
|-
 +
! 1
 +
| 1 || 2 || 3 ||4
 +
|-
 +
! 2
 +
| 0.2 || 0.2 || 0.1 ||0.5  
 +
|}
 +
=PROB(A1:D1,A2:D2,2) = 0.2
 +
=PROB(A1:D1,A2:D2,2,4) = 0.8
 +
 
 +
3.
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D
 +
|-
 +
! 1
 +
| 0 || 1 || 2
 +
|-
 +
! 2
 +
| 0.3 || 0.7 || 0.1  
 +
|}
 +
 
 +
=PROB(A1:C1,A2:C2,2) = NAN
  
 
==See Also==
 
==See Also==

Revision as of 03:35, 22 January 2014

PROB(xr,pr,ll,ul)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle xr} is the array of x range of values in the function.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle pr} is the set of probabilities.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ll} is the lower limit
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ul} is the upper limit value.

Description

  • This function gives the probability that values in a range of given limits.
  • Probability is the likelihood that an event will occur.
  • Probabilities can be used to describe frequencies of outcomes in random experiments.
  • In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PROB(xr,pr,ll,ul)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle xr} is the array of numeric values which there are associated probabilities, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle pr} is a set of probabilities associated with Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle xr} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ll} is the lower limit of the probability and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ul} is the upper limit of the probability.
  • Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ul} is optional. When we are omitting the value of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ul} , then the function simply returns the probability associated with the value of the given Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ll} .
  • This function will return the result as error when
1.Any one of the value is non-numeric.
2.Any value of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle  pr \le 0 }
 or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle pr >1}

3.The values in the given Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle pr}
  do not adding  up to 1
4.Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle xr}
 and  is of different number of data points.

Examples

1.

Spreadsheet
A B C D E
1 0 1 2
2 0.3 0.5 0.2 
=PROB(A1:C1,A2:C2,1) = 0.5
=PROB(A1:C1,A2:C2,1,3) = 0.7

2.

Spreadsheet
A B C D
1 1 2 3 4
2 0.2 0.2 0.1 0.5 
=PROB(A1:D1,A2:D2,2) = 0.2
=PROB(A1:D1,A2:D2,2,4) = 0.8

3.

Spreadsheet
A B C D
1 0 1 2
2 0.3 0.7 0.1 
=PROB(A1:C1,A2:C2,2) = NAN

See Also

References

Probability

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/PROB&oldid=197389"