Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben
 
Posts: n/a
Default Excel Linear Regression by set slope (not intercept)

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.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default Excel Linear Regression by set slope (not intercept)

Answered under your post in microsoft.public.excel.misc. Please do not
separately post the same question to multiple news groups.

"Ben" wrote:

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.


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
Linear Regression by set Slope (not intercept) Ben Excel Discussion (Misc queries) 5 May 21st 06 10:49 AM
Regression intercept to 0 squalidae Excel Worksheet Functions 2 February 22nd 06 05:56 AM
how do i graph multiple linear regression? enortirol Excel Discussion (Misc queries) 0 February 21st 06 01:18 PM
Multiple Regression in Excel 2002 SP3 (Office XP)? KA Excel Worksheet Functions 3 September 23rd 05 01:50 AM
linear interpolation function in excel tskoglund Excel Worksheet Functions 4 September 10th 05 03:31 AM


All times are GMT +1. The time now is 09:51 PM.

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"