Calculating frequency

G

ghost

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?
 
B

Bernie Deitrick

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
 
G

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?
 
S

Stan Brown

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?
Click to expand...

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?
 
Top