Thread: data analysis
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default 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?