standard deviation

Can someone help me out? I'm comparing various sets of data in a table based on certain conditions. I must include these conditions so I can exclude data based on dates and how I categorize clients based on tier. I am using this formula, =STDEV(IF(March[Go...

Hi guys I am having serious problems with a very large database I need to use. I am trying to calculate standard deviation but my results are being thrown by 0s in the data, is there a formula that ignores the 0 and still calculates the standard deviation, I also need to do this for mean formula...

This is probably a no-brainer for most of you, but I've been working on it all day! Lets say I have a data set in column A. In column B, I would like to show exactly how many SDs above or below the mean each datapoint is. Example (Made up numbers, not checking accuracy of Sample SDs) Column...

I'm trying to create formula that will calculate the population standard deviation that ignores all zeros. For example, I want to get a result of 5.969309262 instead of 9.393982839 when I calculate the population standard deviation of the following list: 17 19 12 0 25 25 9 24 0 How do I need...

im trying to find the standard deviation of a bunch of subjects in a population. i have 1 sheet which has three columns: date, the subject, and number. this sheet is updated daily. the dates and subject names are listed through the end of the trial, while the numbers are manually updated...