Interpreting graph of a slope

[Graphing a function]

I am studying pre-calc as a hobby - on my own.
I need to graph the function y=2x-3 in the following window:
(a) -10<=x<=10 by -10 <=y<=10
How do I enter this information for an excel chart?
Thanks, JNeal

 

[Jon Peltier]

Since this is a straight line, you need two points. In A1 and A2 enter the X
endpoints, that is, -10 and 10. In B1 enter the formula that calculates Y
from X:

=2*A1-3

Copy this cell, select B2, and paste. The range will look like this:

-10 -23
10 17

Select this range and go to the Chart Wizard (Insert menu > Chart, or the
little button that looks like a chart on the Standard toolbar). In step 1
choose an XY chart, and select a subtype that has a connecting line. To get
the X and Y axes to show the ranges you want, double click on either, click
on the Scale tab, and enter appropriate values for min and max.

This might not be necessary, I don't know what exactly your assignment is,
but to show this relationship for the range -10<=Y<=10, you have to
rearrange the formula to determine how to compute X from Y.

Y = 2X - 3
Y + 3 = 2X
(Y + 3)/2 = X

Now as above, put -10 and 10 into E1 and E2. In D1 put this formula:

=(E1+3)/2

This produces the following range in D1:E2:

-3.5 -10
6.5 10

Copy D1, select D2, and paste. Make an XY chart as above.

- Jon

 

[Graphing a function]

Thanks Jon - this worked and was very helpful.

Since this is a straight line, you need two points. In A1 and A2 enter the X
endpoints, that is, -10 and 10. In B1 enter the formula that calculates Y
from X:

=2*A1-3

Copy this cell, select B2, and paste. The range will look like this:

-10 -23
10 17

Select this range and go to the Chart Wizard (Insert menu > Chart, or the
little button that looks like a chart on the Standard toolbar). In step 1
choose an XY chart, and select a subtype that has a connecting line. To get
the X and Y axes to show the ranges you want, double click on either, click
on the Scale tab, and enter appropriate values for min and max.

This might not be necessary, I don't know what exactly your assignment is,
but to show this relationship for the range -10<=Y<=10, you have to
rearrange the formula to determine how to compute X from Y.

Y = 2X - 3
Y + 3 = 2X
(Y + 3)/2 = X

Now as above, put -10 and 10 into E1 and E2. In D1 put this formula:

=(E1+3)/2

This produces the following range in D1:E2:

-3.5 -10
6.5 10

Copy D1, select D2, and paste. Make an XY chart as above.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______