This is a long shot and totally useless except for me, but...

Does anyone know how I can produce a Std. Deviation graph in excel that references data from all my sessions I've previously entered in a chart?

I would just love to see what graph looks like. It sorts of leads on from this post...

Side,

Not sure exactly what you are trying to do here. If you took the Standard Deviation of say your winnings for a month, its one number. You need lots of numbers to plot a chart or graph.

In Excel, you calculate standard deviatino using the "StDev" function.

Trodgers,

I've got all the formulas sorted in excel that calculate my std. deviation.

I was just wondering if there is a graph in excel that could take all my session data, and have dollars won/loss along the x axis and the frequency along the y axis. Then I could have my own trademark Std. Deviation graph. I would just love to see how my graph would look like.

Would it be the perfect bell curve, or would it be a tall, squished one if my variance was low. Or a long, shallow one, if my variance was high.

p.s. I just found a Micro$oft article that shows you how to create one from random data. Now I've just gotta figure out how to do it with my data

You might look at the pokertracker forum website. There is a free product called PokerGrapher (from Vern I think). It does what you are saying and I think you can export it to excel too.

TR

Trodgers,

I've got Vern's PokerGrapher tool, and fantastic it is too.

But I'm gonna continue ploughing on with trying to reproduce my std. dev. graph.

Cheers,

SS

Trodgers,

I finally got what I wanted.

Here's my $0.02 NL Standard Deviation in all it's glory...



At least it's positive...............just!

SS

p.s. You might have trouble viewing the image, it's a free web host site and they're a pain in the ass. Try right-clicking on image and select VIEW IMAGE.