In: Statistics and Probability
As a researcher, you have been given a set of standards to use in analysis of
cellobiase. You have the standard numbers and absorbance, graph this standard
curve
Standard Number | Absorbance | Amt of p-nitrophenol Produced |
S1 | 0 | 0 |
S2 | 0.221 | 12.5 |
S3 | 0.454 | 25 |
S4 | 0.901 | 50 |
S5 | 1.783 | 100 |
Standard curve is plotted as Amt of P- nitrophenol produced against absorbance rate . I have done graph in Excel and uploaded 2 pictures down below. Second one is just a clearer picture of the graph.
If you want to recreate this in Excel first enter data in columns and then select the two columns and insert a scatter plot from the Insert tab..
Now when you click on the chart and go to design tab as shown in first picture you can change the chart layout and have these criss cross dense lines for graph.
To add the line connecting the dots right click on any of the points and click "Add trendline" and give linear if needed to specify.
Hope you understand , Happy learning.