johnpdavey
Board Regular
- Joined
- May 30, 2002
- Messages
- 88
i would like to set up a spread sheet to show relative frequency and plot a graph of this tending to a limit.
my idea was to set up a list of random numbers 1 or 2, using rand between, to represent heads and tails.
i then want to extract the relative frequency of getting a 2 at say 10 events, 50 events, 100 events 200 events 500 events and plot the results on a graph, number of events along the x axis, relative frequency on the y axis, to show tendancy to 0.5.
i would like to be able to use the F9 key to show the students that as the numbers change the relative frequencies change but they still tend towards 0.5.
any suggestions as to how i can achieve this would be gratefully received.
ps i am not allowed to run any macros at school and we dont have easy access to the internet to be able to use any sites that have aplets of this activity
thanks in advance for your help
john
my idea was to set up a list of random numbers 1 or 2, using rand between, to represent heads and tails.
i then want to extract the relative frequency of getting a 2 at say 10 events, 50 events, 100 events 200 events 500 events and plot the results on a graph, number of events along the x axis, relative frequency on the y axis, to show tendancy to 0.5.
i would like to be able to use the F9 key to show the students that as the numbers change the relative frequencies change but they still tend towards 0.5.
any suggestions as to how i can achieve this would be gratefully received.
ps i am not allowed to run any macros at school and we dont have easy access to the internet to be able to use any sites that have aplets of this activity
thanks in advance for your help
john