How do I calcuate an IC50 from analyze it?
|
First you need to tell us what IC50 is.
-- Regards, Fred "jc33" wrote in message ... |
Create a simple table of two columns. The first column could be the
concentration in the desired units i.e. micrograms per litre. The second column could be the inhibitory effect from 0% to 100%. Then you can use VLOOKUP() to find the approximate 50% level. -- Gary''s Student "Fred Smith" wrote: First you need to tell us what IC50 is. -- Regards, Fred "jc33" wrote in message ... |
Can you please define each paramater that needs to be entered?
lookup_value table_array col_index_num range_lookup "Gary''s Student" wrote: Create a simple table of two columns. The first column could be the concentration in the desired units i.e. micrograms per litre. The second column could be the inhibitory effect from 0% to 100%. Then you can use VLOOKUP() to find the approximate 50% level. -- Gary''s Student "Fred Smith" wrote: First you need to tell us what IC50 is. -- Regards, Fred "jc33" wrote in message ... |
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html It might help with the questions caused by excel's help for =vlookup(). jc33 wrote: Can you please define each paramater that needs to be entered? lookup_value table_array col_index_num range_lookup "Gary''s Student" wrote: Create a simple table of two columns. The first column could be the concentration in the desired units i.e. micrograms per litre. The second column could be the inhibitory effect from 0% to 100%. Then you can use VLOOKUP() to find the approximate 50% level. -- Gary''s Student "Fred Smith" wrote: First you need to tell us what IC50 is. -- Regards, Fred "jc33" wrote in message ... -- Dave Peterson |
All times are GMT +1. The time now is 03:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com