Weighting within Tabulate

[#1]

Hello,

Is it possible to calculate a weighted mean within Tabulate?

Thanks,
Stefan

[#2 · Accepted solution]

Hi Stefan,

You can pre-assign the Weight role to your weighting column in the data table.

To do that use the columns panel on the left side of the data table and right-click on your weighting column and choose "Pre-select Role -> Weight".

Then Tabulate will use that column when calculating statistics.

Jeff

[#3]

Fantastic-- thanks, Jeff!

Stefan

[#4]

Dear Jeff,

Could you please specify it?

Let's say we have the following table:

How to calculate the weighted mean of ADR as the next column to ADR??

Thank you

Date		Revenue Sold	Rooms Sold	ADR
Monday		$ 60,000	200	$300.00
Tuesday		$ 96,000	300	$320.00
Mean ADR		$156,000	500	$312.00