Slope and Intercept using Macro

[habeebshafi]

User inputs N entries in column A and B corresponding to values X and Y of a liner function. and write a macro to compute the Slope and Intercept. Macro to be linked to the button.
cant use inbuilt statistical / mathematical functions

[patel45]

You don't need a macro, only simple formulas, attach please a sample file with data

[jeffreybrown]

Hi habeebshafi,

This seems to look like a homework type question and we don't do homework, but we are here to help get you moving in the right direction.

Also, is it possilby this person is a friend of yours and you are struggling with the same problem (or homework problem)?

http://www.excelforum.com/excel-prog...html?p=2922378

[Vikky]

Yeah dis was the question in our paper.. but we were unable to solve (atleast i could not) so i asked in open forum. So if such kind of problem comes again I will be able to solve it.

And the problem is not how to create the program... anybody can write the code. It is very easy.it is what is the procedure to solve the problem for calculating slope and intercept with "n" numbers. Calculating with two x and y co ordinate or by regression anybody can do it.

If you don't want to help it its fine... no problem .... Just don't give excuses or just accept you people are also not able to solve it without formula.

[MrShorty]

The first step in any problem like this (especially if you are not allowed to use preprogrammed functions) is to understand the statistics behind the problem. Programming it in VBA should then be easy. Any intro to statistics text should have a chapter on linear regression and how to obtain slope and intercept, or an internet site like http://www.easycalculation.com/stati...regression.php It's a fairly simple algorithm for linear regressions, but it should be easy to program those sums into VBA.