I have a scatter chart based on two columns of data (X data in left column, Y data in right column):
Final Concentration Absorbance
0.00E+00 0
1.06E-05 0.147
2.12E-05 0.306
3.19E-05 0.464
4.25E-05 0.626
5.31E-05 0.752
I want to predict the Concentration (X-value) at an Absorbance (Y-value) of .582
How would I go about doing this using Excel? I've read about the VLOOKUP function, but I don't think that's what I'm looking for here.
Thanks,
Steven
Bookmarks