How to re-arrange data and find mean of alike entries
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (0)
Ver también
Categorías
Más información sobre Descriptive Statistics and Visualization en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!