Help Multiple Linear REG.

[naderkamal188]

I have a very weird question which I guess is not replicated hopefully I can get an answer.
when using the multiple regression analysis in excel via data analysis tool each one of the independent variables gets a coefficient with a certain value.
the tricky question here is there any means that I can enforce excel to assign a value of 1 as a coefficient for a certain independent variable and hopefully it pops out the whole regression results.
as an example of what I mean the following equation:
Y = Bo + B1* X1 + B2 * X2 + ............
what I mean here is to enforce a coefficient like B1 to be equals to one.
I would really appreciate any help guys.
Thank you...

 

[shg]

Subtract the value of X1 from Y, and then remove it from the regression.

 

[shg]

I.e., regress

Y - X1 = B0 + B2 * X2 + ...

 

[naderkamal188]

I.e., regress

Y - X1 = B0 + B2 * X2 + ...

thanks for your help man and it was a really good idea. However; it didn't result in the same statistics besides I need that variable to be in the side of independent variables to get some stats and results about it like the anova and the p-value.

 

[shg]

You can readily calculate its correlation with Y. I don't know enough statistics to suggest anything else.