Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jc33
 
Posts: n/a
Default How do I calcuate an IC50 from analyze it?


  #2   Report Post  
Fred Smith
 
Posts: n/a
Default

First you need to tell us what IC50 is.

--
Regards,
Fred


"jc33" wrote in message
...



  #3   Report Post  
Gary''s Student
 
Posts: n/a
Default

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




  #4   Report Post  
jc33
 
Posts: n/a
Default

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




  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calcuate bond yields engineer Excel Worksheet Functions 8 October 18th 05 04:34 AM
how to analyze freight expense? boots Excel Worksheet Functions 1 June 25th 05 11:59 PM
How do I analyze data from a survey in excel LaReina Excel Worksheet Functions 1 June 25th 05 11:43 PM
calcuate sales by date and segments Pete Petersen Excel Worksheet Functions 2 January 3rd 05 09:09 PM
Using Excel to analyze HTML GreggRoberts Excel Discussion (Misc queries) 2 January 1st 05 04:41 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"