cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
marshmadness98
marshmadness98
Level II

Going from Quarterly to Yearly averages

Created: Jul 20, 2021 01:24 PM  |  Last Modified: Jun 10, 2023 4:34 PM (767 views)

Hi! I have average water level elevation by quarter, but I am trying to get yearly averages. Is there a conditional statement or formula I could use to do this, even if every year doesn't have an even four quarters?

0 Kudos
1 REPLY 1
txnelson
Super User txnelson
Super User

Re: Going from Quarterly to Yearly averages

Jul 20, 2021 02:58 PM (751 views)  |  Posted in reply to message from marshmadness98 07-20-2021
If your quarterly water level elevation data is in a single column, then one can use Tables=> Summary to calculate the mean of the quarterly averages.
If your data are laid out with each quarter in a separate column, then you will need to create a new column that has the formula
mean(qt1,qt2,qt3,qt4),
where qt1-qt4 need to be replaced with the actual names of the columns have have the average data.
Jim
0 Kudos