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

Jerry W. Lewis

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

Automatic Regressions based on Field Values 0
LINEST Issue - forced crossing zero R2 is wrong? 4
Linear Regression by set Slope (not intercept) 5
Calculation of slope when the trendline has a forced intercept 9
Setting intercept to zero with SLOPE/STEYX/etc 3
Regression with zero intercept 2
Multiple (as in many) regressions 3
Regression gives slope of zero when x values smaller than 10^-7 4

Top