Average of Column Values with Condition

Hello, all!

I'm currently trying to bin a large CTD data file and I know I must use a for loop to create the average values, but I'm not sure how to implement it. For example, I have about 100 lines of data for depth "2" that are 2.3455, 2.3434, 2.4532 and so on. I have this for depth 2 meters - 751 meters. I would like to average all the values together that begin with the same number (all of the "2"s, "3"s, etc.). Thanks in advance!

Answer 1

[Image Analyst]

Why not just set up edges and take the histogram? Then take the center bin value and multiply it by the count?

If you can't figure it out, let me know.

[Jennifer Holifield]

To be honest, im not sure what you mean by setting up the edges. I am familiar with taking the histogram, but I'm stuck on how to limit it to similar values.

Answer 2

[Jeff Miller]

if your data are in a table, maybe you can use grpstats something like this:

tbl.IntDepth = trunc(tbl.depth);  % assuming depth values like 2.3455, etc
avgs = grpstats(tbl,'IntDepth','mean','DataVars',{'depth'});  % to get the average depth within each range