For tasks 1.1-1.6, download the Excel file \"workshop.xlsx\". Drag and drop the
ID: 3723129 • Letter: F
Question
For tasks 1.1-1.6, download the Excel file "workshop.xlsx". Drag and drop the file into the current folder. Task 1.1 Read the data into MatLab. Use this line of code at the start of the script: xyz = xlsread('workshop.xlsx') ; Task 1.2 (a) Find the dimensions of the array xyz. (b) Find the number of elements in the array xyz. Task 1.3 (a) Find the value of the 11th row, 3rd column. (b) Find the value of the 31st row, 2nd column. Task 1.4 Find the minimum value of z. b)Find the maximum value of y. Task 1.5 (a) Find the sum of only the third column. (b) Find the average values of y from rows 1 to 20, inclusive.Explanation / Answer
As the question has more than 4 sub parts ,we are supposed to answer around 4 or more.so ill be answering first few questions as you havent mentioned any question specifically
(1.2)
(a)
d = size(X) returns the sizes of each dimension of array X in a vector d with ndims(X) elements.
or
[m,n] = size(X) returns the size of matrix X in separate variables m and n.
(b)
n = numel(A) returns the number of elements, n, in array A
(1.3)
(a)
(1.4)
(a) if xyz were rows respectively
min(xyz(3,:))
(b) max(2,:)
(1.5)
(a) sum(xyz(:,3))
(b) mean(xyz(1:20,:))