Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Linear Regression by set slope (not intercept) | Excel Worksheet Functions | |||
non linear regression in excel | Charts and Charting in Excel | |||
linear regression | Excel Worksheet Functions | |||
How do I conduct linear regression in Excel with more than 16 x's | Excel Worksheet Functions | |||
formula for linear regression | Excel Worksheet Functions |