Calculating frequency
 

Spinner is spun 100 times, what is the frequency of spins that land in each
100 regions? (Each rang should be in color) how can I make that in Excel
please?
One more thing,
How to make spreadsheet that compares two fractions?

Calculating frequency
 

In A1, enter

=RANDBETWEEN(1,UpperLimit)

where upperlimit is the count of your regions.

Then copy down for as many rows as you have "number of spins"

Then in another column, say C2:C...., type 1, 2, 3, 4,....UpperLimit, and next to this column, use
the formula

=COUNTIF(A:A,C2)

and copy down to get a count.

Everytime you recalc, the numbers will change.

HTH,
Bernie
MS Excel MVP


"ghost" wrote in message
...
Spinner is spun 100 times, what is the frequency of spins that land in each
100 regions? (Each rang should be in color) how can I make that in Excel
please?
One more thing,
How to make spreadsheet that compares two fractions?

Calculating frequency
 

Thank you Bernie, But there is an error in the first
formula"=RANDBETWEEN(1,UpperLimit)"
I put it as =RANDBETWEEN(1,100) but does not work an shows me an error
please advice?


"Bernie Deitrick" wrote:

In A1, enter

=RANDBETWEEN(1,UpperLimit)

where upperlimit is the count of your regions.

Then copy down for as many rows as you have "number of spins"

Then in another column, say C2:C...., type 1, 2, 3, 4,....UpperLimit, and next to this column, use
the formula

=COUNTIF(A:A,C2)

and copy down to get a count.

Everytime you recalc, the numbers will change.

HTH,
Bernie
MS Excel MVP


"ghost" wrote in message
...
Spinner is spun 100 times, what is the frequency of spins that land in each
100 regions? (Each rang should be in color) how can I make that in Excel
please?
One more thing,
How to make spreadsheet that compares two fractions?

Calculating frequency
 

Tue, 12 Feb 2008 00:28:03 -0800 from ghost
:
Thank you Bernie, But there is an error in the first
formula"=RANDBETWEEN(1,UpperLimit)"
I put it as =RANDBETWEEN(1,100) but does not work an shows me an error
please advice?

From Excel help on RANDBETWEEN:

"If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in."

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?