Concentration Analysis

[Phillip Olan'g]

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

 

[Jarek Kujawa]

you might look for FREQUENCY function in Help

 

[Mike H]

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.

 

[Jarek Kujawa]

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

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

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

adjust yr ranges to suit

HIH
pls click YES if it helped

 

[p45cal]

Check out Data,Analysis,Histogram