I guess using the Poisson calculator is really difficult for some
You have to enter the actual number of Deuces that happened
In this case zero
Then you have to enter the expected number in this case 6.
you also have to click on the calculate button.
http://stattrek.com/Tables/Poisson.aspx
--- In vpFREE@yahoogroups.com, "bogus" <boguslumber@...> wrote:
>
>
>
> Here is a simple spreadsheet to do the calculation for you. Just copy everything below starting with <?xml.. into a text file (use notepad), save it with an xml extension and then open it in Excel.
>
> Change cell B1 with the desired cycle and change cell B4 with the # of hands.
>
>
> <?xml version="1.0"?>
> <?mso-application progid="Excel.Sheet"?>
> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
> xmlns:o="urn:schemas-microsoft-com:office:office"
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
> xmlns:html="http://www.w3.org/TR/REC-html40">
> <Styles>
> <Style ss:ID="Default" ss:Name="Normal">
> <Alignment ss:Vertical="Bottom"/>
> <Borders/>
> <Font/>
> <Interior/>
> <NumberFormat/>
> <Protection/>
> </Style>
> <Style ss:ID="s20" ss:Name="Percent">
> <NumberFormat ss:Format="0%"/>
> </Style>
> <Style ss:ID="s21">
> <NumberFormat ss:Format="0"/>
> </Style>
> <Style ss:ID="s23" ss:Parent="s20">
> <NumberFormat ss:Format="0.0%"/>
> </Style>
> <Style ss:ID="s24" ss:Parent="s20">
> <NumberFormat ss:Format="0.0"/>
> </Style>
> <Style ss:ID="s25">
> <NumberFormat ss:Format="0.0"/>
> </Style>
> </Styles>
> <Worksheet ss:Name="Sheet1">
> <Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="38" x:FullColumns="1"
> x:FullRows="1">
> <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="74.25"/>
> <Column ss:AutoFitWidth="0" ss:Width="93"/>
> <Column ss:AutoFitWidth="0" ss:Width="69.75"/>
> <Row>
> <Cell><Data ss:Type="String">Success</Data></Cell>
> <Cell ss:Formula="=1/4900"><Data ss:Type="Number">2.0408163265306123E-4</Data></Cell>
> </Row>
> <Row>
> <Cell><Data ss:Type="String">Failure</Data></Cell>
> <Cell ss:Formula="=1-R[-1]C"><Data ss:Type="Number">0.99979591836734694</Data></Cell>
> </Row>
> <Row ss:Index="4">
> <Cell><Data ss:Type="String">Hands</Data></Cell>
> <Cell ss:StyleID="s21"><Data ss:Type="Number">28710</Data></Cell>
> <Cell><Data ss:Type="String">Expected</Data></Cell>
> <Cell ss:StyleID="s25" ss:Formula="=RC[-2]*R[-3]C[-2]"><Data ss:Type="Number">5.8591836734693876</Data></Cell>
> </Row>
> <Row ss:Index="6">
> <Cell><Data ss:Type="String">Count</Data></Cell>
> <Cell><Data ss:Type="String">Prob</Data></Cell>
> <Cell><Data ss:Type="String"># of sessions</Data></Cell>
> </Row>
> <Row ss:Index="8">
> <Cell><Data ss:Type="Number">0</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">2.4090838124644128E-3</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">415.09556239848428</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">1</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">1.4118228768086261E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">70.830414808156632</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">2</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">4.136789260617383E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">24.173336783676476</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">3</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">8.0805364384450323E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">12.375416008796982</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">4</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">0.11837585364652689</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">8.4476687533424144</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">5</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">0.13872697388330812</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">7.2084034705547753</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">6</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">0.1354759878994817</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">7.3813818633451405</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">7</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">0.11339706676091074</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">8.8185702555113306</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">8</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">8.3048967539081767E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">12.041088885655478</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">9</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">5.4062858067577414E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">18.496987317060103</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">10</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">3.1673141629636768E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">31.57249166165106</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">11</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">1.6868461226656022E-2</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">59.282230107614772</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">12</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">8.2348576891336858E-3</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">121.43500686351277</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">13</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">3.7107311512557593E-3</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">269.48866927790959</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">14</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">1.5526124524969551E-3</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">644.0757308056958</Data></Cell>
> </Row>
> <Row>
> <Cell ss:Formula="=R[-1]C+1"><Data ss:Type="Number">15</Data></Cell>
> <Cell ss:StyleID="s23"
> ss:Formula="=R2C2^(R4C2-RC[-1])*R1C2^(RC[-1]) * COMBIN(R4C2,RC[-1])"><Data
> ss:Type="Number">6.0630099717937579E-4</Data></Cell>
> <Cell ss:StyleID="s24" ss:Formula="=1/RC[-1]"><Data ss:Type="Number">1649.3457946666501</Data></Cell>
> </Row>
> </Table>
> </Worksheet>
> </Workbook>
>
