Bug #3190 | Standard Deviation STDDEV - 2 different calculations | ||
---|---|---|---|

Submitted: | 16 Mar 2004 9:45 | Modified: | 28 Feb 2005 19:29 |

Reporter: | Juliana Chua | Email Updates: | |

Status: | Closed | Impact on me: | |

Category: | MySQL Server | Severity: | S4 (Feature request) |

Version: | OS: | ||

Assigned to: | Sergey Vojtovich | CPU Architecture: | Any |

[16 Mar 2004 9:45]
Juliana Chua

[16 Mar 2004 11:14]
Sergei Golubchik

it's a duplicate of Bug#1270, but as the issue is rather trivial we'll consider the adding the second variant of stddev

[15 Feb 2005 22:04]
Vivienne Boogaard

I think it is very important to have both the sample and the population standard deviation calculations available to use. I now have to RE your std() by squaring, multiplying by the population, dividing by the sample and then taking the SQRT(). This then matches other applications such as Excel. Thanks, Vivienne

[28 Feb 2005 14:02]
Sergey Vojtovich

Fixed in 5.0.3

[28 Feb 2005 19:29]
Paul DuBois

Noted in 5.0.3 changelog. Function descriptions were added to: http://dev.mysql.com/doc/mysql/en/group-by-functions.html