Changes

Manuals/calci/DSTDEV (view source)

Revision as of 19:43, 10 October 2015

340 bytes added , 19:43, 10 October 2015

→‎Examples

Line 24: Line 24:

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

+

| class="sshl_f" |

+

| class="sshl_f" | A

+

| class="sshl_f" | B

+

| class="sshl_f" | C

+

| class="sshl_f" | D

+

|- class="odd"

+

| class="sshl_f" | 1

| class="sshl_f" | '''Name'''

| class="sshl_f" | '''Age'''

| class="sshl_f" | '''Salary'''

| class="sshl_f" | '''Age'''

−

|- class="~~odd~~"

+

|- class="even"

+

| class="sshl_f" | 2

| class="sshl_f" |

| class="sshl_f" | <40

| class="sshl_f" | >8000

| class="sshl_f" | >32

−

|- class="~~even~~"

+

|- class="odd"

+

| class="sshl_f" | 3

| class="sshl_f" |

| class="sshl_f" | >30

| class="sshl_f" |

−

|- class="~~odd~~"

+

|- class="even"

+

| class="sshl_f" | 4

| class="sshl_f" | '''Name'''

| class="sshl_f" | '''Age'''

| class="sshl_f" | '''Salary'''

| class="sshl_f" |

−

|- class="~~even~~"

+

|- class="odd"

+

| class="sshl_f" | 5

| class="sshl_f" | John

| class="sshl_f" | 34

| class="sshl_f" | 5500

| class="sshl_f" |

−

|- class="~~odd~~"

+

|- class="even"

+

| class="sshl_f" | 6

| class="sshl_f" | Bill

| class="sshl_f" | 35

| class="sshl_f" | 6500

| class="sshl_f" |

−

|- class="~~even~~"

+

|- class="odd"

+

| class="sshl_f" | 7

| class="sshl_f" | Clark

| class="sshl_f" | 29

| class="sshl_f" | 7000

| class="sshl_f" |

−

|- class="~~odd~~"

+

|- class="even"

+

| class="sshl_f" | 8

| class="sshl_f" | Bob

| class="sshl_f" | 45

| class="sshl_f" | 9000

| class="sshl_f" |

−

|- class="~~even~~"

+

|- class="odd"

+

| class="sshl_f" | 9

| class="sshl_f" | Susan

| class="sshl_f" | 37

| class="sshl_f" | 4000

| class="sshl_f" |

−

|- class="~~odd~~"

+

|- class="even"

+

| class="sshl_f" | 10

| class="sshl_f" | Jill

| class="sshl_f" | 45

Line 77: Line 103:

=DSTDEV(A4:C10,"Age",B1:B3) : Calculates the standard deviation for 'Age' column <br>in the range A4 to C10, for the cells with 40>Age>30. <br /> ''Returns 5.214829282387338'' as a result.

=DSTDEV(A4:C10,3,D1:D2) : Calculates the standard deviation for 'salary' <br>in the range A4 to C10, for the cells with Age>32. <br />''Returns 1981.161275615895'' as a result.

−

+

==Related Videos==

Swapna

writer

2,661

edits