Regression in VBA
FYI: A sample of some of the data I am working with is attached.
I used VBA a couple times in school and didn't really understand much, so I basically only know that it exists. I hope someone can help me with an assignment I have for work, because I'm definitely struggling. I've done the necessary analysis in Minitab, but now my supervisor wants a program in Excel since he doesn't know how to use Minitab. So here it goes....
This has to do with doing regression analysis to determine the variance in different accounts based upon numerous variables. First, I have monetary figures (dependant variable) for three years, listed by month under each account name. I also have six possible independant variables also listed by month.
I am hoping to do the following:
1. Have the ability to add data at the end of every month to the columns.
2. Be able to pick the dates (from-to) to use in the regression (combo box).
3. Be able to pick the independant variables to use in the regression (from just one to all in combo box).
4. The regression needs to be able to exclude the variables that don't have a p-value of at least 90% significance.
5. Be able to pick the dependant variable to be analyzed (ability to select multiple variables at once, resulting in multiple outputs would be ideal).
6. I need the following regression statistics to be displayed for each analysis: Adjusted R2, F-value with conditional formatting, F significance level, and independant variable p-value.
I know that the chance of getting all this is slim, but does anyone at least have some advice on how to get started or where else to look?
Last edited by willie447; October 26th, 2005 at 07:21.
Video Tutorials / Excel Dashboards Reports