Concentration Analysis

  • Thread starter Thread starter Phillip Olan'g
  • Start date Start date
P

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

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.
 
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
 
Back
Top