# What Is Lower And Upper Std Deviation?

**URL:** <https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175>\
**Category:** Kibana\
**Created:** [June 23, 2020, 3:40am UTC](https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175 "2020-06-23T03:40:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ethan777100](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethan777100/32/70366_2.png) [@Ethan777100](https://discuss.elastic.co/u/Ethan777100)\
**Post date:** [June 23, 2020, 3:40am UTC](https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175/1 "2020-06-23T03:40:39Z")

</div>

Hi,

I wanted to show the spread of data about the zero mark wrt to the positive side and negative side.

So i tried with standard deviation - i get 2 indices - lower and upper standard deviation.

What do they mean exactly? Coz after closer look, and thought, i dont think standard deviation was applied correctly here in my use case.

I want to show a visualisation that shows wrt to the zero mark, the max ever value of that bucket to the right and the min ever value of that same bucket to the left.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/3/6379fb1c11ec3cb87f0416d20dac755e52be0452.png)

---

<div class="post-metadata">

**Author:** ![mykael](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@mykael](https://discuss.elastic.co/u/mykael)\
**Post date:** [June 23, 2020, 3:54am UTC](https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175/2 "2020-06-23T03:54:29Z")

</div>

By default, +/- 2 standard deviations from the average.

See: [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-extendedstats-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-extendedstats-aggregation.html)

If you set sigma to 1 ont he query, it'll give you +/- 1 standard deviation.

---

<div class="post-metadata">

**Author:** ![Ethan777100](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethan777100/32/70366_2.png) [@Ethan777100](https://discuss.elastic.co/u/Ethan777100)\
**Post date:** [June 23, 2020, 4:06am UTC](https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175/3 "2020-06-23T04:06:16Z")

</div>

abit silly qn but how can i edit my query? i searched ard i never found it

---

<div class="post-metadata">

**Author:** ![mykael](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@mykael](https://discuss.elastic.co/u/mykael)\
**Post date:** [June 23, 2020, 5:16am UTC](https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175/4 "2020-06-23T05:16:33Z")

</div>

Bottom right. Little pencil icon.

Mik

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 21, 2020, 5:26am UTC](https://discuss.elastic.co/t/what-is-lower-and-upper-std-deviation/238175/5 "2020-07-21T05:26:07Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.