Using the Binomial Distribution function in excel

**Gadam** · 10-16-2008, 05:09 PM

WOW!!!!

Thank you so much for your help SHG, this looks awesome!

**shg** · 10-16-2008, 05:17 PM

Thought you'd died ...

To be clear, the posted code computes the probability of flipping (for the example) 7 more heads than tails.

The probability of flipping 7 heads before 9 tails would require changing the code -- you only need to simulate 16 flips total.

**Gadam** · 10-16-2008, 05:28 PM

err....

I've just realised that I don't really know what to do with this bit of code. Could someone enlighten me on how to apply it to a spreadsheet?

**shg** · 10-16-2008, 05:30 PM

1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

**Gadam** · 10-16-2008, 05:38 PM

Thanks a lot SHG. Without wanting to test your patience - how do I get it to perform the calculations for me now? I've followed the steps that you listed but now I'm back on a blank worksheet.

I've never used the VBA side of things before you see.

Once again - really appreciate your help mate. I can't thank you enough