LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine the STDEV of Avg? Eric Excel Discussion (Misc queries) 4 November 4th 07 10:45 AM
how do I get STDEV() 2 sigma? jimbo Excel Worksheet Functions 4 January 25th 06 07:49 AM
STDEV Kimo Excel Discussion (Misc queries) 3 January 13th 06 02:51 PM
StDev Results Michael Excel Discussion (Misc queries) 1 August 22nd 05 09:33 PM
STDEV...HELP JRH New Users to Excel 5 January 22nd 05 08:47 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"