Excel Linear Regression by set slope (not intercept)

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

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.
 
Answered under you post to microsoft.public.excel.misc. Please do not
separately post the same question to multiple newsgroups.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linear Regression by set Slope (not intercept) 5
LINEST Issue - forced crossing zero R2 is wrong? 4
Setting intercept to zero with SLOPE/STEYX/etc 3
Regression with zero intercept 2
Regression gives slope of zero when x values smaller than 10^-7 2
Custom function for max residual from linear regression 7
Anomolous behaviour of slope function. 2
Regression intercept to 0 2

Back
Top