Hey, I'm having trouble reading off values from a couple of charts for a molecular biology lab. I'm supposed to get the X value for each of the four lines at 50% of the max. response (i.e. where a line drawn from 50 on the y axis would intercept the lines I've plotted). Log scales are hard to work with though, is there any way I can get excel to do this for me? I've attached a screen grab of them to show what I'm talking about. Thanks to anyone who can help.
Why not use the log(10) of the numbers on the X-axis on your dose response plot which will be linear.
Are you using a parameterised formula to define your sigmodal function or just letting Excel generate a best fit? If its the former, you could obviously insert 50% as the answer and work backwards.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
You could add major and minor gridlines to the x axis, which would make it easier to read and interpolate visually, or interpolate it mathematically.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks