https://community.jmp.com/t5/Discussions/Going-from-Quarterly-to-Yearly-averages/m-p/402643#M65343 If your quarterly water level elevation data is in a single column, then one can use Tables=&gt; Summary to calculate the mean of the quarterly averages.<BR />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<BR /> mean(qt1,qt2,qt3,qt4), <BR />where qt1-qt4 need to be replaced with the actual names of the columns have have the average data. Tue, 20 Jul 2021 18:58:27 GMT txnelson 2021-07-20T18:58:27Z https://community.jmp.com/t5/Discussions/Going-from-Quarterly-to-Yearly-averages/m-p/402580#M65337 <P>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?</P> Sat, 10 Jun 2023 23:34:10 GMT https://community.jmp.com/t5/Discussions/Going-from-Quarterly-to-Yearly-averages/m-p/402580#M65337 marshmadness98 2023-06-10T23:34:10Z https://community.jmp.com/t5/Discussions/Going-from-Quarterly-to-Yearly-averages/m-p/402643#M65343 If your quarterly water level elevation data is in a single column, then one can use Tables=&gt; Summary to calculate the mean of the quarterly averages.<BR />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<BR /> mean(qt1,qt2,qt3,qt4), <BR />where qt1-qt4 need to be replaced with the actual names of the columns have have the average data. Tue, 20 Jul 2021 18:58:27 GMT https://community.jmp.com/t5/Discussions/Going-from-Quarterly-to-Yearly-averages/m-p/402643#M65343 txnelson 2021-07-20T18:58:27Z