ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linear Regression in Excel (https://www.excelbanter.com/excel-worksheet-functions/152484-re-linear-regression-excel.html)

Bernard Liengme

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?






All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com