Weighting within TabulateHello,
Is it possible to calculate a weighted mean within Tabulate?
Thanks,
StefanRe: Weighting within Tabulate<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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
| |
| Revenue Sold | Rooms Sold | ADR |
Monday | $ 60,000 | 200 | $300.00 |
Tuesday | $ 96,000 | 300 | $320.00 |
Mean ADR | $156,000 | 500 | $312.00 |
Re: Weighting within TabulateFantastic-- thanks, Jeff!
StefanRe: Weighting within TabulateHi 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
