# Desire Cumulative Frequency

1. ## Desire Cumulative Frequency

Dear all,
I have the chart with cumulative% frequency (Y values) vs Bin (X values)
But I have to find X values according to Y values..
For example...
This is the data..

Bin Frequency Cumulative %
50 5 5.00%
100 9 14.00%
150 16 30.00%
200 19 49.00%
250 18 67.00%
300 9 76.00%
350 12 88.00%
400 6 94.00%
450 2 96.00%
500 4 100.00%

Now, I have to find X value when cumulative% is equal to 30%, 40%, and 50%..?
It's OK, if cumulative% value is the same with the questions (30% for example, so the X value is 150). But how if it's 40%... 50%..?

Any help would be appreciated
Thanks and regards
Mut

2. ## Re: Desire Cumulative Frequency

Here is an example using TREND on a pair of values from your data source

3. ## Re: Desire Cumulative Frequency

Great!!!.. love it so much...
Thanks Andy..

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1