How do I make a simple table in MatLab? Skew function?

Question

Macy 2023-2-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1909345-how-do-i-make-a-simple-table-in-matlab-skew-function

评论： Macy 2023-2-9

采纳的回答： Amal Raj

Data1.xlsx

在 MATLAB Online 中打开

Hello. How can I make a table that displays the mean and median of "students" and "courses"?

Also, is there a way to calculate skew for "students" and "courses"?

table_a = readtable('Data1.xlsx')
table_a = 9×4 table
    month    year    students    courses
    _____    ____    ________    _______

      1      2000       12          4   
      2      2000       14          6   
      3      2000       13          5   
      4      2000       11          6   
      5      2000       17          8   
      6      2000       14          7   
      7      2000       10          5   
      8      2000        9          3   
      9      2000       16          4   
mean (table_a.students);
median (table_a.students);
mean (table_a.courses);
median (table_a.courses);
%Calculate skew?
%Make/display a table of mean, median, and skew for students and courses

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

Arif Hoq 2023-2-9

在 MATLAB Online 中打开

table_a = readtable('Data1.xlsx')
average=mean(table_a.students)
median_value=median(table_a.courses)
skew_students=skewness(table_a.students)
skew_courses=skewness(table_a.courses)

请先登录，再进行评论。

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

Answer 1

Amal Raj 2023-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1909345-how-do-i-make-a-simple-table-in-matlab-skew-function#answer_1167180

编辑：Amal Raj 2023-2-9

在 MATLAB Online 中打开

table_a = readtable('Data1.xlsx');
% Calculate mean, median, and skew
mean_students = mean(table_a.students);
median_students = median(table_a.students);
skew_students = skewness(table_a.students);
mean_courses = mean(table_a.courses);
median_courses = median(table_a.courses);
skew_courses = skewness(table_a.courses);
% Create table
table_data = {'Students', mean_students, median_students, skew_students;
              'Courses', mean_courses, median_courses, skew_courses};
table = cell2table(table_data, 'VariableNames', {'Variable', 'Mean', 'Median', 'Skew'});
% Display table
disp(table)