Results 1 to 14 of 14

Combine standard deviations

Threaded View

abousetta Combine standard deviations 09-29-2015, 02:10 PM
shg Re: Combine standard... 09-29-2015, 02:16 PM
plotting Re: Combine standard... 09-29-2015, 02:17 PM
abousetta Re: Combine standard... 09-29-2015, 02:43 PM
abousetta Re: Combine standard... 09-29-2015, 02:31 PM
plotting Re: Combine standard... 09-29-2015, 02:36 PM
abousetta Re: Combine standard... 09-29-2015, 02:44 PM
abousetta Re: Combine standard... 09-29-2015, 03:02 PM
shg Re: Combine standard... 09-29-2015, 02:45 PM
abousetta Re: Combine standard... 09-29-2015, 02:49 PM
shg Re: Combine standard... 09-29-2015, 02:58 PM
shg Re: Combine standard... 09-29-2015, 03:18 PM
abousetta Re: Combine standard... 09-29-2015, 03:40 PM
shg Re: Combine standard... 09-29-2015, 04:11 PM
  1. #1
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Combine standard deviations

    Hello,

    I'm trying to replicate the formulas from here in order to calculate the weighted standard deviation from different samples. The formula is as follows:

    image026.gif

    I've put together an example workbook and isolated the problem that the error is caused by trying to get the square root of a negative number. The culprit seems to be:
    Formula: copy to clipboard
    - (3*A2*D2*G2)


    Can anyone help me to correct this formula?

    Thanks.

    abousetta
    Attached Files Attached Files
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting for Standard Deviations
    By ajzeleny in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-19-2014, 06:13 PM
  2. Error Bars-standard deviations
    By shantibala in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2008, 09:01 PM
  3. 4 Standard Deviations
    By NathanScott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2008, 04:52 AM
  4. Calculate 2 Standard Deviations
    By Michael in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2006, 01:15 PM
  5. Mean of standard deviations across columns?
    By ModelerGirl in forum Excel General
    Replies: 3
    Last Post: 02-04-2006, 01:00 PM
  6. Graph Standard Deviations
    By ed in forum Excel General
    Replies: 1
    Last Post: 08-03-2005, 05:05 PM
  7. [SOLVED] Standard deviations in Excel
    By Fred Zack in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-14-2005, 09:05 PM

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