View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
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.