[Iq75]

[ QUOTE ]
For those working in BB/100 and Pokertracker:

A1: Hands
B1: Hand Count from PT
A2: EV/100
B2: BB/100 from PT
A3: SD/100
B3: SD/100 from PT session tab, 'more detail' button.
A4: Confidence Interval
B4: an integer between 0-99 (note: Homer originally used 0-.99)
A5: Upper Bound
B5: =B2-NORMSINV((100-B4)/200)*B3*(1/SQRT(B1/100))
A6: Lower Bound
B6: =B2+NORMSINV((100-B4)/200)*B3*(1/SQRT(B1/100))

[/ QUOTE ]

for the Finns:

B5 =B2-NORM.JAKAUMA.NORMIT.KÄÄNT((100-B4)/200)*B3*(1/NELIÖJUURI(B1/100))

B6 =B2+NORM.JAKAUMA.NORMIT.KÄÄNT((100-B4)/200)*B3*(1/NELIÖJUURI(B1/100))