Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stdev of an array?
Hello,
I have some data that I have collected, and there is a fairly large number of data points (900). The way the data is recorded is like this: 172.5 16 172.6 16 172.7 36 and so on. I figured out how to average the values using the sumproduct() function, but how can I calculate the stdev of the values without having 900 cells filled with individual data points? Thanks, Monte |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the STDEV of Avg? | Excel Discussion (Misc queries) | |||
how do I get STDEV() 2 sigma? | Excel Worksheet Functions | |||
STDEV | Excel Discussion (Misc queries) | |||
StDev Results | Excel Discussion (Misc queries) | |||
STDEV...HELP | New Users to Excel |