How to re-arrange data and find mean of alike entries

1 visualizzazione (ultimi 30 giorni)
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).

Risposte (0)

Categorie

Scopri di più su Descriptive Statistics and Visualization in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by