Concentration Analysis
 

I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:

local equivalent
1096.68
6000
513.25
174.45
18000
53.86
399.74
118.73
1010.31
19316.81
8066.49
220000
28.92
1567614.68
206.56
667.75

My output should be:

Range No. Value
0 - 25,000 4 30,000
25, 001- 50,000 10 275,000

Concentration Analysis
 

you might look for FREQUENCY function in Help


On 16 Kwi, 08:44, Phillip Olan'g <Phillip
wrote:
I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:

local equivalent
1096.68
6000
513.25
174.45
18000
53.86
399.74
118.73
1010.31
19316.81
8066.49
220000
28.92
1567614.68
206.56
667.75

My output should be:

Range * * * * * * * * * * * *No. * * * * * * * * * * * * Value
0 - 25,000 * * * * * * * * *4 * * * * * * * * * * * * * * 30,000
25, 001- 50,000 * * * *10 * * * * * * * * * * * * * 275,000

Concentration Analysis
 

Hi,

Could you explain how you derive this from your posted data

Range No. Value
0 - 25,000 4 30,000
25, 001- 50,000 10 275,000

I think 0 - 25k is 14 and can't see where 30,000 comes from.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Phillip Olan'g" wrote:

I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:

local equivalent
1096.68
6000
513.25
174.45
18000
53.86
399.74
118.73
1010.31
19316.81
8066.49
220000
28.92
1567614.68
206.56
667.75

My output should be:

Range No. Value
0 - 25,000 4 30,000
25, 001- 50,000 10 275,000

Concentration Analysis
 

another way:
with
A1=0
B1=25000
A2=25000
B2=50000
and your data in column C

count
=SUMPRODUCT(($C$1:$C$16A1)*($C$1:$C$16<=B1))

Value/sum
=SUMPRODUCT(($C$1:$C$16A1)*($C$1:$C$16<=B1)*$C$1: $C$16)

adjust yr ranges to suit

HIH
pls click YES if it helped


On 16 Kwi, 08:44, Phillip Olan'g <Phillip
wrote:
I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:

local equivalent
1096.68
6000
513.25
174.45
18000
53.86
399.74
118.73
1010.31
19316.81
8066.49
220000
28.92
1567614.68
206.56
667.75

My output should be:

Range * * * * * * * * * * * *No. * * * * * * * * * * * * Value
0 - 25,000 * * * * * * * * *4 * * * * * * * * * * * * * * 30,000
25, 001- 50,000 * * * *10 * * * * * * * * * * * * * 275,000