standard deviation
 

Hello! I have a small problem. I have two columns, A and B. In these
columns there are returns for different bonds. In column C I calculate
the diffence between A and B (C1=A1-B1). In column D I want to
calculate the standard deviation of the difference dating 30 data
points back. Thus, in D31 i write =STDAV(C1:C30).

This all works fine. However I want to skip having the C column and
make the calculations for the standard deviation of the dífference
dierctly from the values in A and B. However I have not managed to do
so. Please help me out! I know it does not sound worthwhile but having
the extra column really messes up my spreadsheet! Any help appreciated!
Thanks alot!


--
freddie mac
------------------------------------------------------------------------
freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101
View this thread: http://www.excelforum.com/showthread...hreadid=568322

standard deviation
 

One way to do this would be to put column C on a separate sheet in the
workbook, call it 'returns difference' and then reference that sheet in your
stdev calculations. Further you could hide the returns difference sheet by
going to Format--Sheet--Hide Sheets.

Dave

"freddie mac" wrote:


Hello! I have a small problem. I have two columns, A and B. In these
columns there are returns for different bonds. In column C I calculate
the diffence between A and B (C1=A1-B1). In column D I want to
calculate the standard deviation of the difference dating 30 data
points back. Thus, in D31 i write =STDAV(C1:C30).

This all works fine. However I want to skip having the C column and
make the calculations for the standard deviation of the dÃ*fference
dierctly from the values in A and B. However I have not managed to do
so. Please help me out! I know it does not sound worthwhile but having
the extra column really messes up my spreadsheet! Any help appreciated!
Thanks alot!


--
freddie mac
------------------------------------------------------------------------
freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101
View this thread: http://www.excelforum.com/showthread...hreadid=568322