How to create a graph for a given regression equation?

[JJaya]

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?

 

[JJaya]

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

:

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?

 

[Del Cotter]

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.

 

[Mike Middleton]

JJaya -

Your equation has four variables. Excel charts are limited to two numerical
variables using an XY (Scatter) chart or three variables using a 3D Column
chart (using one numerical variable and two categorical or
equally-spaced-numerical variables).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[JJaya]

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

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.

 

[JJaya]

Thanks Mike, at least now I know I can't do the charting...

 

[Del Cotter]

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.