Using standard deviation function in excel for a specific criteria

0 votes
I was wondering if there was a way to determine the standard deviation of numbers within a given range in a data set because I am currently working on a project. For instance, I want to figure out the standard deviation of the data points in my overall data that are larger than or equal to -0.5 but less than or equal to 0.5.
Nov 12 in Others by Kithuzzz
• 20,660 points
25 views

1 answer to this question.

0 votes

Use this:

=STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000))

Depending on one's version this may need to be array entered with Ctrl-Shift-Enter when exiting edit mode instead of Enter.

answered Nov 12 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
230 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
68 views
0 votes
1 answer

How do delete an specific page in a word document using Excel VBA?

Check the code below. I eliminated the ...READ MORE

answered 5 days ago in Others by narikkadan
• 37,660 points
14 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
187 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP