Standard deviation only for data that meets two conditions in Excel

0 votes

I'm attempting to determine the standard deviation for a set of data points that must satisfy two requirements. The precise example is: It is necessary to determine the yield standard deviation for the crop variety "Z1" in region "A." A list of a few thousand yields, together with their matching area and variety, is available. The results should be the standard deviation for the three values (1500, 1800, and 1600) in the table below that satisfy this requirement. All other yields should be disregarded.

Region  Variety Yield
A   Z1  1500
B   Z1  2100
B   X2  1900
A   X1  1700
C   Z2  2000
C   X1  1500
A   Z1  1800
B   Z2  2500
C   X1  1700
A   Z1  1600

I tried using this formula, but it does not work (also not as an array formula) and only returns "FALSE"

=IF(AND(Region="A",Variety="Z1"),STDEV.S(Yield))

Can someone please help me with this?

Dec 16, 2022 in Others by Kithuzzz
• 38,000 points
550 views

1 answer to this question.

0 votes

I would say:

=STDEV.S(IF((A2:A11="A")*(B2:B11="Z1"),C2:C11,""))

Array entered.

answered Dec 16, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

answered Jan 10, 2023 in Others by narikkadan
• 63,600 points
437 views
0 votes
1 answer

How can I allow a user to change a cell in excel only under particular conditions?

Copy the next event code in the ...READ MORE

answered Jan 31, 2023 in Others by narikkadan
• 63,600 points
612 views
0 votes
1 answer

Excel VBA function that cross references two data sets to come up with one solution

Solution using dictionary to count Public Sub citizens() ...READ MORE

answered Feb 16, 2023 in Others by narikkadan
• 63,600 points
821 views
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, 2022 in Others by Edureka
• 13,690 points
4,154 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, 2022 in Others by Edureka
• 13,690 points
2,021 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, 2022 in Others by Edureka
• 13,690 points
998 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,735 views
0 votes
1 answer

Using standard deviation function in excel for a specific criteria?

Use this: =STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000)) Depending on one's version this may ...READ MORE

answered Nov 12, 2022 in Others by narikkadan
• 63,600 points
925 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,600 points
1,222 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