G
GreySky
If you're talking about "Standard Deviation Population"
(StdDevP), then, yes, you can use it.
You might want to start by using StdDev, then switch to
SQL View, and change StdDev to StdDevP. It will
show "Expression" in the list, but it does work (and won't
preform simple sampling).
For example, a query for annualizing standard deviation of
equity returns:
SELECT StDevP([MonthlyGross])*Sqr(12) AS 1YRStdDevGross,
StDevP([MonthlyNet])*Sqr(12) AS 1YRStdDevNet
FROM qryPerformanceRepresentative1YRMonthly
David Atkins, MCP
(StdDevP), then, yes, you can use it.
You might want to start by using StdDev, then switch to
SQL View, and change StdDev to StdDevP. It will
show "Expression" in the list, but it does work (and won't
preform simple sampling).
For example, a query for annualizing standard deviation of
equity returns:
SELECT StDevP([MonthlyGross])*Sqr(12) AS 1YRStdDevGross,
StDevP([MonthlyNet])*Sqr(12) AS 1YRStdDevNet
FROM qryPerformanceRepresentative1YRMonthly
David Atkins, MCP