topic Re: Weighting within Tabulate in Discussions https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/837#M837 <HTML><HEAD></HEAD><BODY><P>Dear Jeff,</P><P>Could you please specify it?</P><P>Let's say we have the following table:</P><P>How to calculate the weighted mean of ADR as the next column to ADR??</P><P>Thank you</P><P></P><P></P><TABLE><TBODY><TR><TD style="border-style: solid; border-top-width: 0.583000pt; border-top-color: rgb(0.000000%, 45.662100%, 61.643836%); border-right-width: 0.000000pt; border-bottom-width: 4.919000pt; border-bottom-color: rgb(0.000000%, 44.680851%, 61.702128%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"> </TD><TD colspan="4" rowspan="1" style="border-style: solid; border-top-width: 0.583000pt; border-top-color: rgb(0.000000%, 45.662100%, 61.643836%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.454545%, 61.616162%); border-bottom-width: 4.919000pt; border-bottom-color: rgb(0.000000%, 45.238095%, 61.904762%); border-left-width: 0.000000pt;"> </TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 44.680851%, 61.702128%); border-right-width: 0.500000pt; border-right-color: rgb(0.000000%, 45.408163%, 61.734694%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.177665%, 61.421320%);"><DIV class="column"><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">Date </SPAN></P><P></P></DIV></TD><TD style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 44.680851%, 61.702128%); border-right-width: 0.500000pt; border-right-color: rgb(0.000000%, 45.408163%, 61.734694%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"><P class="column"></P><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">Revenue Sold </SPAN></P></TD><TD style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 44.680851%, 61.702128%); border-right-width: 0.500000pt; border-right-color: rgb(0.000000%, 45.408163%, 61.734694%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"><P class="column"></P><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">Rooms Sold </SPAN></P></TD><TD style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 43.478261%, 60.869565%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.000000%, 61.000000%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"><P class="column"></P><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">ADR </SPAN></P></TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">Monday </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$ 60,000 </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">200 </SPAN></P></TD><TD style="border-style: solid; border-top-width: 0.500000pt; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.081967%, 61.475410%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.679012%, 61.728395%);"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$300.00 </SPAN></P></TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">Tuesday </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$ 96,000 </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">300 </SPAN></P></TD><TD style="border-style: solid; border-top-width: 0.500000pt; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.081967%, 61.475410%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.679012%, 61.728395%);"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$320.00 </SPAN></P></TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">Mean ADR </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">$156,000 </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">500 </SPAN></P></TD><TD style="border-style: solid; border-top-width: 0.500000pt; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.081967%, 61.475410%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.679012%, 61.728395%);"><P class="column"></P><P><SPAN style="font-size: 8.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">$312.00 </SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 06 Feb 2015 16:35:07 GMT saitcopuroglu 2015-02-06T16:35:07Z Weighting within Tabulate https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/834#M834 Hello,<BR /><BR />Is it possible to calculate a weighted mean within Tabulate?<BR /><BR />Thanks,<BR />Stefan Tue, 20 Oct 2009 19:24:48 GMT https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/834#M834 sfkeydel 2009-10-20T19:24:48Z Re: Weighting within Tabulate https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/835#M835 Hi Stefan,<BR /><BR />You can pre-assign the Weight role to your weighting column in the data table. <BR /><BR />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 -&gt; Weight".<BR /><BR />Then Tabulate will use that column when calculating statistics.<BR /><BR />Jeff Tue, 20 Oct 2009 23:39:57 GMT https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/835#M835 Jeff_Perkinson 2009-10-20T23:39:57Z Re: Weighting within Tabulate https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/836#M836 Fantastic-- thanks, Jeff!<BR /><BR />Stefan Wed, 21 Oct 2009 00:14:58 GMT https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/836#M836 sfkeydel 2009-10-21T00:14:58Z Re: Weighting within Tabulate https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/837#M837 <HTML><HEAD></HEAD><BODY><P>Dear Jeff,</P><P>Could you please specify it?</P><P>Let's say we have the following table:</P><P>How to calculate the weighted mean of ADR as the next column to ADR??</P><P>Thank you</P><P></P><P></P><TABLE><TBODY><TR><TD style="border-style: solid; border-top-width: 0.583000pt; border-top-color: rgb(0.000000%, 45.662100%, 61.643836%); border-right-width: 0.000000pt; border-bottom-width: 4.919000pt; border-bottom-color: rgb(0.000000%, 44.680851%, 61.702128%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"> </TD><TD colspan="4" rowspan="1" style="border-style: solid; border-top-width: 0.583000pt; border-top-color: rgb(0.000000%, 45.662100%, 61.643836%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.454545%, 61.616162%); border-bottom-width: 4.919000pt; border-bottom-color: rgb(0.000000%, 45.238095%, 61.904762%); border-left-width: 0.000000pt;"> </TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 44.680851%, 61.702128%); border-right-width: 0.500000pt; border-right-color: rgb(0.000000%, 45.408163%, 61.734694%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.177665%, 61.421320%);"><DIV class="column"><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">Date </SPAN></P><P></P></DIV></TD><TD style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 44.680851%, 61.702128%); border-right-width: 0.500000pt; border-right-color: rgb(0.000000%, 45.408163%, 61.734694%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"><P class="column"></P><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">Revenue Sold </SPAN></P></TD><TD style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 44.680851%, 61.702128%); border-right-width: 0.500000pt; border-right-color: rgb(0.000000%, 45.408163%, 61.734694%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"><P class="column"></P><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">Rooms Sold </SPAN></P></TD><TD style="border-style: solid; border-top-width: 4.919000pt; border-top-color: rgb(0.000000%, 43.478261%, 60.869565%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.000000%, 61.000000%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.408163%, 61.734694%);"><P class="column"></P><P><SPAN style="font-size: 9.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">ADR </SPAN></P></TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">Monday </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$ 60,000 </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">200 </SPAN></P></TD><TD style="border-style: solid; border-top-width: 0.500000pt; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.081967%, 61.475410%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.679012%, 61.728395%);"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$300.00 </SPAN></P></TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">Tuesday </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$ 96,000 </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">300 </SPAN></P></TD><TD style="border-style: solid; border-top-width: 0.500000pt; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.081967%, 61.475410%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.679012%, 61.728395%);"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">$320.00 </SPAN></P></TD></TR><TR><TD colspan="2" rowspan="1" style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8pt; font-family: NewsGothicSB;">Mean ADR </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">$156,000 </SPAN></P></TD><TD style="border-style: solid; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-color: rgb(0.000000%, 45.679012%, 61.728395%); border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-color: rgb(0.000000%, 45.679012%, 61.728395%); border-width: 0.500000pt;"><P class="column"></P><P><SPAN style="font-size: 8.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">500 </SPAN></P></TD><TD style="border-style: solid; border-top-width: 0.500000pt; border-top-color: rgb(0.000000%, 45.882353%, 61.960784%); border-right-width: 0.989000pt; border-right-color: rgb(0.000000%, 45.081967%, 61.475410%); border-bottom-width: 0.500000pt; border-bottom-color: rgb(0.000000%, 45.882353%, 61.960784%); border-left-width: 0.500000pt; border-left-color: rgb(0.000000%, 45.679012%, 61.728395%);"><P class="column"></P><P><SPAN style="font-size: 8.000000pt; font-family: 'NewsGothicStd'; font-weight: bold;">$312.00 </SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 06 Feb 2015 16:35:07 GMT https://community.jmp.com/t5/Discussions/Weighting-within-Tabulate/m-p/837#M837 saitcopuroglu 2015-02-06T16:35:07Z