How To Use Excel Graph To Find Unknown

How can i determine the concentration of my sample.

How to use excel graph to find unknown. Thanks for helping me. Add unknown data point linear graph excel 2003. Click the chart elements button. Is there a way for me to have excel calculate this. Double click on the trendline choose the options tab in the format trendlines dialogue box and check the display r squared value on chart box.

By default excel shows one numeric value for the label y value in our case. Select the data labels box and choose where to position the label. Now this tutorial is talking about data extracting from a chart or graph. So we had to do a beer s law plot in my chemistry class. Can i add an unknown data point to linear graph in excel 2003.

Note the value of r squared on the graph. Your graph should now look like figure 6. To let your users know which exactly data point is highlighted in your scatter chart you can add a label to it. In this case you may want to extract the data from this chart. Using the r squared coefficient calculation to estimate fit.

The absorbance is my y value and the concentration is graphed on the x axis. We are suppose to use excel to do so. I have an unknown sample s absorbance and i need to determine the concentration.