The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar
Highlighted
FN
FN
Level V

Statistics for time aggregated results in JMP

I have a table with a column that is my time index.

 

This column is in minutes and I want to calculate statistics aggregating the results but per hour, for example.

 

How to do that?

 

1 REPLY 1
Highlighted
FN
FN
Level V

Re: Statistics for time aggregated results in JMP

One way to do this I found:

 

Tables>Summary and Grouping by Date and Hour (in this order).

 

To have a column with the complete date, and not splitted by two: include in the Statistics min(Date), being median or max are also possible.

 

Here is a simpler example aggregating the Lead Production Data table by year.

jmp_aggregation.png

 

Article Labels

    There are no labels assigned to this post.