How can I modify the coin-simulation code and charting to allow tossing of two coints to account for four possibilities: H-H,H-T,T-H, and T-T.
How can I modify the coin-simulation code and charting to allow tossing of two coints to account for four possibilities: H-H,H-T,T-H, and T-T.
Last edited by mmart001; 08-10-2011 at 10:21 PM.
I changed the sheet, now you put the number of COINS to toss in F1, then click away.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
The macro you wrote tosses 4 coins and gives the total number of heads or tails
my problem is that I need to figure out to toss 2 coins and find the number of HH,HT,TH,TT, and then make a chart. so that the chart will have 4 bars corresponding to the respective cases. thank -
Like so...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks