multiple data files from multiple measurements, averaging the measurement results

Rolf_Rank — Sat, 10 Jun 2023 23:55:29 GMT

Dear Community,

I have data files from n multiple measurements (x, y, z, Mx, My, Mz) as separate jmp tables. They are identical regarding the measurement points (x, y, z), i.e. they have the same no. of cols and rows.

table 1 = 1. measurement: x, y, z, Mx.(1), My.(1), Mz(1)

table 2 = 2. measurement: x, y, z, Mx.(2), My.(2), Mz(2)

...

table n = n. measurement: x, y, z, Mx.(n), My.(n), Mz(n)

I want to do calculations like Mx.avg = mean(Mx.(1), ... Mx.(n)) and create a result table like x, y, z, Mx.avg, My.avg, Mz.avg.

Any hints?

Thank you!

Re: multiple data files from multiple measurements, averaging the measurement results

txnelson — Tue, 18 Oct 2022 13:40:20 GMT

Typically one needs to have all of the data that are to be summarized to be in a single data table. Then platforms such as Tabulate or Summary will be able to summarize across all of the data.

JMP can easily put the tables together.

The notation you are using to describe you data tables is somewhat confusing to me. Would you be able to provide a couple of examples of actual data tables?

topic Re: multiple data files from multiple measurements, averaging the measurement results in Discussions

multiple data files from multiple measurements, averaging the measurement results

Re: multiple data files from multiple measurements, averaging the measurement results