How to create a graph for a given regression equation?

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" <JJaya.DeleteThis@discussions.microsoft.com> wrote in message
news:FC322845-AAD8-4C3D-9A2A-0B9B218C7712@microsoft.com...
> My equation of the form
> y = m1x1 + m2x2 + m3x3 + c
>
> "JJaya" 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?

On Fri, 29 Aug 2008, in microsoft.public.excel.charting,
JJaya <JJaya.TakeThisOut@discussions.microsoft.com> said:
>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.

--
Del Cotter
NB Personal replies to this post will send email to del.TakeThisOut@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

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

"Del Cotter" wrote:

> On Fri, 29 Aug 2008, in microsoft.public.excel.charting,
> JJaya <JJaya.TakeThisOut@discussions.microsoft.com> said:
> >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.
>
> --
> Del Cotter
> NB Personal replies to this post will send email to del.TakeThisOut@branta.demon.co.uk,
> which goes to a spam folder-- please send your email to del3 instead.
>

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

"Mike Middleton" wrote:

> 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" <JJaya RemoveThis @discussions.microsoft.com> wrote in message
> news:FC322845-AAD8-4C3D-9A2A-0B9B218C7712@microsoft.com...
> > My equation of the form
> > y = m1x1 + m2x2 + m3x3 + c
> >
> > "JJaya" 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?
>
>
>

On Tue, 2 Sep 2008, in microsoft.public.excel.charting,
JJaya <JJaya DeleteThis @discussions.microsoft.com> 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 del DeleteThis @branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.