Info

この質問は閉じられています。 編集または回答するには再度開いてください。

trying to output mean values that were calculated into excel.

1 回表示 (過去 30 日間)
isamh
isamh 2020 年 10 月 15 日
閉鎖済み: MATLAB Answer Bot 2021 年 8 月 20 日
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?
  3 件のコメント
isamh
isamh 2020 年 10 月 15 日
so if i have Mean_1 - Mean_10, how would i get a table with the values under those variables?
isamh
isamh 2020 年 10 月 15 日
i want to do an excel sheet that is 3x10
mean_speed mean_force mean_power
mean_1
.
.
.
mean_10

回答 (1 件)

KSSV
KSSV 2020 年 10 月 15 日
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.
  3 件のコメント
KSSV
KSSV 2020 年 10 月 15 日
Read about table. It is easy to get table.
isamh
isamh 2020 年 10 月 15 日
i did the table, how can i get them ontop of each other?

この質問は閉じられています。

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by