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

1 visualización (últimos 30 días)
Mekala balaji
Mekala balaji el 18 de Feb. de 2015
Editada: Mekala balaji el 18 de Feb. de 2015
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).

Respuestas (0)

Categorías

Más información sobre Descriptive Statistics and Visualization en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by