( MATLAB PROGRAMMING) https://drive.google.com/file/d/0B5SqE-vMokXEUFliYmktSHRHN
ID: 3841783 • Letter: #
Question
(MATLAB PROGRAMMING)
https://drive.google.com/file/d/0B5SqE-vMokXEUFliYmktSHRHNWM/view
(Follow This Link and Download the Excel File)
Using the 'matlabtext.xls' file, import the data using the uiimport wizard.
a. Using comments show which rows/columns were not included in the import. What data replacement was used?
b. Calculate the final score using the formula: (max 10 assignments - i.e. drop the lowest) midterms Finalexam Discussion. Add a column to show the final score.
c. Calculate the final grade based on 90-100 = A, 80- < 90 B, 70 - < 80 C, 60 - < 70 D, and < 60 F. Add a column to show the final grade.
d. Using fprintf, show a table of the final score and grade.
e. Sort the table by the final score, and show the result.
f. Show the min, max and average final score.
Explanation / Answer
% content records
information = dataset('file', 'tobramycin.txt')
% content documents with . set up of missing qualities
information = dataset('file', 'tobramycin.txt', 'TreatAsEmpty', '.')
% For Excel records
information = dataset('xlsfile', 'tobramycin.xls')
You can likewise develop the dataset cluster from factors in the MATLAB Workspace.
% Create a 10x2 exhibit
x = rand(10,2);
% Construct a dataset exhibit containing x
information = dataset({x(:, 1), 'Column1'}, {x(:,2), 'Column2'})
On the off chance that you import the information as isolated factors containing duplicates, you can build the dataset cluster by linking the factors.
% Create 2 10x1 vectors
x = rand(10,1);
y = rand(10,1);
% Construct a dataset exhibit containing x and y
information = dataset({x, 'Column1'}, {y, 'Column2'})
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.