Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Create an x-axis based on number of occurences

3 views
Skip to first unread message

Christopher M.

unread,
Apr 9, 2012, 7:17:40 PM4/9/12
to
I have a list of prices for condos.

Instead of having an x-axis with an typical increment of $25K I'd like to
have a scale that reflects the number of condos that have a particular
price.

For instance if most of the condos are between 200K and 400K I might have a
scale like:

<=100K 200K 225K 250K 275k >=300K

How could I compute a scale like this? Thanks.


W. Pooh (AKA Winnie P.)


Ray Koopman

unread,
Apr 10, 2012, 11:39:58 AM4/10/12
to
List the prices in order (lowest to highest), then pick cutpoints so
that the number and size of the resulting groups suit your purposes.

Christopher M.

unread,
Apr 10, 2012, 1:21:23 PM4/10/12
to

"Ray Koopman" <koo...@sfu.ca> wrote in message
news:9c557396-baca-4bbb...@f27g2000yqc.googlegroups.com...
Kind of like a bunch of medians, I guess.

Thanks. Math is some powerful stuff.

Odysseus

unread,
Apr 10, 2012, 10:25:11 PM4/10/12
to
In article
<9c557396-baca-4bbb...@f27g2000yqc.googlegroups.com>,
Another approach that might be useful -- depending on the distribution
of the data set and what you're doing with it -- is to base the size of
the bins on a function of difference from the mean, perhaps a
logarithmic one.

--
Odysseus

Christopher M.

unread,
Apr 13, 2012, 5:08:51 PM4/13/12
to

"Odysseus" <odysseu...@yahoo-dot.ca> wrote in message
news:odysseus1479-at-F8...@news.eternal-september.org...
I used linear regression to find a function.
0 new messages