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

2 visualizaciones (últimos 30 días)
Macy
Macy el 9 de Feb. de 2023
Comentada: Macy el 9 de Feb. de 2023
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 comentario
Arif Hoq
Arif Hoq el 9 de Feb. de 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)

Iniciar sesión para comentar.

Respuesta aceptada

Amal Raj
Amal Raj el 9 de Feb. de 2023
Editada: Amal Raj el 9 de Feb. de 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 comentarios
Macy
Macy el 9 de Feb. de 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 el 9 de Feb. de 2023
@Amal Raj nevermind I just have to install the toolbox! Thanks!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Statistics and Machine Learning Toolbox en Help Center y File Exchange.

Productos


Versión

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by