Hi. I want to use the function for standard deviation, stdev(), for all measures in the attached excel file. I want to calculate with 1 measure of 10, 48, 4 measures of 10,49, 6 measures of 10,50, and so on. If I just use stdev and mark all cells, excel treats them as individual numbers. How should I do?
Thank you in advance.
Hi. Here's one way:
http://www.ltcconline.net/greenl/cou...nsdgrouped.htm
You should also be able to get the answer using SUMPRODUCT (see attached sheet).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
here's the manual calculation as well (pink cells) for comparison with SUMPRODUCT (Green cells)
..here's a way that uses a User Defined function
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
mrgson 
Register To Reply
Bookmarks