Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would like to calculate the standard deviation of forecast vs. actual for
10 periods Right now, I have to do step of step, (1) calculate deviation (actual-forecast) (2) square deviation (3) average of the squares of the deviation (4) square root of (3). I am looking for a Excel formular to calcuate this... I only found STDEV(number1,number2,...), a measure of how widely values are dispersed from the average value. not the variation between forecast and actual. Please help ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formular of one cell as text shown in another cell | Excel Discussion (Misc queries) | |||
excel formular update | Excel Worksheet Functions | |||
Reducing Formular length | Excel Discussion (Misc queries) | |||
Historical Excel question statistical capabilities | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |