standard deviation

  1. R

    Creating a random skewed distribution

    Good evening, I am creating a monte-carlo simulation using NORM.INV distribution based on a mean and standard deviation. However, the distribution of the data that these numbers are based on is skewed; which doesn't get reflected, as only using mean/sd produces a symmetrical distribution. Is...
  2. I

    Removing Outliers with standard deviation

    Hello, I am working on a project and told to remove all outliers by using the ? +- 3? approach. I am wondering how i should go about this? do i need to calculate the mean and all quartiles to remove the outliers or is there a single excel function that can remove the data outside 3 standard...
  3. A

    STD Deviation Discrepancy

    I am trying to find the standard deviation for data presented in different ranges and I am currently using the following equation: =+STDEV.S(IF((e7a1!A12:A1010>=Primary!K$5)*e7a1!A12:A1010<=Primary!K$6);INDEX(Table1;0;MATCH($D19;Table1[#Headers];0));)) The reason for the formatting is that its...
  4. G

    Standard deviation on multiple criteria not working

    I'm trying to calculate standard deviation based on multiple criteria. I've used suggestions show on this site and on Google, but it keeps returning the SD of the entire list, not just those that match. Here's the formula I'm using: =STDEV.S(IF($C$2:$C$10=$L2,IF($E$2:$E$10=$M2,$H$2:$H$10)))...
  5. I

    Standard Deviation between two specific cell values.

    I can calculate the standard deviation when the cell condition is above or equal to 70 using this formula. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas...
  6. T

    Removing outliers from being counted in Average/Standard deviation functions??

    Hi, As a sciences undergrad, I have a number of massive lists of data that I need to sort through... Some of the averages and standard deviations are getting massively skewed as a result of outlier data.. Is there a way I can exclude these from my =St.dev or =avg function without having to...
  7. J

    Calculating Actual Standard Deviation

    I am looking for a way to calculate the actual standard deviation in excel. For example if the mean is at 10, what would be the actual standard deviation for 12? Thanks!
  8. A

    Excel Formula: Standard Deviation IF

    Hi all, Looking for some help with a standard deviation formula, integrated with an if statement. I'm using 'AVERAGEIF' and have read many articles about how to achieve something similar for the standard deviation using an array formula, i.e.; {=STDEV(IF(B3:B8="TEST1",D3:D8,""))} This appears...
  9. N

    If between a and b but not between x and y- Standard deviation

    I am trying to highlight cells which are between two numbers but not between two other numbers in order to highlight data values used to create a histogram using standard deviation. I understand that I would use conditional formatting but I'm not sure how to set up the equations. Here is...
  10. R

    How to define standard error for individual bars in excel, when the bars are already grouped together

    have a chart on excel which has two groups, i can usually set custom standard error for one group but here i have two groups. The solution for having one group is already solved and here is the answer Excel Graph with custom standard deviation but i dont want this, my bars are grouped together...
  11. M

    Calculating the standard deviation (in a pivot table) of my data (hourly) and adding it to the hourly average of the data

    I have 3 years of data in 6 minute averages that I would like to get the standard deviation by hour and add it to the hourly average. I created a standard deviation in the "Values" section, but this field does not show up in the calculation field list. Is there a way to create a calculation of...
  12. Z

    Mean & Std. Dev of Middle 80%

    Hi guys, I have a column of data (column H), and I'm trying to take the average & standard deviation of just the middle 80%. I can't seem to figure out how to do this. Thank you all for your time!
  13. G

    How to rank based on sum and break tie with standard deviation?

    Can anyone help me with how to break a ranking tie using standard deviation? 10 people rank their choices from 1-10 (10 being best), so I started with a plain basic rank based on the sum of all 10 people's choices. Highest overall number represents the groups most favorite choice. I would like...
  14. V

    Even Sum of Colums of a Random generated array

    I am sure you can tell by the title this is going to be fun! I have an array of random number of card players getting a random (but equal) number of cards. The cards are all numbered based on "power". So card 50 is weaker than card 49. I have the random number generator all set up to...
  15. B

    Averageif formulae

    Hi. I have a simple question on an averageif statement that is ending in an error code for me. I have in worksheet of data. I have made a pivot based on the data and in column A is the postcode, column B is the Average for the rent, column C is the Standard Deviation of the rent All easy to...
  16. S

    Dynamic Standard Deviation VBA

    Hi I am working on a project where I am trying to find the standard deviation within a dynamic range. I am having some trouble as to how to calculate the standard deviation. I am trying to do this step by step, but I cannot get the sum difference of squares working Here a link to a screen...
  17. M

    Writing formulas using the calculated field of a pivot table

    All, I got an easy one for you Excel geniuses.. It concerns the calculated fields in a pivot table (PT). I want to add a field in a PT that is calculated using standard deviation and average of existing fields in the datasource. But how I declare standard deviation and average in the "Formula"...
  18. T

    How to calculate standard deviation

    Hi, I need to calculate standard deviation from the following table. The issue is that I have Number Column and a QTY Column For example No QTY 34 6 55 7 23 0 79 55 88 3 Is there a way I could do it in one formula please?
  19. D

    Calculating Standard Deviation in a column based on criteria from another column using VBA

    Hi, I have tried looking everywhere on google but, no luck. I need help calculating standard deviation based on criteria from other columns using VBA. What I mean is I need to calculate standard deviation when column A (Tread Code) is = to A and when Column C (Fall Num) is = to 1 and then...
  20. D

    Standard deviation based on 2 criteria

    Hi there, I read a few other posts but had much difficulty modifying the formulas to match my needs. I have two columns, one with different times (i.e. 1:07, 2:25, etc.) and another with a different values that range from 1-200. I already used the averageifs function to find the average for...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top