(See Accessing Excel data from the computer lab) Insert a row at the top. Position the cursor in the text box next to Input Y Range and use the mouse to. Check the 'Display Equation on chart' and 'Display R-squared value' boxes. Click 'Close.' This will display the equation of your trendline in slope-intercept form, y = mx + b, where m is the slope and b is the intercept, in addition to the correlation coefficient, R-squared. Label the axes and the legend. Your graph is now complete.

You can the standard form is y = mx + b where m is the slope and b is the y-intercept. Assume you are given the slope and one point on the line. Let the slope = 2 let the point = (3,5) the standard form of y = mx + b becomes y = 2x + b now you take the point (x,y) = (3,5) that is on the line (has to be on the line) and replace x and y in the equation with it.

We do have an upgrade available but you should be able to continue using our program, free of charge. We will look into that problem.

The equation becomes 5 = 2*3 + b then you solve for b. In this case b = 5-1 = -1 your equation becomes y = 2x - 1 graph of that equation looks like: b is the y intercept which is the value of y when x = 0 which is -1. The graph confirms that. The slope is 2 which means that everytime x increases 1 unit, y increases 2 units. That can be seen on the graph as well.

When x = 0, y = -1. When x = 1, y = 1 when = 2, y = 3 etc.