does anyone know how to calculate the standard deviation in a bivariate system. i have a scatter plot. and i have plotted a regression. how do i calculate the stdev and can it be done in excel for such a systemThanks

can anyone help me with the equations for calculating orthogonal regressions. Need to generate a linear OR model. Need to calculate slope and intercept. Appreciate our help guys.

unfortunately that doesnt help

<t>hi guys,does anyone know how to do an orthogonal regression. I would be intersted in the maths but more so how to implement it in excel or vbaalso websites of relevance would be of interst if u guys know. I've been looking all morning and I'm real stressed out cos i cant find anything. hope one o...

Hi GuysDoes anyone know how to do an orthoganol regression in excel or the formula. Does anyone know how to implement this. Ur help would be appreciated.atrom

Also I am not sure why u would want to invert a matrix like that, however if u wish u may look at this paper to help u solve ithttp://www.math.wustl.edu/~sawyer/handouts/Genrlinv.pdf

<r>hi guysi've kinda solved the problem in vba. If u send me an e-mail to <EMAIL email="nurun.tafadar@stalimited.com">nurun.tafadar@stalimited.com</EMAIL> i will send u the excel file its still a lil experimental and quite slow and i've had to put it aside for a bit. But u are welcome to the code if...

hi guysthankyou for ur help. still slightly confused but i have enuff material to try and sniff it all out. thankyou once again atrom

<t>hi guys hope u can point me in the right direction. I've just finished a project and have developed a startegy for trading baskets of equities. And now i have some reletively easy problems with market depth; what i mean to say is that i want to find out how scaleable the strategy is (can i throw ...

Thankyou guys for ur help. It has been useful.

i dont ndestand what u mean when u say add.these are the mathematical steps that need to be taken1.set up x and y matrix2.transpose x and y arrays3.compute x'x4.compute INV(x'x) and x'y5compute beta INV(x'x)*x'yat what poit do u do any addition. Please help really stuckthankyou

<t>could someone please help. I am trying to write code in vba for performing multiple linear regression.the code is copied below, however i need to set the intercept to zero and i'm having a little trouble seeing how i can do that. I am aware that excel has an add-in that does MLR but it doesnt do ...