Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graph an equation on scatterplot graph | Charts and Charting in Excel | |||
how do i graph a regression analysis? | Excel Discussion (Misc queries) | |||
how do i graph multiple linear regression? | Excel Discussion (Misc queries) | |||
how do i graph multiple linear regression? | Excel Discussion (Misc queries) | |||
How do I create a graph from an equation and not a set of data? | Charts and Charting in Excel |