|
CORREL formula work on multiple dependents
I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...968&highlight= |
CORREL formula work on multiple dependents
Fin Fang Foom -
Use the array-entered LINEST worksheet function. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Fin Fang Foom" wrote in message oups.com... I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...968&highlight= |
CORREL formula work on multiple dependents
On Oct 10, 12:04 pm, "Mike Middleton" wrote:
Fin Fang Foom - Use the array-entered LINEST worksheet function. - Mike Middletonhttp://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Fin Fang Foom" wrote in ooglegroups.com... I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...68&highlight=- Hide quoted text - - Show quoted text - Hi Mike, I have but I'm trying to get indiviual formulas for Regression Statistics. Multiple R R Square Adjusted R Square Standard Error Observations Does anyone has a sample file for this? |
CORREL formula work on multiple dependents
Fin Fang Foom -
You asked about "formulas" but your examples are "functions." Which do you want? If worksheet functions are acceptable, you can use the INDEX and LINEST functions to get most of the results. John Walkenbach shows how at http://www.j-walk.com/ss/excel/tips/tip101.htm Instead, if you want formulas (add-subtract-multiply-divide), the answer for multiple regression usually involves matrix operations (linear algebra), and it's not much fun to do the calculations any other way. - Mike "Fin Fang Foom" wrote in message ups.com... On Oct 10, 12:04 pm, "Mike Middleton" wrote: Fin Fang Foom - Use the array-entered LINEST worksheet function. - Mike Middletonhttp://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Fin Fang Foom" wrote in ooglegroups.com... I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...68&highlight=- Hide quoted text - - Show quoted text - Hi Mike, I have but I'm trying to get indiviual formulas for Regression Statistics. Multiple R R Square Adjusted R Square Standard Error Observations Does anyone has a sample file for this? |
CORREL formula work on multiple dependents
On Oct 10, 3:48 pm, "Mike Middleton" wrote:
Fin Fang Foom - You asked about "formulas" but your examples are "functions." Which do you want? If worksheet functions are acceptable, you can use the INDEX and LINEST functions to get most of the results. John Walkenbach shows how athttp://www.j-walk.com/ss/excel/tips/tip101.htm Instead, if you want formulas (add-subtract-multiply-divide), the answer for multiple regression usually involves matrix operations (linear algebra), and it's not much fun to do the calculations any other way. - Mike "Fin Fang Foom" wrote in oglegroups.com... On Oct 10, 12:04 pm, "Mike Middleton" wrote: Fin Fang Foom - Use the array-entered LINEST worksheet function. - Mike Middletonhttp://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Fin Fang Foom" wrote in ooglegroups.com... I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...ighlight=-Hide quoted text - - Show quoted text - Hi Mike, I have but I'm trying to get indiviual formulas for Regression Statistics. Multiple R R Square Adjusted R Square Standard Error Observations Does anyone has a sample file for this? Click on the link below I post a an example. It will give you a better idea what I'm looking for. |
CORREL formula work on multiple dependents
All of the output from the ATP multiple regression tool comes either directly
or indirectly from the LINEST function (as Mike already told you). Help is misleading, but you can pass a multiple column range to LINEST and get multiple regression output. Jerry "Fin Fang Foom" wrote: On Oct 10, 3:48 pm, "Mike Middleton" wrote: Fin Fang Foom - You asked about "formulas" but your examples are "functions." Which do you want? If worksheet functions are acceptable, you can use the INDEX and LINEST functions to get most of the results. John Walkenbach shows how athttp://www.j-walk.com/ss/excel/tips/tip101.htm Instead, if you want formulas (add-subtract-multiply-divide), the answer for multiple regression usually involves matrix operations (linear algebra), and it's not much fun to do the calculations any other way. - Mike "Fin Fang Foom" wrote in oglegroups.com... On Oct 10, 12:04 pm, "Mike Middleton" wrote: Fin Fang Foom - Use the array-entered LINEST worksheet function. - Mike Middletonhttp://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Fin Fang Foom" wrote in ooglegroups.com... I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...ighlight=-Hide quoted text - - Show quoted text - Hi Mike, I have but I'm trying to get indiviual formulas for Regression Statistics. Multiple R R Square Adjusted R Square Standard Error Observations Does anyone has a sample file for this? Click on the link below I post a an example. It will give you a better idea what I'm looking for. |
CORREL formula work on multiple dependents
On Oct 11, 5:22 am, Jerry W. Lewis wrote:
All of the output from the ATP multiple regression tool comes either directly or indirectly from the LINEST function (as Mike already told you). Help is misleading, but you can pass a multiple column range to LINEST and get multiple regression output. Jerry "Fin Fang Foom" wrote: On Oct 10, 3:48 pm, "Mike Middleton" wrote: Fin Fang Foom - You asked about "formulas" but your examples are "functions." Which do you want? If worksheet functions are acceptable, you can use the INDEX and LINEST functions to get most of the results. John Walkenbach shows how athttp://www.j-walk.com/ss/excel/tips/tip101.htm Instead, if you want formulas (add-subtract-multiply-divide), the answer for multiple regression usually involves matrix operations (linear algebra), and it's not much fun to do the calculations any other way. - Mike "Fin Fang Foom" wrote in oglegroups.com... On Oct 10, 12:04 pm, "Mike Middleton" wrote: Fin Fang Foom - Use the array-entered LINEST worksheet function. - Mike Middletonhttp://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Fin Fang Foom" wrote in ooglegroups.com... I'm trying to do a multiple regression but using formulas but it seems I can't get these formulas to work on multiple dependents. =CORREL(Y,X1,X2,X3,X4) =RSQ(Y,X1,X2,X3,X4) =INTERCEPT(Y,X1,X2,X3,X4) =SLOPE(Y,X1,X2,X3,X4) Are there other formulas could do this? I know I could use the Data Analysis in excel for this but managment would like a formula version. I also post this qustion to the link below. http://www.mrexcel.com/board2/viewto...ighlight=-Hide quoted text - - Show quoted text - Hi Mike, I have but I'm trying to get indiviual formulas for Regression Statistics. Multiple R R Square Adjusted R Square Standard Error Observations Does anyone has a sample file for this? Click on the link below I post a an example. It will give you a better idea what I'm looking for.- Hide quoted text - - Show quoted text - Hi Jerry Thank you so much for replying. Honestly I very little experience in stats. Can you post example file. |
| All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com