How to re-arrange data and find mean of alike entries
1 次查看(过去 30 天)
显示 更早的评论
Hi,
I have data library (RecipeandHTDList) and main sheet contains RecipeList and the numeric data. I want to re-arrange the table RecipeList, in this I don't have HTD name, I want add corresponding HTD name to the Recipe list, my rearranging final table is FinaldataTable. Then, I want to filter the data based on HTD name, and find the mean, Stdv, max, & min of each HTD name. Finally, I want create a result table which contains HTD name(column1), Recipe Name(column2), Mean(Column3), Max(column4), Min(column5), Stdev (column6). Please someone kindly help me. Many many thanks in advance.
I have attached my input data, final resulting data table (for your reference).
0 个评论
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Descriptive Statistics and Visualization 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!