Graph this! (Practice) – Add a trendline

When using Excel to generate this graph, be sure to pay attention to the following points:

  1. When adding the trendline, right-mouse click over a data point. From the context menu, select:
    • Linear as the Trend/Regression Type
    • Set intercept 0,0
    • Display line on chart
    • Display R-squared value on chart

  2. For this graph, the slope of the trendline needs to display 3 significant figures in order to get 3 significant figures for the sample’s unknown concentration. Right-mouse click over the equation of the trend line. From the context menu, select Format Trendline label.
  3. Select Number on the left menu. In the Category menu, select Number. In the Decimal Places field, type ‘4’. Click Close.

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>