Results 1 to 4 of 4

Mean of standard deviations across columns?

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2004
    Posts
    17

    Mean of standard deviations across columns?

    I'm looking for an (array) formula that will take the mean of standard deviations across several columns given the value of another column. For example, I would have

    A B C D
    2 4 2 1
    2 2 2 1
    4 2 1 0

    I am looking for a formula that will take the mean of the standard deviations of A B and C IN EACH ROW given that column D contains value 1.

    (Note that I am not trying to take the standard deviations of all the values in columns A, B and C where the value in column D is 2. I'm trying to take an average of the standard deviations. I have not succeeded in finding an array formula that will do this.

    Thanks again for everyone's help on previous problems!
    Last edited by ModelerGirl; 02-04-2006 at 12:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1