In column (A) of an Excel spreadsheet, I have calculated a 150-day simple moving average (sma), updated daily, for each day over a period of 3000 days. In column (B) I want to calculate the corresponding values for 1 standard deviation from the 150-day sma. In Column (C) I want to calculate 2 standard deviations from the 150 sma and in Column D, I want to calculate 3 standard deviations from the 150 sma. What would be the formulas for Columns (B), (C) and (D)? Thank you.
2006-07-08
07:47:25
·
3 answers
·
asked by
Anonymous
in
Mathematics