writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 18:
Line 18: − x pr+ − + − 1 0.5+ − 2 0.2+ − + − + − x pr+ − + − 2 0.2+ − 3 0.1+ − 4 0.5+ − + − + − x pr+ − + − 1 0.7+ − 2 0.1+ − + + + + + + + + + + + + + + + + + + + + + + + + + + +
→Examples
==Examples==
==Examples==
1.
0 0.3
{| class="wikitable"
|+Spreadsheet
|-
=PROB(A2:A4,B2:B4,1) = 0.5
! !! A !! B !! C !! D!! E
=PROB(A2:A4,B2:B4,1,3) = 0.7
|-
! 1
1 0.2
| 0 || 1 || 2
|-
! 2
| 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
=PROB(A1:C1,A2:C2,1,3) = 0.7
0 0.3
2.
{| 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==