# Standard Deviation from one sheet to another

New Member
Join Date: Jul 2012
Posts: 2

 19th Jul 2012
Hi all

I have a workbook dealing a large amount of logged Data over a period of 4 months and counting. I want to take the standard deviation of the temperature readings, for each individual day. I have a 'Data' sheet which has readings for temperature taken roughly every 3 minutes with their corresponding date/time. In a second 'Results' sheet I have a set of results calculated for each day which is where i want to formula to go . There are in the region of 500-700 readings taken each day, the exact number taken is recorded in the 'Results' sheet.

I am running Excel 2007, on not the fastest machine.

Any help would be greatly appreciated.

Josh

New Member
Join Date: Jul 2012
Posts: 2

 19th Jul 2012
Here is some more info of what I have tried. I meant to put it in an edit, but those are only allowed before 120mins...

STDEVP, This function would be perfect, although it lacks the ability to choose the correct temperatures to calculate.
IF, If commands require a false input for the case that the date is incorrect. I can't use zero, as this will destroy the average part of the deviation. Using "" to give nothing seems to cause my final formula to also give nothing as the final answer.
DSTDEVP, I was unsure of the syntax of this formula and was therefore unable to get anything of use out of it.

As far as i can tell STDEVPIF would be perfect if it were to exist, but it doesn't.

For those who are unsure SQRT(VAR( will give the same value as STDEV..

Finally the formula for STDEV in maths terms is as follows.

SQRT((SUM(x-X)^2)n)
Where:
x is each of the values
X is the average of all the values used
n is the number of values used

Regards

Josh

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Jason Microsoft Excel Worksheet Functions 2 24th Mar 2012 10:11 PM =?Utf-8?B?Q2hlcnlsIExhbW9uZHM=?= Microsoft Access Queries 2 14th Nov 2006 03:36 PM Terri S Microsoft Excel Discussion 1 13th Jul 2004 06:10 PM Bob Weiner Microsoft Excel Discussion 1 4th Feb 2004 07:25 PM Anuta Microsoft Excel Discussion 2 1st Feb 2004 07:34 AM

Features