Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Analysis | Excel Discussion (Misc queries) | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |