|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 16th, 2010, 07:44 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
April 16th, 2010, 09:50 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
April 16th, 2010, 09:53 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
April 16th, 2010, 09:57 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
