Results 1 to 7 of 7

Standard deviation - New average

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Slovakia
    MS-Off Ver
    2013
    Posts
    6

    Post Standard deviation - New average

    Hello Guys

    I have one problem is about calculating average according standard devitation. I have several results, where I need to cut out the results outside the standard devitation "line". I'm trying to use average and countif but it doesnt work for me
    The basic calculation principle is to find if the value is in SD range if not use False / 0 and with averageif ignore "zero" results. I've also tried a countif but it's still not working for me.

    Can you help me please why this average did not work in formula?

    I would like to use only one formula without additional cells.

    See more in worksheet.

    Thank you for any help

    Kind regards
    Andrej
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average plus minus standard deviation excel in one well
    By edwin.ndukwe in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-25-2016, 05:25 PM
  2. SQL calculate Average and Standard Deviation and Group BY
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2015, 05:49 AM
  3. Average plus minus standard deviation excel in one well
    By dasag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2015, 09:51 AM
  4. Help with calculating standard deviation for a weighted average
    By m.a.a.psu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-31-2013, 11:31 AM
  5. Average and Standard Deviation Question
    By ryankarmouta in forum Excel General
    Replies: 1
    Last Post: 10-22-2011, 01:19 AM
  6. Average & Standard Deviation Loop
    By smadsen99 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-01-2011, 06:03 PM
  7. Weighted Average Standard Deviation
    By kthenning in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2005, 12:05 PM

Tags for this Thread

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