View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Linear Regression in Excel

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bank Analyst" wrote in message
...
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?