PC Review


Reply
Thread Tools Rate Thread

how do I graph a linear equation?

 
 
=?Utf-8?B?VGhyb3N0bGU=?=
Guest
Posts: n/a
 
      10th Jan 2005
I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
do this? On my TI-83 Plus I could easily do this. I also know I could create
a data table and use the table of values to chart the line in excel. But I
want just enter the equation in excel and have excel graph it. Thanks.
 
Reply With Quote
 
 
 
 
Del Cotter
Guest
Posts: n/a
 
      10th Jan 2005
On Sun, 9 Jan 2005, in microsoft.public.excel.charting,
Throstle <(E-Mail Removed)> said:

>I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
>do this? On my TI-83 Plus I could easily do this. I also know I could create
>a data table and use the table of values to chart the line in excel. But I
>want just enter the equation in excel and have excel graph it. Thanks.


You need only two points to define a straight line. Create a
spreadsheet that takes the minimum and maximum values of x, and the
values of a and b, and calculates just two values of y, and you will
have forever more a spreadsheet that will give you a graph of y=ax+b
whenever you want.

--
Del Cotter
Thanks to the recent increase in UBE, I will soon be ignoring email
sent to http://www.pcreview.co.uk/forums/(E-Mail Removed). Please send your email to del2 instead.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sm9obiBNYW5zZmllbGQ=?=
Guest
Posts: n/a
 
      10th Jan 2005
Throstle,

In addition to plotting the points by solving for X and Y, you can also have
Excel automatically do this via the use of defined names as a data source for
your chart. This link provides an explanation on how to chart a function:

http://www.pdbook.com/index.php/exce...rt_a_function/

----
Regards,
John Mansfield
http://www.pdbook.com


"Throstle" wrote:

> I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
> do this? On my TI-83 Plus I could easily do this. I also know I could create
> a data table and use the table of values to chart the line in excel. But I
> want just enter the equation in excel and have excel graph it. Thanks.

 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      10th Jan 2005
In A1:A10 enter some x-values (say 1,2,.....)
In B1 enter =2*A1+4
Copy this down to B10
Select A1:B10; click the chart wizard, and select an XY (NOT a Line) chart

best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Throstle" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
> do this? On my TI-83 Plus I could easily do this. I also know I could
> create
> a data table and use the table of values to chart the line in excel. But I
> want just enter the equation in excel and have excel graph it. Thanks.



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar graph and stacked bar graph on same graph BRB Microsoft Excel Misc 3 22nd Aug 2008 07:26 PM
The multiple regression tool - linear or non-linear regression? Statistical interest Microsoft Excel Misc 2 7th Feb 2008 12:01 AM
Powerpoint Graph- Shading in between two linear graph lines =?Utf-8?B?VGVyZW5Zb3VuZw==?= Microsoft Excel Charting 1 15th Jun 2006 09:29 AM
Hyperlinkage of one graph with another graph or Drill down graph =?Utf-8?B?U2FuamF5IEt1bWFyIFNpbmdo?= Microsoft Excel Charting 1 3rd Jan 2006 01:22 PM
using linear / non linear graphs to extract results Ebodski Microsoft Excel New Users 1 3rd Mar 2004 05:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 PM.