Excel Linear Regression by set slope (not intercept)

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.
 
G

Guest

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
Anomolous behaviour of slope function. 2
Regression intercept to 0 2
Custom function for max residual from linear regression 7

Top