Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default How to create a graph for a given regression equation?

On Tue, 2 Sep 2008, in microsoft.public.excel.charting,
JJaya said:
"Del Cotter" wrote:
I have a regression equation generated in Minitab. I need to chart that
equation for different sets of data so I can predict behavior. How can I
create a graph for the equation in Excel 2007?

My equation of the form
y = m1x1 + m2x2 + m3x3 + c


Fill the cells in one column with a range of values of x. Fill the
column to the right with the calculated values of y. Plot the two
columns using an XY (Scatter) graph.


Thanks Del, but I have multiple "x's"


You can still do it in a column of multiple XY graphs of several series
each, or even a single graph with multi-coloured series, if the values
are right.

They're not going to be very interesting curves though, what with being
simple straight lines in each x.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph an equation on scatterplot graph Jonzor Charts and Charting in Excel 1 July 21st 08 11:04 PM
how do i graph a regression analysis? Brad Excel Discussion (Misc queries) 1 September 29th 07 12:01 AM
how do i graph multiple linear regression? enortirol Excel Discussion (Misc queries) 1 February 21st 06 02:38 PM
how do i graph multiple linear regression? enortirol Excel Discussion (Misc queries) 0 February 21st 06 01:18 PM
How do I create a graph from an equation and not a set of data? ashemorry Charts and Charting in Excel 1 January 20th 05 10:14 AM


All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"