Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2006

Tip: Looking for answers? Try searching our database.

Excel Linear Regression by set slope (not intercept)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben - 15 May 2006 04:15 GMT
Hi Guys
is there a way in excel to get the linear regression function to
specify a function based on a set intercept (say =1), instead of a set
intercept.

I believe this ability should have been included in excel from day 1.
Jerry W. Lewis - 15 May 2006 11:50 GMT
Answered under you post to microsoft.public.excel.misc.  Please do not
separately post the same question to multiple newsgroups.

Jerry

> Hi Guys
> is there a way in excel to get the linear regression function to
> specify a function based on a set intercept (say =1), instead of a set
> intercept.
>
> I believe this ability should have been included in excel from day 1.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.