Thread: data analysis
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] JDaich@southtowneexpo.com is offline
external usenet poster
 
Posts: 2
Default 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