Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 18, 05:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 7
Default Standard deviation of data in a range matching condition

Hi

I have my excel dataset arranged as follows :

K T
APPLE .....
ORANGE .....
APPLE .....
ORANGE .....


In Column K, I have fruit data which is either APPLE or ORANGE.

In Column T, I have corresponding numerical values.

Each row has apple followed by orange data successively.

Rows of data are added each day.

In column W, I'm trying to compute the standard deviation of the last 7 days worth of numerical values but for specific fruit in the samw row of column K.

So if the fruit in K20 is Apple, W20 must calculate standard deviation of the past 7 numerical values of just apples. In K21, the same computation is done for Orange.

How do I solve this with a simple line of code?

I have tried the following :

The code I have in row W557 is :

{=IF($K543:$K556=K543,STDEV.S($T543:$T556))}

This is not giving me correct values of standard deviation.

What am I missing?

Thanks a lot for your help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Standard Deviation Soccerboy83 Excel Discussion (Misc queries) 2 June 16th 09 01:27 AM
Automatically show Standard deviation in a selected range Mike K Excel Programming 1 July 1st 08 04:50 PM
standard deviation [email protected] Charts and Charting in Excel 3 April 16th 08 01:04 AM
Standard Deviation Stan Banner Excel Worksheet Functions 1 March 12th 06 01:54 AM
Standard Deviation Stan Banner Excel Worksheet Functions 1 March 11th 06 10:11 PM


All times are GMT +1. The time now is 06:22 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017