cannotquitexcel
New Member
- Joined
- Aug 10, 2020
- Messages
- 1
- Office Version
- 365
Hi all,
New here! Quick question on multiple r sqaured. I'm trying to run a batch of about 400 regressions at once. I can do that pretty easily for a regression with one X and one Y with the RSQ formula in excel.
Issue is when I try and run a regression with 2 X's and 1 Y. I'd like to run a batch rather than use the Toolpak add-in one at a time. Anyone aware of a function in excel like RSQ to run this calculation? I'd also buy an add-in that would provide an RSQ formula for multiple r-sqauare calculations.
New here! Quick question on multiple r sqaured. I'm trying to run a batch of about 400 regressions at once. I can do that pretty easily for a regression with one X and one Y with the RSQ formula in excel.
Issue is when I try and run a regression with 2 X's and 1 Y. I'd like to run a batch rather than use the Toolpak add-in one at a time. Anyone aware of a function in excel like RSQ to run this calculation? I'd also buy an add-in that would provide an RSQ formula for multiple r-sqauare calculations.