nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate Average by two groups

sweetycha

Hi All

How to calculate average of total visit by location and by day of the week.

like average of all Sundays total visits by facility and all Mondays total visits by facility (attached sample)

Thank you

average.PNG

Accepted answers

Thierry_S

Hi,
The Column Mean function lets you add as many "By" parameters as you need.
In the Formula edit window, choose Statistical > Col Mean, select the column containing the data, press "," to add the "By" parameter, amd repeat the last step as needed.
I hope that this is what you were looking for.

Best regards,
TS

All comments

Thierry_S

sweetycha

Thank you..

sweetycha

Hi TS

I imported the data in duration format from excel and in JMP it is showing as time format. I tried to convert in col info in the duration. It is not working as planned.

Please advise. After that I need to calulate an average by two groups

time jmp.PNG

Thierry_S

Hi,
I'm not sure that it will help but have your tried to change the Format of your duration column to "Best" which will represent the data in decimal format. Ideally, it would be easiest for me to test a couple of approaches if you could share an example of the data (nothing confidential or proprietary).

sweetycha

Thank you

Attached is the sample file where G H I are duration ( hours and min) and I would like to calculate mean by site and day

JMP SAMPLE.xlsx