1 2 Previous Next 21 Replies Latest reply on Apr 11, 2018 2:29 PM by Jim Dehner Go to original post
• ###### 15. Re: How to calculate sum of square of each element in the group

well, question is same just that I added more dimensions to this than the original question.

Anyway, thanks for your suggestion. I will wait for sometime, if I don't get answers - will close this and open a new thread.

• ###### 17. Re: How to calculate sum of square of each element in the group

Oh

Attaching again , followed instructions given by Jim.

Hopefully you can now see it.

• ###### 19. Re: How to calculate sum of square of each element in the group

Deepak Rai / Jim Dehner - Finally uploading tableau with dummy data. Earlier, I was connecting to a google sheet and no matter what I did it would ask for user credentials for google sheets.

Please find attached tableau. I have only one question :

I am using the formula Jim gave and it is giving me correct value when I have three labels in a test but when there are two it gives me wrong values as noted below.

Formula is generic, so should give correct values irrespective of how many tests are there. Could you please tell me where am I going wrong?

For Test_name = T1 : calculation of stddev_puchasers_lift is correct

For Test_name = T2 : calculation of stddev_puchasers_lift is not correct, when calculating manually i am getting this value as 0.0425

• ###### 20. Re: How to calculate sum of square of each element in the group

Jim Dehner / Deepak Rai - are you guys able to open it now ?

• ###### 21. Re: How to calculate sum of square of each element in the group

Hi Uday,

I can open, but I am not picking it up, because what I gave you was based upon SQUARE, but you say that Jim's method is closer to what you need. So, I would suggest Jim to finish it.

Thanks

Deepak

• ###### 22. Re: How to calculate sum of square of each element in the group

Ok

Sorry I got totally lost in your terminology so I recreated the formulas you see below

this is your original formula now JD yur original formula              SQRT(([purchasers_rate]*(1-[purchasers_rate]))/SUM([Bucket Size]))

next is JD square of the original formula                                        POWER([JD yur original sqrt pr /bucket size],2)

next is the JD sum of the square formula                                        { FIXED [Test Name]:sum({ INCLUDE  [Variation Type]:sum([square std dev PR] )} )  }

Last is the JD sqrt of the sum of the squares                                  power([JD sum of sqrs by test],.5)

it returns this Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 2 Previous Next