How to create a graph for a given regression equation?

  • Thread starter Thread starter JJaya
  • Start date Start date
J

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?
 
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?
 
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
Click to expand...

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 -

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
 
Thanks Del, but I have multiple "x's"

Del Cotter said:
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.
Click to expand...
 
Thanks Del, but I have multiple "x's"
Click to expand...

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.
 
Back
Top