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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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 (11651 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 (12350 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 (12351 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 (11196 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 (11196 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