Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?




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
Excel Linear Regression by set slope (not intercept) Ben Excel Worksheet Functions 1 May 15th 06 11:49 AM
non linear regression in excel Nikeel Charts and Charting in Excel 1 January 5th 06 12:07 AM
linear regression Jason - MR Excel Worksheet Functions 1 November 28th 05 07:51 PM
How do I conduct linear regression in Excel with more than 16 x's Ken Excel Worksheet Functions 5 September 22nd 05 01:02 PM
formula for linear regression DBane Excel Worksheet Functions 14 September 1st 05 09:54 PM


All times are GMT +1. The time now is 12:42 AM.

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

About Us

"It's about Microsoft Excel"