Nutttttt

profilebaron123
Howtomakestandardcurve.docx

How to make standard curve?

1 Input your data in excel

C:\Users\Qing\AppData\Local\Temp\1542746864.png

2 select all the data and insert the Scatter charts C:\Users\Qing\AppData\Local\Temp\1542746940(1).png

C:\Users\Qing\AppData\Local\Temp\1542746960(1).png

3 Double-click one of the points in the chart, it will show some options

C:\Users\Qing\AppData\Local\Temp\1542747160(1).png

4 Click Add Chart Element-Trendline- Linear

C:\Users\Qing\AppData\Local\Temp\1542747239(1).png

5 Click Display Equation on chart, and display R-squared value on chart

C:\Users\Qing\AppData\Local\Temp\1542747289(1).png

6 In this graph, x-axis is concentration, y- axis is absorbance. Use the equation to calculate your unknow samples’ concentration, which is you know y and solve x.