User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
sfkeydel
sfkeydel
Level III

Weighting within Tabulate

Oct 20, 2009 03:24 PM (11794 views)
Hello,

Is it possible to calculate a weighted mean within Tabulate?

Thanks,
Stefan
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager
Solution

Re: Weighting within Tabulate

Oct 20, 2009 07:39 PM (12493 views)  |  Posted in reply to message from sfkeydel 10-20-2009
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
-Jeff

View solution in original post

3 REPLIES 3
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager
Solution

Re: Weighting within Tabulate

Oct 20, 2009 07:39 PM (12494 views)  |  Posted in reply to message from sfkeydel 10-20-2009
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
-Jeff
sfkeydel
sfkeydel
Level III

Re: Weighting within Tabulate

Oct 20, 2009 08:14 PM (11339 views)  |  Posted in reply to message from Jeff_Perkinson 10-20-2009
Fantastic-- thanks, Jeff!

Stefan
0 Kudos
saitcopuroglu
saitcopuroglu
Level IV

Re: Weighting within Tabulate

Feb 6, 2015 11:35 AM (11339 views)  |  Posted in reply to message from sfkeydel 10-20-2009

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

0 Kudos

Recommended Articles