# STDEV help

#### enagy

##### New Member
I have column A (timeline) and column B (corresponding heart frequency data).

We enter timepoint 1 into a cell (beginning of the measurement - entered into E1) and timepoint 2 (end of the measured period) into E2. I'd like to know the average heart rate for that given period and the STDEV of the heart rate data.
In E 3 we calculate the corresponding average of the heart rates :

[FONT=&quot][/FONT]=AVERAGEIFS(B2:B10000,A2:A10000,">="&E1,A2:A10000,"<="&E2)

I don't know how to calculate the corresponding standard deviations of the above data.

I would be very grateful for help, it is to make my students' work less easier in a psychology project.
thank you!

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### Stiuart_W

##### Well-known Member
In column c add formula =(b2-\$E\$3)^2 (I have assumed that you have a header in A and B. then fill this down

In E4, say, enter = SQRT((sumifs(B2:B10000,A2:A10000,">="&E1,A2:A10000,"<="&E2)^2/countifs(B2:B10000,A2:A10000,">="&E1,A2:A10000,"<="&E2)-1)))

NB. I haven't tested this

#### enagy

##### New Member
Thank you, Stuart for the fast help. Unfortunately I get 'too few arguments for this function' note when I try to enter this.
Emese

#### shg

##### MrExcel MVP
 A​ B​ C​ D​ E​ F​ G​ H​ 1​ Point​ Time​ BPM​ ​ ​ ​ ​ ​ 2​ 1​ 12:32​ 72​ Beg​ 12:34​ 3​ G2: =MATCH(F2, \$B\$2:\$B\$17) 3​ 2​ 12:33​ 73​ End​ 12:45​ 14​ G3: =MATCH(F3, \$B\$2:\$B\$17) 4​ 3​ 12:34​ 75​ 5​ 4​ 12:35​ 72​ Avg​ 73.6​ G5: =AVERAGE(INDEX(\$C\$2:\$C\$17, G\$2):INDEX(\$C\$2:\$C\$17, G\$3)) 6​ 5​ 12:36​ 70​ SD​ 3.4​ G6: =STDEV(INDEX(\$C\$2:\$C\$17, G\$2):INDEX(\$C\$2:\$C\$17, G\$3)) 7​ 6​ 12:37​ 68​ 8​ 7​ 12:38​ 70​ 9​ 8​ 12:39​ 71​ 10​ 9​ 12:40​ 73​ 11​ 10​ 12:41​ 75​ 12​ 11​ 12:42​ 78​ 13​ 12​ 12:43​ 77​ 14​ 13​ 12:44​ 77​ 15​ 14​ 12:45​ 77​ 16​ 15​ 12:46​ 76​ 17​ 16​ 12:47​ 78​

#### enagy

##### New Member
Thank you very much for this help, it works beautifully! I am very happy, thank you again!!!
Emese

You're welcome.

1,106,418
Messages
5,511,242
Members
408,834
Latest member
BoyBoy

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...