+ Reply to Thread
Results 1 to 3 of 3

Thread: "averaging" standard deviations

  1. #1
    Points: 1,110, Level: 18
    Level completed: 10%, Points required for next Level: 90

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    "averaging" standard deviations




    Hello,

    I've been given the mean and standard deviation of many sets of the same measurement (bead size). So, I basically have a list of means and a list of corresponding standard deviations. I need to pool and analyze the data to figure out the overall distribution of bead size over these 100+ sets. Fortunately, each group has the same number of measurements, so they can be weighted equally.

    Ideally, I would like to create an aggregate distribution curve for all of the data, but as I only have a list of 100+ means and SDs, I'm not sure how to do this in excel. Is it possible?

    If I can't easily make a size distribution curve, at the very least I would like to (1) get a total mean (I am assuming since all groups are of equal size I can average the means), and then (2) get an "average" standard deviation. I can't figure out how to get an average standard deviation. Can anyone help with this?

  2. #2
    Points: 1,110, Level: 18
    Level completed: 10%, Points required for next Level: 90

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: "averaging" standard deviations

    Nevermind, figured it out...

  3. #3
    Devorador de queso
    Points: 95,705, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Posting AwardCommunity AwardDiscussion EnderFrequent Poster
    Dason's Avatar
    Location
    Tampa, FL
    Posts
    12,931
    Thanks
    307
    Thanked 2,629 Times in 2,245 Posts

    Re: "averaging" standard deviations


    Would you care to share the solution? Others might able to learn from what you did... and who knows maybe you assumed something that isn't true and one of us can help you catch that. Either way it would be nice if you shared what you did.

+ Reply to Thread

           




Similar Threads

  1. Replies: 0
    Last Post: 12-19-2010, 12:24 PM
  2. Replies: 2
    Last Post: 10-04-2010, 06:41 PM
  3. Replies: 2
    Last Post: 09-14-2010, 04:54 PM
  4. Replies: 1
    Last Post: 09-23-2009, 12:32 AM
  5. "Hepatitis" and "Golf" probabilities.
    By DAI&DF in forum Probability
    Replies: 7
    Last Post: 06-01-2008, 06:51 PM

Tags for this Thread

Posting Permissions

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






Advertise on Talk Stats