mean of each column entry

5 visualizzazioni (ultimi 30 giorni)
Blazej Dobija
Blazej Dobija il 6 Feb 2021
Commentato: Cris LaPierre il 6 Feb 2021
I have 2 arrays colA and colB, how can I get for example mean or other statistic of each entry of colB
I need to get something like this:
x = [-3084 -3085 -3086 -3087 etc]
y = [meanOfEachColB(-3084) meanOfEachColB(-3085) meanOfEachColB(-3086) meanOfEachColB(-3087) etc]
colA colB
+13884 -3084
+13884 -3082
+13864 -3084
+13892 -3086
+13848 -3084
+13776 -3086
+13940 -3085
+13792 -3085
+13856 -3084
+13908 -3082
+13888 -3086
+13884 -3085
+14004 -3086
+13860 -3084
+13860 -3082
+13856 -3082
+13860 -3083
+13840 -3085
+13908 -3083
+13772 -3084
+13764 -3085
+13920 -3085
+13904 -3086
+13944 -3085
+13900 -3086
+13912 -3086
+13852 -3086
+13964 -3087
+13944 -3083
+13908 -3085
+13848 -3085
+13860 -3083
+13984 -3084
+13936 -3086

Risposta accettata

Cris LaPierre
Cris LaPierre il 6 Feb 2021
I'd look into grpstats. See this example.
meanA = grpstats(colA,colB,'mean')
Another option is to use groupsummary. This might be helpful because it also returns the groups.
[meanA,grpB] = groupsummary(colA,colB,'mean')
  2 Commenti
Blazej Dobija
Blazej Dobija il 6 Feb 2021
Modificato: Blazej Dobija il 6 Feb 2021
[meanA,grpB] = groupsummary(colA,colB,'mean')
this work great, thanks
PS. it there any similar function for "mean 95 confidence interval"?
Cris LaPierre
Cris LaPierre il 6 Feb 2021
I'm not aware of a mean function in MATLAB that also returns a confidence interval. However, you can do this manually using the mean and standard deviation of each group. Perhaps this post can help you get started.

Accedi per commentare.

Più risposte (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by