Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 846
Default how do i graph a regression analysis?

i am learning (slowly) how to perform a regression analysis on two columns of
data. Excel has given me a formula and i came up with an answer using the
LINEST function. How do i turn this into a graph or does Excel do it for me.
I'd like to see the different points scattered. thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default how do i graph a regression analysis?

Brad -

Arrange data with X values on the left and Y values on the right. Select
both ranges. Create an XY (Scatter) chart.

Or, use the Regression tool of Excel's Analysis ToolPak, in which case Excel
automatically provides a scatter chart of the original data with the best
fit line.

Or, after creating an XY (Scatter) chart of the original data, select the
data series (click on a point), and insert a trendline.

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


"Brad" wrote in message
...
i am learning (slowly) how to perform a regression analysis on two columns
of
data. Excel has given me a formula and i came up with an answer using the
LINEST function. How do i turn this into a graph or does Excel do it for
me.
I'd like to see the different points scattered. thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Regression Analysis? ccpalm2 New Users to Excel 1 February 21st 07 10:03 AM
Regression Analysis Format RickH Excel Discussion (Misc queries) 1 October 17th 05 03:54 PM
In Regression Analysis, How do you get a Correlation Matrix to be. tjp32 Excel Discussion (Misc queries) 1 April 4th 05 08:59 PM
how can i find out what all the terms in the regression analysis . may Excel Discussion (Misc queries) 1 February 9th 05 01:43 PM


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"