3 Replies Latest reply on Apr 8, 2016 9:12 AM by Carl Slifer

# Display -1,1 deviation as crosstab

Hello All!

I'm wondering if it is possible to have a cross tab showing Average, +1 SD, -1SD.

I have built a box and whiskers plot and swapped this to standard deviation rather than quartile ranges.

The information is available by hovering over the reference lines, but it would be great if this could be a cross tab with these three numbers in it?

Josef

• ###### 1. Re: Display -1,1 deviation as crosstab

Howdy Josef,

Of course it is! Check out the workbook I've provided with the values requested.

Cheers!

Carl Slifer

InterWorks

• ###### 2. Re: Display -1,1 deviation as crosstab

Hi Carl,

I hadn't realised there was a standard deviation function, thank you for that!

Let's say I want to look at the average order value, plus or minus one standard deviation. (I know this doesn't make sense here, since it is not normally distributed, but my data is and the problem I've run into is the same.)

I have attached an example where I have the figures in the graph, and I would like to replicate these three figures into a crosstab.

SD-1:-£393.39

Average:£229.86

SD+1 :£853.10

Josef

• ###### 3. Re: Display -1,1 deviation as crosstab

Sorry Josef,

On my way out of the door,

TRY

AVG([Sales]) - STDEV(Sales)

AVG([Sales]) + STDEV(Sales)

AVG([Sales])

Btw, this is not the average per order this is the average per line. There are multiple order id's in this data base with multiple rows. In order to get that instead of [sales]

You will need to do something with an LOD calculation: I'm thinking something like

{FIXED [Order ID] : SUM([Sales]}

Subsitute the above for [Sales] in every calc.

Cheers!

Carl Slifer

InterWorks

1 of 1 people found this helpful