I need to find the 10th percentile of 24 minute sections of logged data that spans 24 hours, in 1 second samples.
Every sample has its own row.
There are 1440 rows in a 24 minute period (24 minutes x 60 seconds)
I am finding the 10th percentile of each 24 minute period.
There is 24 hours of data in total that I need to process, meaning I need to perform this calculation 60 times.
I can use the formula =PERCENTILE(F2:F1441,0.9) to find the 10th percentile of the first 24 minute period (Headers are row 1, data starts on row 2, in column F)
I can then manually write the formula =PERCENTILE(F1442:F2882,0.9) to find the 10th percentile of the next period.
My question is: how do I automate this process so that my end result is a column of 60 cells, each cell containing the 10th percentile of consecutive 24 minute periods (each 24 min period being a range of data samples spanning 1440 rows)?
Every sample has its own row.
There are 1440 rows in a 24 minute period (24 minutes x 60 seconds)
I am finding the 10th percentile of each 24 minute period.
There is 24 hours of data in total that I need to process, meaning I need to perform this calculation 60 times.
I can use the formula =PERCENTILE(F2:F1441,0.9) to find the 10th percentile of the first 24 minute period (Headers are row 1, data starts on row 2, in column F)
I can then manually write the formula =PERCENTILE(F1442:F2882,0.9) to find the 10th percentile of the next period.
My question is: how do I automate this process so that my end result is a column of 60 cells, each cell containing the 10th percentile of consecutive 24 minute periods (each 24 min period being a range of data samples spanning 1440 rows)?
