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

3 views (last 30 days)
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 Comment
Arif Hoq
Arif Hoq on 9 Feb 2023
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)

Sign in to comment.

Accepted Answer

Amal Raj
Amal Raj on 9 Feb 2023
Edited: Amal Raj on 9 Feb 2023
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)
  2 Comments
Macy
Macy on 9 Feb 2023
Thank you @Amal Raj! When I use the skew function, I get this error:
'skewness' requires Statistics and Machine Learning Toolbox.
Do you know what that issue means?
Macy
Macy on 9 Feb 2023
@Amal Raj nevermind I just have to install the toolbox! Thanks!

Sign in to comment.

More Answers (0)

Categories

Find more on Statistics and Machine Learning Toolbox in Help Center and File Exchange

Products


Release

R2022b

Community Treasure Hunt

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

Start Hunting!