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