STDEV help

[enagy]

Could someone help me, please?
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!

 

[Stiuart_W]

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]

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]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][td="bgcolor:#C0C0C0"]

G​

[/td][td="bgcolor:#C0C0C0"]

H​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Point​

[/td][td="bgcolor:#F3F3F3"]

Time​

[/td][td="bgcolor:#F3F3F3"]

BPM​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

1​

[/td][td]

12:32​

[/td][td]

72​

[/td][td][/td][td="bgcolor:#F3F3F3"]

Beg​

[/td][td]

12:34​

[/td][td="bgcolor:#E5E5E5"]

3​

[/td][td]G2: =MATCH(F2, $B$2:$B$17)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

2​

[/td][td]

12:33​

[/td][td]

73​

[/td][td][/td][td="bgcolor:#F3F3F3"]

End​

[/td][td]

12:45​

[/td][td="bgcolor:#E5E5E5"]

14​

[/td][td]G3: =MATCH(F3, $B$2:$B$17)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

3​

[/td][td]

12:34​

[/td][td]

75​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

4​

[/td][td]

12:35​

[/td][td]

72​

[/td][td][/td][td="bgcolor:#F3F3F3"]

Avg​

[/td][td][/td][td="bgcolor:#E5E5E5"]

73.6​

[/td][td]G5: =AVERAGE(INDEX($C$2:$C$17, G$2):INDEX($C$2:$C$17, G$3))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

5​

[/td][td]

12:36​

[/td][td]

70​

[/td][td][/td][td="bgcolor:#F3F3F3"]

SD​

[/td][td][/td][td="bgcolor:#E5E5E5"]

3.4​

[/td][td]G6: =STDEV(INDEX($C$2:$C$17, G$2):INDEX($C$2:$C$17, G$3))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

6​

[/td][td]

12:37​

[/td][td]

68​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]

7​

[/td][td]

12:38​

[/td][td]

70​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]

8​

[/td][td]

12:39​

[/td][td]

71​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]

9​

[/td][td]

12:40​

[/td][td]

73​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]

10​

[/td][td]

12:41​

[/td][td]

75​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]

11​

[/td][td]

12:42​

[/td][td]

78​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]

12​

[/td][td]

12:43​

[/td][td]

77​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]

13​

[/td][td]

12:44​

[/td][td]

77​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]

14​

[/td][td]

12:45​

[/td][td]

77​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

16​

[/td][td]

15​

[/td][td]

12:46​

[/td][td]

76​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

17​

[/td][td]

16​

[/td][td]

12:47​

[/td][td]

78​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

 

[enagy]

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

 

[shg]

You're welcome.