Hi every1,this is my 1st time using this forum....pls can any1 tell me how to create a code in VB that can do LINEAR REGRESSION in excel.....i'm not sure how to xplain exactly what i need but basically you know when u use the data analysis tool for regression in excel and it outputs the intercept,anova,residuals e.t.c.,basically i need to be able to do a code in VB that can calculate all dis(linear regression) using the data that i have and output the result in2 excel.

PLS if any1 knows how to do this pls pls reply me asap...am at my wits end....Thanx...x