data analysis
 

I am looking to create a formula for projecting a variable from two
other variables. I have done this in previous versions of excel years
ago. I was able to have excel calcuate an "R" factor. I used the "R"
factor to develop a liner equation. Can anybody help with how to
calculate this "R" factor for a 2 variable equation?

data analysis
 

JDaich -

Use the Regression tool of Excel's Analysis ToolPak add-in.

- Mike
http://www.mikemiddleton.com

wrote in message
oups.com...
I am looking to create a formula for projecting a variable from two
other variables. I have done this in previous versions of excel years
ago. I was able to have excel calcuate an "R" factor. I used the "R"
factor to develop a liner equation. Can anybody help with how to
calculate this "R" factor for a 2 variable equation?

data analysis
 

On Mar 9, 3:05 pm, "Mike Middleton" wrote:
JDaich -

Use the Regression tool of Excel's Analysis ToolPak add-in.

- Mikehttp://www.mikemiddleton.com

wrote in message

oups.com...



I am looking to create a formula for projecting a variable from two
other variables. I have done this in previous versions of excel years
ago. I was able to have excel calcuate an "R" factor. I used the "R"
factor to develop a liner equation. Can anybody help with how to
calculate this "R" factor for a 2 variable equation?- Hide quoted text -

- Show quoted text -

I guess I just did not look close enough. Thanks for the help