<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>For those that did not come see me on Thursday or Friday
afternoon and that are still needing help making the two trend
lines:</p>
<p><br>
</p>
<p>Create you Excel spreadsheet and then copy the point for the
lower trend line and the upper trend line into adjacent columns.</p>
<p><img src="cid:part1.DC91511D.A7EA88F8@sandbox.mercer.edu" alt=""></p>
<p><br>
</p>
<p>Then highlight all of the regions all the data and create a
scatter plot. Be sure to format the y-axis so it is not at zero.<br>
</p>
<p><img src="cid:part2.92901DD8.30DB5A2C@sandbox.mercer.edu" alt=""></p>
<p><br>
</p>
<p>Then select the lower values on the graph to be fitted to a
trend line (series 2 in this case) and then right click the mouse
to add a trend line. Do the same thing for the upper trend line.</p>
<p><img src="cid:part3.829975CA.4F48F8DC@sandbox.mercer.edu" alt=""></p>
<p><br>
</p>
<p>And that's how you make multiple trend lines on the same graph.</p>
<p><br>
</p>
<p><br>
</p>
</body>
</html>