topic Re: How to calcualte the average values from selected cells/rows/columns? in Discussions

How to calcualte the average values from selected cells/rows/columns?

Fruit325 — Thu, 25 Apr 2024 16:25:22 GMT

Hi, I'm wondering what would be the quickest way to calculate the average values from seleted rows/columns/cells on JMP 17? The average value from column 1 to column 6

Thank you!

Re: How to calcualte the average values from selected cells/rows/columns?

jthi — Thu, 25 Apr 2024 16:31:00 GMT

For what do you want the average for? Rows, Columns or Cells? All of these require different methods. For columns Summary, Tabulate or Col Mean formula are good options

Re: How to calcualte the average values from selected cells/rows/columns?

txnelson — Thu, 25 Apr 2024 17:43:02 GMT

To add to Jarmo's answer, you can apply a Data Filter on your data to select the rows you want and then use the Summary

Tables=>Summary

or the Tabulate Platform

Analyze=>Tabulate

to get the statistics for the selected rows.

If you want to create a new column and only show in the new column the mean of selected rows, the below formula will work

Col Mean( If( Selected(), :your column, . ) )

Re: How to calcualte the average values from selected cells/rows/columns?

Fruit325 — Fri, 26 Apr 2024 03:53:21 GMT

Thanks a lot!

For example, I have a 3x3 table. I want to calculate final average value and maximum value for the top-left 4 cells from (0,0) to (2,2).

Is there any easy way to do that? Thank you!

Re: How to calcualte the average values from selected cells/rows/columns?

jthi — Fri, 26 Apr 2024 04:22:41 GMT

One option is to use matrix calculations (as a reminder ) and

Names Default To Here(1);

dt = New Table("Untitled 2",
	Add Rows(3),
	Compress File When Saved(1),
	New Column("Column 1", Numeric, "Continuous", Format("Best", 12), Set Values([1, 2, 2])),
	New Column("Column 2", Numeric, "Continuous", Format("Best", 12), Set Values([3, 4, 3])),
	New Column("Column 3", Numeric, "Continuous", Format("Best", 12), Set Values([7, 8, 9]))
);

myvals = dt[1::2, 1::2];
myavg = Mean(myvals);
mymax  = Max(myvals);

https://www.jmp.com/support/help/en/17.2/#page/jmp/additional-ways-to-access-data-values.shtml#

Re: How to calcualte the average values from selected cells/rows/columns?

BHarris — Wed, 21 Aug 2024 18:54:54 GMT

Great answers from jthi and txnelson -- here's another:

Select the cells you're interested in, then copy/paste them into a new data table. Further edit if needed, then Table->Stack the columns into a single column, then run a distribution analysis on that column and it will give you all the common statistics on that column.

Re: How to calcualte the average values from selected cells/rows/columns?

ron_horne — Thu, 22 Aug 2024 08:37:53 GMT

@BHarris ,
i would say this is perhaps the most JMPish way to do this.
snitching the script from the log windows is also useful for further generalisation if this needs to be done repeatedly with different selections.