MEAN OF A VARIABLE WITH RESPECT TO OTHER VARIABLES

Question

SAPTORSHEE KANTO 2024-8-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2146874-mean-of-a-variable-with-respect-to-other-variables

评论： SAPTORSHEE KANTO 2024-8-22

I would like to find mean of the variable a25 other variable a6a7 and by year .

input int(year a6a7) long a25
121 12000
121 30000
121 13000
121 14000
121 15000
121 15000
121 15000
121 20000
121 15000
121  8000
121 10000
121 14000
121 35000
121  6000
121  2000
121 10000
17 15000
17 15000
17 12000
17 15000
17 15000
17  8000
17  7000
17  5000
121 10000
121 10000
121  6000
121  8000
121  8000
121 12000
121 10000
121 10000
121 16000
121  8000
121 12000
121 15000
121 15000
121 15000
121  8000
121 10000
121 10000
121  8000
121  6000
121  6000
121  6000
121 10000
121 10000
121 10000
121  7000
121  8000
121 10000
121 10000
121 15000
121  5000
121 10000
121 10000
17 25000
17  8000
17  8000
17 10000
17  7000
17  6000
17  3500
17  8000
17 20000
17 16000
17 16000
17 14000
17 25000
17 15000
17 16000
17 16000
121 12000
121 15000
121 12000
121 12000
121 13000
121 12000
121 14000
121  8000
120  5000
120  5000
120  4000
120  5000
120  3000
120  4000
120  4000
120  4000
119  6000
119  6000
119  4000
119  5000
119  5000
119  7000
119  7000
119  6000
16 20000
16 15000
16 20000
16 15000
end
[/CODE]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Voss 2024-8-21

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2146874-mean-of-a-variable-with-respect-to-other-variables#answer_1502704

https://www.mathworks.com/help/matlab/ref/double.groupsummary.html

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

SAPTORSHEE KANTO 2024-8-22

Thank you very much.

请先登录，再进行评论。

Answer 2

Ronit 2024-8-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2146874-mean-of-a-variable-with-respect-to-other-variables#answer_1502989

在 MATLAB Online 中打开

datafile.mat

Hello Saptorshee,

To calculate the mean of the variable a25 grouped by the variables a6a7 and year in MATLAB, you can use the groupsummary function. First, you'll need to create a table from your data, then use this function to compute the mean.

% Load and extract the data matrix from the .mat file
loadedData = load("datafile.mat");
data = loadedData.data;
% Convert the data to a table
T = array2table(data, 'VariableNames', {'Year', 'A6A7', 'A25'});
% Use groupsummary to calculate the mean of A25 grouped by Year and A6A7
result = groupsummary(T, {'Year', 'A6A7'}, 'mean', 'A25');
disp(result);
    Year    A6A7    GroupCount    mean_A25
    ____    ____    __________    ________

    2017     16          4         17500  
    2017     17         24         12729  
    2017    119          8          5750  
    2017    120          8          4250  
    2017    121         56         11536  

Here is the documentation link of groupsummary function for more details: https://www.mathworks.com/help/matlab/ref/double.groupsummary.html

I hope it helps you query!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

SAPTORSHEE KANTO 2024-8-22

Thank you very much indeed.

请先登录，再进行评论。

MEAN OF A VARIABLE WITH RESPECT TO OTHER VARIABLES

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（2 个）

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

MEAN OF A VARIABLE WITH RESPECT TO OTHER VARIABLES

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（2 个）

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论