Hello! I am new to using excel for analyzing data. I have a calibration curve from the first part of my experiment. It is derived from absorbance vs concentration data points to give me my equation for Beer's Law. It is in the form of A=mC+b, rearranging to solve for C, I have C=(A-b)/M

I have two sets of data points on absorbance vs time. I need to use excel to plug in my absorbance data to convert it to concentration so I can figure out the order of the reaction.

How can I get excel to do this for me? I have 200 data points each in the abs v time tables, so by hand wouldn't be efficient. I don't have the initial absorbance vs concentration data, just the line. I am using excel '04 on a mac.

Help is much appreciated!