How to re-arrange data and find mean of alike entries
1 view (last 30 days)
Show older comments
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 Comments
Answers (0)
See Also
Categories
Find more on Probability Distributions in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!