Hi everyone,
I have got a set of data points (I don't have an equation unfortunately) from an experiment which I have plotted on a scatter graph. The x-axis has a log scale to the base of 2. I need to find the median for the data points plotted (the curve), therefore the intercept between the curve and line (drawn at y=50 to find the median) needs to be calculated to give a value for the x co-ordinate (which is on a log scale to the base of 2). Is there any way that the x value for the intercept can be found either graphically or using formulae in excel, as I need to repeat this process to find the intercept for 40 different graphs?
The Excel file is attached to hopefully demonstrate the problem a bit clearer. I hope I have explained everything clearly. If not, please let me know and I will have another go!
Thanks very much for any help in advance.
Intercept Problem.xlsx
I have got a set of data points (I don't have an equation unfortunately) from an experiment which I have plotted on a scatter graph. The x-axis has a log scale to the base of 2. I need to find the median for the data points plotted (the curve), therefore the intercept between the curve and line (drawn at y=50 to find the median) needs to be calculated to give a value for the x co-ordinate (which is on a log scale to the base of 2). Is there any way that the x value for the intercept can be found either graphically or using formulae in excel, as I need to repeat this process to find the intercept for 40 different graphs?
The Excel file is attached to hopefully demonstrate the problem a bit clearer. I hope I have explained everything clearly. If not, please let me know and I will have another go!
Thanks very much for any help in advance.
Intercept Problem.xlsx
