How to calculate weighted averages in Tableau

In this silent video, you'll learn how to calculate weighted averages in order to compare the results from using a weighted average versus an unweighted average to summarize the data.

Read the full article here: Weighted Averages Calculation - kb.tableau.com/articles/howto/weighted-averages…

- - - - - - - - - - - - - -

The weighted average of the results is calculated by factoring in the sample size with the rate of affirmative answers. This helps to create a more even comparison between the two test results. The general formula for calculating a weighted average is as follows: SUM (Weight * Value) / SUM (Weight)

1. Create a calculated field similar to: SUM([Frequency]*[Sample Size])/SUM([Sample Size])
2. Confirm that the status message indicates that the formula is valid, and then click OK.

Related solutions:
Get Started with Calculations in Tableau - onlinehelp.tableau.com/current/pro/desktop/en-u…

- - - - - - - - - - - - - -

Subscribe to the Tableau YouTube channel here: youtube.com/subscription_center?add_user=tablea…

Free Trial of Tableau: tableau.com/products/trial