trying to output mean values that were calculated into excel.

i have about 40 values that were calcualted but would only like to output 10 out of the 40. i calculated the mean, Standard deviation and addition, how would i only take the mean values and output them into excel?

[Mathieu NOE]

to output 10 out of the 40 : define the index of interest => your choice

to save the result to excel : see writetable or xlswrite doc

[isamh]

so if i have Mean_1 - Mean_10, how would i get a table with the values under those variables?

[isamh]

i want to do an excel sheet that is 3x10

mean_speed mean_force mean_power

mean_1

.

.

.

mean_10

Answer 1

[KSSV]

May be you want to find the mean for every four elements and get 10 means. See the below:

A = rand(1,40) ;  % random data for demo 
M = mean(reshape(A,10,[]),2) ; % reshape and get mean 

If you want t0 select any 10 elements randomly, use:

A = rand(1,40) ; 
M = A(randperm(40,10)) ;

If you want to select first 10 elements

A = rand(1,40) ; 
M = A(1:10) ; 

Use writetable, xlswrite to write array M into xls file.

[isamh]

did you see the way i set it up above? how would i set this up?

and for:

A = rand(1,40)

do i add the variable names with ' '?

for example, A = rand('mean_1'...)

how would i get all three columns though?

[KSSV]

Read about table. It is easy to get table.

[isamh]

i did the table, how can i get them ontop of each other?