Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Probabilty - Binomial - a simulation game?
Hello,
Life has presented me with an opportunity to teach some math to children/young adults with challenging backgrounds. Many have come a long way and want to pursue more challenging material. I want to teach them more about probability and want to design an Excel simulation. My idea was to get them to work out how variables altered probability. Specifically I am looking for help to develop a game where students would alter variables "probability" (expressed as a ratio or percentage) of picking a colored ball from a bag. So if they said there were three red balls, 4 blue, six white etc. the simulation would calculate the probability of each ball. And I'd like to show them the impact of selecting "out" or "in" where "out" is keeping the ball (and all others selected) out of the bag for subsequent turns and "in" is putting the ball back in the bag. Then a random generator would be used to "pick" the next ball and excel would display a cell of the matching ball color. I then want excel to show some statistics like comparison of theoretical probability to outcome (to show sample size variance), the number of times in a row a particular ball was drawn (as in a streak). I know the math but am a baby beginner at Excel programming. It looks like from the help that a Binomial distribution is the function with a rounded random function for selection. Am I on the right track? Any ideas on "out" and "in"? Thanks very much for your help Rob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Probabilty - Binomial - a simulation game?
Sorry, "feathers" are sometimes also known as "the features"
vandenberg p wrote: : Hello: : I think I have a little model of what you wanted. It is not complete, : it does not have all feathers that you mentioned. But it should : give you a start. Here is the file: : ftp://rohan.sdsu.edu/faculty/vandenberg/Game.zip : When you try to use it, your macro security will probably complain. : You will need to allow the macros to execute. : Pieter Vandenberg : Rob Eyes <Rob wrote: : : Hello, : : Life has presented me with an opportunity to teach some math to : : children/young adults with challenging backgrounds. Many have come a long way : : and want to pursue more challenging material. I want to teach them more about : : probability and want to design an Excel simulation. My idea was to get them : : to work out how variables altered probability. : : Specifically I am looking for help to develop a game where students would : : alter variables "probability" (expressed as a ratio or percentage) of picking : : a colored ball from a bag. So if they said there were three red balls, 4 : : blue, six white etc. the simulation would calculate the probability of each : : ball. And I'd like to show them the impact of selecting "out" or "in" where : : "out" is keeping the ball (and all others selected) out of the bag for : : subsequent turns and "in" is putting the ball back in the bag. Then a random : : generator would be used to "pick" the next ball and excel would display a : : cell of the matching ball color. I then want excel to show some statistics : : like comparison of theoretical probability to outcome (to show sample size : : variance), the number of times in a row a particular ball was drawn (as in a : : streak). : : I know the math but am a baby beginner at Excel programming. It looks like : : from the help that a Binomial distribution is the function with a rounded : : random function for selection. Am I on the right track? Any ideas on "out" : : and "in"? : : Thanks very much for your help : : Rob |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Probabilty - Binomial - a simulation game?
Pieter, that is extremely generous of you. Thanks you so VERY much!
"vandenberg p" wrote: Hello: I think I have a little model of what you wanted. It is not complete, it does not have all feathers that you mentioned. But it should give you a start. Here is the file: ftp://rohan.sdsu.edu/faculty/vandenberg/Game.zip When you try to use it, your macro security will probably complain. You will need to allow the macros to execute. Pieter Vandenberg Rob Eyes <Rob wrote: : Hello, : Life has presented me with an opportunity to teach some math to : children/young adults with challenging backgrounds. Many have come a long way : and want to pursue more challenging material. I want to teach them more about : probability and want to design an Excel simulation. My idea was to get them : to work out how variables altered probability. : Specifically I am looking for help to develop a game where students would : alter variables "probability" (expressed as a ratio or percentage) of picking : a colored ball from a bag. So if they said there were three red balls, 4 : blue, six white etc. the simulation would calculate the probability of each : ball. And I'd like to show them the impact of selecting "out" or "in" where : "out" is keeping the ball (and all others selected) out of the bag for : subsequent turns and "in" is putting the ball back in the bag. Then a random : generator would be used to "pick" the next ball and excel would display a : cell of the matching ball color. I then want excel to show some statistics : like comparison of theoretical probability to outcome (to show sample size : variance), the number of times in a row a particular ball was drawn (as in a : streak). : I know the math but am a baby beginner at Excel programming. It looks like : from the help that a Binomial distribution is the function with a rounded : random function for selection. Am I on the right track? Any ideas on "out" : and "in"? : Thanks very much for your help : Rob |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Probabilty - Binomial - a simulation game?
Rob:
Hope it works for you. Post back if you have any further questions. Pieter Vandenberg Rob Eyes wrote: : Pieter, that is extremely generous of you. Thanks you so VERY much! : "vandenberg p" wrote: : Hello: : : I think I have a little model of what you wanted. It is not complete, : it does not have all feathers that you mentioned. But it should : give you a start. Here is the file: : : ftp://rohan.sdsu.edu/faculty/vandenberg/Game.zip : : When you try to use it, your macro security will probably complain. : You will need to allow the macros to execute. : : Pieter Vandenberg : : : Rob Eyes <Rob wrote: : : Hello, : : Life has presented me with an opportunity to teach some math to : : children/young adults with challenging backgrounds. Many have come a long way : : and want to pursue more challenging material. I want to teach them more about : : probability and want to design an Excel simulation. My idea was to get them : : to work out how variables altered probability. : : : Specifically I am looking for help to develop a game where students would : : alter variables "probability" (expressed as a ratio or percentage) of picking : : a colored ball from a bag. So if they said there were three red balls, 4 : : blue, six white etc. the simulation would calculate the probability of each : : ball. And I'd like to show them the impact of selecting "out" or "in" where : : "out" is keeping the ball (and all others selected) out of the bag for : : subsequent turns and "in" is putting the ball back in the bag. Then a random : : generator would be used to "pick" the next ball and excel would display a : : cell of the matching ball color. I then want excel to show some statistics : : like comparison of theoretical probability to outcome (to show sample size : : variance), the number of times in a row a particular ball was drawn (as in a : : streak). : : : I know the math but am a baby beginner at Excel programming. It looks like : : from the help that a Binomial distribution is the function with a rounded : : random function for selection. Am I on the right track? Any ideas on "out" : : and "in"? : : : Thanks very much for your help : : : Rob : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IFMAX Formula | Excel Worksheet Functions | |||
Game in Excel | Excel Discussion (Misc queries) | |||
Game score without game being played | Excel Worksheet Functions | |||
any game in excel 2003 | Excel Discussion (Misc queries) |