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

[#1]

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! 

[#2]

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

[#3]

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, . ) )

[#4]

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! 

[#5 · Accepted solution]

One option is to use matrix calculations (as a reminder JMP is Not a Spreadsheet ) and Data table subscripting 

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#