Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / July 2007

Tip: Looking for answers? Try searching our database.

Linear Regression in Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bank Analyst - 31 Jul 2007 17:48 GMT
I have a data set that I would like to run a linear regression analysis on.
Can Excel help me with this and if so how do you do it?
Bernard Liengme - 31 Jul 2007 20:29 GMT
The short answer is YES but there are many options
1) On an XY chart of your data use Insert Trendline; specify Linear and
specify Display Equation
2) Use function SLOPE & INTERCEPT to get these statistics from your data
3) Use LINEST for same purpose but with more statistics
4) If you have Analysis ToolPac installed; use Tools | Data Analysis and
select Regression

a) Have a look at these in Help
be) Google with search term: Excel Regression
c) Try a simple Excel book (from library or second hand from
www.abebooks.com)

Then come back with more details of the data and your needs so we can get
specific.
You
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I have a data set that I would like to run a linear regression analysis on.
> Can Excel help me with this and if so how do you do it?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.