
1. Re: Help! Create a proportional ztest calculation for "weighted data" in tableau?
Bora Beran Apr 11, 2017 1:13 PM (in response to Yamil Medina)The document you attached talks about computing weighted variance estimates. Is what you're asking for how to compute the weighted variance so you can use it for ztest (which you already know how to do in Tableau)?
If so weighted variance can be written as an LOD expression. If you're doing it for the entire table it can be written in the following form.
First calculated field is weighted mean, let's call it Wmean
{SUM([Weight]*[X])/SUM([Weight])}
Then the variance calculation SPSS uses (relies on the Wmean calculation)
SUM([Weight]*([X][Wmean])^2)/SUM([Weight]1)
Note that this uses a fixed LOD expression for Wmean that computes the mean of x over the entire table
You can learn more about level of detail (LOD) expressions here
What’s new in Tableau 9.0? Part 2 – Level of Detail Expressions  Bora Beran